blob: 654e968faf5ccb2b15d16b9b02fc639830d3a5b3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
<?php
/* make sure that we are not called from outside the scripts,
* use a variable defined in config.php to check this
*/
if(!isset($HOST))
exit;
/* 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(*) 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= DB_fetch_array($r);
else
$avgage[0]=0;
$pre = $pre[0];
$game = $game[0];
$done = $done[0];
$avgage = $avgage[0];
echo "<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>Some statistics:</h4>";
if($pre == 0)
echo "<p> At the moment there are no games that are being started ";
else if($pre==1)
echo "<p> At the moment there is one games that is being started ";
else
echo "<p> 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 "<br />\n";
if($done==0)
echo "No game has been completed on this server. </p>";
else if($done==1)
echo "One game has been completed on this server. </p>";
else
echo "$done games have been completed on this server. Average time of a game: $avgage days</p>";
?>
<h4> Login/Register:</h4>
<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>
</fieldset>
</form>
</div>
|