Help - daily respect (gte) - help

I need daily respects for GTE instead of one time of respects, I want everyday:P:

Quote:

---

Originally Posted by The General

Code:

---

CREATE DEFINER=`root`@`localhost` EVENT `update_respect` 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'

---

Run this as SQL

---

Should work - haven't tested it though, as I don't use GTE

Still doesn't work ):

Quote:

---

Originally Posted by JumpingJellybee

Still doesn't work ):

---

It runs every 24 hours so the first time you run it it doesn't automatically update the respects. It always runs at midnight.

Trust me, it works unless you have messed up your database then it would've thrown errors.