Last Map Updated
'; if ($moreThan2Teams) { echo ' '; } echo '

'.$lastMapFileName.'
'.$lastMapScore0.' '.mdate($lastMapTime).' '.$lastMapScore1.'
'.$lastMapScore2.' '.$lastMapScore3.'

View stats

'; $sql_recent = "SELECT m.id, m.time, g.name AS gamename, m.mapfile, m.gametime, t0score, t1score, t2score, t3score, (SELECT count(p.id) FROM uts_player AS p WHERE m.id = p.matchid) as players FROM uts_match AS m, uts_games AS g WHERE g.id = m.gid $where ORDER BY m.time DESC LIMIT 10"; $q_recent = mysql_query($sql_recent) or die(mysql_error()); while ($r_recent = mysql_fetch_array($q_recent)) { $r_time = mdate($r_recent[time]); $r_mapfile = un_ut($r_recent[mapfile]); $r_gametime = GetMinutes($r_recent[gametime]); $winner = max($r_recent[t0score], $r_recent[t1score], $r_recent[t2score], $r_recent[t3score]); if ($winner == $r_recent[t0score]) { $winnercolor = "red"; $winmsg = "Red is the winner!"; } elseif ($winner == $r_recent[t1score]) { $winnercolor = "blue"; $winmsg = "Blue is the winner!"; } elseif ($winner == $r_recent[t2score]) { $winnercolor = "green"; $winmsg = "Green is the winner!"; } else { $winnercolor = "gold"; $winmsg = "Gold is the winner!"; }; echo' '; } echo '
Last 10 Matches
ID Date/Time Match Type Map Scores
'.$r_recent[id].' '.$r_time.' '.$r_recent[gamename].' '.$r_mapfile.' '.$r_recent[t0score].''.$r_recent[t1score].''; if ($moreThan2Teams) { echo ''.$r_recent[t2score].' '.$r_recent[t3score].''; } echo '
Show all games

'; echo' '; // Get Summary Info $r_playercount = small_query("SELECT COUNT(*) AS result FROM uts_pinfo"); $playercount = $r_playercount['result']; $servercount = small_count("SELECT DISTINCT servername FROM uts_match"); $mapcount = small_count("SELECT COUNT(mapfile) AS result FROM uts_match GROUP BY mapfile"); $r_matchcount = small_query("SELECT COUNT(*) AS result FROM uts_match"); $matchcount= $r_matchcount['result']; $hourscount = small_query("SELECT SUM(gametime) AS result FROM uts_player"); $gametime = sec2hour($hourscount[result]); echo '
UTStats Summary
Players Servers Maps Matches Logged Player Hours
'.$playercount.' '.$servercount.' '.$mapcount.' '.$matchcount.' '.$gametime.'

'; $sql_gamesummary = "SELECT g.id AS gid, g.name AS gamename, SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, COUNT(DISTINCT p.matchid) AS matchcount FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id GROUP BY gamename, gid ORDER BY gamename ASC"; $q_gamesummary = mysql_query($sql_gamesummary) or die(mysql_error()); while ($r_gamesummary = mysql_fetch_array($q_gamesummary)) { $gid = $r_gamesummary[gid]; $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match WHERE gid = '$gid'"); $gametime = sec2hour($q_gametime[gametime]); echo ' '; } $totalsummary = small_query("SELECT SUM(p.frags) AS frags, SUM(p.kills) AS kills, SUM(p.suicides) AS suicides, SUM(p.teamkills) AS teamkills, COUNT(DISTINCT p.matchid) AS matchcount, SUM(p.gametime) AS gametime FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id"); $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match"); $gametime = sec2hour($q_gametime[gametime]); echo '
Game Summary
Match Type Frags Kills Suicides Team Kills Matches Game Hours
'.$r_gamesummary[gamename].' '.$r_gamesummary[frags].' '.$r_gamesummary[kills].' '.$r_gamesummary[suicides].' '.$r_gamesummary[teamkills].' '.$r_gamesummary[matchcount].' '.$gametime.'
Totals for All Players '.$totalsummary[frags].' '.$totalsummary[kills].' '.$totalsummary[suicides].' '.$totalsummary[teamkills].' '.$totalsummary[matchcount].' '.$gametime.'

'; // Do graph stuff $gtitle = "Across All Servers"; $bgwhere = "id >= 0"; include("pages/graph_mbreakdown.php"); ?>