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

[e-DoKo.git] / db.php

diff --git a/db.php b/db.php
index 1c20b8e2051272b685e055e41d9709ee7256c2a7..bae70cbc943b7273f4478bce795c0d64871bb34c 100644 (file)
--- a/db.php
+++ b/db.php
@@ -771,9 +771,9 @@ function DB_get_PREF($myid)
 
 function DB_get_unused_randomnumbers($userstr)
 {
-  $queryresult = mysql_query("SELECT randomnumbers,Game.id FROM Game ".
+  $queryresult = mysql_query("SELECT randomnumbers,Game.id, COUNT(*) as num FROM Game ".
                             "  LEFT JOIN Hand ON Hand.game_id=Game.id ".
-                            "                 AND  user_id not in (".$userstr.")".
+                            "                 AND user_id not in (".$userstr.")".
                             "  GROUP BY  Game.id ".
                             "  HAVING num=4");