Totals Summary
'; $sql_totsumm = "SELECT g.name AS gamename, SUM(p.gamescore) AS gamescore, 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 sumgametime FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id GROUP BY gamename ORDER BY gamename ASC"; $q_totsumm = mysql_query($sql_totsumm) or die(mysql_error()); while ($r_totsumm = zero_out(mysql_fetch_array($q_totsumm))) { $gametime = sec2hour($r_totsumm[sumgametime]); echo' '; } $sql_summtot = zero_out(small_query("SELECT SUM(gamescore) AS gamescore, SUM(frags) AS frags, SUM(kills) AS kills, SUM(suicides) AS suicides, SUM(teamkills) AS teamkills, COUNT(DISTINCT matchid) AS matchcount, SUM(gametime) AS sumgametime FROM uts_player")); $gametime2 = sec2hour($sql_summtot[sumgametime]); echo'

Summary
Game Type	Score	Frags	Kills	Suicides	Team Kills	Matches	Hours
'.$r_totsumm[gamename].'	'.$r_totsumm[gamescore].'	'.$r_totsumm[frags].'	'.$r_totsumm[kills].'	'.$r_totsumm[suicides].'	'.$r_totsumm[teamkills].'	'.$r_totsumm[matchcount].'	'.$gametime.'
Totals	'.$sql_summtot[gamescore].'	'.$sql_summtot[frags].'	'.$sql_summtot[kills].'	'.$sql_summtot[suicides].'	'.$sql_summtot[teamkills].'	'.$sql_summtot[matchcount].'	'.$gametime2.'

'; $q_assgids = mysql_query("SELECT id FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); $assgids = array(); while ($r_assgids = mysql_fetch_array($q_assgids)) { $assgids[] = $r_assgids['id']; } $assquery = (count($assgids) > 0) ? 'SUM(IF (gid IN ('. implode(',', $assgids) .'), ass_obj, 0)) AS ass_obj' : '0 AS ass_obj'; $sql_cdatot = zero_out(small_query("SELECT SUM(dom_cp) AS dom_cp, $assquery, SUM(flag_taken) AS flag_taken, SUM(flag_pickedup) AS flag_pickedup, SUM(flag_dropped) AS flag_dropped, SUM(flag_assist) AS flag_assist, SUM(flag_cover) AS flag_cover, SUM(flag_seal) AS flag_seal, SUM(flag_capture) AS flag_capture, SUM(flag_kill)as flag_kill, SUM(flag_return) AS flag_return FROM uts_player")); echo'

Assault, Domination and CTF Events Summary
Assault Objectives	Control Point Captures	Capture The Flag
		Flag Takes	Flag Pickups	Flag Drops	Flag Assists	Flag Covers	Flag Seals	Flag Captures	Flag Kills	Flag Returns
'.$sql_cdatot[ass_obj].'	'.$sql_cdatot[dom_cp].'	'.$sql_cdatot[flag_taken].'	'.$sql_cdatot[flag_pickedup].'	'.$sql_cdatot[flag_dropped].'	'.$sql_cdatot[flag_assist].'	'.$sql_cdatot[flag_cover].'	'.$sql_cdatot[flag_seal].'	'.$sql_cdatot[flag_capture].'	'.$sql_cdatot[flag_kill].'	'.$sql_cdatot[flag_return].'

'; $sql_firstblood = zero_out(small_count("SELECT firstblood FROM uts_match WHERE firstblood != ''")); $sql_multis = zero_out(small_query("SELECT SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster FROM uts_player")); $sql_sprees = zero_out(small_query("SELECT SUM(spree_kill) AS spree_kill, SUM(spree_rampage) AS spree_rampage, SUM(spree_dom) AS spree_dom, SUM(spree_uns) AS spree_uns, SUM(spree_god) AS spree_god FROM uts_player")); echo'

Special Events
Special/Multis		Sprees
First Blood	'.$sql_firstblood.'	Killing Spree	'.$sql_sprees[spree_kill].'
Double Kills	'.$sql_multis[spree_double].'	Rampage	'.$sql_sprees[spree_rampage].'
Multi Kills	'.$sql_multis[spree_multi].'	Dominating	'.$sql_sprees[spree_dom].'
Ultra Kills	'.$sql_multis[spree_ultra].'	Unstoppable	'.$sql_sprees[spree_uns].'
Monster Kills	'.$sql_multis[spree_monster].'	Godlike	'.$sql_sprees[spree_god].'

