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

[TinyBuilder]

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:

 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:

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:

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:

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%

 

[vRory]

This is useful for people who don't already have this, i like how you used images.

 

[TinyBuilder]

This is useful for people who don't already have this, i like how you used images.

Thanks!

 

[Delight]

Good tutorial! Keep up the good work!

 

[Deion]

Nice tutorial. +1

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

 

[TinyBuilder]

Good tutorial! Keep up the good work!

Thank you! 

Nice tutorial. +1

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

Oh damn i forgot! Ohhh shit
-Calms myself-
Hackers these days are dummy!

 

[Aruthra]

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

SET GLOBAL event_scheduler =ON;

Step 4: Click "Events" and click "New Event"

Step 5: In the box, type this code:

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:

SET GLOBAL event_scheduler =ON;

Step 11: Restart your emulator.

NOTE: If you want the daily pet scratch refill, run this 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

 

[Aruthra]

Good tutorial! Keep up the good work!

Thanks.

 

[Aruthra]

Nice tutorial. +1

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

Removed the images lol.

 

[jayk]

Very useful, great tutorial!

 

[Aruthra]

Very useful, great tutorial!

Thanks.

 

[Pocket]

Please Update Images.

 

[Aruthra]

Please Update Images.

I removed the images. Please see my previous post in this page

 

[Obey]

Well done.

 

[IsRasmus]

Works fine!

 

[cammy]

Meh, I guess it's a quick fix but it isn't great. Won't update for your users that are online.