+ $note = $_REQUEST["note"];
+
+ if($note != "")
+ DB_insert_note($note,$gameid,$myid);
+ };
+
+ /* get everything relevant to display the tricks */
+ $result = mysql_query("SELECT Hand_Card.card_id as card,".
+ " Hand.position as position,".
+ " Play.sequence as sequence, ".
+ " Trick.id, ".
+ " GROUP_CONCAT(CONCAT('<span>',User.fullname,': ',Comment.comment,'</span>')".
+ " SEPARATOR '\n' ), ".
+ " 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 ".
+ "LEFT JOIN Hand ON Hand_Card.hand_id=Hand.id ".
+ "LEFT JOIN Comment ON Play.id=Comment.play_id ".
+ "LEFT JOIN User On User.id=Comment.user_id ".
+ "WHERE Trick.game_id='".$gameid."' ".
+ "GROUP BY Trick.id, sequence ".
+ "ORDER BY Trick.id, sequence ASC");
+ $trickNR = 1;
+ $lasttrick = DB_get_max_trickid($gameid);
+
+ $play = array(); /* needed to calculate winner later */
+ $seq = 1;
+ $pos = DB_get_startplayer_by_gameid($gameid)-1;
+ $firstcard = ""; /* first card in a trick */
+
+ echo "\n<ul class=\"tricks\">\n";
+ echo " <li class=\"nohighlight\"> Game ".DB_format_gameid($gameid).": </li>\n";
+
+ /* output vorbehalte */
+ $mygametype = DB_get_gametype_by_gameid($gameid);
+ if($mygametype != "normal") /* only show when needed */
+ {
+ echo " <li onclick=\"hl('0');\" class=\"current\"><a href=\"#\">Pre</a>\n".
+ " <div class=\"trick\" id=\"trick0\">\n";
+ $show = 1;
+ for($mypos=1;$mypos<5;$mypos++)
+ {
+ $usersick = DB_get_sickness_by_pos_and_gameid($mypos,$gameid);
+ if($usersick!=NULL)
+ {
+ echo " <div class=\"vorbehalt".($mypos-1)."\"> Vorbehalt <br />";
+ if($show)
+ echo " $usersick <br />";
+ echo " </div>\n";
+
+ if($mygametype == $usersick)
+ $show = 0;
+ }
+ }
+ echo " </div>\n </li>\n"; /* end div trick, end li trick */
+ }
+
+ /* output tricks */
+ while($r = mysql_fetch_array($result,MYSQL_NUM))
+ {
+ $pos = $r[1];
+ $seq = $r[2];
+ $trick = $r[3];
+ $comment = $r[4];
+ $user = $r[6];
+
+ /* check if first schweinchen has been played */
+ if( $GAME["schweinchen"] && ($r[0] == 19 || $r[0] == 20) )
+ $GAME["schweinchen"]++;
+
+ /* save card to be able to find the winner of the trick later */
+ $play[$seq] = array("card"=>$r[0],"pos"=>$pos);
+
+ if($seq==1)
+ {
+ /* first card in a trick, output some html */
+ if($trick!=$lasttrick)
+ {
+ /* start of an old trick? */
+ echo " <li onclick=\"hl('$trickNR');\" class=\"old\"><a href=\"#\">Trick $trickNR</a>\n".
+ " <div class=\"trick\" id=\"trick".$trickNR."\">\n".
+ " <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";
+ }
+ else if($trick==$lasttrick)
+ {
+ /* start of a last trick? */
+ echo " <li onclick=\"hl('$trickNR');\" class=\"current\"><a href=\"#\">Trick $trickNR</a>\n".
+ " <div class=\"trick\" id=\"trick".$trickNR."\">\n".
+ " <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";
+ };
+
+ /* remember first card, so that we are able to check, what cards can be played */
+ $firstcard = $r[0];
+ };
+
+ /* display card */
+ echo " <div class=\"card".($pos-1)."\">\n";
+
+ /* display comments */
+ if($comment!="")
+ echo " <span class=\"comment\">".$comment."</span>\n";
+
+ echo " ";
+ display_card($r[0],$PREF["cardset"]);
+
+ echo " </div>\n"; /* end div card */
+
+ /* end of trick? */
+ if($seq==4)
+ {
+ $trickNR++;
+ echo " </div>\n </li>\n"; /* end div trick, end li trick */
+ }
+ }
+
+ /* whos turn is it? */
+ if($seq==4)
+ {
+ $winner = get_winner($play,$gametype); /* returns the position */
+ $next = $winner;
+ $firstcard = ""; /* new trick, no first card */
+ }
+ else
+ {
+ $next = $pos+1;
+ if($next==5) $next = 1;
+ }
+
+ /* my turn?, display cards as links, ask for comments*/
+ if(DB_get_pos_by_hash($me) == $next)
+ $myturn = 1;
+ else
+ $myturn = 0;
+
+ /* do we want to play a card? */
+ if(myisset("card") && $myturn)
+ {
+ $card = $_REQUEST["card"];
+ $handid = DB_get_handid_by_hash($me);
+
+ /* check if we have card and that we haven't played it yet*/
+ /* set played in hand_card to true where hand_id and card_id*/
+ $result = mysql_query("SELECT id FROM Hand_Card WHERE played='false' and ".
+ "hand_id='$handid' AND card_id=".DB_quote_smart($card));
+ $r = mysql_fetch_array($result,MYSQL_NUM);
+ $handcardid = $r[0];
+
+ if($handcardid) /* everything ok, play card */
+ {
+ /* 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));
+
+ /* 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);
+
+ /* check special output for schweinchen in case:
+ * schweinchen is in the rules, a fox has been played and the gametype is correct
+ */
+ if( $GAME["schweinchen"] &&
+ ($card == 19 || $card == 20) &&
+ ($gametype == "normal" || $gametype == "silent"|| $gametype=="trump"))
+ {
+ $GAME["schweinchen"]++; // count how many have been played including this one
+ if($GAME["schweinchen"]==3 && $RULES["schweinchen"]=="second" )
+ DB_insert_comment("Schweinchen! ",$playid,$myid);
+ if($RULES["schweinchen"]=="both" )
+ DB_insert_comment("Schweinchen! ",$playid,$myid);
+ if ($debug)
+ echo "schweinchen = ".$GAME["schweinchen"]." ---<br />";
+ }
+
+ /* 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');
+ }
+ }
+ }
+
+ /* if sequence == 4, set winner of the trick, count points and set the next player */
+ if($sequence==4)
+ {
+ $play = DB_get_cards_by_trick($trickid);
+ $winner = get_winner($play,$gametype); /* returns the position */
+
+ /* check if someone caught a fox */
+ /* first check if we should account for solos at all,
+ * since it doesn't make sense in some games
+ */
+ $ok = 0; /* fox shouldn't be counted */
+ if(DB_get_gametype_by_gameid($gameid)=="solo")
+ {
+ $solo = DB_get_solo_by_gameid($gameid);
+ if($solo == "trump" || $solo == "silent")
+ $ok = 1; /* for trump solos and silent solos, foxes are ok */
+ }
+ else
+ $ok = 1; /* for all other games (not solos) foxes are ok too */
+
+ if($ok==1)
+ foreach($play as $played)
+ {
+ if ( $played['card']==19 || $played['card']==20 )
+ if ($played['pos']!= $winner )
+ {
+ /* possible caught a fox, check party */
+ $uid1 = DB_get_userid_by_gameid_and_position($gameid,$winner);
+ $uid2 = DB_get_userid_by_gameid_and_position($gameid,$played['pos']);
+
+ $party1 = DB_get_party_by_gameid_and_userid($gameid,$uid1);
+ $party2 = DB_get_party_by_gameid_and_userid($gameid,$uid2);
+
+ if($party1 != $party2)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'$party1',$uid1,$uid2,'fox')");
+ }
+ }
+
+ /* check for karlchen (jack of clubs in the last trick)*/
+ /* same as for foxes, karlchen doesn't always make sense
+ * check what kind of game it is and set karlchen accordingly */
+ $ok = 1; /* default: karlchen should be accounted for */
+ if($tricknr != 12 )
+ $ok = 0; /* Karlchen works only in the last trick */
+ if($ok && DB_get_gametype_by_gameid($gameid)=="solo" )
+ {
+ $solo = DB_get_solo_by_gameid($gameid);
+ if($solo == "trumpless" || $solo == "jack" || $solo == "queen" )
+ $ok = 0; /* no Karlchen in these solos */
+ }
+
+ if($ok)
+ foreach($play as $played)
+ if ( $played['card']==11 || $played['card']==12 )
+ if ($played['pos'] == $winner )
+ {
+ /* possible caught a fox, check party */
+ $uid1 = DB_get_userid_by_gameid_and_position($gameid,$winner);
+ $party1 = DB_get_party_by_gameid_and_userid($gameid,$uid1);
+
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'$party1',$uid1,NULL,'karlchen')");
+ }
+ /* check for doppelopf (>40 points)*/
+ $points = 0;
+ foreach($play as $played)
+ {
+ $points += DB_get_card_value_by_cardid($played['card']);
+ }
+ if($points > 39)
+ {
+ $uid1 = DB_get_userid_by_gameid_and_position($gameid,$winner);
+ $party1 = DB_get_party_by_gameid_and_userid($gameid,$uid1);
+
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'$party1',$uid1,NULL,'doko')");
+ }
+
+ if($winner>0)
+ mysql_query("UPDATE Trick SET winner='$winner' WHERE id='$trickid'");
+ else
+ echo "ERROR during scoring";
+
+ if($debug)
+ echo "DEBUG: position $winner won the trick <br />";
+
+ /* who is the next player? */
+ $next = $winner;
+ }
+ else
+ {
+ $next = DB_get_pos_by_hash($me)+1;
+ }
+ if($next==5) $next=1;
+
+ /* check for coment */
+ if(myisset("comment"))
+ {
+ $comment = $_REQUEST["comment"];
+ if($comment != "")
+ DB_insert_comment($comment,$playid,$myid);
+ };
+
+ /* check for note */
+ if(myisset("note"))
+ {
+ $note = $_REQUEST["note"];
+ if($note != "")
+ DB_insert_note($note,$gameid,$myid);
+ };
+
+ /* display played card */
+ $pos = DB_get_pos_by_hash($me);
+ if($sequence==1)
+ {
+ echo " <li onclick=\"hl('".($tricknr)."');\" class=\"current\"><a href=\"#\">Trick ".($tricknr)."</a>\n".
+ " <div class=\"trick\" id=\"trick".($tricknr)."\">\n".
+ " <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";
+ }
+
+ echo " <div class=\"card".($pos-1)."\">\n ";
+
+ /* display comments */
+ display_card($card,$PREF["cardset"]);
+ if($comment!="")
+ echo "\n <span class=\"comment\"> ".$comment."</span>\n";
+ echo " </div>\n";
+
+ /*check if we still have cards left, else set status to gameover */
+ if(sizeof(DB_get_hand($me))==0)
+ {
+ DB_set_hand_status_by_hash($me,'gameover');
+ $mystatus = 'gameover';
+ }
+
+ /* if all players are done, set game status to game over,
+ * get the points of the last trick and send out an email
+ * to all players
+ */
+ $userids = DB_get_all_userid_by_gameid($gameid);
+
+ $done=1;
+ foreach($userids as $user)
+ if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='gameover')
+ $done=0;
+
+ if($done)
+ DB_set_game_status_by_gameid($gameid,"gameover");
+
+ /* email next player, if game is still running */
+ if(DB_get_game_status_by_gameid($gameid)=='play')
+ {
+ $next_hash = DB_get_hash_from_game_and_pos($gameid,$next);
+ $email = DB_get_email_by_hash($next_hash);
+ $who = DB_get_userid_by_email($email);
+ 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."?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);
+ }
+ else /* send out final email */
+ {
+ /* individual score */
+ $result = mysql_query("SELECT User.fullname, IFNULL(SUM(Card.points),0), Hand.party 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" );
+ $message = "The game is over. Thanks for playing :)\n";
+ $message .= "Final score:\n";
+ while( $r = mysql_fetch_array($result,MYSQL_NUM))
+ $message .= " ".$r[0]."(".$r[2].") ".$r[1]."\n";
+
+ $result = mysql_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" );
+ $message .= "\nTotals:\n";
+ $re = 0;
+ $contra = 0;
+ while( $r = mysql_fetch_array($result,MYSQL_NUM))
+ {
+ $message .= " ".$r[0]." ".$r[1]."\n";
+ if($r[0] == "re")
+ $re = $r[1];
+ else if($r[0] == "contra")
+ $contra = $r[1];
+ }
+
+ /*
+ * save score in database
+ *
+ */
+
+ /* get calls from re/contra */
+ $call_re = NULL;
+ $call_contra = NULL;
+ foreach($userids as $user)
+ {
+ $hash = DB_get_hash_from_gameid_and_userid($gameid,$user);
+ $call = DB_get_call_by_hash($hash);
+ $party = DB_get_party_by_hash($hash);
+
+ if($call!=NULL)
+ {
+ $call = (int) $call;
+
+ if($party=="re")
+ {
+ if($call_re==NULL)
+ $call_re = $call;
+ else if( $call < $call_re)
+ $call_re = $call;
+ }
+ else if($party=="contra")
+ {
+ if($call_contra==NULL)
+ $call_contra = $call;
+ else if( $call < $call_re)
+ $call_contra = $call;
+ }
+ }
+ }
+
+ /* figure out who one */
+ $winning_party = NULL;
+
+ if($call_re == NULL && $call_contra==NULL)
+ if($re>120)
+ $winning_party="re";
+ else
+ $winning_party="contra";
+ else
+ {
+ if($call_re)
+ {
+ $offset = 120 - $call_re;
+ if($call_re == 0)
+ $offset--; /* since we use a > in the next equation */
+
+ if($re > 120+$offset)
+ $winning_party="re";
+ else if ( $call_contra == NULL )
+ $winning_party="contra";
+ }
+
+ if($call_contra)
+ {
+ $offset = 120 - $call_contra;
+ if($call_contra == 0)
+ $offset--; /* since we use a > in the next equation */
+
+ if($contra > 120+$offset)
+ $winning_party="contra";
+ else if ( $call_contra == NULL )
+ $winning_party="re";
+ }
+ }
+
+ /* one point for each call of the other party in case the other party didn't win
+ * and one point each in case the party made more than points than one of the calls
+ */
+ if($winning_party!="contra" && $call_contra!=NULL)
+ {
+ for( $p=$call_contra;$p<=120; $p+=30 )
+ {
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'against$p')");
+ }
+
+ for( $p=$call_contra; $p<120; $p+=30)
+ {
+ if( $re >= $p )
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'made$p')");
+ }
+ }
+ if($winning_party!="re" and $call_re!=NULL)
+ {
+ for( $p=$call_re;$p<=120; $p+=30 )
+ {
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'against$p')");
+ }
+
+ for( $p=$call_re; $p<120; $p+=30)
+ {
+ if( $contra>=$p )
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'made$p')");
+ }
+ }
+
+ /* point in case contra won */
+ if($winning_party=="contra")
+ {
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'againstqueens')");
+ }
+
+ /* one point each for winning and each 30 points + calls */
+ if($winning_party=="re")
+ {
+ foreach(array(120,150,180,210,240) as $p)
+ {
+ $offset = 0;
+ if($p==240 || $call_contra!=NULL)
+ $offset = 1;
+
+ if($re>$p-$offset)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'".(240-$p)."')");
+ }
+ /* re called something and won */
+ foreach(array(0,30,60,90,120) as $p)
+ {
+ if($call_re!=NULL && $call_re<$p+1)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'call$p')");
+ }
+ }
+ else if( $winning_party=="contra")
+ {
+ foreach(array(120,150,180,210,240) as $p)
+ {
+ $offset = 0;
+ if($p==240 || $call_re!=NULL)
+ $offset = 1;
+
+ if($contra>$p-$offset)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'".(240-$p)."')");
+ }
+ /* re called something and won */
+ foreach(array(0,30,60,90,120) as $p)
+ {
+ if($call_contra!=NULL && $call_contra<$p+1)
+ mysql_query("INSERT INTO Score".
+ " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'call$p')");
+ }
+ }
+
+
+ /* add score points to email */
+ $message .= "\n";
+ $Tpoint = 0;
+ $message .= " Points Re: \n";
+ $queryresult = mysql_query("SELECT score FROM Score ".
+ " WHERE game_id=$gameid AND party='re'".
+ " ");
+ while($r = mysql_fetch_array($queryresult,MYSQL_NUM) )
+ {
+ $message .= " ".$r[0]."\n";
+ $Tpoint ++;
+ }
+ $message .= " Points Contra: \n";
+ $queryresult = mysql_query("SELECT score FROM Score ".
+ " WHERE game_id=$gameid AND party='contra'".
+ " ");
+ while($r = mysql_fetch_array($queryresult,MYSQL_NUM) )
+ {
+ $message .= " ".$r[0]."\n";
+ $Tpoint --;
+ }
+ $message .= " Total Points (from the Re point of view): $Tpoint\n";
+ $message .= "\n";
+
+ $session = DB_get_session_by_gameid($gameid);
+ $score = generate_score_table($session);
+ /* convert html to ascii */
+ $score = str_replace("<div class=\"scoretable\">\n<table class=\"score\">\n <tr>\n","",$score);
+ $score = str_replace("</table></div>\n","",$score);
+ $score = str_replace("\n","",$score);
+ $score = str_replace(array("<tr>","</tr>","<td>","</td>"),array("","\n","","|"),$score);
+ $score = explode("\n",$score);
+
+ $header = array_slice($score,0,1);
+ $header = explode("|",$header[0]);
+ for($i=0;$i<sizeof($header);$i++)
+ $header[$i]=str_pad($header[$i],6," ",STR_PAD_BOTH);
+ $header = implode("|",$header);
+ $header.= "\n------+------+------+------+------+\n";
+ if(sizeof($score)>5) $header.= " ... \n";
+
+ if(sizeof($score)>5) $score = array_slice($score,-5,5);
+ for($i=0;$i<sizeof($score);$i++)
+ {
+ $line = explode("|",$score[$i]);
+ for($j=0;$j<sizeof($line);$j++)
+ $line[$j]=str_pad($line[$j],6," ",STR_PAD_LEFT);
+ $score[$i] = implode("|",$line);
+ }
+
+ $score = implode("\n",$score);
+ $score = $header.$score;
+
+ $message .= "Score Table:\n";
+ $message .= $score;
+
+ /* send out final email */
+ $all = array();
+
+ foreach($userids as $user)
+ $all[] = DB_get_email_by_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_by_userid($user);
+ $hash = DB_get_hash_from_gameid_and_userid($gameid,$user);
+
+ $link = "Use this link to have a look at game ".DB_format_gameid($gameid).": ".
+ $HOST.$INDEX."?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);
+ }
+ }
+ }
+ else
+ {
+ echo "can't find that card?! <br />\n";
+ }
+ }
+ else if(myisset("card") && !$myturn )
+ {
+ echo "please wait until it's your turn! <br />\n";
+ }
+
+ if($seq!=4 && $trickNR>1)
+ echo " </div>\n </li>\n"; /* end div trick, end li trick */
+
+ /* display points in case game is over */
+ if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' )
+ {
+ echo " <li onclick=\"hl('13');\" class=\"current\"><a href=\"#\">Score</a>\n".
+ " <div class=\"trick\" id=\"trick13\">\n";
+ /* add pic for re/contra
+ " <img class=\"arrow\" src=\"pics/arrow".($pos-1).".png\" alt=\"table\" />\n";*/
+
+ $result = mysql_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 = mysql_fetch_array($result,MYSQL_NUM))
+ echo " <div class=\"card".($r[3]-1)."\">\n".
+ " <div class=\"score\">".$r[2]."<br /> ".$r[1]."</div>\n".
+ " </div>\n";
+
+ echo " </div>\n </li>\n"; /* end div trick, end li trick */
+ }
+
+
+ echo "</ul>\n"; /* end ul tricks*/
+
+ echo "<div class=\"notes\"> Personal notes: <br />\n";
+ $notes = DB_get_notes_by_userid_and_gameid($myid,$gameid);
+ foreach($notes as $note)
+ echo "$note <hr \>\n";
+ echo "Insert note:<input name=\"note\" type=\"text\" size=\"15\" maxlength=\"100\" />\n";
+ echo "</div> \n";
+
+ $mycards = DB_get_hand($me);
+ $mycards = mysort($mycards,$gametype);
+ echo "<div class=\"mycards\">\n";
+
+ if($myturn && !myisset("card") && $mystatus=='play' )
+ {
+ echo "Hello ".$myname.", it's your turn! <br />\n";
+ echo "Your cards are: <br />\n";
+
+ /* do we have to follow suite? */
+ $followsuit = 0;
+ if(have_suit($mycards,$firstcard))
+ $followsuit = 1;
+
+ foreach($mycards as $card)
+ {
+ if($followsuit && !same_type($card,$firstcard))
+ display_card($card,$PREF["cardset"]);
+ else
+ display_link_card($card,$PREF["cardset"]);
+ }
+ }
+ else if($mystatus=='play' )
+ {
+ echo "Your cards are: <br />\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: <br />\n";
+ foreach($oldcards as $card)
+ display_card($card,$PREF["cardset"]);
+
+ $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 "<br />";
+
+ $name = DB_get_name_by_userid($user);
+ $oldcards = DB_get_all_hand($userhash);
+ $oldcards = mysort($oldcards,$gametype);
+ echo "$name's cards were: <br />\n";
+ foreach($oldcards as $card)
+ display_card($card,$PREF["cardset"]);
+ }
+ };
+ }
+ echo "</div>\n";
+
+ /* if the game is over do some extra stuff, therefore exit the swtich statement if we are still playing*/
+ if($mystatus=='play')