how to make cash every 10mins

[Groby]

make a event 

CREATE EVENT `OnlineCashAdd`
ON SCHEDULE
EVERY 10 MINUTE STARTS '2014-08-06 00:34:11'
ON COMPLETION PRESERVE
ENABLE
COMMENT ''
DO UPDATE newproject_db_auth.bg_user SET cash = cash + 10 WHERE user_code IN (SELECT a_portal_index FROM newproject_db_user.t_users WHERE a_zone_num != -1)








nach neustart diesen befehl in die console balern/ console öffenen in newproject_db_auth::::

SET GLOBAL event_scheduler = ON;




SHOW PROCESSLIST