X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=index.php;h=6daea5e20ae67dc82332270b7daa195005812b22;hp=90b91cead33914e4accd08b868de26dd3fc64a8d;hb=11bc256437ae08976ca1b65fcab39f9e326c760f;hpb=75ad669f06207b8e2813c7ae4f238d46dab25160 diff --git a/index.php b/index.php index 90b91ce..6daea5e 100644 --- a/index.php +++ b/index.php @@ -3,208 +3,690 @@ "http://www.w3.org/2002/04/xhtml-math-svg/xhtml-math-svg.dtd"> - Doko via email - + e-Doko + + + - + +

Welcome to E-Doko

+
"; - echo " player 1
"; - echo " player 2
"; - echo " player 3
"; - echo " player 4
"; - /* read in random.txt */ - if(file_exists("random.txt")) - $random = file("random.txt"); - else - die("no random file"); - - $randomNR = explode( ":", $random[1] ); - - /* write status into file */ - $output = fopen("status.txt","w"); - if ($output) - { - fwrite($output, "0\n"); - - fwrite($output, "hash1:".$PlayerA.":".$EmailA."::" ); - for($i=0;$i<12;$i++) - fwrite($output,";$randomNR[$i]" ); - fwrite($output,"\n"); - - fwrite($output, "hash2:$PlayerB:$EmailB::" ); - for(;$i<24;$i++) - fwrite($output,";$randomNR[$i]" ); - fwrite($output,"\n"); - - fwrite($output, "hash3:$PlayerC:$EmailC::" ); - for(;$i<36;$i++) - fwrite($output,";$randomNR[$i]" ); - fwrite($output,"\n"); - - fwrite($output, "hash4:$PlayerD:$EmailD::"); - for(;$i<48;$i++) - fwrite($output,";$randomNR[$i]" ); - fwrite($output,"\n"); - - fclose($output); - } - else - echo "can't open file for writing"; -}; - -/* test if a game is running, else output everything for a new game */ -if(sizeof($lines)<2) -{ +if(isset($_REQUEST["new"])) + { ?> -

no game in progress, please input 4 names and email addresses

-
+

Please add 4 names, please make sure that the names are correct!

