+- 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: General Support (https://lckb.dev/forum/forumdisplay.php?fid=203)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=159)
+------ Thread: Cash minutes (/showthread.php?tid=4387)
- zanatie59 - 01-10-2015
hello people lckb: D
I want to know how to put a cash every 5 to 10 minutes automatically
- ren0d1 - 01-10-2015
you can use a bash file schedulded every 5/10 minutes with crontab
- DamonA - 01-10-2015
SQL Event ( i recommend this one)
Cron Tab bash file(useless much code & crontab needed)
- zanatie59 - 01-10-2015
SQL Event ( i recommend this one)
Cron Tab bash file(useless much code & crontab needed)
how can I do to create this cash event every five minutes remaining in
- DamonA - 01-11-2015
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)
- zanatie59 - 01-11-2015
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)
I it's more how do you add
- Wizatek - 01-11-2015
You just open a mysql client, and execute it once as a normal query.
- zanatie59 - 01-11-2015
thank you all
It Works Closed topic thank you alot!
- zanatie59 - 01-13-2015
You just open a mysql client, and execute it once as a normal query.
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)
- camaro2683 - 01-13-2015
@zanatie59 i myself tried doing this exactly as you said to do and seems to not work for me can u explain of wat might be the problem?