From ba97ac2dae0f582781e713ee9aa8dae0449417a5 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Thu, 6 Aug 2009 21:04:33 -0700 Subject: [PATCH] BUGFIX: counted cancled games as active games in the statistics instead of testing if the game was in 'pre' or 'play' modus I just tested for <> 'gameover' which also included games which where canceled because of e.g. five nines. --- include/stats.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/include/stats.php b/include/stats.php index 1e6a033..f450880 100644 --- a/include/stats.php +++ b/include/stats.php @@ -190,7 +190,7 @@ if( !$content = getCache("cache/stats.html",60*60*24) ) " FROM Hand". " LEFT JOIN User ON User.id=user_id". " LEFT JOIN Game ON Game.id=game_id". - " WHERE Game.status<>'gameover'". + " WHERE Game.status IN ('pre','play')". " GROUP BY user_id". " ORDER BY c DESC LIMIT 7" ); array_unshift($result,array("Name","Number of active games")); -- 2.25.1