PastExpGamer
Member
- Oct 11, 2013
- 77
- 11
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 ?
I dont get what you meant by.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.
1st one is for all the usersI 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')"
can reply me back with an example? unclear how it works.1st one is for all the users
2nd one is for a particular user.
UPDATE user_stats set dailyrespectpoints = 10 where username = PastExpGamer; <~This one is for only 1 user aka you.can reply me back with an example? unclear how it works.
"UPDATE `user_stats` SET `DailyRespectPoints`='NUMBER' WHERE (`id`='USERIDHERE')"
Thanks ! It works (Y)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