<?php
-/* make sure that we are not called from outside the scripts,
+/* make sure that we are not called from outside the scripts,
* use a variable defined in config.php to check this
*/
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)
$done = $done[0];
$avgage = $avgage[0];
-echo "<div class=\"login\">\n";
+echo "\n\n<div class=\"login\">\n";
echo "<p> If you want to play a game of Doppelkopf, you found the right place ;)</p>".
"<p> For more information please visit our <a href=\"$WIKI\">wiki</a>. </p>".
?>
<h4> Login/Register:</h4>
- <p>
+ <p>
Please <a href="index.php?action=register">register</a>, in case you have not done that yet <br />
or login with you email-address or name and password here:
</p>
<form action="index.php?action=login" method="post">
<fieldset>
- <table>
- <tr>
- <td><label for="email">Email:</label></td>
- <td><input type="text" class="submitbutton" id="email" name="email" size="20" maxlength="30" /> </td>
- </tr>
- <tr>
- <td><label for="password">Password:</label></td>
- <td><input type="password" class="submitbutton" id="password" name="password" size="20" maxlength="30" /></td>
- </tr>
- <tr class="center">
- <td> <input type="submit" class="submitbutton" name="login" value="login" /></td>
- <td> <input type="submit" class="submitbutton" name="forgot" value="Forgot your password?" /></td>
- </tr>
- </table>
+ <label for="email">Email:</label>
+ <input type="text" id="email" name="email" size="20" maxlength="30" /> <br />
+ <label for="password">Password:</label>
+ <input type="password" id="password" name="password" size="20" maxlength="30" /> <br />
+ <input type="submit" class="submitbutton" name="login" value="login" />
+ <input type="submit" class="submitbutton" name="forgot" value="Forgot your password?" />
+<?php
+ if($OPENIDPATH)
+ {?>
+ <hr>
+ <p> Have an OpenID account? Sign in below <br />
+ <input type="text" id="openid_url" name="openid_url" size="20" maxlength="50" />
+ <input type="submit" class="submitbutton" name="login" value="Sign in" /><br />
+ e.g. http://username.openid.net. See <a href="http://openid.net">openid.net</a> for more information.</p>
+<?php }?>
</fieldset>
</form>
-
-</div>
\ No newline at end of file
+</div>