Location: PHPKode > projects > Total ISP > total-isp/getcall.php
<?
include "./auth.inc.php";

if ($Year){
	$datetime = "$Year-$Month-$Day $Hour:$Minute:00";	

	print "$datetime <BR>";

	#offset for Adelaide!
	#ideally get offset from OS.
	$offset = date("Z")/60 - $gmt;
	$mtime = mktime($Hour,$Minute + $offset,0,$Month,$Day,$Year);
	
	$getdate= date("Y-m-d H:i:s",$mtime);

	$sql = "SELECT UserName, realtime, FramedIPAddress, AcctSessionTime, unix_timestamp(realtime) as t 
		FROM $table
		WHERE AcctStatusType='Stop' 
		HAVING t <= '$mtime' AND (t+AcctSessionTime) >= '$mtime'";

	print $sql;
	$res = mysql_query($sql);
	print mysql_error();
	print "<BR><TABLE border=1>";
	print "<TR><TH>Username</TH><TH>Time</TH><TH>IP Address</TH><TH>Duration</TH></TR>\n";
	while ($row = mysql_fetch_row($res)){
		print "<TR>";
		print "<TD>$row[0]</TD>";
		print "<TD>$row[1]</TD>";
		print "<TD>$row[2]</TD>";
		print "<TD>$row[3]</TD>";
		print "</TR>\n";
	}
	print "</TABLE>";
exit;	
}
?>
<HTML>
<HEAD></HEAD>
<BODY bgcolor=white>
<FORM>
<H2>Enter a Time to find out who was on at that time</H2>
<BR>
Warning: This is a database intensive Search.
<BR>

Date: <select name=Day>
<? for ($i=1;$i<32;$i++){
        print "<option value=\"$i\">".date("jS",mktime(0,0,0,1,$i,2000))."</option>\n";
}
?>
</SELECT>

<SELECT name=Month>
<? for ($i=1;$i<13;$i++){
	print "<option value=\"$i\">".date("F",mktime(0,0,0,$i,1,2000))."</option>\n";	
}
?>	
</SELECT>
<SELECT NAME=Year>
        <option><? echo date("Y") ?></option>
        <option><? echo date("Y")-1 ?></option>
</SELECT>
<BR>
Time: <select name=Hour>
<?  for ($i=0;$i<24;$i++){
	print "<option>$i</option>\n";

}
?>
</select>:
<select name=Minute>
<?  for ($i=0;$i<60;$i++){
        print "<option>$i</option>\n";

}
?>
</select>
<BR>
GMT: <select name=gmt>
<? for ($i=-24;$i<24;$i++){
	$gmtn = intval($i/2)*100 + ($i%2)*30;
	if (intval($gmtn) > 0){
		#if (strlen($gmtn)==3){
		#	$gmtn = '0'.$gmtn;
		#}
		$gmtn = '+'.$gmtn;
	}
	$value=$i*30;
	print "<option value=\"$value\"";
	if ($value == 570)
		print " selected";
	print ">$gmtn</option>";
}
?></SELECT>
<BR>
Data: <SELECT NAME="table">
<option>radacct</option>
<option>radacctarchive</option>
</SELECT>
<BR>
<INPUT TYPE=SUBMIT>
</FORM>

</BODY>
</HTML>

Return current item: Total ISP