From 18ed58881d0bb23749cbd27f02b7ae0ed69fbd3f Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Mon, 25 Jun 2007 11:44:30 +0200
Subject: BUGFIX: fixed bug in getting randomnumbers from a previous game
DB querry was missing a column
---
db.php | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
(limited to 'db.php')
diff --git a/db.php b/db.php
index 1c20b8e..bae70cb 100644
--- 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");
--
cgit v1.2.3-18-g5258