X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=index.php;h=8e303ad28b12aafd9b4c6f25688e86e802a97bd9;hp=7addf0ef375a7f371238ffda434f372b3c2fbef9;hb=e8474ef47d5f0df524207e5dd4ab1abf2b5a7b37;hpb=a0b3efd697ed19fe2bf204868ab5920e4af5d467 diff --git a/index.php b/index.php index 7addf0e..8e303ad 100644 --- a/index.php +++ b/index.php @@ -13,15 +13,26 @@ include_once("functions.php"); /* the rest */ if(!isset($EmailName)) $EmailName="[DoKo] "; -if(0) -{ - output_header(); - echo "Working on the database...please check back in a few mintues"; - output_footer(); - exit(); -} - -DB_open(); + +/* in case work has to be done on the database or other section we can + * shut down the server and tell people to come back later + */ +if(0) + { + output_header(); + echo "Working on the database...please check back in a few mintues"; + output_footer(); + exit(); + } + +if(DB_open()<0) + { + output_header(); + echo "Database error, can't connect..."; + output_footer(); + exit(); + } + output_header(); /* check if we want to start a new game */ @@ -80,20 +91,20 @@ 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','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',". + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,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', ". + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre', ". "'$ruleset',NULL ,NULL)"); $game_id = mysql_insert_id(); @@ -147,10 +158,9 @@ if(myisset("new")) 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")) { - /* cancle a game, if it is older than N minutes */ - $me = $_REQUEST["me"]; /* test for valid ID */ @@ -172,7 +182,7 @@ else if(myisset("cancle","me")) /* check if game really is old enough */ $result = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " ); $r = mysql_fetch_array($result,MYSQL_NUM); - if(time()-strtotime($r[0]) > 60*60*24*30) + if(time()-strtotime($r[0]) > 60*60*24*30) /* = 1 month */ { $message = "Hello, \n\n". "Game $gameid has been cancled since nothing happend for a while and $myname requested it.\n"; @@ -192,12 +202,10 @@ else if(myisset("cancle","me")) else echo "

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")) { - /* handle request from one specific player, - * the hash is set on a per game base - */ - $me = $_REQUEST["me"]; /* test for valid ID */ @@ -209,7 +217,8 @@ else if(myisset("me")) output_footer(); exit(); } - + + /* the user had done something, update the timestamp */ DB_update_user_timestamp($myid); /* get some information from the DB */ @@ -217,28 +226,45 @@ 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); - /* display rule set */ - echo "
\n"; - $result = mysql_query("SELECT * FROM Rulesets LEFT JOIN Game ON Game.ruleset=Rulesets.id WHERE Game.id='$gameid'" ); + /* get prefs and save them */ + $result = mysql_query("SELECT value from User_Prefs". + " WHERE user_id='$myid' AND pref_key='cardset'" ); + $r = mysql_fetch_array($result,MYSQL_NUM); + if($r) + { + if($r[0]=="germancards" && (time()-strtotime( "2009-12-31 23:59:59")<0) ) /* licence only valid until then */ + $PREF["cardset"]="altenburg"; + else + $PREF["cardset"]="english"; + } + else + $PREF["cardset"]="english"; + + + /* get rule set for this game */ + $result = mysql_query("SELECT * FROM Rulesets". + " LEFT JOIN Game ON Game.ruleset=Rulesets.id ". + " WHERE Game.id='$gameid'" ); $r = mysql_fetch_array($result,MYSQL_NUM); - $RULES["dullen"]=$r[2]; - $RULES["schweinchen"]=$r[3]; + $RULES["dullen"] = $r[2]; + $RULES["schweinchen"] = $r[3]; /* get some infos about the game */ - $gametype = DB_get_gametype_by_gameid($gameid); + $gametype = DB_get_gametype_by_gameid($gameid); $gamestatus = DB_get_game_status_by_gameid($gameid); - $GT = $gametype; + $GT = $gametype; if($gametype=="solo") { $gametype = DB_get_solo_by_gameid($gameid); - $GT = $gametype." ".$GT; + $GT = $gametype." ".$GT; } - else - $gametype="normal"; - + + /* display rule set for this game */ + echo "
\n"; + if($gamestatus != 'pre') echo " Gametype: $GT
\n"; @@ -278,9 +304,12 @@ else if(myisset("me")) DB_set_hand_status_by_hash($me,'init'); break; case 'init': + /* first check if everything went ok in the last step + * if not, send user back, if yes, check what he did + */ 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 @@ -309,7 +338,7 @@ 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); @@ -319,10 +348,13 @@ else if(myisset("me")) } } break; - + case 'check': - echo "checking if you selected solo or nines...
". - " Please click here to finish the setup.
"; + /* ok, user is in the game, saw his cards and selected his vorbehalt + * so first we check what he selected + */ + echo "Processing what you selected in the last step...
"; + if(!myisset("solo","wedding","poverty","nines") ) { /* all these variables have a pre-selected default, @@ -338,9 +370,12 @@ else if(myisset("me")) if( $_REQUEST["solo"]!="No") { + /* user wants to play a solo */ + /* store the info in the user's hand info */ DB_set_solo_by_hash($me,$_REQUEST["solo"]); DB_set_sickness_by_hash($me,"solo"); + echo "
Seems like you want to play a ".$_REQUEST["solo"]." solo. Got it.
\n"; if($gametype == "solo" && $startplayer<$mypos) @@ -363,32 +398,30 @@ 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,". - " so 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") { - echo "What you just don't want to play a game because you have a few nines? Well, if no one". + echo "What? You just don't want to play a game because you have a few nines? Well, if no one". " 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.
"; + /* move on to the next stage*/ DB_set_hand_status_by_hash($me,'poverty'); - - break; + case 'poverty': /* here we need to check if there is a solo or some other form of sickness. - * If so, which one counts + * If so, which one is the most important one * set that one in the Game table * tell people about it. */ - echo "
checking if someone else selected solo or nines... poverty not handled at the moment
". - " Please click here to finish the setup.
"; + 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); @@ -400,26 +433,70 @@ else if(myisset("me")) $ok=0; }; - if($ok) + 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....
"; + } + else { echo "Everyone has finished checking their cards, let's see what they said...
"; - /* check what kind of game we are playing */ + + /* check what kind of game we are playing, in case there are any solos this already + *will have the correct information in it */ $gametype = DB_get_gametype_by_gameid($gameid); $startplayer = DB_get_startplayer_by_gameid($gameid); + + /* check for different sickness and just output a general info */ + - /* nines? */ $nines = 0; - /* check for nines */ + $poverty = 0; + $wedding = 0; + $solo = 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); + $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++; + echo "$name has a Vorbehalt.
"; + } + else if($usersick == 'wedding') + { + $wedding=$user; + echo "$name has a Vorbehalt.
" ; + } + else if($usersick == 'solo') + { + $solo++; + echo "$name has a Vorbehalt.
" ; + } + } + + /* now check which sickness comes first and set the gametype to it */ + /* gamestatus == normal, => cancel game */ - if($nines && $gametype != "solo") + if($gametype == "solo") + { + /* do nothing */ + } + else if($nines) { + /* cancle game */ /* TODO: should we keep statistics of this? */ $message = "Hello, \n\n". - "the game has been canceled because ".DB_get_name_by_userid($nines)." has five or more nines.\n"; + "the game has been canceled because ".DB_get_name_by_userid($nines). + " has five or more nines and nobody is playing solo.\n"; + + /* TODO: add info about redeal in case this is a game of a series */ $userids = DB_get_all_userid_by_gameid($gameid); foreach($userids as $user) @@ -430,85 +507,73 @@ else if(myisset("me")) /* delete everything from the dB */ DB_cancel_game($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(); exit(); } - - /* check for different sickness and just output a general info */ - - /* check players for poverty */ - $poverty = 0; - foreach($userids as $user) + else if($poverty==1) { - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'poverty') + DB_set_gametype_by_gameid($gameid,"poverty"); + $gametype = "poverty"; + $who=DB_get_sickness_by_gameid($gameid); + if(!$who) { - $poverty++; - $name = DB_get_name_by_userid($user); - echo "$name has a Vorbehalt.
"; + $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 */ } } - - /* check players for wedding */ - $wedding = 0; - foreach($userids as $user) + else if($poverty==2) { - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'wedding') + DB_set_gametype_by_gameid($gameid,"dpoverty"); + $gametype = "dpoverty"; + $who=DB_get_sickness_by_gameid($gameid); + if(!$who) { - $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') - { - $solo++; - $name = DB_get_name_by_userid($user); - echo "$name has a Vorbehalt.
" ; + $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 */ } } - - /* now check which sickness comes first and set the gametype to it */ - - /* if gamestatus == normal, set poverty or dpovert (in case two people have poverty) */ - if($poverty>0 && $gametype == "normal") - { - if($poverty==1) - { - DB_set_gametype_by_gameid($gameid,"poverty"); - $gametype = "poverty"; - } - else if($poverty==2) - { - DB_set_gametype_by_gameid($gameid,"dpoverty"); - $gametype = "dpoverty"; - }; - }; - /* if gamestatus == normal, set wedding */ - if($wedding> 0 && $gametype == "normal") + else if($wedding> 0) { DB_set_gametype_by_gameid($gameid,"wedding"); $gametype = "wedding"; }; - + + echo "
\n"; + /* now the gametype is set correctly (shouldn't matter that this is calculated for every user) * output what kind of game we have */ - echo "
\n"; - - $poverty=0; + $poverty = 0; foreach($userids as $user) { - $name = DB_get_name_by_userid($user); + /* userids are sorted by position... + * so output whatever the firstone has, then whatever the next one has + * stop when the sickness is the same as the gametype + */ + + $name = DB_get_name_by_userid($user); $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? */ + if($usersick=="poverty") $poverty++; - if($usersick) - echo "$name has $usersick
"; if($usersick == "wedding" && $gametype =="wedding") break; if($usersick == "poverty" && $gametype =="poverty") @@ -517,9 +582,9 @@ else if(myisset("me")) break; if($usersick == "solo" && $gametype =="solo") break; - }; + /* output Schweinchen in case the rules need it */ if( $gametype != "solo") if($GAME["schweinchen"] && $RULES["schweinchen"]=="both" ) echo DB_get_name_by_hash($GAME["schweinchen-who"])." has Schweinchen.
"; @@ -538,11 +603,18 @@ else if(myisset("me")) DB_set_party_by_hash($me,"contra"); DB_set_hand_status_by_hash($me,'play'); break; + case "wedding": + /* set person with the wedding to re, do the rest during the game */ + $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid); + if($usersick == "wedding") + DB_set_party_by_hash($me,"re"); + echo "Don't know who will be Re and Contra, you need to ". "figure that out at the end of the game yourself
\n"; DB_set_hand_status_by_hash($me,'play'); break; + case "normal": $hand = DB_get_all_hand($me); @@ -553,31 +625,205 @@ else if(myisset("me")) DB_set_hand_status_by_hash($me,'play'); break; case "poverty": - /* figure out who has poverty */ - /* check who was asked already - * everyone or trump was taken? - * trump was taken, start game - * trump was not taken, cancle game - * - * not everyone, figure out who is next in the list - * is the next person this one? - * no, display wait message, e.g. player X is asked at the moment - * yes, display trump, ask if he wants to take it - * no, set player asked to true, email next player - * yes, display all cards, ask for N return cards + case "dpoverty": + /* check if poverty resolved (e.g. DB.Game who set to NULL) + * yes? =>trump was taken, start game; break; + */ + $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); + + /* 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'" ); + + /* set re/contra, if it is not already set */ + $party = DB_get_party_by_hash($me); + if(!$party) + { + foreach($userids as $user) + { + $hash = DB_get_hash_from_gameid_and_userid($gameid,$user); + if($user == $trump || $user == $myid) + DB_set_party_by_hash($hash,"re"); + else + DB_set_party_by_hash($hash,"contra"); + } + } + /* 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; + + $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); + }; + } + + /* 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'); + + 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
"; + } + 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 double poverty here"; - DB_set_hand_status_by_hash($me,'play'); }; } - else + /* check if noone 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) { - echo "You need to wait for the others, the game can only start after everyone finished checking their cards.
"; - }; - + $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 cancled (poverty not resolved)",$message); + } + + /* delete everything from the dB */ + DB_cancel_game($me); + + echo "

