";
+ if($finalscore)
+ {
+ echo "Score: \n";
+ /* output the final score on the front page */
+ foreach($finalscore as $user=>$value)
+ {
+ $name = DB_get_name('userid',$user);
+ echo " ".substr($name,0,2).": $value ";
+ }
+ }
+ else
+ {
+ /* first game, no score yet */
+ echo " ";
+ }
+
echo format_score_table_html($score,$myid);
echo "
\n";
+
+ /* figure out which game in a session we are in and link to the previous and next game if possible */
$hashes = DB_get_hashes_by_session($session,$myid);
+ $next = NULL;
$i = 1;
foreach($hashes as $hash)
{
@@ -179,8 +247,27 @@ if($session)
$lasthash=$hash;
}
$i--;
- echo "This is game number $j of $i in session $session.";
- echo "\n";
+
+ if($j>1)
+ $previous = $hashes[$j-2];
+ else
+ $previous = NULL;
+ if($j<$i)
+ $next = $hashes[$j];
+ else
+ $next = NULL;
+
+ if(isset($_SESSION['id']) && $_SESSION['id']==$myid)
+ {
+ if($previous)
+ echo "previous game \n";
+ echo "This is game number $j of $i in session $session.\n";
+ if($next)
+ echo " next game \n";
+ }
+ else
+ echo "This is game number $j of $i in session $session.";
+ echo "\n\n";
}
/* display the table and the names */
@@ -220,8 +307,8 @@ switch($mystatus)
$userids = DB_get_all_userid_by_gameid($gameid);
foreach($userids as $user)
{
- $To = DB_get_email('userid',$user);
- mymail($To,"$EmailName game ".DB_format_gameid($gameid)." canceled",$message);
+ $subject = 'Game '.DB_format_gameid($gameid).' canceled';
+ mymail($user,$subject,$message);
}
/* delete everything from the dB */
@@ -264,14 +351,13 @@ switch($mystatus)
{
/* email startplayer */
/*
- $email = DB_get_email('position-gameid',$startplayer,$gameid);
$hash = DB_get_hash_from_game_and_pos($gameid,$startplayer);
- $who = DB_get_userid('email',$email);
+ $who = DB_get_userid('hash',$hash);
DB_set_player_by_gameid($gameid,$who);
$message = "It's your turn now in game ".DB_format_gameid($gameid).".\n".
"Use this link to go the game: ".$HOST.$INDEX."?action=game&me=".$hash."\n\n" ;
- mymail($email,$EmailName."ready, set, go... (game ".DB_format_gameid($gameid).") ",$message);
+ mymail($who,"Ready, set, go... (game ".DB_format_gameid($gameid).") ",$message);
*/
}
}
@@ -297,7 +383,7 @@ switch($mystatus)
$userstatus = DB_get_hand_status_by_userid_and_gameid($userid,$gameid);
if($userstatus=='start' || $userstatus=='init')
- echo "
still needs to decide
\n"; /* show this to everyone */
+ echo "
still needs to decide
\n"; /* show this to everyone */
else
if($usersick!=NULL && $pos<=$mypos ) /* only show this for people sitting before the player */
echo "
\n";
else
{
- $email = DB_get_email('position-gameid',$who,$gameid);
$whohash = DB_get_hash_from_game_and_pos($gameid,$who);
DB_set_player_by_gameid($gameid,$whoid);
@@ -682,7 +767,8 @@ switch($mystatus)
/* email player for poverty */
$message = "Poverty: It's your turn now in game ".DB_format_gameid($gameid).".\n".
"Use this link to play a card: ".$HOST.$INDEX."?action=game&me=".$whohash."\n\n" ;
- mymail($email,$EmailName."Poverty (game ".DB_format_gameid($gameid).") ",$message);
+ $subject = 'Poverty (game '.DB_format_gameid($gameid).') ';
+ mymail($whoid,$subject,$message);
}
}
}
@@ -706,9 +792,6 @@ switch($mystatus)
* it is easier to check B) first
*/
- /* output pre game in case user reloads */
-
-
set_gametype($gametype); /* this sets the $CARDS variable */
$myparty = DB_get_party_by_hash($me);
@@ -734,6 +817,25 @@ switch($mystatus)
$mycards = DB_get_hand($me);
$mycards = mysort($mycards,$gametype);
+ /* output pre-game trick in case user reloads,
+ * only needs to be done when a team has been formed */
+ if($myparty=='re' || $myparty=='contra')
+ {
+ echo "\n
\n";
}
/* the following is part A) of what needs to be done */
@@ -844,8 +946,8 @@ switch($mystatus)
$userids = DB_get_all_userid_by_gameid($gameid);
foreach($userids as $user)
{
- $To = DB_get_email('userid',$user);
- mymail($To,$EmailName."game ".DB_format_gameid($gameid)." canceled (poverty not resolved)",$message);
+ $subject = 'Game '.DB_format_gameid($gameid).' canceled (poverty not resolved)';
+ mymail($user,$subject,$message);
}
/* delete everything from the dB */
@@ -857,16 +959,16 @@ switch($mystatus)
else
{
/* email next player, set his status to poverty */
- $To = DB_get_email('position-gameid',$mypos+$next,$gameid);
$userhash = DB_get_hash_from_game_and_pos($gameid,$mypos+$next);
- $userid = DB_get_userid('email',$To);
+ $userid = DB_get_userid('hash',$userhash);
DB_set_player_by_gameid($gameid,$userid);
DB_set_hand_status_by_hash($userhash,'poverty');
$message = "Someone has poverty, it's your turn to decide, if you want to take the trump. Please visit:".
" ".$HOST.$INDEX."?action=game&me=".$userhash."\n\n" ;
- mymail($To,$EmailName." poverty (game ".DB_format_gameid($gameid).")",$message);
+ $subject = 'Poverty (game '.DB_format_gameid($gameid).')';
+ mymail($userid,$subject,$message);
}
}
else
@@ -949,21 +1051,19 @@ switch($mystatus)
if($mypos+$next>4)
echo "
Error in poverty, please contact the Admin
\n";
- $To = DB_get_email('position-gameid',$mypos+$next,$gameid);
$userhash = DB_get_hash_from_game_and_pos($gameid,$mypos+$next);
- $userid = DB_get_userid('email',$To);
+ $userid = DB_get_userid('hash',$userhash);
DB_set_player_by_gameid($gameid,$userid);
DB_set_hand_status_by_hash($userhash,'poverty');
$message = "Two people have poverty, it's your turn to decide, if you want to take the trump. Please visit:".
" ".$HOST.$INDEX."?action=game&me=".$userhash."\n\n" ;
- mymail($To,$EmailName." double poverty (game ".DB_format_gameid($gameid).")",$message);
-
-
+ $subject = 'Double poverty (game '.DB_format_gameid($gameid).')';
+ mymail($userid,$subject,$message);
}
}
- echo "
\n";
+ /* get information so show the cards that have been handed over in a poverty game */
+ output_exchanged_cards();
- if($mygametype == $usersick)
- $show = 0;
- }
- }
echo "
\n
\n"; /* end div trick, end li trick */
}
@@ -1320,7 +1338,11 @@ switch($mystatus)
else
$GAME['schweinchen-second'] = 1; /* this must be the second fox */
- if( ($GAME['schweinchen-second']==1 && $RULES['schweinchen']=='second') || $RULES['schweinchen']=='both')
+ if( $RULES['schweinchen']=='both' ||
+ ($RULES['schweinchen']=='second' && $GAME['schweinchen-second']==1 )||
+ ($RULES['schweinchen']=='secondaftercall' && $GAME['schweinchen-second']==1 &&
+ (DB_get_call_by_hash($GAME['schweinchen-who']) || DB_get_partner_call_by_hash($GAME['schweinchen-who']) ))
+ )
{
DB_insert_comment('Schweinchen! ',$playid,$myid);
$commentSchweinchen = 'Schweinchen! ';
@@ -1515,15 +1537,17 @@ switch($mystatus)
if(DB_get_game_status_by_gameid($gameid)=='play')
{
$next_hash = DB_get_hash_from_game_and_pos($gameid,$next);
- $email = DB_get_email('hash',$next_hash);
- $who = DB_get_userid('email',$email);
+ $who = DB_get_userid('hash',$next_hash);
DB_set_player_by_gameid($gameid,$who);
$message = "A card has been played in game ".DB_format_gameid($gameid).".\n\n".
"It's your turn now.\n".
"Use this link to play a card: ".$HOST.$INDEX."?action=game&me=".$next_hash."\n\n" ;
if( DB_get_email_pref_by_uid($who)!='emailaddict' )
- mymail($email,$EmailName."a card has been played in game ".DB_format_gameid($gameid),$message);
+ {
+ $subject = 'A card has been played in game '.DB_format_gameid($gameid);
+ mymail($who,$subject,$message);
+ }
}
else /* send out final email */
{
@@ -1751,27 +1775,27 @@ switch($mystatus)
$message .= "Score Table:\n";
$message .= format_score_table_ascii($score);
+ $message .= "\nUse these links to have a look at game ".DB_format_gameid($gameid).": \n";
/* send out final email */
$all = array();
- foreach($userids as $user)
- $all[] = DB_get_email('userid',$user);
- $To = implode(",",$all);
-
- $help = "\n\n (you can use reply all on this email to reach all the players.)\n";
- mymail($To,$EmailName."game over (game ".DB_format_gameid($gameid).") part 1(2)",$message.$help);
-
foreach($userids as $user)
{
- $To = DB_get_email('userid',$user);
+ $all[] = DB_get_email('userid',$user);
+
+ /* add links for all players */
$hash = DB_get_hash_from_gameid_and_userid($gameid,$user);
+ $name = DB_get_name('userid',$user);
- $link = "Use this link to have a look at game ".DB_format_gameid($gameid).": ".
- $HOST.$INDEX."?action=game&me=".$hash."\n\n" ;
- if( DB_get_email_pref_by_uid($user) != 'emailaddict' )
- mymail($To,$EmailName."game over (game ".DB_format_gameid($gameid).") part 2(2)",$link);
+ $link = "$name: ".$HOST.$INDEX."?action=game&me=".$hash."\n" ;
+ $message .= $link;
}
+ $To = implode(",",$all);
+
+ $message .= "\n\n (you can use reply all on this email to reach all the players.)\n";
+ $subject = $EmailName.' Game over (game '.DB_format_gameid($gameid).') ';
+ sendmail($To,$subject,$message);
}
}
else
@@ -1808,6 +1832,42 @@ switch($mystatus)
"
".$r[2]." ".$r[1]."
\n".
" \n";
+ /* display totals */
+ $result = DB_query("SELECT Hand.party, IFNULL(SUM(Card.points),0) FROM Hand".
+ " LEFT JOIN Trick ON Trick.winner=Hand.position AND Trick.game_id=Hand.game_id".
+ " LEFT JOIN User ON User.id=Hand.user_id".
+ " LEFT JOIN Play ON Trick.id=Play.trick_id".
+ " LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id".
+ " LEFT JOIN Card ON Card.id=Hand_Card.card_id".
+ " WHERE Hand.game_id='$gameid'".
+ " GROUP BY Hand.party" );
+ echo "
\n";
+
echo " \n \n"; /* end div trick, end li trick */
}
@@ -1831,9 +1891,15 @@ switch($mystatus)
foreach($mycards as $card)
{
+ /* display only cards that the player is allowed to play as links, the rest just display normal
+ * also check if we have both schweinchen, in that case only display on of them as playable
+ */
if( ($followsuit && !same_type($card,$firstcard)) ||
- ( (int)($card)==19 && ($RULES['schweinchen']=='second'||$RULES['schweinchen']=='secondaftercall')
- && $GAME['schweinchen-who']==$me && !$GAME['schweinchen-first'] )
+ ( (int)($card)==19 && !$GAME['schweinchen-first'] &&
+ ($RULES['schweinchen']=='second'||
+ ( $RULES['schweinchen']=='secondaftercall' &&
+ (DB_get_call_by_hash($GAME['schweinchen-who']) || DB_get_partner_call_by_hash($GAME['schweinchen-who']) )))
+ && $GAME['schweinchen-who']==$me )
)
display_card($card,$PREF['cardset']);
else
@@ -1883,61 +1949,38 @@ switch($mystatus)
if(DB_get_game_status_by_gameid($gameid)=='play')
{
echo "The game is over for you.. other people still need to play though";
- }
- else
- {
- $result = DB_query("SELECT Hand.party, IFNULL(SUM(Card.points),0) FROM Hand".
- " LEFT JOIN Trick ON Trick.winner=Hand.position AND Trick.game_id=Hand.game_id".
- " LEFT JOIN User ON User.id=Hand.user_id".
- " LEFT JOIN Play ON Trick.id=Play.trick_id".
- " LEFT JOIN Hand_Card ON Hand_Card.id=Play.hand_card_id".
- " LEFT JOIN Card ON Card.id=Hand_Card.card_id".
- " WHERE Hand.game_id='$gameid'".
- " GROUP BY Hand.party" );
- echo "
\n";
-
-
}
break;
default:
myerror("error in testing the status");
}
-/* output left menu */
-display_user_menu();
-/* output right menu */
+/* output other games where it is the users turn
+ * make sure that the people looking at old games don't see the wrong games here
+ */
+if( $mystatus != 'gameover' )
+ display_user_menu($myid);
+else if( $mystatus == 'gameover' &&
+ isset($_SESSION['id']) )
+ {
+ display_user_menu($_SESSION['id']);
+ }
+else
+ {
+ echo "
\n";
+ echo "It's your turn in these games: \n";
+ echo "Please log in to see this information.\n";
+ echo "
\n";
+ }
/* display rule set for this game */
echo "
\n";
if($gamestatus == 'play' )
- output_form_calls($me);
-
+ {
+ $myparty = DB_get_party_by_hash($me);
+ output_form_calls($me,$myparty);
+ }
/* get time from the last action of the game */
$r = DB_query_array("SELECT mod_date from Game WHERE id='$gameid' " );
$gameend = time() - strtotime($r[0]);
@@ -1949,11 +1992,26 @@ if($gamestatus == 'play' || $gameend < 60*60*24*7)
echo "\n";
+/* has this hand been played by others? */
+$other_game_ids = DB_played_by_others($gameid);
+if(sizeof($other_game_ids)>0 && $mystatus=='gameover')
+ {
+ $mypos = DB_get_pos_by_hash($me);
+ echo "
See how other played the same hand: \n";
+ foreach($other_game_ids as $id)
+ {
+ $otherhash = DB_get_hash_from_game_and_pos($id,$mypos);
+ $othername = DB_get_name('hash',$otherhash);
+ echo "$othername ";
+ }
+ echo "