BUGFIX: solo statistics didn't include silent solo

[e-DoKo.git] / include / welcome.php

diff --git a/include/welcome.php b/include/welcome.php
index 5436ecf5f1015902f4d0f1a84907b7b53ad33a72..654e968faf5ccb2b15d16b9b02fc639830d3a5b3 100644 (file)
--- a/include/welcome.php
+++ b/include/welcome.php
@@ -9,12 +9,15 @@ if(!isset($HOST))
 
 $pre[0]=0;$game[0]=0;$done[0]=0;
 
 
 $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)
 
 $r=DB_query("SELECT AVG(datediff(mod_date,create_date)) FROM Game where status='gameover' ");
 if($r)