From: Arun Persaud <arun@nubati.net>
Date: Fri, 29 Jun 2007 11:10:18 +0000 (+0200)
Subject: BUGFIX: final email didn't add up points for re/contra
X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=commitdiff_plain;h=90c9f0ee729d1960df96989b2b38d77f16ec1284;ds=sidebyside

BUGFIX: final email didn't add up points for re/contra

had a wrong GROUP BY SQL statement in the code.
---

diff --git a/index.php b/index.php
index 6eecd4b..cd03f57 100644
--- a/index.php
+++ b/index.php
@@ -1475,7 +1475,7 @@ else if(myisset("me"))
 				" LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id".
 				" LEFT JOIN Card ON Card.id=Hand_Card.card_id".
 				" WHERE Hand.game_id='$gameid'".
-				" GROUP BY User.fullname" );
+				" GROUP BY Hand.party" );
 		  $message .= "\nTotals:\n";
 		  while( $r = mysql_fetch_array($result,MYSQL_NUM))
 		    $message .= "    ".$r[0]." ".$r[1]."\n";