X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=index.php;h=71d40506c27d5cd52d2000b8dad41714ecd8fda7;hp=4863b29ed95c92e5197e30623db5513c9318ea03;hb=d8eac0035f97a64371557e7da8b9730fe28d8788;hpb=2d91a24aa681266bff36810746de016e2804989a diff --git a/index.php b/index.php index 4863b29..71d4050 100644 --- a/index.php +++ b/index.php @@ -1,436 +1,148 @@ - - -
-If you find bugs, please list them in the wiki
\n"; - -echo "Cards that have a green background have a comment, which you can access by hovering over the card with your mouse ;)
\n"; +config_check(); -$history=array(); +if(DB_open()<0) + { + output_header(); + echo "Database error, can't connect... Please wait a while and try again. ". + "If the problem doesn't go away feel free to contact $ADMIN_NAME at $ADMIN_EMAIL."; + output_footer(); + exit(); + } -/* check for status file and read it, if possible */ +/* start a session, if it is not already running */ +session_start(); -if(file_exists("status.txt")) - $lines = file("status.txt"); - else - die("no file"); +/* done major error checking, output header of HTML page */ +output_header(); /* check if we want to start a new game */ -if( isset($_REQUEST["PlayerA"]) && - isset($_REQUEST["PlayerB"]) && - isset($_REQUEST["PlayerC"]) && - isset($_REQUEST["PlayerD"]) && - isset($_REQUEST["EmailA"]) && - isset($_REQUEST["EmailB"]) && - isset($_REQUEST["EmailC"]) && - isset($_REQUEST["EmailD"]) && sizeof($lines<2)) +if(myisset("logout")) + { + session_unset(); + session_destroy(); + $_SESSION = array(); + echo "you are now logged out!"; + } +else if(myisset("new")) + { + $names = DB_get_all_names(); + output_form_for_new_game($names); + } +/*check if everything is ready to set up a new game */ + else if( myisset("PlayerA", "PlayerB","PlayerC","PlayerD","dullen","schweinchen","call" )) { $PlayerA = $_REQUEST["PlayerA"]; $PlayerB = $_REQUEST["PlayerB"]; $PlayerC = $_REQUEST["PlayerC"]; $PlayerD = $_REQUEST["PlayerD"]; - $EmailA = $_REQUEST["EmailA"] ; - $EmailB = $_REQUEST["EmailB"] ; - $EmailC = $_REQUEST["EmailC"] ; - $EmailD = $_REQUEST["EmailD"] ; - - $hashA = md5("AGameOfDoko".$PlayerA.$EmailA); - $hashB = md5("AGameOfDoko".$PlayerB.$EmailB); - $hashC = md5("AGameOfDoko".$PlayerC.$EmailC); - $hashD = md5("AGameOfDoko".$PlayerD.$EmailD); - /* send out email, check for error with email */ + $dullen = $_REQUEST["dullen"]; + $schweinchen = $_REQUEST["schweinchen"]; + $call = $_REQUEST["call"]; + $EmailA = DB_get_email_by_name($PlayerA); + $EmailB = DB_get_email_by_name($PlayerB); + $EmailC = DB_get_email_by_name($PlayerC); + $EmailD = DB_get_email_by_name($PlayerD); + + if($EmailA=="" || $EmailB=="" || $EmailC=="" || $EmailD=="") + { + echo "couldn't find one of the names, please start a new game"; + output_footer(); + DB_close(); + exit(); + } + + $useridA = DB_get_userid_by_name($PlayerA); + $useridB = DB_get_userid_by_name($PlayerB); + $useridC = DB_get_userid_by_name($PlayerC); + $useridD = DB_get_userid_by_name($PlayerD); + + /* create random numbers */ + $randomNR = create_array_of_random_numbers($useridA,$useridB,$useridC,$useridD); + $randomNRstring = join(":",$randomNR); + + /* create game */ + $followup = NULL; + if(myisset("followup") ) + { + $followup= $_REQUEST["followup"]; + $session = DB_get_session_by_gameid($followup); + $ruleset = DB_get_ruleset_by_gameid($followup); /* just copy ruleset from old game, + this way no manipulation is possible */ + if($session) + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre',". + "'$ruleset','$session' ,NULL)"); + else + { + /* get max session */ + $max = DB_get_max_session(); + $max++; + mysql_query("UPDATE Game SET session='".$max."' WHERE id=".DB_quote_smart($followup)); + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre',". + "'$ruleset','$max' ,NULL)"); + } + } + else + { + /* get ruleset information or create new one */ + $ruleset = DB_get_ruleset($dullen,$schweinchen,$call); + if($ruleset <0) + { + myerror("Error defining ruleset: $ruleset"); + output_footer(); + DB_close(); + exit(); + }; + /* get max session */ + $max = DB_get_max_session(); + $max++; + + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre', ". + "'$ruleset','$max' ,NULL)"); + } + $game_id = mysql_insert_id(); + + /* create hash */ + $TIME = (string) time(); /* to avoid collisions */ + $hashA = md5("AGameOfDoko".$game_id.$PlayerA.$EmailA.$TIME); + $hashB = md5("AGameOfDoko".$game_id.$PlayerB.$EmailB.$TIME); + $hashC = md5("AGameOfDoko".$game_id.$PlayerC.$EmailC.$TIME); + $hashD = md5("AGameOfDoko".$game_id.$PlayerD.$EmailD.$TIME); + + /* create hands */ + mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridA). + ", ".DB_quote_smart($hashA).", 'start','1',NULL,NULL,NULL,NULL)"); + $hand_idA = mysql_insert_id(); + mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridB). + ", ".DB_quote_smart($hashB).", 'start','2',NULL,NULL,NULL,NULL)"); + $hand_idB = mysql_insert_id(); + mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridC). + ", ".DB_quote_smart($hashC).", 'start','3',NULL,NULL,NULL,NULL)"); + $hand_idC = mysql_insert_id(); + mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridD). + ", ".DB_quote_smart($hashD).", 'start','4',NULL,NULL,NULL,NULL)"); + $hand_idD = mysql_insert_id(); + + /* save cards */ + for($i=0;$i<12;$i++) + mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idA', '".$randomNR[$i]."', 'false')"); + for($i=12;$i<24;$i++) + mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idB', '".$randomNR[$i]."', 'false')"); + for($i=24;$i<36;$i++) + mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idC', '".$randomNR[$i]."', 'false')"); + for($i=36;$i<48;$i++) + mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idD', '".$randomNR[$i]."', 'false')"); + + /* send out email, TODO: check for error with email */ $message = "\n". "you are invited to play a game of DoKo (that is to debug the program ;).\n". "Place comments and bug reports here:\n". @@ -441,606 +153,1667 @@ if( isset($_REQUEST["PlayerA"]) && "$PlayerC\n". "$PlayerD\n\n". "If you want to join this game, please follow this link:\n\n". - " ".$host."?a="; + "".$host."?me="; mymail($EmailA,"You are invited to a game of DoKo","Hello $PlayerA,\n".$message.$hashA); mymail($EmailB,"You are invited to a game of DoKo","Hello $PlayerB,\n".$message.$hashB); mymail($EmailC,"You are invited to a game of DoKo","Hello $PlayerC,\n".$message.$hashC); mymail($EmailD,"You are invited to a game of DoKo","Hello $PlayerD,\n".$message.$hashD); - /* read in random.txt */ - if(file_exists("random.txt")) - $random = file("random.txt"); - else - die("no random file"); - - $randomNR = explode( ":", $random[2] ); + echo "You started a new game. The emails have been sent out!"; + } /* end set up a new game */ +/* cancle a game, if nothing has happend in the last N minutes */ +else if(myisset("cancle","me")) + { + $me = $_REQUEST["me"]; - /* write initial status into file */ - $output = fopen("status.txt","w"); - if ($output) + /* test for valid ID */ + $myid = DB_get_userid_by_hash($me); + if(!$myid) { - fwrite($output, "$hashA:$PlayerA:$EmailA:::" ); - for($i=0;$i<11;$i++) - fwrite($output,"$randomNR[$i];" ); - fwrite($output,"$randomNR[11]:" ); $i++; - fwrite($output,"\n"); - - fwrite($output, "$hashB:$PlayerB:$EmailB:::" ); - for(;$i<23;$i++) - fwrite($output,"$randomNR[$i];" ); - fwrite($output,"$randomNR[23]:" ); $i++; - fwrite($output,"\n"); + echo "Can't find you in the database, please check the url.Game ".DB_format_gameid($gameid)." has been cancled.
You need to wait longer before you can cancle a game...
\n"; + } +/* handle request from one specific player for one game, + * (the hash is set on a per game base) */ +else if(myisset("me")) { -?> -no game in progress, please input 4 names and email addresses, please make sure that the addresses are correct!
- - - \n"; - } - } + /* get some infos about the game */ + $gametype = DB_get_gametype_by_gameid($gameid); + $gamestatus = DB_get_game_status_by_gameid($gameid); + $GT = $gametype; + if($gametype=="solo") + { + $gametype = DB_get_solo_by_gameid($gameid); + $GT = $gametype." ".$GT; + } + + /* does anyone have both foxes */ + $GAME["schweinchen"]=0; + for($i=1;$i<5;$i++) + { + $hash = DB_get_hash_from_game_and_pos($gameid,$i); + $cards = DB_get_all_hand($hash); + if( in_array("19",$cards) && in_array("20",$cards) ) + { + $GAME["schweinchen"]=1; + $GAME["schweinchen-who"]=$hash; + } + }; -/* *** - * * * - * *** - * * * - * *** - * yes? email him his hand, ask for solo, poverty, email every move or every card? - */ - if(isset($_REQUEST["b"])) + /* put everyting in a form */ + echo "\n"; + output_footer(); + DB_close(); + exit(); + } +/* user status page */ +else if( myisset("email","password") || isset($_SESSION["name"]) ) + { + /* test id and password, should really be done in one step */ + if(!isset($_SESSION["name"])) + { + $email = $_REQUEST["email"]; + $password = $_REQUEST["password"]; + } + else + { + $name = $_SESSION["name"]; + $email = DB_get_email_by_name($name); + $password = DB_get_passwd_by_name($name); + }; + + if(myisset("forgot")) { - $b=$_REQUEST["b"]; + $ok = 1; + + $uid = DB_get_userid_by_email($email); + if(!$uid) + $ok = 0; - if( ereg("s",$player[$b]["option"]) && $game["init"]<4) + if($ok) { - echo "just wait for the game to start"; - } - else if( (!isset($_REQUEST["in"])|| !isset($_REQUEST["update"])) && !ereg("i",$player[$b]["option"])) - { - echo "go back to "; - echo " here and fill out the formaehm... at the moment poverty is not implented. so I guess you need to play a normal game, even if you have less than 3 turmp :(...sorry
- \n"; - } - } - } - if(isset($_REQUEST["c"])) - { - $c=$_REQUEST["c"]; - - if(!isset($_REQUEST["solo"])|| !isset($_REQUEST["wedding"])|| !isset($_REQUEST["poverty"]) || !isset($_REQUEST["nines"]) ) - { - echo "go back to "; - echo " here and fill out the formThese are your games that haven't started yet:
\n";
+ $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.mod_date,Game.player from Hand".
+ " LEFT JOIN Game On Hand.game_id=Game.id".
+ " WHERE Hand.user_id='$uid' AND Game.status='pre'" );
+ while( $r = mysql_fetch_array($result,MYSQL_NUM))
+ {
+ echo "game".DB_format_gameid($r[1])." ";
+ if($r[3]==$uid || $r[3]==NULL)
+ echo "(it's your turn)\n";
+ else
+ {
+ $name = DB_get_name_by_userid($r[3]);
+ echo "(it's $name's turn)\n";
+ };
+
+ if(time()-strtotime($r[2]) > 60*60*24*30)
+ echo " The game has been running for over a month.".
+ " Do you want to cancel it? yes".
+ " (clicking here is final and can't be restored)";
+ echo "
";
+ }
+ echo "
\n";
- /* is it our turn? */
- if($hash[$next]==$me && !isset($_REQUEST["card"]) && !isset($_REQUEST["win"]))
- {
- echo "ITS YOUR TURN
\n";
- echo "your cards are:
\n";
- foreach($mycards as $card)
- {
- display_link_card($card,$me);
- }
- }
- else
- { /* not our turn, just show the hand */
- echo "your cards are:
\n";
- foreach($mycards as $card)
- {
- display_card($card);
- }
- }
- echo "