X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fwelcome.php;h=654e968faf5ccb2b15d16b9b02fc639830d3a5b3;hp=7aeaf78b05d7e1fd3ba049bc42384c6f1e56ea6e;hb=ca3071da712685fd941f97d3610bad8635bf9c5c;hpb=09515348107d9aab7823a12d31b082a2ebb75555 diff --git a/include/welcome.php b/include/welcome.php index 7aeaf78..654e968 100644 --- a/include/welcome.php +++ b/include/welcome.php @@ -8,19 +8,84 @@ if(!isset($HOST)) /* this outputs the default home page with some extra statistics on it */ $pre[0]=0;$game[0]=0;$done[0]=0; -$r=mysql_query("SELECT COUNT(id) FROM Game GROUP BY status"); -if($r) { - $pre = mysql_fetch_array($r,MYSQL_NUM); - $game = mysql_fetch_array($r,MYSQL_NUM); - $done = mysql_fetch_array($r,MYSQL_NUM); - } - -$r=mysql_query("SELECT AVG(datediff(mod_date,create_date)) FROM Game where status='gameover' "); + +$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) - $avgage= mysql_fetch_array($r,MYSQL_NUM); + $avgage= DB_fetch_array($r); else $avgage[0]=0; -output_home_page($pre[0],$game[0],$done[0],$avgage[0]); +$pre = $pre[0]; +$game = $game[0]; +$done = $done[0]; +$avgage = $avgage[0]; + +echo "
If you want to play a game of Doppelkopf, you found the right place ;)
". +"For more information please visit our wiki.
". +"At the moment there are no games that are being started "; + else if($pre==1) + echo "
At the moment there is one games that is being started "; + else + echo "
At the moment there are $pre games that are being started ";
+
+echo "and ";
+
+if($game==0)
+ echo "zero games that are ongoing. ";
+ else if($game==1)
+ echo "one game that is ongoing. ";
+ else
+ echo "$game games that are ongoing. ";
+
+echo "
\n";
+
+if($done==0)
+ echo "No game has been completed on this server.
+ Please register, in case you have not done that yet
+ or login with you email-address or name and password here:
+