projects
/
e-DoKo.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
88321df
)
added output of average time for a game on the homepage
author
arun
<arun@nubati.net>
Sat, 2 Jun 2007 16:25:28 +0000
(16:25 +0000)
committer
arun
<arun>
Sat, 2 Jun 2007 16:25:28 +0000
(16:25 +0000)
index.php
patch
|
blob
|
history
output.php
patch
|
blob
|
history
diff --git
a/index.php
b/index.php
index 1a825de1223eecbaee350a8c832f2e5cec1c8168..0bb04d4c0044e4f37e234a3cd17d58e9191783b7 100644
(file)
--- 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);
}
$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();
}
output_footer();
diff --git
a/output.php
b/output.php
index 75d013523cd1aef535e48bf76f227d2eb3330c13..0871bcc1d0fca5719cd2491b0363333f857fbe95 100644
(file)
--- a/
output.php
+++ b/
output.php
@@
-282,7
+282,7
@@
function check_want_to_play($me)
return;
}
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>
{
?>
<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
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 />
?>
<p> Please <a href="index.php?register">register</a>, in case you haven't done that yet <br />