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

TinyBuilder

Bike ✔
Mar 19, 2012
717
66
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.


1qnq.png



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

2zez.png




Step 3: Run this Query:

PHP:
 SET GLOBAL event_scheduler =ON;

3vcv.png




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

4xvx.png


Step 5: In the box, type this code:

PHP:
UPDATE user_stats SET DailyRespectPoints = '3';

5jkj.png



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

6xhx.png



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

7bzb.png




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

8eme.png




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

6fd342fe5bdd47689392ba5.png




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

PHP:
SET GLOBAL event_scheduler =ON;

10zez.png




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
Jul 3, 2010
1,273
300
Nice tutorial. +1

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

Tiny

Owner, Swift Industry
Aug 14, 2013
616
61
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:

cammy

Member
May 15, 2014
470
219
Meh, I guess it's a quick fix but it isn't great. Won't update for your users that are online.
 

Users who are viewing this thread

Top