Game $gameid has been cancled.

"; + output_footer(); + exit(); + } + /* check if all players are ready to play */ $ok=1; foreach($userids as $user) @@ -588,8 +834,25 @@ else if(myisset("me")) { /* only set this after all poverty, etc. are handled*/ DB_set_game_status_by_gameid($gameid,'play'); + + /* email startplayer */ + $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); + + if($hash!=$me) + { + /* email startplayer) */ + $message = "It's your turn now.\n". + "Use this link to play a card: ".$host."?me=".$hash."\n\n" ; + mymail($email,$EmailName."ready, set, go... ",$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..
"; + break; case 'play': case 'gameover': @@ -631,7 +894,7 @@ else if(myisset("me")) /* has the game started? No, then just wait here...*/ if($gamestatus == 'pre') { - echo "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...
"; break; /* not sure this works... the idea is that you can * only play a card after everyone is ready to play */ } @@ -734,7 +997,7 @@ else if(myisset("me")) echo " ".$comment."\n"; echo " "; - display_card($r[0]); + display_card($r[0],$PREF["cardset"]); echo "
\n"; /* end div card */ @@ -790,9 +1053,11 @@ else if(myisset("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-
"; + //echo "schweinchen = ".$GAME["schweinchen"]." --$card-
"; if($card == 19 || $card == 20 ) { $GAME["schweinchen"]++; @@ -821,7 +1086,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 */ @@ -952,7 +1217,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; @@ -962,9 +1227,9 @@ 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"]); } echo "
\nA short comments:\n"; @@ -976,7 +1241,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') { @@ -984,7 +1249,7 @@ 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"; @@ -1039,7 +1304,7 @@ else if(myisset("me")) echo "error in testing the status"; } output_footer(); - exit(); + exit(); } /* user status page */ else if(myisset("email","password")) @@ -1047,62 +1312,112 @@ else if(myisset("me")) /* test id and password, should really be done in one step */ $email = $_REQUEST["email"]; $password = $_REQUEST["password"]; - - if(strlen($password)!=32) - $password = md5($password); - - $ok=1; - $uid = DB_get_userid_by_email_and_password($email,$password); - if(!$uid) - $ok=0; - - if($ok) + + if(myisset("forgot")) { - $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); + $ok=1; + + $uid = DB_get_userid_by_email($email); + if(!$uid) + $ok=0; - 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)) + if($ok) { - 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 "Hmm, you forgot your passwort...nothing I can do at the moment:( "; + echo " you need to email Arun for now... in the future it will be all automated and an "; + echo "email with a new password will go to $email."; } - 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 - { - echo "sorry email and password don't match
"; + else + { + if($email=="") + echo "you need to give me an email address!"; + else + echo "couldn't find a player with this email, please contact Arun, if you think this is a mistake"; + } } + else + { + /* verify password and email */ + if(strlen($password)!=32) + $password = md5($password); + + $ok=1; + $uid = DB_get_userid_by_email_and_password($email,$password); + if(!$uid) + $ok=0; + + if($ok) + { + if(myisset("setpref")) + { + $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; + } + } + 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 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 "

\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 + { + echo "sorry email and password don't match
"; + } + }; output_footer(); exit(); }