X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=index.php;h=dd1ce58889d298ef2ef1ba658b8be8ec21fa19b9;hp=d135474612fde9d7cd0a7a292c5c42583af350ff;hb=7128076b9409b55551f206d875218fc8f70bb273;hpb=616c0a755263d974bf8953d71511a2860a3ff7ae diff --git a/index.php b/index.php index d135474..dd1ce58 100644 --- a/index.php +++ b/index.php @@ -25,7 +25,15 @@ if(0) exit(); } -DB_open(); +if(DB_open()<0) + { + output_header(); + echo "Database error, can't connect..."; + output_footer(); + exit(); + } + +/* done major error checking, output header of HTML page */ output_header(); /* check if we want to start a new game */ @@ -54,6 +62,7 @@ if(myisset("new")) { echo "couldn't find one of the names, please start a new game"; output_footer(); + DB_close(); exit(); } @@ -63,7 +72,7 @@ if(myisset("new")) $useridD = DB_get_userid_by_name($PlayerD); /* create random numbers */ - $randomNR = create_array_of_random_numbers(); + $randomNR = create_array_of_random_numbers($useridA,$useridB,$useridC,$useridD); $randomNRstring = join(":",$randomNR); /* get ruleset information or create new one */ @@ -72,6 +81,7 @@ if(myisset("new")) { echo "Error defining ruleset: $ruleset"; output_footer(); + DB_close(); exit(); }; @@ -84,41 +94,42 @@ if(myisset("new")) $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',". + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','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)); + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','1','pre',". + "'$ruleset','$max' ,NULL)"); } } else - mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre', ". + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','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); + $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,'false','false',NULL)"); + ", ".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,'false','false',NULL)"); + ", ".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,'false','false',NULL)"); + ", ".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,'false','false',NULL)"); + ", ".DB_quote_smart($hashD).", 'start','4',NULL,NULL,NULL,NULL)"); $hand_idD = mysql_insert_id(); /* save cards */ @@ -142,7 +153,7 @@ if(myisset("new")) "$PlayerC\n". "$PlayerD\n\n". "If you want to join this game, please follow this link:\n\n". - " ".$host."?me="; + "".$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); @@ -163,6 +174,7 @@ else if(myisset("cancle","me")) echo "Can't find you in the database, please check the url.
\n"; echo "perhaps the game has been cancled, check by login in here."; output_footer(); + DB_close(); exit(); } @@ -184,7 +196,7 @@ else if(myisset("cancle","me")) foreach($userids as $user) { $To = DB_get_email_by_userid($user); - mymail($To,$EmailName."game cancled (timed out)",$message); + mymail($To,$EmailName."game $gameid cancled (timed out)",$message); } /* delete everything from the dB */ @@ -208,6 +220,7 @@ else if(myisset("me")) echo "Can't find you in the database, please check the url.
\n"; echo "perhaps the game has been cancled, check by login in here."; output_footer(); + DB_close(); exit(); } @@ -219,8 +232,14 @@ else if(myisset("me")) $myname = DB_get_name_by_hash($me); $mystatus = DB_get_status_by_hash($me); $mypos = DB_get_pos_by_hash($me); - + $myhand = DB_get_handid_by_hash($me); + $session = DB_get_session_by_gameid($gameid); + /* get prefs and save them */ + DB_get_PREF($myid); + /* end set pref */ + + /* get rule set for this game */ $result = mysql_query("SELECT * FROM Rulesets". " LEFT JOIN Game ON Game.ruleset=Rulesets.id ". @@ -229,7 +248,9 @@ else if(myisset("me")) $RULES["dullen"] = $r[2]; $RULES["schweinchen"] = $r[3]; - + $RULES["call"] = $r[4]; + + /* get some infos about the game */ $gametype = DB_get_gametype_by_gameid($gameid); $gamestatus = DB_get_game_status_by_gameid($gameid); @@ -249,7 +270,27 @@ else if(myisset("me")) echo "Rules:
\n"; echo "10ofhearts : ".$r[2]."
\n"; echo "schweinchen: ".$r[3]."
\n"; + echo "call: ".$r[4]."
\n"; echo "\n"; + + /* output extra division in case this game is part of a session */ + if($session) + { + echo "
\n". + "This game is part of session $session: \n"; + $hashes = DB_get_hashes_by_session($session,$myid); + $i = 1; + foreach($hashes as $hash) + { + if($hash == $me) + echo "$i "; + else + echo "$i "; + $i++; + } + echo "
\n"; + } + /* does anyone have both foxes */ $GAME["schweinchen"]=0; @@ -287,7 +328,7 @@ else if(myisset("me")) */ if( !myisset("in") ) { - echo "you need to answer the question."; + echo "

you need to answer the question.

"; DB_set_hand_status_by_hash($me,'start'); } else @@ -302,7 +343,7 @@ else if(myisset("me")) foreach($userids as $user) { $To = DB_get_email_by_userid($user); - mymail($To,$EmailName."game canceled",$message); + mymail($To,$EmailName."game $gameid canceled",$message); } /* delete everything from the dB */ @@ -316,10 +357,10 @@ else if(myisset("me")) sort($mycards); echo "

