>>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? No idea to be honest, im a novice. Many web-sites seem to advice using that and it works for the "most part" Eg.... http://cakeforge.org/forum/forum.php?forum_id=631 But advice is welcome! >Ivan Kalik >Kalik Informatika ISP - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
