>>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