(RADIATOR) Does anyone have a radacct.cgi

[Miguel A.L. Paraz]

Does anyone have a radacct.cgi that eliminates duplicate accounting records?

I started working on this for the different queries by using a hash to
track down if the session was seen already.  However in the default query,
we have this SQL statement:

my $q = "select USERNAME, sum(ACCTSESSIONTIME),
sum(ACCTINPUTOCTETS), sum(ACCTOUTPUTOCTETS)
from $DBTableName group by USERNAME";

which aggregates the session time and others by username.  Has anyone
"unrolled" this SQL statement yet?  If not, we will do that here.  Thanks.




-- 

http://www.internet.org.ph			.PH is PHilippines not PHone!
Philippine Internet Resources			http://www.phildac.org






===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.