X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=db.php;h=bae70cbc943b7273f4478bce795c0d64871bb34c;hp=a78afb6aa744d58550385e0084abc56e69978ddd;hb=14cdf8ad54e90d7b208b72cd0bfd568e9c22bc32;hpb=26c07fd03d0bf3bdd6142f0474b625afcfae508b

diff --git a/db.php b/db.php
index a78afb6..bae70cb 100644
--- a/db.php
+++ b/db.php
@@ -466,7 +466,7 @@ function DB_get_current_trickid($gameid)
   
   if(!$sequence || $sequence==4)
     {
-      mysql_query("INSERT INTO Trick VALUES (NULL,NULL,NULL, ".DB_quote_smart($gameid).")");
+      mysql_query("INSERT INTO Trick VALUES (NULL,NULL,NULL, ".DB_quote_smart($gameid).",NULL)");
       $trickid  = mysql_insert_id();
       $sequence = 1;
       $number++;
@@ -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");