Скрипт массового выкидывания абонентов по условию
Скрипт массового выкидывания абонентов по условию
USER="mikbill"PASS="PASSWORD"
DB="mikbill"
#QUERY="SELECT uid FROM $DB.radacctbras WHERE uid IN (SELECT uid FROM $DB.users WHERE deposit+credit<0)"
QUERY="SELECT uid FROM $DB.radacctbras WHERE uid IN (SELECT uid FROM $DB.users WHERE blocked=1)"
result=$(mysql -u$USER -p$PASS -se "$QUERY")
cd /var/www/mikbill/admin
for uid in ${result[*]}
do
echo "kick uid: $uid"
php index.php kick $uid
done
USER="mikbill"
PASS="PASSWORD"
DB="mikbill"
QUERY="SELECT uid FROM users WHERE local_ip LIKE '192.168.64%'"
result=$(mysql -u$USER -p$PASS $DB -se "$QUERY")
cd /var/www/mikbill/admin
for uid in ${result[*]}
do
echo "kick uid: $uid"
php index.php kick $uid
done
Комментарии
Отправить комментарий