>>query = "SELECT SUM(AcctInputOctets - GREATEST((%b -
>UNIX_TIMESTAMP(AcctStartTime)), 0))+ SUM(AcctOutputOctets -GREATEST((%b -
>>UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{%k}' AND
>UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'"

What is "GREATEST((%b - UNIX_TIMESTAMP(AcctStartTime)), 0)" doing in
data (octet) counter?

Ivan Kalik
Kalik Informatika ISP

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to