Welcome to UTStats.
Here you can look up information on UT matches and players.
Select a category from the column on the left.
| Game Summary |
| Match Type |
Frags |
Kills |
Suicides |
Team Kills |
Matches |
Game Hours |
';
$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 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'| '.$r_gamesummary[gamename].' |
'.$r_gamesummary[frags].' |
'.$r_gamesummary[kills].' |
'.$r_gamesummary[suicides].' |
'.$r_gamesummary[teamkills].' |
'.$r_gamesummary[matchcount].' |
'.$gametime.' | ';
}
$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'
| Totals for All Players |
'.$totalsummary[frags].' |
'.$totalsummary[kills].' |
'.$totalsummary[suicides].' |
'.$totalsummary[teamkills].' |
'.$totalsummary[matchcount].' |
'.$gametime.' |
|