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/home.php | 13 +++++++++---- 1 file changed, 9 insertions(+), 4 deletions(-) (limited to 'html/pages/home.php') diff --git a/html/pages/home.php b/html/pages/home.php index 3cb167d..be75b66 100755 --- a/html/pages/home.php +++ b/html/pages/home.php @@ -57,10 +57,14 @@ echo' '; $sql_gamesummary = "SELECT g.id AS gid, g.name AS gamename, 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 -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 gamename, gid +ORDER BY gamename ASC"; + $q_gamesummary = mysql_query($sql_gamesummary) or die(mysql_error()); -while ($r_gamesummary = mysql_fetch_array($q_gamesummary)) { +while ($r_gamesummary = mysql_fetch_array($q_gamesummary)) { $gid = $r_gamesummary[gid]; $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match WHERE gid = '$gid'"); @@ -76,7 +80,8 @@ while ($r_gamesummary = mysql_fetch_array($q_gamesummary)) { } $totalsummary = small_query("SELECT 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 gametime -FROM uts_player AS p, uts_games AS g WHERE p.gid = g.id"); +FROM uts_player AS p, uts_games AS g +WHERE p.gid = g.id"); $q_gametime = small_query("SELECT SUM(gametime) AS gametime FROM uts_match"); $gametime = sec2hour($q_gametime[gametime]); @@ -97,4 +102,4 @@ echo' $gtitle = "Across All Servers"; $bgwhere = "id >= 0"; include("pages/graph_mbreakdown.php"); -?> \ No newline at end of file +?> -- cgit