X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fwelcome.php;h=cb601e37b39bcd949cbc97f3de8c31d855912f73;hp=ccbaea5e864ba7339a5cdb089377bce8bc5d3226;hb=4601624395d2f42086d058668b1b96778c8fcbb6;hpb=5e1a0bda25ddea405798e52388de4dd0a05d356c diff --git a/include/welcome.php b/include/welcome.php index ccbaea5..cb601e3 100644 --- a/include/welcome.php +++ b/include/welcome.php @@ -1,5 +1,24 @@ + * + * This file is part of e-DoKo. + * + * e-DoKo is free software: you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation, either version 3 of the License, or + * (at your option) any later version. + * + * e-DoKo is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with e-DoKo. If not, see . + * + */ + +/* make sure that we are not called from outside the scripts, * use a variable defined in config.php to check this */ if(!isset($HOST)) @@ -9,12 +28,15 @@ if(!isset($HOST)) $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) @@ -27,8 +49,12 @@ $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.

"; +echo "\n\n
\n"; + +echo "

If you want to play a game of Doppelkopf, you found the right place ;)

". +"

For more information please visit our wiki.

". +"

Some statistics:

"; + if($pre == 0) echo "

At the moment there are no games that are being started "; @@ -56,25 +82,29 @@ if($done==0) echo "$done games have been completed on this server. Average time of a game: $avgage days

"; ?> -

Please register, in case you have not done that yet
+

Login/Register:

+

+ Please register, in case you have not done that yet
or login with you email-address or name and password here:

+
- Login - - - - - - - - - - - -
+ +
+ +
+ + + +
+

Have an OpenID account? Sign in below
+ +
+ e.g. http://username.openid.net. See openid.net for more information.

+
- - \ No newline at end of file +