+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: online cash (/showthread.php?tid=4278)
- epic1986 - 12-11-2014
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 - 12-11-2014
What do you mean the original? lol
- epic1986 - 12-11-2014
wiza have post a other i dont find this
- Wizatek - 12-12-2014
That one adds 500 cash every 5 minutes.
i don't know what you are exactly looking for? that is all there is
- epic1986 - 12-12-2014
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 - 12-12-2014
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 - 12-13-2014
thx wiza this i have search is solved can closed