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=5436ecf5f1015902f4d0f1a84907b7b53ad33a72;hb=fceb0d9bc48ae848461e728abaf5065a2578da61;hpb=53314b8335e7565cf63941ba074cafba37d913e2 diff --git a/include/welcome.php b/include/welcome.php index 5436ecf..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,7 +49,7 @@ $game = $game[0]; $done = $done[0]; $avgage = $avgage[0]; -echo "
\n"; +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.

". @@ -61,28 +83,28 @@ if($done==0) ?>

Login/Register:

-

+

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

- - - - - - - - - - - - - -
+ +
+ +
+ + + +
+

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 +