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=34709d35cb6a8f5b3a11cad3dad072e4ac24d096;hb=ca3071da712685fd941f97d3610bad8635bf9c5c;hpb=086ed1db2ec28817b3370481455c84ceaf6448c2;ds=inline diff --git a/include/welcome.php b/include/welcome.php index 34709d3..654e968 100644 --- a/include/welcome.php +++ b/include/welcome.php @@ -8,12 +8,16 @@ 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=DB_query("SELECT COUNT(id) FROM Game GROUP BY status"); -if($r) { - $pre = DB_fetch_array($r); - $game = DB_fetch_array($r); - $done = DB_fetch_array($r); - } + +$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) @@ -21,6 +25,67 @@ if($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:
+