From 8a9ed1ff99fcb888818c2efec5807a8a3e896e04 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sun, 18 Jan 2009 12:01:24 -0800 Subject: [PATCH] BUGFIX: error in card dealing routine same hand got dealt twice due to an error in the new routine. Fixed it, but slowed it down again to roughly 2s per request. --- include/db.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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;"); -- 2.34.1