И так...
Как сделать проверку на блокировки и отрицательный баланс
dialup.conf
authorize_check_query = "SELECT (@cnt := @cnt + 1) AS `id`, `UserName`, `Attribute`, `Value`, `op` \
FROM `${authcheck_table}`, `users`\
CROSS JOIN (SELECT @cnt := 0) AS `dummy` \
WHERE `UserName` = '%{SQL-User-Name}' \
AND `UserName`=`login` AND `cash` > 0 AND `cash` >= `credit` AND `passive` = 0 AND `down` = 0 \
ORDER BY `id`"
Ограничение по подключению одного и того же логина
dialup.conf
# Uncomment simul_count_query to enable simultaneous