Online time cash

[rondo157]

#!/bin/bash

host=localhost
user=root
pass=
auth_db=ep5_lcdbauth
user_db=ep5_lcdbauth
cash=30
date=`date +"%d-%m-%Y %H:%M"`
date2=`date -I`

#Cash-Script

select=`mysql -D $user_db -h $host --user=$user --password=$pass --skip-column-names -e "SELECT a_portal_index FROM t_users WHERE a_zone_num > -1"`

for online in ${select[@]}

do

setcash=`mysql -D $auth_db -h $host --user=$user --password=$pass --skip-column-names -e "UPDATE bg_user SET cash = cash +'$cash' WHERE user_code = '$online'"`

done

#Create a logfile to your specified path how much Accounts was online and how much cash was added.

path="/root/CashLog_$date2.txt"

echo -e "================================================= "$date" =================================================" >> $path

id=$(mysql -D $user_db -h $host --user=$user --password=$pass --skip-column-names -e "SELECT count(*) FROM t_users WHERE a_zone_num > -1")

amount=$(($id * $cash));

echo -e "" >> $path

echo -e "Accounts=$id
Cash=$amount" >> $path

select=`mysql -D $user_db -h $host --user=$user --password=$pass --skip-column-names -e "SELECT a_idname FROM t_users WHERE a_zone_num > -1"`
i=1
for online in ${select[@]}

do
echo -e "$i. Account = $online" >> $path
let i=$i+1
done

echo "Succesfully $amount Cash added distributed $id Accounts."

add to crontab event and its done