'; include('includes/weaponstats.php'); weaponstats(0, 0); echo'

Totals for Players

'; // NGStats Style Total Highs (All Time) $sql_chighfrags = small_query("SELECT p.pid, pi.name, p.country, SUM(frags) AS frags , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY frags DESC LIMIT 0,1"); $sql_chighdeaths = small_query("SELECT p.pid, pi.name, p.country, SUM(deaths) AS deaths , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY deaths DESC LIMIT 0,1"); $sql_chighkills = small_query("SELECT p.pid, pi.name, p.country, SUM(kills) AS kills , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY kills DESC LIMIT 0,1"); $sql_chighsuicides = small_query("SELECT p.pid, pi.name, p.country, SUM(suicides) AS suicides , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY suicides DESC LIMIT 0,1"); $sql_chighteamkills = small_query("SELECT p.pid, pi.name, p.country, SUM(teamkills) AS teamkills , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY teamkills DESC LIMIT 0,1"); $sql_chigheff = small_query("SELECT p.pid, pi.name, p.country, AVG(eff) AS eff , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY eff DESC LIMIT 0,1"); $sql_chighaccuracy = small_query("SELECT p.pid, pi.name, p.country, AVG(accuracy) AS accuracy , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY accuracy DESC LIMIT 0,1"); $sql_chighttl = small_query("SELECT p.pid, pi.name, p.country, AVG(ttl) AS ttl , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY ttl DESC LIMIT 0,1"); $sql_chighflag_capture = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_capture) AS flag_capture , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY flag_capture DESC LIMIT 0,1"); $sql_chighflag_kill = small_query("SELECT p.pid, pi.name, p.country, SUM(flag_kill) AS flag_kill , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY flag_kill DESC LIMIT 0,1"); $sql_chighdom_cp = small_query("SELECT p.pid, pi.name, p.country, SUM(dom_cp) AS dom_cp , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY dom_cp DESC LIMIT 0,1"); $ass_obj_check = small_query("SELECT COUNT(id) AS idcount FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); IF ($ass_obj_check[idcount] > 0 ) { $sql_chighass_obj = small_query("SELECT p.pid, pi.name, p.country, SUM(ass_obj) AS ass_obj , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY ass_obj DESC LIMIT 0,1"); } else { $sql_chighass_obj = ""; } $sql_chighspree_monster = small_query("SELECT p.pid, pi.name, p.country, SUM(spree_monster) AS spree_monster , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY spree_monster DESC LIMIT 0,1"); $sql_chighspree_god = small_query("SELECT p.pid, pi.name, p.country, SUM(spree_god) AS spree_god , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY spree_god DESC LIMIT 0,1"); $sql_chighrank = small_query("SELECT p.pid, pi.name, p.country, SUM(rank) AS rank , SUM(gametime) AS sumgametime, COUNT(matchid) AS mcount FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' GROUP BY pid HAVING sumgametime > 1800 ORDER BY rank DESC LIMIT 0,1"); echo'
'; if ($sql_chighfrags and $sql_chighfrags[frags]) { echo ' '; } if ($sql_chighdeaths and $sql_chighdeaths[deaths]) { echo ' '; } if ($sql_chighkills and $sql_chighkills[kills]) { echo ' '; } if ($sql_chighsuicides and $sql_chighsuicides[suicides]) { echo ' '; } if ($sql_chighteamkills and $sql_chighteamkills[teamkills]) { echo ' '; } if ($sql_chigheff and $sql_chigheff[eff]) { echo ' '; } if ($sql_chighaccuracy and $sql_chighaccuracy[accuracy]) { echo ' '; } if ($sql_chighttl and $sql_chighttl[ttl]) { echo ' '; } if ($sql_chighflag_capture and $sql_chighflag_capture[flag_capture]) { echo ' '; } if ($sql_chighflag_kill and $sql_chighflag_kill[flag_kill]) { echo ' '; } if ($sql_chighdom_cp and $sql_chighdom_cp[dom_cp]) { echo ' '; } if ($sql_chighass_obj and $sql_chighass_obj[ass_obj]) { echo ' '; } if ($sql_chighspree_monster and $sql_chighspree_monster[spree_monster]) { echo ' '; } if ($sql_chighspree_god and $sql_chighspree_god[spree_god]) { echo ' '; } if ($sql_chighrank and $sql_chighrank[rank]) { echo ' '; } echo '

