added output of average time for a game on the homepage

[e-DoKo.git] / index.php

diff --git a/index.php b/index.php
index 10416f1610974a33588be7dcaeff8aed745c3bcb..0bb04d4c0044e4f37e234a3cd17d58e9191783b7 100644 (file)
--- a/index.php
+++ b/index.php
@@ -1059,7 +1059,7 @@ else if(myisset("me"))
              else
                echo "(wedding)";
          
-         if(substr_compare($GT,"solo",0,4)==0 && $party=="re")
+         if(ereg("solo",$GT) && $party=="re")
             echo "($GT)";
 
          /* add point calls */
@@ -1731,7 +1731,14 @@ else if(myisset("me"))
        $game = mysql_fetch_array($r,MYSQL_NUM);     
        $done = mysql_fetch_array($r,MYSQL_NUM);     
      }
-     output_home_page($pre[0],$game[0],$done[0]);
+
+     $r=mysql_query("SELECT AVG(datediff(mod_date,create_date)) FROM Game where status='gameover' ");
+     if($r)
+       $avgage= mysql_fetch_array($r,MYSQL_NUM);     
+     else
+       $avgage[0]=0;
+
+     output_home_page($pre[0],$game[0],$done[0],$avgage[0]);
    }
 
 output_footer();