+ Name: - Email:
- Name: - Email:
- Name: - Email:
- Name: - Email:
-
- Do you want to play a game of DoKo? - yes - no
- - Do you want to get an email for every card played or only if it your move? - every card - only on my turn
-\n"; - echo "\n"; - echo "\n"; - echo "
\n"; -} - /* yes? email him his hand, ask for solo, poverty, email every move or every card? */ -if(isset($_REQUEST["b"])) -{ - $b=$_REQUEST["b"]; - echo "hash is $b
"; - if(!isset($_REQUEST["in"])|| !isset($_REQUEST["update"]) ) - { - echo "go back to "; - echo " here and fill out the form
"; - } - else - { /* show the hand */ - echo $player[$b]["cards"]; - $tmp = $player[$b]["cards"]; - $cards = explode( ":",$tmp); - echo "your cards are"; - foreach($cards as $card) echo " $card "; - echo "
\n"; - ?> -
- - do you want to play solo? - yes - no
- - do you have a wedding? - yes - no
- - do you have poverty? - yes - no
- - - - - + } +/* end start a new game */ + +/*check if everything is ready to set up a new game */ +else if( isset($_REQUEST["PlayerA"]) && + isset($_REQUEST["PlayerB"]) && + isset($_REQUEST["PlayerC"]) && + isset($_REQUEST["PlayerD"]) ) + { + $PlayerA = $_REQUEST["PlayerA"]; + $PlayerB = $_REQUEST["PlayerB"]; + $PlayerC = $_REQUEST["PlayerC"]; + $PlayerD = $_REQUEST["PlayerD"]; + + $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"; + 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); + + /* create game */ + $followup = NULL; + if(isset($_REQUEST["followup"])) + { + $followup= $_REQUEST["followup"]; + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre','$followup' ,NULL)"); + } + else + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre', NULL ,NULL)"); + $game_id = mysql_insert_id(); + + + $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, 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". + "http://wiki.nubati.net/index.php?title=EmailDoko\n\n". + "The whole round would consist of the following players:\n". + "$PlayerA\n". + "$PlayerB\n". + "$PlayerC\n". + "$PlayerD\n\n". + "If you want to join this game, please follow this link:\n\n". + " ".$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); + + } +/* end set up a new game */ + +else if(isset($_REQUEST["me"])) + { + /* handle request from one specifig player, + * the hash is set on a per game base, so first just handle this game + * perhaps also show links to other games in a sidebar + */ + + $me = $_REQUEST["me"]; + + $myid = DB_get_userid_by_hash($me); + + if(!$myid) + { + echo "Can't find you in the database, please check the url.
\n"; + echo "perhaps the game has been cancled."; + exit(); + } + + DB_update_user_timestamp($myid); + $myname = DB_get_name_by_hash($me); + $mystatus = DB_get_status_by_hash($me); + + /* get game id */ + $gameid = DB_get_gameid_by_hash($me); + + switch($mystatus) + { + case 'start': + check_want_to_play($me); + DB_set_hand_status_by_hash($me,'init'); + break; + + case 'init': + if( !isset($_REQUEST["in"]) || !isset($_REQUEST["update"])) + { + DB_set_hand_status_by_hash($me,'start'); + echo "you need to answer both question"; + } + else + { + if($_REQUEST["in"] == "no") + { + echo "TODO: email everyone that the game has been canceld
"; + /*something like + for($i=0;$i<4;$i++) + { + $message = "Hello ".$player[$hash[$i]]["name"].",\n\n". + "the game has been canceled due to the request of one of the players.\n"; + mymail($player[$hash[$i]]["email"],"[DoKo-Debug] the game has been canceled",$message); + } + */ + DB_cancel_game($me); + } + else + { + echo "thanks for joining the game... please scroll down"; + echo "TODO: make this page nicer
"; + echo "TODO: set card pref
"; + + $mycards = DB_get_hand($me); + sort($mycards); + echo "

your cards are:
\n"; + foreach($mycards as $card) + display_card($card); + echo "