Career Highs
Category	Player	Amount	Hours	Matches
Frags	'.FlagImage($sql_chighfrags['country'], false).' '.$sql_chighfrags[name].'	'.$sql_chighfrags[frags].'	'.sec2hour($sql_chighfrags[sumgametime]).'	'.$sql_chighfrags[mcount].'
Deaths	'.FlagImage($sql_chighdeaths['country'], false).' '.$sql_chighdeaths[name].'	'.$sql_chighdeaths[deaths].'	'.sec2hour($sql_chighdeaths[sumgametime]).'	'.$sql_chighdeaths[mcount].'
Kills	'.FlagImage($sql_chighkills['country'], false).' '.$sql_chighkills[name].'	'.$sql_chighkills[kills].'	'.sec2hour($sql_chighkills[sumgametime]).'	'.$sql_chighkills[mcount].'
Suicides	'.FlagImage($sql_chighsuicides['country'], false).' '.$sql_chighsuicides[name].'	'.$sql_chighsuicides[suicides].'	'.sec2hour($sql_chighsuicides[sumgametime]).'	'.$sql_chighsuicides[mcount].'
Team Kills	'.FlagImage($sql_chighteamkills['country'], false).' '.$sql_chighteamkills[name].'	'.$sql_chighteamkills[teamkills].'	'.sec2hour($sql_chighteamkills[sumgametime]).'	'.$sql_chighteamkills[mcount].'
Efficiency	'.FlagImage($sql_chigheff['country'], false).' '.$sql_chigheff[name].'	'.get_dp($sql_chigheff[eff]).'	'.sec2hour($sql_chigheff[sumgametime]).'	'.$sql_chigheff[mcount].'
Accuracy	'.FlagImage($sql_chighaccuracy['country'], false).' '.$sql_chighaccuracy[name].'	'.get_dp($sql_chighaccuracy[accuracy]).'	'.sec2hour($sql_chighaccuracy[sumgametime]).'	'.$sql_chighaccuracy[mcount].'
TTL	'.FlagImage($sql_chighttl['country'], false).' '.$sql_chighttl[name].'	'.get_dp($sql_chighttl[ttl]).'	'.sec2hour($sql_chighttl[sumgametime]).'	'.$sql_chighttl[mcount].'
Flag Caps	'.FlagImage($sql_chighflag_capture['country'], false).' '.$sql_chighflag_capture[name].'	'.$sql_chighflag_capture[flag_capture].'	'.sec2hour($sql_chighflag_capture[sumgametime]).'	'.$sql_chighflag_capture[mcount].'
Flag Kills	'.FlagImage($sql_chighflag_kill['country'], false).' '.$sql_chighflag_kill[name].'	'.$sql_chighflag_kill[flag_kill].'	'.sec2hour($sql_chighflag_kill[sumgametime]).'	'.$sql_chighflag_kill[mcount].'
Domination Control Points	'.FlagImage($sql_chighdom_cp['country'], false).' '.$sql_chighdom_cp[name].'	'.$sql_chighdom_cp[dom_cp].'	'.sec2hour($sql_chighdom_cp[sumgametime]).'	'.$sql_chighdom_cp[mcount].'
Assault Objectives	'.FlagImage($sql_chighass_obj['country'], false).' '.$sql_chighass_obj[name].'	'.$sql_chighass_obj[ass_obj].'	'.sec2hour($sql_chighass_obj[sumgametime]).'	'.$sql_chighass_obj[mcount].'
Monster Kills	'.FlagImage($sql_chighspree_monster['country'], false).' '.$sql_chighspree_monster[name].'	'.$sql_chighspree_monster[spree_monster].'	'.sec2hour($sql_chighspree_monster[sumgametime]).'	'.$sql_chighspree_monster[mcount].'
Godlikes	'.FlagImage($sql_chighspree_god['country'], false).' '.$sql_chighspree_god[name].'	'.$sql_chighspree_god[spree_god].'	'.sec2hour($sql_chighspree_god[sumgametime]).'	'.$sql_chighspree_god[mcount].'
Rank Points	'.FlagImage($sql_chighrank['country'], false).' '.$sql_chighrank[name].'	'.get_dp($sql_chighrank[rank]).'	'.sec2hour($sql_chighrank[sumgametime]).'	'.$sql_chighrank[mcount].'

