\n"; exit; } list($tl_score,$tl_kills,$tl_suicides,$tl_teamkills,$tl_players,$tl_matches,$tl_playertime,$tl_headshots) = sql_fetch_row($result); sql_free_result($result); $frags = $tl_kills - $tl_suicides; $time = sprintf("%0.1f", $tl_playertime / 360000.0); $result = sql_query("SELECT COUNT(*) FROM {$dbpre}servers"); if (!$result) { echo "{$LANG_STATSDATABASEERROR}
\n"; exit; } list($servers) = sql_fetch_row($result); sql_free_result($result); echo << {$LANG_UTSTATSDATABASE} v{$Version} {$LANG_TOTALSCORE} {$LANG_TOTALFRAGS} {$LANG_TOTALKILLS} {$LANG_TEAMKILLS} {$LANG_TOTALHEADSHOTS} {$LANG_HUMANPLAYERS} {$LANG_SERVERS} {$LANG_MATCHESLOGGED} {$LANG_PLAYERHOURS} $tl_score $frags $tl_kills $tl_teamkills $tl_headshots $tl_players $servers $tl_matches $time EOF; // Load Last Match $matches = 0; $result = sql_query("SELECT MAX(gm_start) FROM {$dbpre}matches"); if (!$result) { echo "{$LANG_MATCHDATABASEERROR} (main).
\n"; exit; } if (!list($recent) = sql_fetch_row($result)) { echo "{$LANG_MATCHDATABASEERROR} (main).
\n"; exit; } $result = sql_query("SELECT gm_num,gm_map,gm_start FROM {$dbpre}matches WHERE gm_start='$recent' LIMIT 1"); if (list($gm_num,$gm_map,$gm_start) = sql_fetch_row($result)) { sql_free_result($result); $map = intval($gm_map); $start = strtotime($gm_start); $matchdate = formatdate($start, 1); $link = "matchstats.php?match=$gm_num"; $result = sql_query("SELECT mp_name FROM {$dbpre}maps WHERE mp_num=$map LIMIT 1"); if (!$result) { echo "{$LANG_MAPDATABASEERROR} (main).
\n"; exit; } $row = sql_fetch_row($result); $mapname = $row[0]; echo <<
{$LANG_LASTMATCHLOGGED}
$mapname
$matchdate
EOF; } sql_free_result($result); if ($title_msg == "") $title_msg = " "; echo <<
$title_msg
EOF; $result = sql_query("SELECT server,port,type,password,link,spectators,bots FROM {$dbpre}configquery ORDER BY num"); while (list($query_server,$query_port,$query_type,$query_password,$query_link,$query_spectators,$query_bots) = sql_fetch_row($result)) { if ($query_server != "") { include_once("serverquery.php"); if (GetStatus("$query_server", $query_port)) DisplayStatus($query_link); else DisplayDown($query_server.":".$query_port); } } sql_free_result($result); //============================================================================= //========== Hourly Activity Graph ============================================ //============================================================================= $hactive = array_fill(0, 24, 0); $result = sql_query("SELECT HOUR(gm_start) AS hour, COUNT(gt_pnum) AS pcount FROM {$dbpre}matches, {$dbpre}playersgt WHERE gm_num=gt_num GROUP BY hour"); while ($row = sql_fetch_row($result)) $hactive[$row[0]] = $row[1]; sql_free_result($result); $hmax = max($hactive); if ($hmax > 0) { echo <<
{$LANG_SERVERACTIVITYBYHOUR}
 
EOF; for ($i = 0; $i < 24; $i++) { $height = round(($hactive[$i] / $hmax) * 0.9 * 142); $bottom = $height + 2; echo "
 
 
\n"; } echo "
 
\n"; for ($i = 0; $i < 24; $i++) { $hr = sprintf("%02d", $i); echo "
 
$hr
\n"; } echo << 
EOF; } } echo << EOF; ?>