diff options
-rw-r--r-- | db.php | 14 | ||||
-rw-r--r-- | functions.php | 2 | ||||
-rw-r--r-- | index.php | 18 |
3 files changed, 27 insertions, 7 deletions
@@ -7,8 +7,8 @@ function DB_open() { global $DB; - if ( $DB = mysql_connect('localhost','dokodb', 'doko') ) - mysql_select_db('doko') or die('Could not select database'); + if ( $DB = mysql_connect('mysql.nubati.net','doko', '$DoKo#.') ) + mysql_select_db('dokodb') or die('Could not select database'); else die (mysql_error()); @@ -339,4 +339,14 @@ function DB_get_hash_from_game_and_pos($id,$pos) return ""; } +function DB_get_all_names() +{ + $names = array(); + + $result = mysql_query("SELECT fullname FROM User"); + while($r = mysql_fetch_array($result,MYSQL_NUM)) + $names[] = $r[0]; + + return $names; +} ?>
\ No newline at end of file diff --git a/functions.php b/functions.php index a52ad7a..49e0a1d 100644 --- a/functions.php +++ b/functions.php @@ -6,7 +6,7 @@ $host = "http://doko.nubati.net/database/index.php"; $wiki = "http://wiki.nubati.net/index.php?title=EmailDoko"; -$debug = 1; +$debug = 0; $last=-2; @@ -52,8 +52,8 @@ DB_open(); if(isset($_REQUEST["new"])) { ?> - <p> no game in progress, please input 4 names and email addresses, please make sure that the addresses are correct! </p> - <form action="index.php" method="post"> + <p>Please add 4 names, please make sure that the names are correct! </p> + <form action="index.php" method="post"> Name: <input name="PlayerA" type="text" size="10" maxlength="20" /> Name: <input name="PlayerB" type="text" size="10" maxlength="20" /> Name: <input name="PlayerC" type="text" size="10" maxlength="20" /> @@ -389,7 +389,11 @@ else if(isset($_REQUEST["me"])) $myturn = 1; else $myturn = 0; + + if(isset($_REQUEST["comment"])) + { + } /* do we want to play a card? */ if(isset($_REQUEST["card"]) && $myturn) { @@ -480,7 +484,7 @@ else if(isset($_REQUEST["me"])) foreach($mycards as $card) display_link_card($card); ?> - <br />A short comment:<input name="comment" type="text" size="30" maxlength="50" /> + <br />A short comments:<input name="comment" type="text" size="30" maxlength="50" /> <input type="hidden" name="me" value="<?php echo $me; ?>" /> <input type="submit" value="move" /> </form> @@ -538,7 +542,13 @@ else if(isset($_REQUEST["me"])) if($ok) { echo "ok. your logged in, now what? :)<br />"; - + $names = DB_get_all_names(); + echo "<p>registered players:<br />\n"; + foreach ($names as $name) + echo "$name <br />\n"; + echo "</p>\n"; + echo "<p>Want to start a new game? remember 4 names from the list above and visit ". + "<a href=\"http://doko.nubati.net/database/index.php?new\">this page.</a></p>"; } else { |