From 7abeb203d8b6d537a55b0dd9a1ccac32e6f948ec Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Sat, 4 Feb 2017 23:57:49 +0100 Subject: Fix MySQL ONLY_FULL_GROUP_BY errors --- html/pages/totals.php | 185 ++++++++++++++++++++++++++------------------------ 1 file changed, 98 insertions(+), 87 deletions(-) (limited to 'html/pages/totals.php') diff --git a/html/pages/totals.php b/html/pages/totals.php index 64acedd..e5b5126 100755 --- a/html/pages/totals.php +++ b/html/pages/totals.php @@ -22,10 +22,14 @@ echo' '; $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"; +FROM uts_player AS p, uts_games AS g +WHERE p.gid = g.id +GROUP BY g.name +ORDER BY gamename ASC"; + $q_totsumm = mysql_query($sql_totsumm) or die(mysql_error()); -while ($r_totsumm = zero_out(mysql_fetch_array($q_totsumm))) { +while ($r_totsumm = zero_out(mysql_fetch_array($q_totsumm))) { $gametime = sec2hour($r_totsumm[sumgametime]); echo' @@ -166,29 +170,28 @@ echo'
'; // 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"); +$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, p.country 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, p.country 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, p.country 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, p.country 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, p.country 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, p.country 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, p.country 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, p.country 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, 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 ) { +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"); +$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, p.country 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, 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'
@@ -203,8 +206,9 @@ echo'
'; + if ($sql_chighfrags and $sql_chighfrags[frags]) { - echo ' + echo ' @@ -214,7 +218,7 @@ if ($sql_chighfrags and $sql_chighfrags[frags]) { '; } if ($sql_chighdeaths and $sql_chighdeaths[deaths]) { - echo ' + echo ' @@ -224,7 +228,7 @@ if ($sql_chighdeaths and $sql_chighdeaths[deaths]) { '; } if ($sql_chighkills and $sql_chighkills[kills]) { - echo ' + echo ' @@ -234,7 +238,7 @@ if ($sql_chighkills and $sql_chighkills[kills]) { '; } if ($sql_chighsuicides and $sql_chighsuicides[suicides]) { - echo ' + echo ' @@ -244,7 +248,7 @@ if ($sql_chighsuicides and $sql_chighsuicides[suicides]) { '; } if ($sql_chighteamkills and $sql_chighteamkills[teamkills]) { - echo ' + echo ' @@ -254,7 +258,7 @@ if ($sql_chighteamkills and $sql_chighteamkills[teamkills]) { '; } if ($sql_chigheff and $sql_chigheff[eff]) { - echo ' + echo ' @@ -264,7 +268,7 @@ if ($sql_chigheff and $sql_chigheff[eff]) { '; } if ($sql_chighaccuracy and $sql_chighaccuracy[accuracy]) { - echo ' + echo ' @@ -274,7 +278,7 @@ if ($sql_chighaccuracy and $sql_chighaccuracy[accuracy]) { '; } if ($sql_chighttl and $sql_chighttl[ttl]) { - echo ' + echo ' @@ -284,7 +288,7 @@ if ($sql_chighttl and $sql_chighttl[ttl]) { '; } if ($sql_chighflag_capture and $sql_chighflag_capture[flag_capture]) { - echo ' + echo ' @@ -294,7 +298,7 @@ if ($sql_chighflag_capture and $sql_chighflag_capture[flag_capture]) { '; } if ($sql_chighflag_kill and $sql_chighflag_kill[flag_kill]) { - echo ' + echo ' @@ -304,7 +308,7 @@ if ($sql_chighflag_kill and $sql_chighflag_kill[flag_kill]) { '; } if ($sql_chighdom_cp and $sql_chighdom_cp[dom_cp]) { - echo ' + echo ' @@ -314,7 +318,7 @@ if ($sql_chighdom_cp and $sql_chighdom_cp[dom_cp]) { '; } if ($sql_chighass_obj and $sql_chighass_obj[ass_obj]) { - echo ' + echo ' @@ -324,7 +328,7 @@ if ($sql_chighass_obj and $sql_chighass_obj[ass_obj]) { '; } if ($sql_chighspree_monster and $sql_chighspree_monster[spree_monster]) { - echo ' + echo ' @@ -334,7 +338,7 @@ if ($sql_chighspree_monster and $sql_chighspree_monster[spree_monster]) { '; } if ($sql_chighspree_god and $sql_chighspree_god[spree_god]) { - echo ' + echo ' @@ -344,7 +348,7 @@ if ($sql_chighspree_god and $sql_chighspree_god[spree_god]) { '; } if ($sql_chighrank and $sql_chighrank[rank]) { - echo ' + echo ' @@ -357,31 +361,30 @@ echo '
Hours Matches
Frags '.FlagImage($sql_chighfrags['country'], false).' '.$sql_chighfrags[name].'
Deaths '.FlagImage($sql_chighdeaths['country'], false).' '.$sql_chighdeaths[name].'
Kills '.FlagImage($sql_chighkills['country'], false).' '.$sql_chighkills[name].'
Suicides '.FlagImage($sql_chighsuicides['country'], false).' '.$sql_chighsuicides[name].'
Team Kills '.FlagImage($sql_chighteamkills['country'], false).' '.$sql_chighteamkills[name].'
Efficiency '.FlagImage($sql_chigheff['country'], false).' '.$sql_chigheff[name].'
Accuracy '.FlagImage($sql_chighaccuracy['country'], false).' '.$sql_chighaccuracy[name].'
TTL '.FlagImage($sql_chighttl['country'], false).' '.$sql_chighttl[name].'
Flag Caps '.FlagImage($sql_chighflag_capture['country'], false).' '.$sql_chighflag_capture[name].'
Flag Kills '.FlagImage($sql_chighflag_kill['country'], false).' '.$sql_chighflag_kill[name].'
Domination Control Points '.FlagImage($sql_chighdom_cp['country'], false).' '.$sql_chighdom_cp[name].'
Assault Objectives '.FlagImage($sql_chighass_obj['country'], false).' '.$sql_chighass_obj[name].'
Monster Kills '.FlagImage($sql_chighspree_monster['country'], false).' '.$sql_chighspree_monster[name].'
Godlikes '.FlagImage($sql_chighspree_god['country'], false).' '.$sql_chighspree_god[name].'
Rank Points '.FlagImage($sql_chighrank['country'], false).' '.$sql_chighrank[name].'

'; - // 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"); +$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"); +$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, country 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, country 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, country 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, country 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, country 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, country 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, country 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, country 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"); +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, country 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"); +$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, country 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, 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' @@ -396,7 +399,7 @@ echo'
'; if ($sql_mhighfrags) { - echo ' + echo ' @@ -405,7 +408,7 @@ if ($sql_mhighfrags) { '; } if ($sql_mhighdeaths) { - echo ' + echo ' @@ -414,7 +417,7 @@ if ($sql_mhighdeaths) { '; } if ($sql_mhighkills) { - echo ' + echo ' @@ -423,7 +426,7 @@ if ($sql_mhighkills) { '; } if ($sql_mhighsuicides) { - echo ' + echo ' @@ -432,7 +435,7 @@ if ($sql_mhighsuicides) { '; } if ($sql_mhighteamkills) { - echo ' + echo ' @@ -441,7 +444,7 @@ if ($sql_mhighteamkills) { '; } if ($sql_mhigheff) { - echo ' + echo ' @@ -450,7 +453,7 @@ if ($sql_mhigheff) { '; } if ($sql_mhighaccuracy) { - echo ' + echo ' @@ -459,7 +462,7 @@ if ($sql_mhighaccuracy) { '; } if ($sql_mhighttl) { - echo ' + echo ' @@ -468,7 +471,7 @@ if ($sql_mhighttl) { '; } if ($sql_mhighflag_capture) { - echo ' + echo ' @@ -477,7 +480,7 @@ if ($sql_mhighflag_capture) { '; } if ($sql_mhighflag_kill) { - echo ' + echo ' @@ -486,7 +489,7 @@ if ($sql_mhighflag_kill) { '; } if ($sql_mhighdom_cp) { - echo ' + echo ' @@ -495,7 +498,7 @@ if ($sql_mhighdom_cp) { '; } if ($sql_mhighass_obj) { - echo ' + echo ' @@ -504,7 +507,7 @@ if ($sql_mhighass_obj) { '; } if ($sql_mhighspree_monster) { - echo ' + echo ' @@ -513,7 +516,7 @@ if ($sql_mhighspree_monster) { '; } if ($sql_mhighspree_god) { - echo ' + echo ' @@ -522,7 +525,7 @@ if ($sql_mhighspree_god) { '; } if ($sql_mhighrank) { - echo ' + echo ' @@ -530,6 +533,7 @@ if ($sql_mhighrank) { '; } + echo '
Frags '.FlagImage($sql_mhighfrags['country'], false).' '.$sql_mhighfrags[name].'
Deaths '.FlagImage($sql_mhighdeaths['country'], false).' '.$sql_mhighdeaths[name].'
Kills '.FlagImage($sql_mhighkills['country'], false).' '.$sql_mhighkills[name].'
Suicides '.FlagImage($sql_mhighsuicides['country'], false).' '.$sql_mhighsuicides[name].'
Team Kills '.FlagImage($sql_mhighteamkills['country'], false).' '.$sql_mhighteamkills[name].'
Efficiency '.FlagImage($sql_mhigheff['country'], false).' '.$sql_mhigheff[name].'
Accuracy '.FlagImage($sql_mhighaccuracy['country'], false).' '.$sql_mhighaccuracy[name].'
TTL '.FlagImage($sql_mhighttl['country'], false).' '.$sql_mhighttl[name].'
Flag Caps '.FlagImage($sql_mhighflag_capture['country'], false).' '.$sql_mhighflag_capture[name].'
Flag Kills '.FlagImage($sql_mhighflag_kill['country'], false).' '.$sql_mhighflag_kill[name].'
Domination Control Points '.FlagImage($sql_mhighdom_cp['country'], false).' '.$sql_mhighdom_cp[name].'
Assault Objectives '.FlagImage($sql_mhighass_obj['country'], false).' '.$sql_mhighass_obj[name].'
Monster Kills '.FlagImage($sql_mhighspree_monster['country'], false).' '.$sql_mhighspree_monster[name].'
Godlikes '.FlagImage($sql_mhighspree_god['country'], false).' '.$sql_mhighspree_god[name].'
Rank Points '.FlagImage($sql_mhighrank['country'], false).' '.$sql_mhighrank[name].'(click)

@@ -546,22 +550,29 @@ 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)) { +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 ' - '.$r_mweapons[name].' - '.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].' - '.$r_mweaponsl[kills].' - '.$r_mweaponsl[mcount].' - '; + $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 ' + '.$r_mweapons[name].' + '.FlagImage($r_mweaponsl[country], false).' '.$r_mweaponsl[name].' + '.$r_mweaponsl[kills].' + '.$r_mweaponsl[mcount].' + '; } } @@ -571,8 +582,8 @@ echo ' // NGStats Style Weapon Highs (All Time) echo ' - - + + @@ -580,27 +591,27 @@ echo '
Weapon Match Highs
Player - -'; + '; $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)) { +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 ' - - - - - '; + while ($r_mweaponsl = mysql_fetch_array($q_mweaponsl)) { + echo ' + + + + + '; } } // NGStats Style Weapon Highs (Single Match) echo'
Kills Match
'.$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