X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=index.php;h=a4ace5cffb42b107dafd8996d2e0065d34b11ce1;hp=4863b29ed95c92e5197e30623db5513c9318ea03;hb=ee59b6b39abc3691431b027785341aa308d1313c;hpb=2d91a24aa681266bff36810746de016e2804989a diff --git a/index.php b/index.php index 4863b29..a4ace5c 100644 --- a/index.php +++ b/index.php @@ -1,436 +1,133 @@ - - -
-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"; - -$history=array(); - -/* check for status file and read it, if possible */ - -if(file_exists("status.txt")) - $lines = file("status.txt"); - else - die("no file"); +DB_open(); +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("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" )) { $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"]; + + $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(); + 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(); + $randomNRstring = join(":",$randomNR); + + /* get ruleset information or create new one */ + $ruleset = DB_get_ruleset($dullen,$schweinchen); + if($ruleset <0) + { + echo "Error defining ruleset: $ruleset"; + output_footer(); + exit(); + }; + + /* 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,'1','pre',". + "'$ruleset','$session' ,NULL)"); + else + { + /* get max session */ + $max = DB_get_max_session(); + $max++; + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre',". + "'$ruleset','$max' ,NULL)"); + mysql_query("UPDATE Game SET session='".$max."' WHERE id=".DB_quote_smart($followup)); + } + } + else + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre', ". + "'$ruleset',NULL ,NULL)"); + $game_id = mysql_insert_id(); + + /* create hash */ + $hashA = md5("AGameOfDoko".$game_id.$PlayerA.$EmailA); + $hashB = md5("AGameOfDoko".$game_id.$PlayerB.$EmailB); + $hashC = md5("AGameOfDoko".$game_id.$PlayerC.$EmailC); + $hashD = md5("AGameOfDoko".$game_id.$PlayerD.$EmailD); + + /* 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,'false','false',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,'false','false',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,'false','false',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,'false','false',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 +138,1023 @@ 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 */ +else if(myisset("cancle","me")) + { + /* cancle a game, if it is older than N minutes */ + + $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 $gameid has been cancled.
You need to wait longer before you can cancle a game...
\n"; + } +else if(myisset("me")) { -?> -no game in progress, please input 4 names and email addresses, please make sure that the addresses are correct!
- -your cards are:aehm... 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 form\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 "
these are the games you are playing in:
\n";
+ $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.mod_date from Hand".
+ " LEFT JOIN Game On Hand.game_id=Game.id".
+ " WHERE Hand.user_id='$uid' AND Game.status<>'gameover'" );
+ while( $r = mysql_fetch_array($result,MYSQL_NUM))
+ {
+ echo "game #".$r[1]." ";
+ 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 "
and these are your games that are already done:
Game: \n";
+ $result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status='gameover'" );
+ while( $r = mysql_fetch_array($result,MYSQL_NUM))
+ echo "#".$r[1]." , ";
+ echo "
registered players:
\n";
+ foreach ($names as $name)
+ echo "$name, \n";
+ echo "
Want to start a new game? Visit this page.
"; + } + else + { + echo "sorry email and password don't match