\n"; + + check_for_sickness($me,$mycards); + + DB_set_hand_status_by_hash($me,'check'); + } + } + break; + + case 'check': + echo "no checking at the moment... you need to play a normal game"; + if(!isset($_REQUEST["solo"]) || + !isset($_REQUEST["wedding"]) || + !isset($_REQUEST["poverty"]) || + !isset($_REQUEST["nines"]) ) + { + DB_set_hand_status_by_hash($me,'init'); + /* problem: by setting it back to init, variables "in" and "update" are + * not set, so the player will be send back to the start, after seeing his hand + */ + echo "you need to fill out the form"; + } + else + { + if( $_REQUEST["solo"]!="No") + { + DB_set_solo_by_hash($me,$_REQUEST["solo"]); + DB_set_sickness_by_hash($me,"solo"); + } + else if($_REQUEST["wedding"] == "yes") + { + echo "wedding was chosen
\n"; + DB_set_sickness_by_hash($me,"wedding"); + } + else if($_REQUEST["poverty"] == "yes") + { + echo "poverty was chosen
\n"; + DB_set_sickness_by_hash($me,"poverty"); + } + else if($_REQUEST["nines"] == "yes") + { + echo "nines was chosen
\n"; + DB_set_sickness_by_hash($me,"nines"); + } + } + DB_set_hand_status_by_hash($me,'poverty'); + + /* check all players and set game to final result, e.g. solo, wedding, povert, redeal */ + + /* reset solo, etc from players who did say something, but it didn't matter? */ + break; + case 'poverty': + echo "
poverty not handeled at the moment... you need to play a normal game
"; + + /* only set this after all poverty, etc. are handeled*/ + DB_set_hand_status_by_hash($me,'play'); + + /* check if the game can start */ + $userids = DB_get_all_userid_by_gameid($gameid); + $done=1; + foreach($userids as $user) + if(DB_get_hand_status_by_userid($user)!='play') + $done=0; + + if($done) + DB_set_game_status_by_gameid($gameid,'play'); + + break; + case 'play': + case 'gameover': /* gameover and play, so that the tricks are visible for both */ + display_news(); + display_status(); + + $gamestatus =DB_get_game_status_by_gameid($gameid); + if($gamestatus == 'pre') + { + echo "you need to wait for the others...
"; + break; + } + /* get trick ids */ + $result = mysql_query("SELECT Hand_Card.card_id as card,". + " User.fullname as name,". + " Hand.position as position,". + " Play.sequence as sequence, ". + " Hand.hash as hash, ". + " Trick.id ". + "FROM Trick ". + "LEFT JOIN Play ON Trick.id=Play.trick_id ". + "LEFT JOIN Hand_Card ON Play.hand_card_id=Hand_Card.id ". + "LEFT JOIN Hand ON Hand_Card.hand_id=Hand.id ". + "LEFT JOIN User ON User.id=Hand.user_id ". + "LEFT JOIN Comment ON Play.id=Comment.play_id ". + "WHERE Trick.game_id='".$gameid."' ". + "ORDER BY Trick.id,sequence ASC"); + + + $trickNR = 1; + + $lasttrick = DB_get_max_trickid($gameid); + + $play = array(); /* needed to calculate winner later */ + $seq=1; + $pos=0; + + echo "\n\n"; + + /* whos turn is it? */ + if($seq==4) + { + $winner = get_winner($play); /* returns the position */ + $next = $winner; + } + else + { + $next = $pos+1; + } + if($next==5) $next=1; + + /* my turn?, display cards as links, ask for comments*/ + if(DB_get_pos_by_hash($me) == $next) + $myturn = 1; + else + $myturn = 0; + + /* do we want to play a card? */ + if(isset($_REQUEST["card"]) && $myturn) + { + $card = $_REQUEST["card"]; + $handid = DB_get_handid_by_hash($me); + + /* check if we have card and that we haven't played it yet*/ + /* set played in hand_card to true where hand_id and card_id*/ + $result = mysql_query("SELECT id FROM Hand_Card WHERE played='false' and ". + "hand_id='$handid' AND card_id=".DB_quote_smart($card)); + $r = mysql_fetch_array($result,MYSQL_NUM); + $handcardid = $r[0]; + + if($handcardid) + { + mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".DB_quote_smart($card)); + + /* get trick id or start new trick */ + $a = DB_get_current_trickid($gameid); + $trickid = $a[0]; + $sequence = $a[1]; + + $playid = DB_play_card($trickid,$handcardid,$sequence); + /*check for coment */ + if(isset($_REQUEST["comment"])) + { + DB_insert_comment($_REQUEST["comment"],$playid,$myid); + }; + + echo "
"; + echo " you played
"; + display_card($card); + echo "
\n"; + + + /*check if we still have cards left, else set status to gameover */ + if(sizeof(DB_get_hand($me))==0) + { + DB_set_hand_status_by_hash($me,'gameover'); + $mystatus='gameover'; + } + + /* if all players are done, set game status also to game over */ + $userids = DB_get_all_userid_by_gameid($gameid); + $done=1; + foreach($userids as $user) + if(DB_get_hand_status_by_userid($user)!='gameover') + $done=0; + + if($done) + DB_set_game_status_by_gameid($gameid,"gameover"); + + /* email next player */ + if(DB_get_game_status_by_gameid($gameid)=='play') + { + if($sequence==4) + { + $play = DB_get_cards_by_trick($trickid); + $winner = get_winner($play); /* returns the position */ + $next = $winner; + } + else + { + $next = DB_get_pos_by_hash($me)+1; + } + if($next==5) $next=1; + + echo "TODO: email next player at pos $next
"; + if($debug) + echo "DEBUG: next player
\n"; + + } + } + else + { + echo "couldn't find card
\n"; + } + } + else if(isset($_REQUEST["card"]) && !$myturn ) + { + echo "please wait until it is your turn!
\n"; + } + + $mycards = DB_get_hand($me); + sort($mycards); + echo "
\n"; + + if($myturn && !isset($_REQUEST["card"])) + { + echo "Hello ".$myname.", it's your turn!
\n"; + echo "Your cards are:
\n"; + echo "\n"; + foreach($mycards as $card) + display_link_card($card); +?> +
A short comments: + + + \n"; + foreach($mycards as $card) + display_card($card); + } + echo "
\n"; + /* check if we need to set status to 'gameover' is done during playing of the card */ + if($mystatus=='play') + break; + /* the following happens only when the gamestatus is 'gameover' */ + /* check if game is over, display results */ + if(DB_get_game_status_by_gameid($gameid)=='play') + { + echo "the game is over for you.. other people still need to play though"; + } + else + { + echo "the game is over now... guess the final score should be displayed here...
\n"; + + /* suggest a new game with the same people in it, just rotated once */ + $names = DB_get_all_names_by_gameid($gameid); + + echo "Do you want to continue playing?(This will start a new game, with the next person as dealer.)\n"; + echo "
\n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo "
\n"; + } + break; + default: + echo "error in testing the status"; + } + exit(); + } + else if(isset($_REQUEST["email"]) && isset($_REQUEST["password"])) + { + $ok=1; + $uid = DB_get_userid_by_email($_REQUEST["email"]); + if(!$uid) + $ok=0; + if(!DB_get_userid_by_passwd(md5($_REQUEST["password"]))) + $ok=0; + + if($ok) + { + $time = DB_get_user_timestamp($uid); + $unixtime =strtotime($time); + + $offset = DB_get_user_timezone($uid); + $zone = return_timezone($offset); + date_default_timezone_set($zone); + + echo "ok. your logged in, now what? :)
last login: "; + echo date("r",$unixtime)."
"; + + DB_update_user_timestamp($uid); + + echo "

