[TUT] How to automatically refill daily respect points [Both respect and Pet Scratch] [100% EASY]

Messages
717
Likes
66
#1
Hi, this tutorial teaches you how to automatically refill daily respect points [Both respect and Pet Scratch] in simple steps! Plus, this is only for navicat users!


STEP 1: Open navicat and go to your database.





Step 2: Click "Query" and click "New Query"





Step 3: Run this Query:

PHP:
 SET GLOBAL event_scheduler =ON;




Step 4: Click "Events" [See the image if you don't know where it is] and click "New Events"



Step 5: In the box, type this code:

PHP:
UPDATE user_stats SET DailyRespectPoints = '3';



Step 6: Now Switch to the "Schedule" tab and then click "Every" option.




Step 7: In the two boxes [Present near "EVERY" option], type "24" in the first box and "HOUR" in the second box.





Step 8: Then hit "Save" at the top and name it as "Daily Respect Points"





Step 9: Again, in the "Schedule" tab, click "AT" option and hit "Save as", then name it as "Daily Respect Points 2"





Step 10: Finally, run this query into your database:

PHP:
SET GLOBAL event_scheduler =ON;




Step 11: Restart your emulator, hope you no need image for this xD

NOTE: If you want the daily pet scratch refill, run this code:

Code:
UPDATE user_stats SET DailyPetRespectPoints = 3;
Instead of running the given code in step 5!

If you need any further help, feel free to add me on skype: tiny.builder
Hit the "Like" button if this tutorial helped you :)


CREDITS:

Tyler - 75%
Me - 25%
 

Deion

Posting Freak
Messages
1,249
Likes
299
#5
Nice tutorial. +1

- OFT
Funny how you made the IP black in some screenshots but it shows in others :p
 

Aruthra

Swift is Back, Folks :D
Messages
618
Likes
61
#7
Here is the fixed TUT:

STEP 1: Open navicat and go to your database.

Step 2: Click "Query" and click "New Query"

Step 3: Run this Query

PHP:
SET GLOBAL event_scheduler =ON;
Step 4: Click "Events" and click "New Event"

Step 5: In the box, type this code:

PHP:
UPDATE user_stats SET DailyRespectPoints = '3';
Step 6: Now Switch to the "Schedule" tab (Nearest tab) and then click "Every" option.

Step 7: In the two boxes [Present near "EVERY" option], type "24" in the first box and "HOUR" in the second box.

Step 8: Then hit "Save" at the top and name it something like "Daily Respect Points"

Step 10: Finally, run this query into your database:

PHP:
SET GLOBAL event_scheduler =ON;
Step 11:
Restart your emulator.

NOTE: If you want the daily pet scratch refill, run this code:

PHP:
UPDATE user_stats SET DailyPetRespectPoints = 3;
Instead of running the given code in step 5!

If you need any further help, feel free to add me on skype: tiny.builder
Hit the "Like" button if this tutorial helped you :)
 
Last edited:

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top