keiller
Mr Tutorial Man
- Jun 9, 2012
- 492
- 108
Hey,
Just a quick tutorial on how to get respectes/pet scratches daily. Two simple SQL codes.
Go into your database and run this SQL;
The SQL code above will create a event to automatically update daily respects daily. (Every 24 hours.)
THEN run this;
That's you done!
Just a quick tutorial on how to get respectes/pet scratches daily. Two simple SQL codes.
Go into your database and run this SQL;
PHP:
CREATE DEFINER=`root`@`localhost` EVENT `resetear_respetos_caricias` ON SCHEDULE EVERY 24 HOUR STARTS '2012-01-01 23:59:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE user_stats
SET
DailyRespectPoints = '3',
DailyPetRespectPoints = '3'
The SQL code above will create a event to automatically update daily respects daily. (Every 24 hours.)
THEN run this;
PHP:
SET GLOBAL event_scheduler =ON;
That's you done!