Online time cash

[Scura]

2 hours ago, rondo157 said:





#!/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




really nice bash skills! However, I guess the simplest way is to add it directly in the database event, as /index.php?/profile/2-wizatek/&do=hovercard" data-mentionid="2" href="/index.php?/profile/2-wizatek/" rel="">@Wizatek said. You can always check mysql in case of error

 

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)