'; // NGStats Style Total Highs (Single Match) $sql_mhighfrags = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(frags) AS frags , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND frags > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY frags DESC LIMIT 0,1"); $sql_mhighdeaths = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(deaths) AS deaths , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND deaths > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY deaths DESC LIMIT 0,1"); $sql_mhighkills = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(kills) AS kills , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND kills > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY kills DESC LIMIT 0,1"); $sql_mhighsuicides = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(suicides) AS suicides , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND suicides > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY suicides DESC LIMIT 0,1"); $sql_mhighteamkills = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(teamkills) AS teamkills , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND teamkills > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY teamkills DESC LIMIT 0,1"); $sql_mhigheff = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(eff) AS eff , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND eff > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY eff DESC LIMIT 0,1"); $sql_mhighaccuracy = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(accuracy) AS accuracy , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND accuracy > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY accuracy DESC LIMIT 0,1"); $sql_mhighttl = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(ttl) AS ttl , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND ttl > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY ttl DESC LIMIT 0,1"); $sql_mhighflag_capture = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(flag_capture) AS flag_capture , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND flag_capture > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY flag_capture DESC LIMIT 0,1"); $sql_mhighflag_kill = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(flag_kill) AS flag_kill , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND flag_kill > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY flag_kill DESC LIMIT 0,1"); $sql_mhighdom_cp = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(dom_cp) AS dom_cp , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND dom_cp > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY dom_cp DESC LIMIT 0,1"); $ass_obj_check = small_query("SELECT COUNT(id) AS idcount FROM uts_games WHERE gamename LIKE '%Assault%';") or die(mysql_error()); IF ($ass_obj_check[idcount] > 0 ) { $sql_mhighass_obj = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(ass_obj) AS ass_obj , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND ass_obj > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY ass_obj DESC LIMIT 0,1"); } else { $sql_mhighass_obj = ""; } $sql_mhighspree_monster = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(spree_monster) AS spree_monster , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND spree_monster > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY spree_monster DESC LIMIT 0,1"); $sql_mhighspree_god = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(spree_god) AS spree_god , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND spree_god > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY spree_god DESC LIMIT 0,1"); $sql_mhighrank = small_query("SELECT p.matchid, p.pid, pi.name, p.country, SUM(rank) AS rank , SUM(gametime) AS sumgametime FROM uts_player AS p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND rank > 0 GROUP BY matchid, pid HAVING sumgametime > 600 ORDER BY rank DESC LIMIT 0,1"); echo''; if ($sql_mhighfrags) { echo ' '; } if ($sql_mhighdeaths) { echo ' '; } if ($sql_mhighkills) { echo ' '; } if ($sql_mhighsuicides) { echo ' '; } if ($sql_mhighteamkills) { echo ' '; } if ($sql_mhigheff) { echo ' '; } if ($sql_mhighaccuracy) { echo ' '; } if ($sql_mhighttl) { echo ' '; } if ($sql_mhighflag_capture) { echo ' '; } if ($sql_mhighflag_kill) { echo ' '; } if ($sql_mhighdom_cp) { echo ' '; } if ($sql_mhighass_obj) { echo ' '; } if ($sql_mhighspree_monster) { echo ' '; } if ($sql_mhighspree_god) { echo ' '; } if ($sql_mhighrank) { echo ' '; } echo '

