NEW FEATURE: implement Lance's Schweinchen rule

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

diff --git a/include/welcome.php b/include/welcome.php
index 5436ecf5f1015902f4d0f1a84907b7b53ad33a72..d760c26c388be44ec9fd15d11f43451fc2cc7dfd 100644 (file)
--- a/include/welcome.php
+++ b/include/welcome.php
@@ -1,5 +1,5 @@
 <?php
-/* make sure that we are not called from outside the scripts, 
+/* make sure that we are not called from outside the scripts,
  * use a variable defined in config.php to check this
  */
 if(!isset($HOST))
@@ -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)
@@ -61,7 +64,7 @@ if($done==0)
 ?>
 
   <h4> Login/Register:</h4>
-  <p> 
+  <p>
   Please <a href="index.php?action=register">register</a>, in case you have not done that yet  <br />
   or login with you email-address or name and password here:
   </p>
@@ -84,5 +87,5 @@ if($done==0)
   </table>
   </fieldset>
   </form>
-  
-</div>  
\ No newline at end of file
+
+</div>
\ No newline at end of file