From 3a58cb2802c8be14f78015105afe759b1c7ce692 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Tue, 9 Jan 2018 00:43:43 +0100 Subject: Implement design for pages and update includes --- html/pages/totals.php | 565 ++++++++++++++++++++++++-------------------------- 1 file changed, 274 insertions(+), 291 deletions(-) (limited to 'html/pages/totals.php') diff --git a/html/pages/totals.php b/html/pages/totals.php index e5b5126..0e81f82 100755 --- a/html/pages/totals.php +++ b/html/pages/totals.php @@ -1,31 +1,25 @@ - - - Totals Summary - - -
- + +
- + - - - - - - - - - '; + + + + + + + + + + - - - - - - - - - '; + + + + + + + + + + '; } $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")); + FROM uts_player")); $gametime2 = sec2hour($sql_summtot[sumgametime]); echo' - - - - - - - - + + + + + + + +
SummarySummary
Game TypeScoreFragsKillsSuicidesTeam KillsMatchesHours
Game TypeScoreFragsKillsSuicidesTeam KillsMatchesHours
'.$r_totsumm[gamename].''.$r_totsumm[gamescore].''.$r_totsumm[frags].''.$r_totsumm[kills].''.$r_totsumm[suicides].''.$r_totsumm[teamkills].''.$r_totsumm[matchcount].''.$gametime.'
'.$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.'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()); @@ -98,23 +92,23 @@ echo' echo' - - - - - - - - - - - + + + + + + + + + + +
Assault, Domination and CTF Events SummaryAssault, Domination and CTF Events Summary
Assault ObjectivesControl Point CapturesCapture The FlagAssault ObjectivesControl Point CapturesCapture The Flag
Flag TakesFlag PickupsFlag DropsFlag AssistsFlag CoversFlag SealsFlag CapturesFlag KillsFlag ReturnsFlag TakesFlag PickupsFlag DropsFlag AssistsFlag CoversFlag SealsFlag CapturesFlag KillsFlag 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_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 != ''")); @@ -123,38 +117,38 @@ $sql_sprees = zero_out(small_query("SELECT SUM(spree_kill) AS spree_kill, SUM(sp echo' - - + + - - - - + + + + - - - - + + + + - - - - + + + + - - - - + + + + - - - - + + + +
Special EventsSpecial Events
Special/MultisSpreesSpecial/MultisSprees
First Blood'.$sql_firstblood.'Killing Spree'.$sql_sprees[spree_kill].'First Blood'.$sql_firstblood.'Killing Spree'.$sql_sprees[spree_kill].'
Double Kills'.$sql_multis[spree_double].'Rampage'.$sql_sprees[spree_rampage].'Double Kills'.$sql_multis[spree_double].'Rampage'.$sql_sprees[spree_rampage].'
Multi Kills'.$sql_multis[spree_multi].'Dominating'.$sql_sprees[spree_dom].'Multi Kills'.$sql_multis[spree_multi].'Dominating'.$sql_sprees[spree_dom].'
Ultra Kills'.$sql_multis[spree_ultra].'Unstoppable'.$sql_sprees[spree_uns].'Ultra Kills'.$sql_multis[spree_ultra].'Unstoppable'.$sql_sprees[spree_uns].'
Monster Kills'.$sql_multis[spree_monster].'Godlike'.$sql_sprees[spree_god].'Monster Kills'.$sql_multis[spree_monster].'Godlike'.$sql_sprees[spree_god].'

'; @@ -163,9 +157,9 @@ include('includes/weaponstats.php'); weaponstats(0, 0); echo'
- +
- +
Totals for PlayersTotals for Players
'; @@ -181,8 +175,8 @@ $sql_chighttl = small_query("SELECT p.pid, pi.name, p.country, AVG(ttl) AS ttl , $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, p.country 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, p.country 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, p.country 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 { @@ -193,168 +187,167 @@ $sql_chighspree_monster = small_query("SELECT p.pid, pi.name, p.country, SUM(spr $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, p.country 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, p.country HAVING sumgametime > 1800 ORDER BY rank DESC LIMIT 0,1"); -echo'
- +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 ' @@ -362,7 +355,6 @@ echo '
'; // 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, country 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, country 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, country HAVING sumgametime > 600 ORDER BY kills DESC LIMIT 0,1"); @@ -386,193 +378,184 @@ $sql_mhighspree_monster = small_query("SELECT p.matchid, p.pid, pi.name, p.count $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, country 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, country HAVING sumgametime > 600 ORDER BY rank DESC LIMIT 0,1"); -echo'
Career HighsCareer Highs
CategoryPlayerAmountHoursMatchesCategoryPlayerAmountHoursMatches
Frags'.FlagImage($sql_chighfrags['country'], false).' '.$sql_chighfrags[name].''.$sql_chighfrags[frags].''.sec2hour($sql_chighfrags[sumgametime]).''.$sql_chighfrags[mcount].'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].'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].'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].'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].'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].'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].'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].'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 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].'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].'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].'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].'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].'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].'Rank Points'.FlagImage($sql_chighrank['country'], false).' '.$sql_chighrank[name].''.get_dp($sql_chighrank[rank]).''.sec2hour($sql_chighrank[sumgametime]).''.$sql_chighrank[mcount].'
+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 ' - - - - + + + + '; } - echo '
Match HighsMatch Highs
CategoryPlayerAmountMatchCategoryPlayerAmountMatch
Frags'.FlagImage($sql_mhighfrags['country'], false).' '.$sql_mhighfrags[name].''.$sql_mhighfrags[frags].'(click)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)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)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)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)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)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)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)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 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)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)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)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)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)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)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"; + $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 ' + + + + + '; + } } @@ -581,37 +564,37 @@ echo '
Weapon Career Highs
CategoryPlayerKillsMatchesWeapon Career Highs
CategoryPlayerKillsMatches
'.$r_mweapons[name].''.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].''.$r_mweaponsl[kills].''.$r_mweaponsl[mcount].'
'.$r_mweapons[name].''.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].''.$r_mweaponsl[kills].''.$r_mweaponsl[mcount].'
// NGStats Style Weapon Highs (All Time) -echo ' - - - +echo '
Weapon Match Highs
+ + + - - - - - '; + + + + + +'; $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 ' - - - - - '; + + echo ' + + + + + '; } } // NGStats Style Weapon Highs (Single Match) echo'
Weapon Match Highs
CategoryPlayerKillsMatch
CategoryPlayerKillsMatch
'.$r_mweapons[name].''.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].''.$r_mweaponsl[kills].'(click)
'.$r_mweapons[name].''.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].''.$r_mweaponsl[kills].'(click)
'; - ?> -- cgit