[HELP] How to set different daily respect / scratch points for different ranks

[PastExpGamer]

As mentioned in the tile, i was trying to set different respect points for different ranks but still to not avail. Could someone help me out ?

 

[Hindi]

You must be registered for see links

This should sum it up.

 

[JacobMLucado]

I'm not sure if you can set respects for a certain rank, if so I'd like to know too. but I do know that you can set events for the users id
I think there is a tut for this? I'm not sure.

1.) Run this
SET GLOBAL event_scheduler =ON;

2.) go to events and put this

UPDATE `user_stats` SET `DailyRespectPoints`='NUMBER' WHERE (`id`='USERIDHERE')

3.) After that go the schedual tab and set the time like so:

5.) After you do that click save and name it.

6.) After you set your event run this again

SET GLOBAL event_scheduler =ON;

7.) Restart your emulator and you're all set.

This also applies for pet scratches. Just change DailyRespectPoints to DailyPetRespectPoints

I hope this helped you, if so rep. I'll rep back.

 

[PastExpGamer]

I'm not sure if you can set respects for a certain rank, if so I'd like to know too. but I do know that you can set events for the users id
I think there is a tut for this? I'm not sure.

1.) Run this
SET GLOBAL event_scheduler =ON;

2.) go to events and put this

UPDATE `user_stats` SET `DailyRespectPoints`='NUMBER' WHERE (`id`='USERIDHERE')

3.) After that go the schedual tab and set the time like so:

5.) After you do that click save and name it.

6.) After you set your event run this again

SET GLOBAL event_scheduler =ON;

7.) Restart your emulator and you're all set.

This also applies for pet scratches. Just change DailyRespectPoints to DailyPetRespectPoints

I hope this helped you, if so rep. I'll rep back.

I dont get what you meant by.
Am i suppose to put this?
UPDATE `user_stats` SET `DailyRespectPoints`= 5
Or others?
"UPDATE `user_stats` SET `DailyRespectPoints`='NUMBER' WHERE (`id`='USERIDHERE')"

 

[Hindi]

I dont get what you meant by.
Am i suppose to put this?
UPDATE `user_stats` SET `DailyRespectPoints`= 5
Or others?
"UPDATE `user_stats` SET `DailyRespectPoints`='NUMBER' WHERE (`id`='USERIDHERE')"

1st one is for all the users
2nd one is for a particular user.

 

[PastExpGamer]

1st one is for all the users
2nd one is for a particular user.

can reply me back with an example? unclear how it works.
"UPDATE `user_stats` SET `DailyRespectPoints`='NUMBER' WHERE (`id`='USERIDHERE')"

 

[Hindi]

can reply me back with an example? unclear how it works.
"UPDATE `user_stats` SET `DailyRespectPoints`='NUMBER' WHERE (`id`='USERIDHERE')"

UPDATE user_stats set dailyrespectpoints = 10 where username = PastExpGamer; <~This one is for only 1 user aka you.

UPDATE user_stats set dailyrespectpoints = 10; <~ this one is for everyone that have registered in the database

 

[PastExpGamer]

UPDATE user_stats set dailyrespectpoints = 10 where username = PastExpGamer; <~This one is for only 1 user aka you.

UPDATE user_stats set dailyrespectpoints = 10; <~ this one is for everyone that have registered in the database

Thanks ! It works (Y)

 

[lepos]

/closed on op request.