online cash

[epic1986]

CREATE EVENT 'OnlineCash'
ON SCHEDULE EVERY 5 MINUTE
DO BEGIN
 
UPDATE bg_user 
SET cash = cash + 500 
WHERE user_code IN (SELECT a_portal_index FROM t_users WHERE a_zone_num != -1);
 
END;
 
SET GLOBAL event_scheduler = ON;   

 

 

 

hi i search the  original from wizatek for  ep3 

[Walletman987]

What do you mean the original? lol

[epic1986]

wiza have  post  a  other  i dont  find  this

[Wizatek]

That one adds 500 cash every 5 minutes.

i don't know what you are exactly looking for? that is all there is

[epic1986]

you have  a sc

 

That one adds 500 cash every 5 minutes.
i don't know what you are exactly looking for? that is all there is

i have a  error  look 

 

UPDATE bg_user 
SET Cash = Cash + 50 
WHERE user_code IN (SELECT a_portal_index FROM t_users WHERE a_zone_num != -1);
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''OnlineCash'
ON SCHEDULE EVERY 5 MINUTE
DO BEGIN
 
UPDATE bg_user 
SET Cash' at line 1

[Wizatek]

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)

[epic1986]

thx  wiza  this  i have  search  is  solved  can closed