diff options
author | Arun Persaud <arun@nubati.net> | 2007-06-25 11:44:30 +0200 |
---|---|---|
committer | Arun Persaud <arun@nubati.net> | 2007-06-25 11:44:30 +0200 |
commit | 18ed58881d0bb23749cbd27f02b7ae0ed69fbd3f (patch) | |
tree | 72c6507c908f4aeb24af4cd8191690d62e9459b0 /db.php | |
parent | 822dd99d21ade0e223428976d5f9d72de1e3439b (diff) | |
download | e-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.php | 4 |
1 files changed, 2 insertions, 2 deletions
@@ -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"); |