From 981c12ce5d5aaf606584a4ab59054316d2b6c6c2 Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sun, 4 May 2008 19:40:10 -0700 Subject: NEW FEATURES: show global statistic show points/game for all players that have 10 or more games Signed-off-by: Arun Persaud --- include/db.php | 13 +++++++++---- 1 file changed, 9 insertions(+), 4 deletions(-) (limited to 'include/db.php') diff --git a/include/db.php b/include/db.php index 42d2bef..b13c0f0 100644 --- a/include/db.php +++ b/include/db.php @@ -919,10 +919,15 @@ function DB_get_gameids_of_finished_games_by_session($session) { $ids = array (); - $queryresult = mysql_query("SELECT id FROM Game ". - " WHERE session=$session ". - " AND status='gameover' ". - " ORDER BY create_date ASC"); + if($session==0) /* return all games */ + $queryresult = mysql_query("SELECT id FROM Game ". + " WHERE status='gameover' ". + " ORDER BY create_date ASC"); + else /* return games in a session */ + $queryresult = mysql_query("SELECT id FROM Game ". + " WHERE session=$session ". + " AND status='gameover' ". + " ORDER BY create_date ASC"); $i=0; while($r = mysql_fetch_array($queryresult,MYSQL_NUM) ) -- cgit v1.2.3-18-g5258