"; include "header.phtml"; > \n"; echo "\n"; $i=0; while($i < 31) { $t = time()-60*60*24*$i; $year= date("Y",$t); $month= date("m",$t); $day = date("d",$t); echo "\n"; $i++; } echo "\n"; $i=-1; while($i < 12) { $t = time()-60*60*24*31*$i; $year= date("Y",$t); $month= date("m",$t); $day = date("d",$t); echo "\n"; $i++; } echo "\n"; ); SecureVar("REMOTE_*"); $self="active_users_since.phtml"; mysql_Connect($host,$dbuser,$dbpassword); if(!$firstdate) { if(!$days) { $days=14; } $firstdate= date("Ymd000000",time()-60*60*24*$days); }; if(!$lastdate) { $lastdate= date("Ymd235959",time()); }; >
"> Back > days
"> From to
$firstdate AND usertime.start_time<=$lastdate"; $query += " GROUP by name "; if (!$order) { $query += " ORDER BY usertime.name"; } else { $query += " ORDER BY usertime.$order $sort"; } echo ""; echo "
$query
"; $result = mysql($db, $query); if (!$result) { echo "An error occured.\n"; exit; } echo "
"; $num = mysql_NumRows($result); $i = 0; if ($num == 0) { echo "Keine User eingeloggt"; } else { echo "
Users: $num from $firstdate to $lastdate
"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; while ($i < $num) { $Id=mysql_Result($result, $i, "usertime.id" ); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $i++; } /* while */ echo "
\n"; echo "Name"; echo "
order+order-"; echo "
\n"; echo "Connects"; echo "
order+order-"; echo "
\n"; echo "Time (hours)"; echo "
order+order-"; echo "
\n"; echo "Outbytes"; echo "
order+order-"; echo "
\n"; echo "InBytes"; echo "
order+order-"; echo "
\n"; $Name = mysql_Result($result, $i, "name" ); echo "$Name"; echo "\n"; echo mysql_Result($result, $i, "anzahl" ); echo "\n"; $seconds = mysql_Result($result, $i, "time_on" ); $minutes = $seconds / 60; $hours = $minutes / 60; echo "%5.2f" $hours; echo "\n"; echo mysql_Result($result, $i, "outbytes" ); echo "\n"; echo mysql_Result($result, $i, "inbytes" ); echo "
"; mysql_FreeResult($result); mysql_Close(); >