Биллинговая система Nodeny

UPDATE `bill`.`users` SET `paket` = '1' WHERE mid =0 && `state` = "off" && `balance`<`limit_balance`

echo 'UPDATE `bill`.`users` SET `paket` = '1' WHERE mid = 0 && `state` = "off" && `balance`<`limit_balance`;' | mysql -uтвойлогин -pтвойпароль твоябд

#!/bin/sh
PATH=/etc:/bin:/sbin:/usr/bin:/usr/sbin
passwd_root_mysql=`perl -e'require "/usr/local/nodeny/history.nod"; print $sql_root_pass;'`
mysql_cmd='/usr/local/bin/mysql'

SQL='UPDATE `bill`.`users` SET `paket` = "1" WHERE `mid` =0 && `state` = "off" && `balance`<`limit_balance`'
echo $SQL | ${mysql_cmd} -u root --password=${passwd_root_mysql} bill

$sql="SELECT id FROM users WHERE balance >= limit_balance and mid=0 AND paket=$i AND id NOT IN ".
             "(SELECT u.id FROM users u LEFT JOIN pays p ON u.id=p.mid WHERE u.paket=$i and p.category=114 AND time>=$t1 AND time<=$t2)";

$sql="SELECT * FROM users WHERE mid=0 and balance >= limit_balance";

$sth=&sql("SELECT DISTINCT id FROM users WHERE id IN($sql) OR mid IN ($sql) AND balance >= limit_balance");

diff new_month.pl.old new_month.pl
211c211
< $sth=&sql("SELECT DISTINCT id FROM users WHERE id IN($sql) OR mid IN ($sql)");
---
> $sth=&sql("SELECT DISTINCT id FROM users WHERE (id IN($sql) OR mid IN ($sql)) AND balance >= limit_balance");
250c250,251
< $sql="SELECT * FROM users WHERE mid=0";
---
> $sql="SELECT * FROM users WHERE mid=0 AND balance >= limit_balance";

$sql="SELECT * FROM users WHERE mid=0 and balance >= limit_balance";

$sql="SELECT * FROM users WHERE if(block_if_limit=1,balance>=limit_balance,1) AND mid=0";

$sql="SELECT id FROM users WHERE if(block_if_limit=1,balance>=limit_balance,1) and mid=0 AND paket=$i AND id NOT IN ".
"(SELECT u.id FROM users u LEFT JOIN pays p ON u.id=p.mid WHERE u.paket=$i and p.category=114 AND time>=$t1 AND time<=$t2)"

config="/usr/local/nodeny/nodeny.cfg"
export `cat ${config} |\
    grep -R '\(Db_name[[:space:]]*=\)\|\(Db_user[[:space:]]*=\)\|\(Db_pw[[:space:]]*=\)\|\(Db_server[[:space:]]*=\)' |\
    sed "s/\\\\$//g; s/\;//g; s/[[:space:]]*//g; s/#.*//g; s/'//g;"`

$sql="SELECT * FROM users WHERE mid=0 and state="on"";

$sql="SELECT id FROM users WHERE balance >= limit_balance AND block_if_limit=0 AND mid=0 AND paket=$i AND id NOT IN ".
"(SELECT u.id FROM users u LEFT JOIN pays p ON u.id=p.mid WHERE u.paket=$i and p.category=114 AND time>=$t1 AND time<=$t2)";