01-11-2015, 03:36 AM
how can I do to create this cash event every five minutes remaining in
Wizatek have post it here 2
CREATE EVENT `OnlineCashAdd`
ON SCHEDULE
EVERY 5 MINUTE STARTS '2014-08-06 00:34:11'
ON COMPLETION PRESERVE
ENABLE
COMMENT ''
DO UPDATE newproject_auth.bg_user SET cash = cash + 50 WHERE user_code IN (SELECT a_portal_index FROM newproject_auth.t_users WHERE a_zone_num != -1)

