summaryrefslogtreecommitdiffstats
path: root/db.php
diff options
context:
space:
mode:
authorArun Persaud <arun@nubati.net>2007-06-25 11:44:30 +0200
committerArun Persaud <arun@nubati.net>2007-06-25 11:44:30 +0200
commit18ed58881d0bb23749cbd27f02b7ae0ed69fbd3f (patch)
tree72c6507c908f4aeb24af4cd8191690d62e9459b0 /db.php
parent822dd99d21ade0e223428976d5f9d72de1e3439b (diff)
downloade-DoKo-18ed58881d0bb23749cbd27f02b7ae0ed69fbd3f.tar.gz
e-DoKo-18ed58881d0bb23749cbd27f02b7ae0ed69fbd3f.tar.bz2
e-DoKo-18ed58881d0bb23749cbd27f02b7ae0ed69fbd3f.zip
BUGFIX: fixed bug in getting randomnumbers from a previous game
DB querry was missing a column
Diffstat (limited to 'db.php')
-rw-r--r--db.php4
1 files changed, 2 insertions, 2 deletions
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");