From 65d3845752e76b9f1895cd9e2bf1a4fa6021f0af Mon Sep 17 00:00:00 2001
From: arun <arun@nubati.net>
Date: Sat, 2 Jun 2007 16:25:28 +0000
Subject: [PATCH] added output of average time for a game on the homepage

---
 index.php  | 9 ++++++++-
 output.php | 4 ++--
 2 files changed, 10 insertions(+), 3 deletions(-)

diff --git a/index.php b/index.php
index 1a825de..0bb04d4 100644
--- a/index.php
+++ b/index.php
@@ -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();
diff --git a/output.php b/output.php
index 75d0135..0871bcc 100644
--- a/output.php
+++ b/output.php
@@ -282,7 +282,7 @@ function check_want_to_play($me)
   return;
 }
 
-function output_home_page($pre,$game,$done)
+function output_home_page($pre,$game,$done,$avgtime)
 {
 ?>
     <p> If you want to play a game of Doppelkopf, you found the right place ;) </p>
@@ -308,7 +308,7 @@ function output_home_page($pre,$game,$done)
     else if($done==1)
       echo "One game has been completed on this server. </p>";
     else
-      echo "$done games have been completed on this server. </p>";
+      echo "$done games have been completed on this server. Average time of a game: $avgtime days</p>";
 ?>
 
     <p> Please <a href="index.php?register">register</a>, in case you haven't done that yet  <br />
-- 
2.34.1