From 246c48b885be01d7d6eb63167b6d346cd314120d Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Wed, 16 Jul 2008 17:20:18 -0700 Subject: BUGFIX: wrong DB query returned sometime less rows than expected this fixes a bug on the home page where, in case no game was in the pre-game phase, the ongoing games were listed as games being started and the completed games were listed as ongoing games. Signed-off-by: Arun Persaud --- include/welcome.php | 15 +++++++++------ 1 file changed, 9 insertions(+), 6 deletions(-) diff --git a/include/welcome.php b/include/welcome.php index 5436ecf..654e968 100644 --- a/include/welcome.php +++ b/include/welcome.php @@ -9,12 +9,15 @@ if(!isset($HOST)) $pre[0]=0;$game[0]=0;$done[0]=0; -$r=DB_query("SELECT COUNT(id) FROM Game GROUP BY status"); -if($r) { - $pre = DB_fetch_array($r); - $game = DB_fetch_array($r); - $done = DB_fetch_array($r); - } +$r=DB_query("SELECT COUNT(*) FROM Game where status='pre'"); +if($r) $pre = DB_fetch_array($r); + +$r=DB_query("SELECT COUNT(*) FROM Game where status='play'"); +if($r) $game = DB_fetch_array($r); + +$r=DB_query("SELECT COUNT(*) FROM Game where status='gameover'"); +if($r) $done = DB_fetch_array($r); + $r=DB_query("SELECT AVG(datediff(mod_date,create_date)) FROM Game where status='gameover' "); if($r) -- cgit v1.2.3-18-g5258