diff options
-rw-r--r-- | index.php | 9 | ||||
-rw-r--r-- | output.php | 4 |
2 files changed, 10 insertions, 3 deletions
@@ -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(); @@ -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 /> |