your cards are:
\n"; foreach($mycards as $card) - display_card($card); + display_card($card,$PREF["cardset"]); echo "

\n"; - check_for_sickness($me,$mycards); + output_check_for_sickness($me,$mycards); /* move on to the next stage*/ DB_set_hand_status_by_hash($me,'check'); @@ -376,9 +417,7 @@ else if(myisset("me")) } else if($_REQUEST["poverty"] == "yes") { - echo "So you got poverty. You might as well have said nothing, since this is not implemented yet,". - " you need to play a normal game...to make it a bit harder, I'll tell the other people that". - " you only have a few trump... should make the game more interesting (although perhaps not for you:))
\n"; + echo "Don't think you can win with just a few trump...? ok, poverty chosen
\n"; DB_set_sickness_by_hash($me,"poverty"); } else if($_REQUEST["nines"] == "yes") @@ -387,12 +426,36 @@ else if(myisset("me")) " is playing solo, this game will be canceled.
\n"; DB_set_sickness_by_hash($me,"nines"); } - } - - echo " Ok, done with checking, please go to the next step of the setup.
"; + + echo " Ok, done with checking, please go to the next step of the setup.
"; + + /* move on to the next stage*/ + DB_set_hand_status_by_hash($me,'poverty'); + + /* check if everyone has reached this stage, send out email */ + $userids = DB_get_all_userid_by_gameid($gameid); + $ok=1; + foreach($userids as $user) + { + $userstat = DB_get_hand_status_by_userid_and_gameid($user,$gameid); + if($userstat!='poverty' && $userstat!='play') + $ok=0; + }; + if($ok) + foreach($userids as $user) + { + $To = DB_get_email_by_userid($user); + $userhash =DB_get_hash_from_gameid_and_userid($gameid,$user); + if($userhash!=$me) + { + $message = "Everyone finish the questionary in game $gameid, ". + "please visit this link now to continue: \n". + " ".$host."?me=".$userhash."\n\n" ; + mymail($To,$EmailName." finished setup in game $gameid",$message); + } + }; + }; - /* move on to the next stage*/ - DB_set_hand_status_by_hash($me,'poverty'); break; case 'poverty': @@ -401,7 +464,7 @@ else if(myisset("me")) * set that one in the Game table * tell people about it. */ - echo "
Checking if someone else selected solo, nines or wedding... Poverty not handled at the moment
"; + echo "
Checking if someone else selected solo, nines or wedding or poverty.
"; /* check if everyone has reached this stage */ $userids = DB_get_all_userid_by_gameid($gameid); @@ -416,7 +479,9 @@ else if(myisset("me")) if(!$ok) { echo "This step can only be handled after everyone finished the last step. ". - "Seems like this is not the case, so you need to wait a bit... please check back later....
"; + "Seems like this is not the case, so you need to wait a bit... ". + "you will get an email once that is the case, please use the link in ". + "that email to continue the game.
"; } else { @@ -428,57 +493,39 @@ else if(myisset("me")) $startplayer = DB_get_startplayer_by_gameid($gameid); /* check for different sickness and just output a general info */ - - /* check for nines */ - $nines = 0; - foreach($userids as $user) - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'nines') - { - $nines = $user; - $name = DB_get_name_by_userid($user); - echo "$name has a Vorbehalt.
"; - break; - } - - /* check players for poverty */ + $nines = 0; $poverty = 0; + $wedding = 0; + $solo = 0; foreach($userids as $user) { - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'poverty') + $name = DB_get_name_by_userid($user); + $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid); + if($usersick == 'nines') + { + $nines = $user; + echo "$name has a Vorbehalt.
"; + break; + } + else if($usersick == 'poverty') { $poverty++; - $name = DB_get_name_by_userid($user); echo "$name has a Vorbehalt.
"; } - } - - /* check players for wedding */ - $wedding = 0; - foreach($userids as $user) - { - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'wedding') + else if($usersick == 'wedding') { $wedding=$user; - $name = DB_get_name_by_userid($user); echo "$name has a Vorbehalt.
" ; } - }; - - /* check for solo, output vorbehalt */ - $solo = 0; - foreach($userids as $user) - { - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'solo') + else if($usersick == 'solo') { $solo++; - $name = DB_get_name_by_userid($user); echo "$name has a Vorbehalt.
" ; } } /* now check which sickness comes first and set the gametype to it */ - /* gamestatus == normal, => cancel game */ if($gametype == "solo") { /* do nothing */ @@ -497,7 +544,7 @@ else if(myisset("me")) foreach($userids as $user) { $To = DB_get_email_by_userid($user); - mymail($To,$EmailName."game canceled",$message); + mymail($To,$EmailName."game $gameid canceled",$message); } /* delete everything from the dB */ @@ -506,21 +553,47 @@ else if(myisset("me")) echo "The game has been canceled because ".DB_get_name_by_userid($nines). " has five or more nines and nobody is playing solo.\n"; output_footer(); + DB_close(); exit(); } - else if($poverty==1 && $gametype !="poverty") + else if($poverty==1) /* one person has poverty */ { DB_set_gametype_by_gameid($gameid,"poverty"); $gametype = "poverty"; + $who=DB_get_sickness_by_gameid($gameid); + if(!$who) + { + $firstsick = DB_get_sickness_by_pos_and_gameid(1,$gameid); + if($firstsick == "poverty") + DB_set_sickness_by_gameid($gameid,2); /* who needs to be asked first */ + else + DB_set_sickness_by_gameid($gameid,1); /* who needs to be asked first */ + } } - else if($poverty==2 && $gametype !="dpoverty") + else if($poverty==2) /* two people have poverty */ { DB_set_gametype_by_gameid($gameid,"dpoverty"); $gametype = "dpoverty"; + $who=DB_get_sickness_by_gameid($gameid); + if(!$who) + { + $firstsick = DB_get_sickness_by_pos_and_gameid(1,$gameid); + if($firstsick == "poverty") + { + $seconsick = DB_get_sickness_by_pos_and_gameid(1,$gameid); + if($secondsick == "poverty") + DB_set_sickness_by_gameid($gameid,30); /* who needs to be asked first */ + else + DB_set_sickness_by_gameid($gameid,20); /* who needs to be asked first */ + } + else + DB_set_sickness_by_gameid($gameid,10); /* who needs to be asked first */ + } } - else if($wedding> 0 && $gametype !="wedding") + else if($wedding> 0) { DB_set_gametype_by_gameid($gameid,"wedding"); + DB_set_sickness_by_gameid($gameid,'-1'); /* wedding not resolved yet */ $gametype = "wedding"; }; @@ -541,7 +614,7 @@ else if(myisset("me")) $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid); if($usersick) - echo "$name has $usersick
"; /*TODO: perhaps save this in a string and store in Game? */ + echo "$name has $usersick.
"; /*TODO: perhaps save this in a string and store in Game? */ if($usersick=="poverty") $poverty++; @@ -580,9 +653,11 @@ else if(myisset("me")) $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid); if($usersick == "wedding") DB_set_party_by_hash($me,"re"); + else + DB_set_party_by_hash($me,"contra"); - echo "Don't know who will be Re and Contra, you need to ". - "figure that out at the end of the game yourself
\n"; + echo "Whoever will make the first trick will be on the re team.
\n"; + echo " Ok, the game can start now, please finish the setup.
"; DB_set_hand_status_by_hash($me,'play'); break; @@ -596,26 +671,264 @@ else if(myisset("me")) DB_set_hand_status_by_hash($me,'play'); break; case "poverty": - /* use extra column in DB.Game to store whom to ask, - * should be set for poverty and dpoverty(use two digits for dpoverty?) earlier*/ - + case "dpoverty": /* check if poverty resolved (e.g. DB.Game who set to NULL) * yes? =>trump was taken, start game; break; - * - * check if we are being asked now - * no, display wait message, e.g. player X is asked at the moment + */ + $who = DB_get_sickness_by_gameid($gameid); + if($who<0) + { /* trump has been taken */ + DB_set_hand_status_by_hash($me,'play'); + break; + }; + + if($who>9) /*= two people still have trump on the table*/ + $add = 10; + else + $add = 1; + + /* check if we are being asked now + * no? display wait message, e.g. player X is asked at the moment + */ + $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid); + if(myisset("trump") && $_REQUEST["trump"]=="no" && ($who==$mypos || $who==$mypos*10)) + { + /* user doesn't want to take trump */ + /* set next player who needs to be asked */ + $firstsick = (string) DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid); + $secondsick = (string) DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid); + + if($firstsick=="poverty") + { + if($secondsick=="poverty") + DB_set_sickness_by_gameid($gameid,$who+$add*3); + else + DB_set_sickness_by_gameid($gameid,$who+$add*2); + } + else + DB_set_sickness_by_gameid($gameid,$who+$add); + + /* email next player */ + $who = DB_get_sickness_by_gameid($gameid); + if($who>9) $who = $who/10; + + if($who<=4) + { + $To = DB_get_email_by_pos_and_gameid($who,$gameid); + $userhash = DB_get_hash_from_game_and_pos($gameid,$who); + DB_set_player_by_gameid($gameid,$who); + + $message = "Someone has poverty, it's your turn to decide, if you want to take the trump. Please visit:". + " ".$host."?me=".$userhash."\n\n" ; + mymail($To,$EmailName." poverty (game $gameid)",$message); + } + + /* this user is done */ + DB_set_hand_status_by_hash($me,'play'); + break; + } + else if(myisset("trump") && !myisset("exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10)) + { + /* user wants to take trump */ + $trump = $_REQUEST["trump"]; + + /* get hand id for user $trump */ + $userhand = DB_get_handid_by_gameid_and_userid($gameid,$trump); + /* copy trump from player A to B */ + $result = mysql_query("UPDATE Hand_Card SET hand_id='$myhand' WHERE hand_id='$userhand' AND card_id<'27'" ); + + /* add hidden button with trump in it to get to the next point */ + echo "
\n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo "
\n"; + } + else if(myisset("trump","exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10)) + { + $trump = $_REQUEST["trump"]; + $exchange = $_REQUEST["exchange"]; + $userhand = DB_get_handid_by_gameid_and_userid($gameid,$trump); + + /* if exchange is set to a value>0, exchange that card back to user $trump */ + if($exchange >0) + { + $result = mysql_query("UPDATE Hand_Card SET hand_id='$userhand'". + " WHERE hand_id='$myhand' AND card_id='$exchange'" ); + }; + + /* if number of cards == 12, set status to play for both users */ + $result = mysql_query("SELECT COUNT(*) FROM Hand_Card WHERE hand_id='$myhand'" ); + $r = mysql_fetch_array($result,MYSQL_NUM); + if(!$r) + { + die("error in poverty"); + }; + if($r[0]==12) + { + if($gametype=="poverty" || $who<9) + { + DB_set_sickness_by_gameid($gameid,-1); /* done with poverty */ + } + else /* reduce poverty count by one, that is go to single digits $who */ + { + $add = 1; + $who = $who/10; + + /* whom to ask next */ + $firstsick = DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid); + $secondsick = DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid); + + if($firstsick!="poverty") + DB_set_sickness_by_gameid($gameid,$who+$add); + else + { + if($secondsick!="poverty") + DB_set_sickness_by_gameid($gameid,$who+$add*2); + else + DB_set_sickness_by_gameid($gameid,$who+$add*3); + }; + + /* email next player */ + $who = DB_get_sickness_by_gameid($gameid); + if($who<=4) + { + $To = DB_get_email_by_pos_and_gameid($who,$gameid); + $userhash = DB_get_hash_from_game_and_pos($gameid,$who); + DB_set_player_by_gameid($gameid,$who); + + $message = "Someone has poverty, it's your turn to decide, ". + "if you want to take the trump. Please visit:". + " ".$host."?me=".$userhash."\n\n" ; + mymail($To,$EmailName." poverty (game $gameid)",$message); + } + + } + + /* this user is done */ + DB_set_hand_status_by_hash($me,'play'); + /* and so is his partner */ + $hash = DB_get_hash_from_gameid_and_userid($gameid,$trump); + DB_set_hand_status_by_hash($hash,'play'); + + /* set party to re, unless we had dpoverty, in that case check if we need to set re/contra*/ + $re_set=0; + foreach($userids as $user) + { + $userhash =DB_get_hash_from_gameid_and_userid($gameid,$user); + $party=DB_get_party_by_hash($userhash); + if($party=="re") + $re_set=1; + } + if($re_set) + { + DB_set_party_by_hash($me,"contra"); + DB_set_party_by_hash($hash,"contra"); + } + else + { + foreach($userids as $user) + { + $userhash =DB_get_hash_from_gameid_and_userid($gameid,$user); + if($userhash==$hash||$userhash==$me) + DB_set_party_by_hash($userhash,"re"); + else + DB_set_party_by_hash($userhash,"contra"); + } + } + + + break; + } + else + { + /* else show all trump, have lowest card pre-selected, have hidden setting for */ + echo "you need to get rid of a few cards
\n"; + + set_gametype($gametype); /* this sets the $CARDS variable */ + $mycards = DB_get_hand($me); + $mycards = mysort($mycards,$gametype); + + echo "
\n"; + $type="exchange"; + foreach($mycards as $card) + display_link_card($card,$PREF["cardset"],$type); + echo " \n"; + echo " \n"; + echo " \n"; + echo "
\n"; + } + } + else if($who == $mypos || $who == $mypos*10) + { + foreach($userids as $user) + { + $name = DB_get_name_by_userid($user); + $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid); + + if($usersick=="poverty") + { + $hash =DB_get_hash_from_gameid_and_userid($gameid,$user); + $cards=DB_get_hand($hash); + $nrtrump=count_trump($cards); + /* count trump */ + if($nrtrump<4) + echo "Player $name has $nrtrump trump. Do you want to take them?". + "yes
"; + } + } + echo "I don't want to take any trump: ". + "yes
"; + + echo "Your cards are:
\n"; + $mycards = DB_get_hand($me); + sort($mycards); + echo "

your cards are:
\n"; + foreach($mycards as $card) + display_card($card,$PREF["cardset"]); + echo "

\n"; + } + else + { + $mysick = DB_get_sickness_by_userid_and_gameid($myid,$gameid); + if($mysick=="poverty") + echo "The others are asked if they want to take your trump, you have to wait (you'll get an email)."; + else + echo "it's not your turn yet to decide if you want to take the trump or not."; + } + /* * yes, display number of trump and user's hand, ask if he wants to take it * no, set whom-to-ask to next player, email next player, cancle game if no next player * yes -> link to new page:display all cards, ask for N return cards * set re/contra * */ - case "dpoverty": - echo "TODO: handle poverty here (almost done in my developing version)"; - DB_set_hand_status_by_hash($me,'play'); }; } - + /* check if no one wanted to take trump, in that case the gamesickness would be set to 5 or 50 */ + $who = DB_get_sickness_by_gameid($gameid); + if($who==5 || $who==50) + { + $message = "Hello, \n\n". + "Game $gameid has been cancled since nobody wanted to take the trump.\n"; + + $userids = DB_get_all_userid_by_gameid($gameid); + foreach($userids as $user) + { + $To = DB_get_email_by_userid($user); + mymail($To,$EmailName."game $gameid cancled (poverty not resolved)",$message); + } + + /* delete everything from the dB */ + DB_cancel_game($me); + + echo "

Game $gameid has been cancled.

"; + output_footer(); + DB_close(); + exit(); + } + /* check if all players are ready to play */ $ok=1; foreach($userids as $user) @@ -631,19 +944,21 @@ else if(myisset("me")) $startplayer = DB_get_startplayer_by_gameid($gameid); $email = DB_get_email_by_pos_and_gameid($startplayer,$gameid); $hash = DB_get_hash_from_game_and_pos($gameid,$startplayer); + $who = DB_get_userid_by_email($email); + DB_set_player_by_gameid($gameid,$who); if($hash!=$me) { /* email startplayer) */ - $message = "It's your turn now.\n". + $message = "It's your turn now in game $gameid.\n". "Use this link to play a card: ".$host."?me=".$hash."\n\n" ; - mymail($email,$EmailName."ready, set, go... ",$message); + mymail($email,$EmailName."ready, set, go... (game $gameid) ",$message); } else echo " Please, start the game.
"; } else - echo "You finished the setup, once everyone else has done the same you'll get an email when it is your turn..
"; + echo "\n
"; break; case 'play': @@ -686,7 +1001,8 @@ else if(myisset("me")) /* has the game started? No, then just wait here...*/ if($gamestatus == 'pre') { - echo "You finished the setup, but not everyone else finished it...so you need to wait for the others...
"; + echo "You finished the setup, but not everyone else finished it... ". + "so you need to wait for the others. Just wait for the an email...
"; break; /* not sure this works... the idea is that you can * only play a card after everyone is ready to play */ } @@ -694,7 +1010,12 @@ else if(myisset("me")) /* display the table and the names */ $result = mysql_query("SELECT User.fullname as name,". " Hand.position as position, ". - " User.id ". + " User.id, ". + " Hand.party as party, ". + " Hand.sickness as sickness, ". + " Hand.point_call, ". + " User.last_login, ". + " Hand.hash ". "FROM Hand ". "LEFT JOIN User ON User.id=Hand.user_id ". "WHERE Hand.game_id='".$gameid."' ". @@ -704,17 +1025,85 @@ else if(myisset("me")) " \"table\"\n"; while($r = mysql_fetch_array($result,MYSQL_NUM)) { - $name = $r[0]; - $pos = $r[1]; - $user = $r[2]; + $name = $r[0]; + $pos = $r[1]; + $user = $r[2]; + $party = $r[3]; + $sickness = $r[4]; + $call = $r[5]; + $lastlogin = strtotime($r[6]); + $hash = $r[7]; $offset = DB_get_user_timezone($user); $zone = return_timezone($offset); date_default_timezone_set($zone); echo " \n"; - echo " $name
\n"; - echo " local time: ".date("Y-m-d H:i:s")."\n"; + if(!$debug) + echo " $name \n"; + else + { + echo "$name\n"; + } + /* add hints for poverty, wedding, solo, etc */ + if($GT=="poverty" && $party=="re") + if($sickness=="poverty") + { + $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user); + $cards = DB_get_all_hand($userhash); + $trumpNR = count_trump($cards); + if($trumpNR) + echo "(poverty < trump back)"; + else + echo "(poverty <)"; + } + else + echo "(poverty >)"; + + if($GT=="dpoverty") + if($party=="re") + if($sickness=="poverty") + { + $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user); + $cards = DB_get_all_hand($userhash); + $trumpNR = count_trump($cards); + if($trumpNR) + echo "(poverty A < trump back)"; + else + echo "(poverty A <)"; + } + else + echo "(poverty A >)"; + else + if($sickness=="poverty") + { + $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user); + $cards = DB_get_all_hand($userhash); + $trumpNR = count_trump($cards); + if($trumpNR) + echo "(poverty B < trump back)"; + else + echo "(poverty B <)"; + } + else + echo "(poverty B >)"; + + if($GT=="wedding" && $party=="re") + if($sickness=="wedding") + echo "(wedding +)"; + else + echo "(wedding)"; + + if(ereg("solo",$GT) && $party=="re") + echo "($GT)"; + + /* add point calls */ + if($call!=NULL) + echo " $party $call "; + + echo "
\n"; + echo " local time: ".date("Y-m-d H:i:s")."
\n"; + echo " last login: ".date("Y-m-d H:i:s",$lastlogin)."
\n"; echo " \n"; } @@ -725,7 +1114,9 @@ else if(myisset("me")) " Hand.position as position,". " Play.sequence as sequence, ". " Trick.id, ". - " Comment.comment ". + " Comment.comment, ". + " Play.create_date, ". + " Hand.user_id ". "FROM Trick ". "LEFT JOIN Play ON Trick.id=Play.trick_id ". "LEFT JOIN Hand_Card ON Play.hand_card_id=Hand_Card.id ". @@ -751,7 +1142,13 @@ else if(myisset("me")) $seq = $r[2]; $trick = $r[3]; $comment = $r[4]; - + $timeplayed = strtotime($r[5]); + $user = $r[6]; + + $offset = DB_get_user_timezone($user); + $zone = return_timezone($offset); + date_default_timezone_set($zone); + /* check if first schweinchen has been played */ if($r[0] == 19 || $r[0] == 20 ) $GAME["schweinchen"]++; @@ -789,7 +1186,7 @@ else if(myisset("me")) echo " ".$comment."\n"; echo " "; - display_card($r[0]); + display_card($r[0],$PREF["cardset"]); echo " \n"; /* end div card */ @@ -838,15 +1235,28 @@ else if(myisset("me")) $r = mysql_fetch_array($result,MYSQL_NUM); $handcardid = $r[0]; - if($handcardid) + if($handcardid) /* everything ok, play card */ { $comment = ""; + /* update Game timestamp */ + DB_update_game_timestamp($gameid); + + /* check if a call was made, must do this before we set the card status to played */ + if(myisset("call120") && $_REQUEST["call120"] == "yes" && can_call(120,$me)) + $result = mysql_query("UPDATE Hand SET point_call='120' WHERE hash='$me' "); + if(myisset("call90") && $_REQUEST["call90"] == "yes" && can_call(90,$me)) + $result = mysql_query("UPDATE Hand SET point_call='90' WHERE hash='$me' "); + if(myisset("call60") && $_REQUEST["call60"] == "yes" && can_call(60,$me)) + $result = mysql_query("UPDATE Hand SET point_call='60' WHERE hash='$me' "); + if(myisset("call30") && $_REQUEST["call30"] == "yes" && can_call(30,$me)) + $result = mysql_query("UPDATE Hand SET point_call='30' WHERE hash='$me' "); + if(myisset("call0") && $_REQUEST["call0"] == "yes" && can_call(0,$me)) + $result = mysql_query("UPDATE Hand SET point_call='0' WHERE hash='$me' "); + /* mark card as played */ mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=". DB_quote_smart($card)); - /* update Game timestamp */ - DB_update_game_timestamp($gameid); /* check for schweinchen */ //echo "schweinchen = ".$GAME["schweinchen"]." --$card-
"; @@ -857,16 +1267,53 @@ else if(myisset("me")) $comment="Schweinchen! "; if($RULES["schweinchen"]=="both" ) $comment="Schweinchen! "; - echo "schweinchen = ".$GAME["schweinchen"]." ---
"; + if ($debug) echo "schweinchen = ".$GAME["schweinchen"]." ---
"; } /* get trick id or start new trick */ $a = DB_get_current_trickid($gameid); $trickid = $a[0]; $sequence = $a[1]; + $tricknr = $a[2]; $playid = DB_play_card($trickid,$handcardid,$sequence); + /* if sequence == 4 check who one in case of wedding */ + if($sequence == 4 && $GT == "wedding") + { + /* is wedding resolve */ + $resolved = DB_get_sickness_by_gameid($gameid); + if($resolved<0) + { + /* who has wedding */ + $userids = DB_get_all_userid_by_gameid($gameid); + foreach($userids as $user) + { + $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid); + if($usersick == "wedding") + $whosick = $user; + } + /* who won the trick */ + $play = DB_get_cards_by_trick($trickid); + $winner = get_winner($play,$gametype); /* returns the position */ + $winnerid = DB_get_userid_by_gameid_and_position($gameid,$winner); + /* is tricknr <=3 */ + if($tricknr <=3 && $winnerid!=$whosick) + { + /* set resolved at tricknr*/ + $resolved = DB_set_sickness_by_gameid($gameid,$tricknr); + /* set partner */ + $whash = DB_get_hash_from_gameid_and_userid($gameid,$winnerid); + DB_set_party_by_hash($whash,"re"); + } + if($tricknr == 3 && $winnerid==$whosick) + { + /* set resolved at tricknr*/ + $resolved = DB_set_sickness_by_gameid($gameid,'3'); + } + } + } + /* check for coment */ if(myisset("comment")) { @@ -878,7 +1325,7 @@ else if(myisset("me")) /* display played card */ echo "
"; echo " you played
"; - display_card($card); + display_card($card,$PREF["cardset"]); echo "
\n"; /*check if we still have cards left, else set status to gameover */ @@ -918,29 +1365,45 @@ else if(myisset("me")) /* email all players */ /* individual score */ - $result = mysql_query("SELECT fullname, SUM(score), Hand.party FROM Score". - " LEFT JOIN Hand ON Hand.id=hand_id". + $result = mysql_query("SELECT fullname, IFNULL(SUM(score),0), Hand.party FROM Hand". + " LEFT JOIN Score ON Hand.id=Score.hand_id". " LEFT JOIN User ON Hand.user_id=User.id". " WHERE Hand.game_id=$gameid". " GROUP BY fullname" ); $message = "The game is over. Thanks for playing :)\n"; + $message .= "Final score:\n"; while( $r = mysql_fetch_array($result,MYSQL_NUM)) - $message .= " FINAL SCORE: ".$r[0]."(".$r[2].") ".$r[1]."\n"; - $message .= "\nIf your not in the list above your score is zero...\n\n"; + $message .= " ".$r[0]."(".$r[2].") ".$r[1]."\n"; - $result = mysql_query("SELECT Hand.party, SUM(score) FROM Score". - " LEFT JOIN Hand ON Hand.id=hand_id". + $result = mysql_query("SELECT Hand.party, IFNULL(SUM(score),0) FROM Hand". + " LEFT JOIN Score ON Hand.id=Score.hand_id". " LEFT JOIN User ON Hand.user_id=User.id". " WHERE Hand.game_id=$gameid". " GROUP BY Hand.party" ); - $message .= "\n"; + $message .= "\nTotals:\n"; while( $r = mysql_fetch_array($result,MYSQL_NUM)) - $message .= " FINAL SCORE: ".$r[0]." ".$r[1]."\n"; - + $message .= " ".$r[0]." ".$r[1]."\n"; + + /* check who wants to be CC'ed on the email */ + $h = array(); + $header = ""; + foreach($userids as $user) + { + $result = mysql_query("SELECT value from User_Prefs". + " WHERE user_id='$user' AND pref_key='ccemail'" ); + $r = mysql_fetch_array($result,MYSQL_NUM); + if($r && $r[0]=="yes") + $h[] = DB_get_email_by_userid($user); + } + if(sizeof($h)) + $header = "CC: ".join(",",$h)."\r\n"; + foreach($userids as $user) { - $To = DB_get_email_by_userid($user); - mymail($To,$EmailName."game over",$message); + $To = DB_get_email_by_userid($user); + $hash = DB_get_hash_from_gameid_and_userid($gameid,$user); + $mymessage = $message."Use this link to have a look at the game: ".$host."?me=".$hash."\n\n" ; + mymail($To,$EmailName."game over (game $gameid)",$mymessage,$header); } } @@ -980,15 +1443,13 @@ else if(myisset("me")) /* email next player */ $next_hash = DB_get_hash_from_game_and_pos($gameid,$next); $email = DB_get_email_by_hash($next_hash); - - $message = "It's your turn now.\n". + $who = DB_get_userid_by_email($email); + DB_set_player_by_gameid($gameid,$who); + + $message = "A card has been played in game $gameid.\n\n". + "It's your turn now.\n". "Use this link to play a card: ".$host."?me=".$next_hash."\n\n" ; - mymail($email,$EmailName."a card has been played",$message); - - if($debug) - echo "DEBUG: next player
\n"; - + mymail($email,$EmailName."a card has been played in game $gameid",$message); } } else @@ -1009,7 +1470,7 @@ else if(myisset("me")) { echo "Hello ".$myname.", it's your turn!
\n"; echo "Your cards are:
\n"; - echo "
\n"; + echo "\n"; /* do we have to follow suite? */ $followsuit = 0; @@ -1019,11 +1480,29 @@ else if(myisset("me")) foreach($mycards as $card) { if($followsuit && !same_type($card,$firstcard)) - display_card($card); + display_card($card,$PREF["cardset"]); else - display_link_card($card); + display_link_card($card,$PREF["cardset"]); } + if( can_call(120,$me) ) + echo " re/contra (120):". + " "; + if( can_call(90,$me) ) + echo " 90:". + " "; + if( can_call(60,$me) ) + echo " 60:". + " "; + if( can_call(30,$me) ) + echo " 30:". + " "; + if( can_call(0,$me) ) + echo " 0:". + " ". + " no call:". + " "; + echo "
\nA short comments:\n"; echo "\n"; echo "\n"; @@ -1033,7 +1512,7 @@ else if(myisset("me")) { echo "Your cards are:
\n"; foreach($mycards as $card) - display_card($card); + display_card($card,$PREF["cardset"]); } else if($mystatus=='gameover') { @@ -1041,11 +1520,11 @@ else if(myisset("me")) $oldcards = mysort($oldcards,$gametype); echo "Your cards were:
\n"; foreach($oldcards as $card) - display_card($card); + display_card($card,$PREF["cardset"]); } echo "\n"; - /* check if we need to set status to 'gameover' is done during playing of the card */ + /* if the game is over do some extra stuff, therefore exit the swtich statement if we are still playing*/ if($mystatus=='play') break; /* the following happens only when the gamestatus is 'gameover' */ @@ -1058,22 +1537,27 @@ else if(myisset("me")) { echo "the game is over now...
\n"; - $result = mysql_query("SELECT fullname, SUM(score), Hand.party FROM Score". - " LEFT JOIN Hand ON Hand.id=hand_id". + $result = mysql_query("SELECT fullname, IFNULL(SUM(score),0), Hand.party FROM Hand". + " LEFT JOIN Score ON Hand.id=Score.hand_id". " LEFT JOIN User ON Hand.user_id=User.id". " WHERE Hand.game_id=$gameid". " GROUP BY fullname" ); + echo "Final Score:
\n". + " \n";; while( $r = mysql_fetch_array($result,MYSQL_NUM)) - echo " FINAL SCORE: ".$r[0]."(".$r[2].") ".$r[1]."
"; - - $result = mysql_query("SELECT Hand.party, SUM(score) FROM Score". - " LEFT JOIN Hand ON Hand.id=hand_id". + echo " "; + echo "
".$r[0]."(".$r[2].") ".$r[1]."
\n"; + + $result = mysql_query("SELECT Hand.party, IFNULL(SUM(score),0) FROM Hand". + " LEFT JOIN Score ON Hand.id=Score.hand_id". " LEFT JOIN User ON Hand.user_id=User.id". " WHERE Hand.game_id=$gameid". " GROUP BY Hand.party" ); + echo "Totals:
\n". + " \n"; while( $r = mysql_fetch_array($result,MYSQL_NUM)) - echo " FINAL SCORE: ".$r[0]." ".$r[1]."
\n"; - + echo " \n"; + echo "
".$r[0]." ".$r[1]."
\n"; $session = DB_get_session_by_gameid($gameid); $result = mysql_query("SELECT id,create_date FROM Game". @@ -1096,6 +1580,7 @@ else if(myisset("me")) echo "error in testing the status"; } output_footer(); + DB_close(); exit(); } /* user status page */ @@ -1104,6 +1589,7 @@ else if(myisset("me")) /* test id and password, should really be done in one step */ $email = $_REQUEST["email"]; $password = $_REQUEST["password"]; + if(myisset("forgot")) { @@ -1129,6 +1615,7 @@ else if(myisset("me")) } else { + /* verify password and email */ if(strlen($password)!=32) $password = md5($password); @@ -1139,46 +1626,122 @@ else if(myisset("me")) 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 "last login: ".date("r",$unixtime)."
"; - - DB_update_user_timestamp($uid); - - 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)) + DB_get_PREF($uid); + + if(myisset("setpref")) { - 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 "
"; + $setpref=$_REQUEST["setpref"]; + switch($setpref) + { + case "germancards": + case "englishcards": + $result = mysql_query("SELECT * from User_Prefs". + " WHERE user_id='$uid' AND pref_key='cardset'" ); + if( mysql_fetch_array($result,MYSQL_NUM)) + $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart($setpref). + " WHERE user_id='$uid' AND pref_key='cardset'" ); + else + $result = mysql_query("INSERT INTO User_Prefs VALUES(NULL,'$uid','cardset',".DB_quote_smart($setpref).")"); + echo "Ok, changed you preferences for the cards.\n"; + break; + case "ccemail": + $result = mysql_query("SELECT * from User_Prefs". + " WHERE user_id='$uid' AND pref_key='ccemail'" ); + if( mysql_fetch_array($result,MYSQL_NUM)) + if($PREF["ccemail"]=="yes") + $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart("no"). + " WHERE user_id='$uid' AND pref_key='ccemail'" ); + else + $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart("yes"). + " WHERE user_id='$uid' AND pref_key='ccemail'" ); + else + $result = mysql_query("INSERT INTO User_Prefs VALUES(NULL,'$uid','ccemail',".DB_quote_smart("yes").")"); + echo "Ok, changed you preferences for being CC'ed on emails.\n"; + break; + + } + } + else /* output default user page */ + { + $time = DB_get_user_timestamp($uid); + $unixtime =strtotime($time); + + $offset = DB_get_user_timezone($uid); + $zone = return_timezone($offset); + date_default_timezone_set($zone); + + /* display links to settings */ + output_user_settings($email,$password); + + echo "last login: ".date("r",$unixtime)."
"; + + DB_update_user_timestamp($uid); + + echo "

these 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 #".$r[1]." "; + if($r[3]) + { + if($r[3]==$uid) + 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"; + + echo "

these are the games you are playing in:
\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='play'" ); + while( $r = mysql_fetch_array($result,MYSQL_NUM)) + { + echo "game #".$r[1]." "; + if($r[3]) + { + if($r[3]==$uid) + 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"; + + + echo "

and these are your games that are already done:
Game: \n"; + $output=array(); + $result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status='gameover'" ); + while( $r = mysql_fetch_array($result,MYSQL_NUM)) + $output[]= "#".$r[1]." "; + echo implode(", ",$output)."

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

