2 Oct
2008
2 Oct
'08
6:02 a.m.
No idea to be honest, im a novice. Many web-sites seem to advice using that and it works for the "most part"
OK. It's wrong. That part of the expression counts time not octets. It handles sessions that started in one counting period and continue into next one. Data is counted properly without such additions. Delete it. query = "SELECT SUM(AcctInputOctets + AcctOutputOctets) FROM radacct WHERE UserName='%{%k}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '%b'" Remove "+ AcctSessionTime" if you don't want sessions that started in one counting period and continuing into the next one to count in the new one. And tell Dirk and others where you found that information not to mix time and data counters. Ivan Kalik Kalik Informatika ISP