X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fgame.php;h=fb807c74ed4533da18ccdc4da77e2f8c159e9e14;hp=2ab444b1aa0d418007efe0407f9479e7071c22cb;hb=11882439a450641bf0d4dd048775d0bdfb592642;hpb=12a7da9216b33c12ecc7939be1f6e8a48a273b00
diff --git a/include/game.php b/include/game.php
index 2ab444b..fb807c7 100644
--- a/include/game.php
+++ b/include/game.php
@@ -25,7 +25,8 @@ if(!$myid)
global $GAME,$RULES,$CARDS;
/* the user has done something, update the timestamp */
-DB_update_user_timestamp($myid);
+if(isset($_SESSION['id']))
+ DB_update_user_timestamp($_SESSION['id']);
/* get some information from the DB */
$gameid = DB_get_gameid_by_hash($me);
@@ -36,7 +37,7 @@ $myhand = DB_get_handid('hash',$me);
$session = DB_get_session_by_gameid($gameid);
/* get prefs and save them in a variable*/
-$PREF = DB_get_PREF($myid);
+$PREF = DB_get_PREF(isset($_SESSION['id'])?$_SESSION['id']:$myid);
/* get rule set for this game */
$RULES = DB_get_RULES($gameid);
@@ -65,7 +66,7 @@ if( $gamestatus == 'pre' )
else
{
/* in a game Schweinchen is not valid in all types of games */
- if( $gametype == 'normal' || $gametype == 'silent' || $gametype=='trump' )
+ if( $gametype == 'normal' || $gametype == 'silent' || $gametype=='trump' || $gametype=='wedding')
if( in_array($RULES['schweinchen'],array('both','second','secondaftercall')) )
$ok=1;
}
@@ -108,7 +109,15 @@ if( $mystatus!='gameover' )
if($note != '')
DB_insert_note($note,$gameid,$myid);
};
-output_user_notes($myid,$gameid,$mystatus);
+
+/* make sure that we don't show the notes to the wrong person
+ * (e.g. other people looking at an old game)
+ */
+if( $mystatus != 'gameover' ||
+ ( $mystatus == 'gameover' &&
+ isset($_SESSION['id']) &&
+ $myid == $_SESSION['id']))
+ output_user_notes($myid,$gameid,$mystatus);
/* handle calls */
if(myisset('call') && $_REQUEST['call'] == '120' && can_call(120,$me))
@@ -126,12 +135,45 @@ if(myisset('call') && $_REQUEST['call'] == '0' && can_call(0,$me))
if($session)
{
echo "
Score \n";
$score = generate_score_table($session);
echo format_score_table_html($score,$myid);
@@ -146,8 +188,11 @@ if($session)
$lasthash=$hash;
}
$i--;
- echo "This is game number $j of $i in session $session.";
- echo "
\n";
+ if(isset($_SESSION['id']) && $_SESSION['id']==$myid)
+ echo "This is game number $j of $i in session $session.";
+ else
+ echo "This is game number $j of $i in session $session.";
+ echo "\n
\n";
}
/* display the table and the names */
@@ -249,31 +294,31 @@ switch($mystatus)
$mycards = DB_get_hand($me);
$mycards = mysort($mycards,$gametype);
- /* output sickness of other playes, in case the already selected and are sitting in front of the current player */
- echo "\n
\n";
-
- for($pos=1;$pos<5;$pos++)
+ if(!myisset('solo','wedding','poverty','nines') )
{
- $usersick = DB_get_sickness_by_pos_and_gameid($pos,$gameid);
- $userid = DB_get_userid('gameid-position',$gameid,$pos);
- $userstatus = DB_get_hand_status_by_userid_and_gameid($userid,$gameid);
+ /* output sickness of other playes, in case the already selected and are sitting in front of the current player */
+ echo "\n
\n"; /* end div trick, end li trick , end tricks*/
+ /* end displaying sickness */
- if(!myisset('solo','wedding','poverty','nines') )
- {
output_check_for_sickness($me,$mycards);
echo "
Your cards are: \n";
@@ -365,35 +410,31 @@ switch($mystatus)
* this can therefore only be handled once all players finished the last stage
*/
- /* only need to redisplay the cards when the user reloads the page and lands directly here */
- if($mystatus=='check')
- {
- $mycards = DB_get_hand($me);
- $mycards = mysort($mycards,$gametype);
+ $mycards = DB_get_hand($me);
+ $mycards = mysort($mycards,$gametype);
- /* output sickness of other playes, in case the already selected and are sitting in front of the current player */
- echo "\n
\n"; /* show this to everyone */
- else
- if($usersick!=NULL) /* in the init-phase we only showed players with $pos<$mypos, now we can show all */
- echo "
sick
\n";
- else
- echo "
healthy
\n";
- }
- echo "
\n
\n
\n"; /* end div trick, end li trick , end tricks*/
- /* end displaying sickness */
+ if($userstatus=='start' || $userstatus=='init')
+ echo "
still needs to decide
\n"; /* show this to everyone */
+ else
+ if($usersick!=NULL) /* in the init-phase we only showed players with $pos<$mypos, now we can show all */
+ echo "
sick
\n";
+ else
+ echo "
healthy
\n";
}
+ echo "
\n
\n
\n"; /* end div trick, end li trick , end tricks*/
+ /* end displaying sickness */
echo "
\n";
echo "
Checking if someone else selected solo, nines, wedding or poverty.
";
@@ -697,6 +738,7 @@ switch($mystatus)
{
$result = DB_query("UPDATE Hand_Card SET hand_id='$partnerhand'".
" WHERE hand_id='$myhand' AND card_id=".DB_quote_smart($exchange));
+ DB_add_exchanged_card(DB_quote_smart($exchange),$myhand,$partnerhand);
};
}
@@ -835,7 +877,7 @@ switch($mystatus)
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" ;
+ " ".$HOST.$INDEX."?action=game&me=".$userhash."\n\n" ;
mymail($To,$EmailName." poverty (game ".DB_format_gameid($gameid).")",$message);
}
}
@@ -848,6 +890,12 @@ switch($mystatus)
$userhand = DB_get_handid('gameid-userid',$gameid,$trump);
$userhash = DB_get_hash_from_gameid_and_userid($gameid,$trump);
+ /* remember which cards were handed over*/
+ $partnerhand = DB_get_all_hand($userhash);
+ foreach ($partnerhand as $card)
+ if($card<27)
+ DB_add_exchanged_card($card,$userhand,$myhand);
+
/* copy trump from player A to B */
$result = DB_query("UPDATE Hand_Card SET hand_id='$myhand' WHERE hand_id='$userhand' AND card_id<'27'" );
@@ -1071,15 +1119,87 @@ switch($mystatus)
{
echo "
\n \n"; /* end div trick, end li trick */
+
/*check if we still have cards left, else set status to gameover */
if(sizeof(DB_get_hand($me))==0)
{
@@ -1488,7 +1606,7 @@ switch($mystatus)
{
if($call_contra==NULL)
$call_contra = $call;
- else if( $call < $call_re)
+ else if( $call < $call_contra)
$call_contra = $call;
}
}
@@ -1649,237 +1767,267 @@ 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;
}
- }
- }
- else
- {
- echo "can't find that card?! \n";
- }
- }
- else if(myisset('card') && !$myturn )
- {
- echo "please wait until it's your turn! \n";
- }
+ $To = implode(",",$all);
- if($seq!=4 && $trickNR>=1)
- echo "
\n \n"; /* end div trick, end li trick */
+ $message .= "\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).") ",$message);
+ }
+ }
+ else
+ {
+ echo "can't find that card?! \n";
+ }
+ }
+ else if(myisset('card') && !$myturn )
+ {
+ echo "please wait until it's your turn! \n";
+ }
- /* display points in case game is over */
- if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' )
- {
- echo "
\n";
- /* add pic for re/contra
- " \n";*/
-
- $result = DB_query("SELECT User.fullname, IFNULL(SUM(Card.points),0), Hand.party,Hand.position 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 User.fullname" );
- while( $r = DB_fetch_array($result))
- echo "
\n".
- "
".$r[2]." ".$r[1]."
\n".
- "
\n";
-
- echo "
\n
\n"; /* end div trick, end li trick */
- }
-
- echo "
\n \n"; /* end div trick, end li trick */
- $userids = DB_get_all_userid_by_gameid($gameid);
- foreach($userids as $user)
- {
- $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
-
- if($userhash!=$me)
- {
- echo " ";
-
- $name = DB_get_name('userid',$user);
- $oldcards = DB_get_all_hand($userhash);
- $oldcards = mysort($oldcards,$gametype);
- echo "$name's cards were: \n";
- foreach($oldcards as $card)
- display_card($card,$PREF['cardset']);
- }
- };
- }
- echo "\n";
-
- /* if the game is over do some extra stuff, therefore exit the swtich statement if we are still playing*/
- if($mystatus=='play')
- break;
+ /* display points in case game is over */
+ if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' )
+ {
+ echo "
\n";
+ /* add pic for re/contra
+ " \n";*/
+
+ $result = DB_query("SELECT User.fullname, IFNULL(SUM(Card.points),0), Hand.party,Hand.position 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 User.fullname" );
+ while( $r = DB_fetch_array($result))
+ echo "
\n".
+ "
".$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";
- /* the following happens only when the gamestatus is 'gameover' */
- /* check if game is over, display results */
- if(DB_get_game_status_by_gameid($gameid)=='play')
- {
- echo "The game is over for you.. other people still need to play though";
- }
- else
- {
- $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";
- /* 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]);
+ if($myturn && !myisset('card') && $mystatus=='play' )
+ {
+ echo "Hello ".$myname.", it's your turn! \n";
+ echo "Your cards are: \n";
- if($gamestatus == 'play' || $gameend < 60*60*24*7)
+ /* do we have to follow suite? */
+ $followsuit = 0;
+ if(have_suit($mycards,$firstcard))
+ $followsuit = 1;
+
+ 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 && !$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
+ display_link_card($card,$PREF['cardset']);
+ }
+ }
+ else if($mystatus=='play' )
{
- echo " \nA short comment:\n";
+ echo "Your cards are: \n";
+ foreach($mycards as $card)
+ display_card($card,$PREF['cardset']);
}
+ else if($mystatus=='gameover')
+ {
+ $oldcards = DB_get_all_hand($me);
+ $oldcards = mysort($oldcards,$gametype);
+ echo "Your cards were: \n";
+ foreach($oldcards as $card)
+ display_card($card,$PREF['cardset']);
- echo "\n";
+ $userids = DB_get_all_userid_by_gameid($gameid);
+ foreach($userids as $user)
+ {
+ $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
+ if($userhash!=$me)
+ {
+ echo " ";
+
+ $name = DB_get_name('userid',$user);
+ $oldcards = DB_get_all_hand($userhash);
+ $oldcards = mysort($oldcards,$gametype);
+ echo "$name's cards were: \n";
+ foreach($oldcards as $card)
+ display_card($card,$PREF['cardset']);
+ }
+ };
+ }
echo "
\n";
- echo "\n";
+ /* if the game is over do some extra stuff, therefore exit the swtich statement if we are still playing*/
+ if($mystatus=='play')
+ break;
- if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' )
+ /* the following happens only when the gamestatus is 'gameover' */
+ /* check if game is over, display results */
+ if(DB_get_game_status_by_gameid($gameid)=='play')
+ {
+ echo "The game is over for you.. other people still need to play though";
+ }
+ break;
+ default:
+ myerror("error in testing the status");
+ }
+
+/* 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);
+
+/* 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]);
+
+if($gamestatus == 'play' || $gameend < 60*60*24*7)
+ {
+ echo " \nA short comment:\n";
+ }
+
+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 "
\n";
+ }
- $session = DB_get_session_by_gameid($gameid);
- $result = DB_query("SELECT id,create_date FROM Game".
- " WHERE session=$session".
- " ORDER BY create_date DESC".
- " LIMIT 1");
- $r = -1;
- if($result)
- $r = DB_fetch_array($result);
+echo "
\n";
- if(!$session || $gameid==$r[0])
- {
- /* suggest a new game with the same people in it, just rotated once (unless last game was solo) */
- $names = DB_get_all_names_by_gameid($gameid);
- $type = DB_get_gametype_by_gameid($gameid);
+echo "\n";
- if($type=='solo')
- {
- $solo = DB_get_solo_by_gameid($gameid);
+if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' && isset($_SESSION['id']) && $_SESSION['id']==$myid)
+ {
+ $session = DB_get_session_by_gameid($gameid);
+ $result = DB_query("SELECT id,create_date FROM Game".
+ " WHERE session=$session".
+ " ORDER BY create_date DESC".
+ " LIMIT 1");
+ $r = -1;
+ if($result)
+ $r = DB_fetch_array($result);
+
+ if(!$session || $gameid==$r[0])
+ {
+ /* suggest a new game with the same people in it, just rotated once (unless last game was solo) */
+ $names = DB_get_all_names_by_gameid($gameid);
+ $type = DB_get_gametype_by_gameid($gameid);
- if($solo!='silent') /* repeat game with same first player */
- output_ask_for_new_game($names[0],$names[1],$names[2],$names[3],$gameid);
- else /* rotate normally */
- output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
- }
+ if($type=='solo')
+ {
+ $solo = DB_get_solo_by_gameid($gameid);
+
+ if($solo!='silent') /* repeat game with same first player */
+ output_ask_for_new_game($names[0],$names[1],$names[2],$names[3],$gameid);
else /* rotate normally */
output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
}
+ else /* rotate normally */
+ output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
}
+ }
?>
\ No newline at end of file