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 6eecd4bae8343fbe3b515cee2ee6c88a21206724..cd03f579b3e5ea746c606efc0b0645e72a6d7a36 100644 (file)
--- 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'".
                                " 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";
                  $message .= "\nTotals:\n";
                  while( $r = mysql_fetch_array($result,MYSQL_NUM))
                    $message .= "    ".$r[0]." ".$r[1]."\n";