BUGFIX: showed cancled games in user menu
authorArun Persaud <arun@nubati.net>
Fri, 3 Apr 2009 20:07:47 +0000 (13:07 -0700)
committerArun Persaud <arun@nubati.net>
Fri, 3 Apr 2009 20:07:47 +0000 (13:07 -0700)
used to test for 'pre' or 'play' games by doing a ...!='gameover', this doesn't work
anymore with canceled games being another option for the game status.

include/functions.php

index d99f9c8732f5757aa14cfcc8ee5caba56104b790..7bdfd31d8121868d4a81c081a6a58347ad2c50c0 100644 (file)
@@ -942,7 +942,7 @@ function display_user_menu($id)
                     " LEFT JOIN Game On Hand.game_id=Game.id".
                     " WHERE Hand.user_id='$id'".
                     " AND ( Game.player='$id' OR ISNULL(Game.player) )".
                     " LEFT JOIN Game On Hand.game_id=Game.id".
                     " WHERE Hand.user_id='$id'".
                     " AND ( Game.player='$id' OR ISNULL(Game.player) )".
-                    " AND Game.status<>'gameover'".
+                    " AND ( Game.status='pre' OR Game.status='play' )".
                     " ORDER BY Game.session" );
 
   $i=0;
                     " ORDER BY Game.session" );
 
   $i=0;