From 910da8ec88cb67f13b84edbc0e61062b4789a8ab Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Fri, 20 Jul 2007 11:09:00 -0700 Subject: BUGFIX: reusing old randomnumbers didn't work old numbers got reused, but more than once for the same people should be fixed now. --- db.php | 13 ++++++++----- 1 file changed, 8 insertions(+), 5 deletions(-) (limited to 'db.php') diff --git a/db.php b/db.php index 50cc3e5..41e4479 100644 --- a/db.php +++ b/db.php @@ -797,11 +797,14 @@ function DB_get_PREF($myid) function DB_get_unused_randomnumbers($userstr) { - $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.")". - " GROUP BY Game.id ". - " HAVING num=4"); + $queryresult = mysql_query(" SELECT randomnumbers FROM Game". + " WHERE randomnumbers NOT IN". + " (SELECT randomnumbers FROM Game". + " LEFT JOIN Hand ON Game.id=Hand.game_id". + " WHERE user_id IN (". $userstr .")". + " GROUP BY randomnumbers". + " )"); + $r = mysql_fetch_array($queryresult,MYSQL_NUM); if($r) -- cgit v1.2.3-18-g5258