', "\n";
/** -- Output most played maps -- **/
echo '
Most played maps
', "\n";
showMostMaps();
/** -- Output overall statistics -- **/
echo '', "\n";
echo '
', "\n";
$sql = 'SELECT COUNT(*) FROM players';
$res = mysql_query($sql);
$pcount = mysql_result($res, 0);
$sql = 'SELECT COUNT(*) FROM kills';
$res = mysql_query($sql);
$kcount = mysql_result($res, 0);
$sql = 'SELECT HOUR(kill_timestamp) AS thehour, COUNT(*) AS num FROM kills GROUP BY thehour ORDER BY num DESC LIMIT 0,1';
$res = mysql_query($sql);
$tophour = mysql_result($res, 0);
$sql = "SELECT class_displayname, SUM(roleperiod_endtime - roleperiod_starttime) AS time FROM classes NATURAL JOIN roleperiods WHERE roleperiod_endtime > '0000-00-00' GROUP BY class_name ORDER BY time DESC LIMIT 0,1";
$res = mysql_query($sql);
$topclass = mysql_result($res, 0);
$sql = "SELECT SUM(session_endtime - session_starttime) FROM sessions WHERE session_endtime > '0000-00-00'";
$res = mysql_query($sql);
$time = mysql_result($res, 0);
echo '- ', number_format($pcount), ' players tracked.
', "\n";
echo '- ', number_format($kcount), ' kills logged.
', "\n";
echo '- Most popular time of day: ', $tophour, '-', (++$tophour % 24), ':00.
', "\n";
echo '- Most played class: ', $topclass, '.
', "\n";
echo '- ', number_format(round($time/(60*60),0)), ' hours of play time.
', "\n";
echo '
', "\n";
/** -- Output top weapons -- **/
echo '
Top weapons
', "\n";
showWeaponsList();
echo '
', "\n";
echo '', "\n";
/** -- Output server list -- **/
if (ENABLE_SERVER_LIST) {
echo '
Participating servers
';
echo '
Server name | Address | Connect |
';
$sql = 'SELECT server_name, server_ip, server_port FROM servers ORDER BY server_name';
$res = mysql_query($sql);
$i = 0;
while ($row = mysql_fetch_assoc($res)) {
$i++;
echo '', htmlentities($row['server_name'], ENT_COMPAT, 'UTF-8'), ' | ';
echo '', $row['server_ip'], ':', $row['server_port'], ' | ';
echo '';
echo 'using steam';
echo '';
echo 'using hlsw';
echo ' |
';
}
echo '
';
}
/** -- Output top players -- **/
echo '
Top players
', "\n";
showPlayerTable('', '1=1', OVERVIEW_PLAYERS);
echo '
', "\n";
require_once('inc/footer.php');
?>