registered players:
\n"; + echo implode(", ",$names)."\n"; + echo "

\n"; + + echo "

Want to start a new game? Visit this page.

"; } - echo "

\n"; - - - 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 "

\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? Visit this page.

"; } else { @@ -1186,6 +1749,7 @@ else if(myisset("me")) } }; output_footer(); + DB_close(); exit(); } /* page for registration */ @@ -1223,14 +1787,21 @@ else if(myisset("me")) /* default login page */ else { - $pre=0;$game=0;$done=0; + $pre[0]=0;$game[0]=0;$done[0]=0; $r=mysql_query("SELECT COUNT(id) FROM Game GROUP BY status"); if($r) { - $pre = mysql_fetch_array($r,MYSQL_NUM); + $pre = mysql_fetch_array($r,MYSQL_NUM); $game = mysql_fetch_array($r,MYSQL_NUM); $done = mysql_fetch_array($r,MYSQL_NUM); } - output_home_page($pre[0],$game[0],$done[0]); + + $r=mysql_query("SELECT AVG(datediff(mod_date,create_date)) FROM Game where status='gameover' "); + if($r) + $avgage= mysql_fetch_array($r,MYSQL_NUM); + else + $avgage[0]=0; + + output_home_page($pre[0],$game[0],$done[0],$avgage[0]); } output_footer();