LCKB › ** OLD LCKB DATABASE ** › Guides & Help Section › Help & Support › Ep3 Support › Solved topics v
Online Time point..

Linear Mode
Online Time point..
Wizatek Offline
Posting Freak
*****
Posts: 768
Threads: 40
Thanks Received: 0 in 0 posts
Thanks Given: 0
Joined: May 2011
Reputation: 0
#16
01-23-2014, 08:16 PM

 

#! /bin/bash

mysql --user=usernamehere --password=passwordhere newproject_auth "UPDATE bg_user SET cash = cash + 5 WHERE user_code in (SELECT a_portal_index FROM t_users WHERE a_zone_num >= 0"
 

 

Set a crontab for it to run every 5 minutes and done

No external thing needed

Find


Messages In This Thread
[No subject] - by MrBuSta - 01-21-2014, 08:59 PM
[No subject] - by Wrong - 01-22-2014, 08:02 AM
[No subject] - by LikeToMove - 01-23-2014, 11:47 AM
[No subject] - by SibaN - 01-23-2014, 06:57 PM
[No subject] - by Paramount - 01-23-2014, 07:02 PM
[No subject] - by MrBuSta - 01-23-2014, 07:04 PM
[No subject] - by MrBuSta - 01-23-2014, 07:11 PM
[No subject] - by SibaN - 01-23-2014, 07:30 PM
[No subject] - by MrBuSta - 01-23-2014, 07:33 PM
[No subject] - by MrBuSta - 01-23-2014, 07:39 PM
[No subject] - by SibaN - 01-23-2014, 07:48 PM
[No subject] - by MrBuSta - 01-23-2014, 07:59 PM
[No subject] - by SibaN - 01-23-2014, 08:04 PM
[No subject] - by MrBuSta - 01-23-2014, 08:06 PM
[No subject] - by MrBuSta - 01-23-2014, 08:11 PM
[No subject] - by Wizatek - 01-23-2014, 08:16 PM
[No subject] - by MrBuSta - 01-23-2014, 08:25 PM
[No subject] - by MrBuSta - 01-23-2014, 08:29 PM
[No subject] - by Wizatek - 01-23-2014, 08:45 PM
[No subject] - by MrBuSta - 01-23-2014, 08:45 PM
[No subject] - by Wizatek - 01-23-2014, 09:16 PM
[No subject] - by MrBuSta - 01-23-2014, 09:24 PM
[No subject] - by Wizatek - 01-23-2014, 10:57 PM
[No subject] - by MrBuSta - 01-24-2014, 10:49 PM
[No subject] - by Wizatek - 01-25-2014, 09:20 AM
[No subject] - by BlaSteDGames - 01-25-2014, 09:20 PM
[No subject] - by Canton - 01-28-2014, 10:22 PM
[No subject] - by MrBuSta - 01-28-2014, 10:32 PM
[No subject] - by Paramount - 01-28-2014, 10:34 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)