<?
include "./auth.inc.php";

$sql = "SELECT sum(AcctOutputOctets),sum(AcctSessionTime) FROM radacct,SubAccounts WHERE UserName=Login AND
AccountType='dealerspecial' AND month(realtime)=$month AND year(realtime)=$year";

$res = mysql_query($sql);
print mysql_error();
$r = mysql_fetch_row($res);

print "Downloaded: ";
print intval($r[0]/1000000);
print " Mb<BR>";

print "Time: ";
print intval($r[1]/3600);
print " Hours<BR>";

$nsql = "SELECT Count(*) 
	FROM Notes, SubAccounts,MasterAccounts 
	WHERE Notes.CustomerID=SubAccounts.CustomerID
	AND Notes.CustomerID=MasterAccounts.CustomerID 
	AND AccountType='dealerspecial'
	AND Month(CreateDate)=$month 
	AND year(CreateDate)=$year";

$nres = mysql_query($nsql);
print mysql_error();
$nr = mysql_result($nres,0);
print "Number of Notes Generated by these customers= $nr";


?>