Match Highs
Category	Player	Amount	Match
Frags	'.FlagImage($sql_mhighfrags['country'], false).' '.$sql_mhighfrags[name].'	'.$sql_mhighfrags[frags].'	(click)
Deaths	'.FlagImage($sql_mhighdeaths['country'], false).' '.$sql_mhighdeaths[name].'	'.$sql_mhighdeaths[deaths].'	(click)
Kills	'.FlagImage($sql_mhighkills['country'], false).' '.$sql_mhighkills[name].'	'.$sql_mhighkills[kills].'	(click)
Suicides	'.FlagImage($sql_mhighsuicides['country'], false).' '.$sql_mhighsuicides[name].'	'.$sql_mhighsuicides[suicides].'	(click)
Team Kills	'.FlagImage($sql_mhighteamkills['country'], false).' '.$sql_mhighteamkills[name].'	'.$sql_mhighteamkills[teamkills].'	(click)
Efficiency	'.FlagImage($sql_mhigheff['country'], false).' '.$sql_mhigheff[name].'	'.get_dp($sql_mhigheff[eff]).'	(click)
Accuracy	'.FlagImage($sql_mhighaccuracy['country'], false).' '.$sql_mhighaccuracy[name].'	'.get_dp($sql_mhighaccuracy[accuracy]).'	(click)
TTL	'.FlagImage($sql_mhighttl['country'], false).' '.$sql_mhighttl[name].'	'.get_dp($sql_mhighttl[ttl]).'	(click)
Flag Caps	'.FlagImage($sql_mhighflag_capture['country'], false).' '.$sql_mhighflag_capture[name].'	'.$sql_mhighflag_capture[flag_capture].'	(click)
Flag Kills	'.FlagImage($sql_mhighflag_kill['country'], false).' '.$sql_mhighflag_kill[name].'	'.$sql_mhighflag_kill[flag_kill].'	(click)
Domination Control Points	'.FlagImage($sql_mhighdom_cp['country'], false).' '.$sql_mhighdom_cp[name].'	'.$sql_mhighdom_cp[dom_cp].'	(click)
Assault Objectives	'.FlagImage($sql_mhighass_obj['country'], false).' '.$sql_mhighass_obj[name].'	'.$sql_mhighass_obj[ass_obj].'	(click)
Monster Kills	'.FlagImage($sql_mhighspree_monster['country'], false).' '.$sql_mhighspree_monster[name].'	'.$sql_mhighspree_monster[spree_monster].'	(click)
Godlikes	'.FlagImage($sql_mhighspree_god['country'], false).' '.$sql_mhighspree_god[name].'	'.$sql_mhighspree_god[spree_god].'	(click)
Rank Points	'.FlagImage($sql_mhighrank['country'], false).' '.$sql_mhighrank[name].'	'.get_dp($sql_mhighrank[rank]).'	(click)

'; $sql_mweapons = "SELECT id, name, image FROM uts_weapons WHERE hide <> 'Y' ORDER BY sequence, id ASC"; $q_mweapons = mysql_query($sql_mweapons) or die(mysql_error()); while ($r_mweapons = mysql_fetch_array($q_mweapons)) { $wid = $r_mweapons[id]; $sql_mweaponsl = "SELECT w.pid AS playerid, pi.name AS name, pi.country AS country, SUM(w.kills) as kills, COUNT(DISTINCT w.matchid) AS mcount FROM uts_weaponstats AS w LEFT JOIN uts_pinfo AS pi ON w.pid = pi.id WHERE w.weapon = '$wid' AND w.pid > 0 AND w.matchid <> 0 AND pi.banned <> 'Y' GROUP BY w.pid ORDER BY kills DESC LIMIT 0,1"; $q_mweaponsl = mysql_query($sql_mweaponsl) or die(mysql_error()); while ($r_mweaponsl = mysql_fetch_array($q_mweaponsl)) { echo ''; } } echo '

Weapon Career Highs
Category	Player	Kills	Matches
'.$r_mweapons[name].'	'.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].'	'.$r_mweaponsl[kills].'	'.$r_mweaponsl[mcount].'

'; // NGStats Style Weapon Highs (All Time) echo ' '; $sql_mweapons = "SELECT id, name, image FROM uts_weapons WHERE hide <> 'Y' ORDER BY sequence, id ASC"; $q_mweapons = mysql_query($sql_mweapons) or die(mysql_error()); while ($r_mweapons = mysql_fetch_array($q_mweapons)) { $wid = $r_mweapons[id]; $sql_mweaponsl = "SELECT w.matchid, w.pid AS playerid, pi.name AS name, pi.country AS country, w.kills FROM uts_weaponstats AS w LEFT JOIN uts_pinfo AS pi ON w.pid = pi.id WHERE w.weapon = '$wid' AND w.pid > 0 AND w.matchid > 0 AND pi.banned <> 'Y' ORDER BY w.kills DESC LIMIT 0,1"; $q_mweaponsl = mysql_query($sql_mweaponsl) or die(mysql_error()); while ($r_mweaponsl = mysql_fetch_array($q_mweaponsl)) { echo ''; } } // NGStats Style Weapon Highs (Single Match) echo'

Weapon Match Highs
Category	Player	Kills	Match
'.$r_mweapons[name].'	'.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].'	'.$r_mweaponsl[kills].'	(click)

'; ?>