Cash minutes

[zanatie59]

hello people lckb: D

I want to know how to put a cash every 5 to 10 minutes automatically

[ren0d1]

you can use a bash file schedulded every 5/10 minutes with crontab

[DamonA]

SQL Event ( i recommend this one)
Cron Tab bash file(useless much code & crontab needed)

[zanatie59]

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]

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]

 

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]

You just open a mysql client, and execute it once as a normal query.

[zanatie59]

thank you all

It Works Closed topic thank you alot!

[zanatie59]

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]

@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?