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/match_info_other.php | 61 +++++++++++++++++++++++------------------ 1 file changed, 35 insertions(+), 26 deletions(-) (limited to 'html/pages/match_info_other.php') diff --git a/html/pages/match_info_other.php b/html/pages/match_info_other.php index d0a3527..21dfca4 100755 --- a/html/pages/match_info_other.php +++ b/html/pages/match_info_other.php @@ -10,28 +10,33 @@ echo'
Special Events - Player - First Blood - Multis - Sprees + Player + First Blood + Multis + Sprees - Dbl - Multi - Ultra - Mons - Kill - Ram - Dom - Uns - God + Dbl + Multi + Ultra + Mons + Kill + Ram + Dom + Uns + God '; + $sql_firstblood = small_query("SELECT firstblood FROM uts_match WHERE id = $mid"); $sql_multis = "SELECT p.pid, pi.name, p.country, SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster, 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 as p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid GROUP BY pid ORDER BY name ASC"; +FROM uts_player as p, uts_pinfo AS pi +WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid +GROUP BY pid, p.country +ORDER BY name ASC"; + $q_multis = mysql_query($sql_multis) or die(mysql_error()); $i = 0; while ($r_multis = zero_out(mysql_fetch_array($q_multis))) { @@ -42,17 +47,17 @@ while ($r_multis = zero_out(mysql_fetch_array($q_multis))) { echo' - '.FormatPlayerName($r_multis[country], $r_multis[pid], $r_pname, $gid, $gamename).' - ', ($sql_firstblood['firstblood'] == $r_multis['pid'] ? "Yes": ""), ' - '.$r_multis[spree_double].' - '.$r_multis[spree_multi].' - '.$r_multis[spree_ultra].' - '.$r_multis[spree_monster].' - '.$r_multis[spree_kill].' - '.$r_multis[spree_rampage].' - '.$r_multis[spree_dom].' - '.$r_multis[spree_uns].' - '.$r_multis[spree_god].' + '.FormatPlayerName($r_multis[country], $r_multis[pid], $r_pname, $gid, $gamename).' + ', ($sql_firstblood['firstblood'] == $r_multis['pid'] ? "Yes": ""), ' + '.$r_multis[spree_double].' + '.$r_multis[spree_multi].' + '.$r_multis[spree_ultra].' + '.$r_multis[spree_monster].' + '.$r_multis[spree_kill].' + '.$r_multis[spree_rampage].' + '.$r_multis[spree_dom].' + '.$r_multis[spree_uns].' + '.$r_multis[spree_god].' '; } @@ -75,7 +80,11 @@ if ((strpos($gamename, '(insta)') === false) && (strpos($gamename, "Last Man Sta $sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg, SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp - FROM uts_player as p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid GROUP BY pid ORDER BY name ASC"; + FROM uts_player as p, uts_pinfo AS pi + WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid + GROUP BY pid, p.country + ORDER BY name ASC"; + $q_pickups = mysql_query($sql_pickups) or die(mysql_error()); $i = 0; while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) { -- cgit