01-23-2014, 08:25 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
Thanks i will try it.

