summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--include/welcome.php15
1 files 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)