these are the games you are playing in:
\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 "game #".$r[1]."
"; + echo "

\n"; + + $names = DB_get_all_names(); + echo "

registered players:
\n"; + foreach ($names as $name) + echo "$name
\n"; + echo "

\n"; + echo "

Want to start a new game? remember 4 names from the list above and visit ". + "this page.

"; + } + else + { + echo "sorry email and password don't match
"; + } + exit(); + } +else if(isset($_REQUEST["register"]) ) + { + echo "TODO: convert timezone into a menu
\n"; + echo "TODO: figure out a way to handle passwrods
\n"; +?> +
+
+ Register + + + + + + + + + + + + + + + +
+ +
+
+
"; + $ok=0; + } + if(DB_get_userid_by_email($_REQUEST["Remail"])) + { + echo "this email address is already used ?!
"; + $ok=0; + } + if($ok) + { + $r=mysql_query("INSERT INTO User VALUES(NULL,".DB_quote_smart($_REQUEST["Rfullname"]). + ",".DB_quote_smart($_REQUEST["Remail"]). + ",".DB_quote_smart(md5($_REQUEST["Rpassword"])). + ",".DB_quote_smart($_REQUEST["Rtimezone"]).",NULL)"); + + if($r) + echo " added you to the database"; + else + echo " something went wrong"; + } + } +else + { /* no new game, not in a game */ ?> +

If you want to play a game of Doppelkopf, you found the right place ;)

+

Please register, in case you haven't done yet
+ or login with you email-address or name and password here: +

+
+ Login + + + + + + + +
+
+
+ +

+ + + + + +