+- 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: how to make cash every 10mins (/showthread.php?tid=3270)
- blake - 04-29-2015
hello could someone please tell me how i can give cash too all every 10mins when they are logged into game ?
- Groby - 04-29-2015
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
- blake - 04-29-2015
its done tyvm