X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fdb.php;h=6e1af93c31faa2c64fd5a000467eade4bc5d8143;hp=6d4080c26ceefaa17232503a9e49e82af096b8a3;hb=8a9ed1ff99fcb888818c2efec5807a8a3e896e04;hpb=ad182154235ff016634c998e52875721f00c4eb0

diff --git a/include/db.php b/include/db.php
index 6d4080c..6e1af93 100644
--- a/include/db.php
+++ b/include/db.php
@@ -820,7 +820,7 @@ function DB_get_unused_randomnumbers($userstr)
   */
   DB_query("DROP   TEMPORARY TABLE IF EXISTS gametmp;");
   DB_query("CREATE TEMPORARY TABLE gametmp SELECT id,randomnumbers FROM Game;");
-  DB_query("DELETE FROM gametmp WHERE id IN (SELECT game_id FROM Hand WHERE user_id IN (".$userstr."));");
+  DB_query("DELETE FROM gametmp WHERE randomnumbers IN (SELECT randomnumbers FROM Hand LEFT JOIN Game ON Game.id=game_id WHERE user_id IN (".$userstr."));");
 
   $r = DB_query_array("SELECT randomnumbers FROM gametmp LIMIT 1;");
   DB_query("DROP   TEMPORARY TABLE IF EXISTS gametmp;");