Totals for This Match Team Score Player Score Frags Kills Deaths Suicides '; // Get Summary Info $teamscore = small_query("SELECT SUM(t0score + t1score + t2score + t3score) AS result FROM uts_match WHERE id = $mid"); $playerscore = small_query("SELECT SUM(gamescore) AS result FROM uts_player WHERE matchid = $mid"); $fragcount = small_query("SELECT SUM(frags) AS result FROM uts_match WHERE id = $mid"); $killcount = small_query("SELECT SUM(kills) AS result FROM uts_match WHERE id = $mid"); $deathcount = small_query("SELECT SUM(deaths) AS result FROM uts_match WHERE id = $mid"); $suicidecount = small_query("SELECT SUM(suicides) AS result FROM uts_match WHERE id = $mid"); echo' '.$teamscore[result].' '.$playerscore[result].' '.$fragcount[result].' '.$killcount[result].' '.$deathcount[result].' '.$suicidecount[result].' '; // Teamgame? Then show score if ($teamgame) { echo ' '; echo ' Score:'; if ($r_info[t0]) { echo ' '.$r_info[t0score]; } if ($r_info[t1]) { echo ' - '.$r_info[t1score]; } if ($r_info[t2]) { echo ' - '.$r_info[t2score]; } if ($r_info[t3]) { echo ' - '.$r_info[t3score]; } echo ' '; } echo '
'; $matchinfo = small_query("SELECT m.time, m.servername, g.name AS gamename, m.gamename AS real_gamename, m.gid, m.mapname, m.mapfile, m.serverinfo, m.gameinfo, m.mutators, m.serverip FROM uts_match AS m, uts_games AS g WHERE m.gid = g.id AND m.id = $mid"); $matchdate = mdate($matchinfo[time]); $gamename = $matchinfo[gamename]; $real_gamename = $matchinfo[real_gamename]; $gid = $matchinfo[gid]; $mapname = un_ut($matchinfo[mapfile]); $mappic = strtolower("images/maps/".$mapname.".jpg"); if (file_exists($mappic)) { } else { $mappic = ("images/maps/blank.jpg"); } $myurl = urlencode($mapname); echo'

Unreal Tournament Match Stats
Match Date	'.$matchdate.'	Server	'.$matchinfo[servername].'
Match Type	'.$gamename.'	Map Name	'.$matchinfo[mapname].'
Server Info	'.$matchinfo[serverinfo].'
Game Info	'.$matchinfo[gameinfo].'
Mutators	'.$matchinfo[mutators].'

'; ?>