2 Oct
2008
2 Oct
'08
5:02 a.m.
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