\n";
/* does anyone have both foxes */
$GAME["schweinchen"]=0;
for($i=1;$i<5;$i++)
{
$hash = DB_get_hash_from_game_and_pos($gameid,$i);
$cards = DB_get_all_hand($hash);
if( in_array("19",$cards) && in_array("20",$cards) )
{
$GAME["schweinchen"]=1;
$GAME["schweinchen-who"]=$hash;
}
};
/* mystatus gets the player through the different stages of a game.
* start: yes/no
* init: check values from start,
* check for sickness
* check: check for return values from init
* poverty: handle poverty, wait here until all player have reached this state
* display sickness and move on to game
* play: game in progress
* gameover: are we revisiting a game
*/
switch($mystatus)
{
case 'start':
check_want_to_play($me);
/* move on to the next stage*/
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 "

\n";
check_for_sickness($me,$mycards);
/* move on to the next stage*/
DB_set_hand_status_by_hash($me,'check');
}
}
break;
case 'check':
/* 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,
* so we should never get here,
* unless a user tries to cheat ;) */
echo "something went wrong...please contact the admin.";
}
else
{
/* check if this sickness needs to be handled first */
$gametype = DB_get_gametype_by_gameid($gameid);
$startplayer = DB_get_startplayer_by_gameid($gameid);
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\n";
DB_set_sickness_by_hash($me,"wedding");
}
else if($_REQUEST["poverty"] == "yes")
{
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".
" 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 is the most important one
* set that one in the Game table
* tell people about it.
*/
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);
$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)
{
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, 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 = 0;
$poverty = 0;
$wedding = 0;
$solo = 0;
foreach($userids as $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($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 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)
{
$To = DB_get_email_by_userid($user);
mymail($To,$EmailName."game canceled",$message);
}
/* 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();
}
else if($poverty==1)
{
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)
{
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)
{
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 */
$poverty = 0;
foreach($userids as $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 == "wedding" && $gametype =="wedding")
break;
if($usersick == "poverty" && $gametype =="poverty")
break;
if($usersick == "poverty" && $gametype =="dpoverty" && $poverty==2)
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. ";
echo "\n";
/* finished the setup, set re/contra parties if possible, go to next stage unless there is a case of poverty*/
switch($gametype)
{
case "solo":
/* are we the solo player? set us to re, else set us to contra */
$pos = DB_get_pos_by_hash($me);
if($pos == $startplayer)
DB_set_party_by_hash($me,"re");
else
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);
if(in_array('3',$hand)||in_array('4',$hand))
DB_set_party_by_hash($me,"re");
else
DB_set_party_by_hash($me,"contra");
DB_set_hand_status_by_hash($me,'play');
break;
case "poverty":
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\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
*
*/
};
}
/* 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)
{
$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)
if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='play')
$ok=0;
if($ok)
{
/* 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, at the moment you need to reload this page after everyone else has finished there setup so that the server can figure out vorbehalte... in future this will get an email in case you need to do anything, but this is not implemented yet :( ";
break;
case 'play':
case 'gameover':
/* both entries here, so that the tricks are visible for both.
* in case of 'play' there is a break later that skips the last part
*/
/* figure out what kind of game we are playing,
* set the global variables $CARDS["trump"],$CARDS["diamonds"],$CARDS["hearts"],
* $CARDS["clubs"],$CARDS["spades"],$CARDS["foxes"]
* accordingly
*/
$gametype = DB_get_gametype_by_gameid($gameid);
$GT = $gametype;
if($gametype=="solo")
{
$gametype = DB_get_solo_by_gameid($gameid);
$GT = $gametype." ".$GT;
}
else
$gametype="normal";
set_gametype($gametype); /* this sets the $CARDS variable */
/* get some infos about the game */
$gamestatus = DB_get_game_status_by_gameid($gameid);
/* display useful things in divs */
/* display links to the users status page */
$result = mysql_query("SELECT email,password from User WHERE id='$myid'" );
$r = mysql_fetch_array($result,MYSQL_NUM);
display_links($r[0],$r[1]);
/* end display useful things*/
/* 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... ";
break; /* not sure this works... the idea is that you can
* only play a card after everyone is ready to play */
}
/* display the table and the names */
$result = mysql_query("SELECT User.fullname as name,".
" Hand.position as position, ".
" User.id ".
"FROM Hand ".
"LEFT JOIN User ON User.id=Hand.user_id ".
"WHERE Hand.game_id='".$gameid."' ".
"ORDER BY position ASC");
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 "