projects / e-DoKo.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
feature: added link to game in final email, CC'ed people in final email
[e-DoKo.git] / index.php
diff --git a/index.php b/index.php
index 712b48b4ce745e6ba2999572b50b88f0a219089e..e8fffb7478d36abf6d195fca5579b44a1c5a1b8e 100644 (file)
--- a/index.php
+++ b/index.php
@@ -117,16 +117,16 @@ if(myisset("new"))
     
     /* create hands */
     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridA).
     
     /* create hands */
     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridA).
-               ", ".DB_quote_smart($hashA).", 'start','1',NULL,NULL,NULL,'false','false',NULL)");
+               ", ".DB_quote_smart($hashA).", 'start','1',NULL,NULL,NULL,NULL)");
     $hand_idA = mysql_insert_id();                                                            
     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridB).
     $hand_idA = mysql_insert_id();                                                            
     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridB).
-               ", ".DB_quote_smart($hashB).", 'start','2',NULL,NULL,NULL,'false','false',NULL)");
+               ", ".DB_quote_smart($hashB).", 'start','2',NULL,NULL,NULL,NULL)");
     $hand_idB = mysql_insert_id();                                                            
     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridC).
     $hand_idB = mysql_insert_id();                                                            
     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridC).
-               ", ".DB_quote_smart($hashC).", 'start','3',NULL,NULL,NULL,'false','false',NULL)");
+               ", ".DB_quote_smart($hashC).", 'start','3',NULL,NULL,NULL,NULL)");
     $hand_idC = mysql_insert_id();                                                            
     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridD).
     $hand_idC = mysql_insert_id();                                                            
     mysql_query("INSERT INTO Hand VALUES (NULL,".DB_quote_smart($game_id).",".DB_quote_smart($useridD).
-               ", ".DB_quote_smart($hashD).", 'start','4',NULL,NULL,NULL,'false','false',NULL)");
+               ", ".DB_quote_smart($hashD).", 'start','4',NULL,NULL,NULL,NULL)");
     $hand_idD = mysql_insert_id();
     
     /* save cards */
     $hand_idD = mysql_insert_id();
     
     /* save cards */
@@ -150,7 +150,7 @@ if(myisset("new"))
       "$PlayerC\n".
       "$PlayerD\n\n".
       "If you want to join this game, please follow this link:\n\n".
       "$PlayerC\n".
       "$PlayerD\n\n".
       "If you want to join this game, please follow this link:\n\n".
-      " ".$host."?me=";
+      "".$host."?me=";
     
     mymail($EmailA,"You are invited to a game of DoKo","Hello $PlayerA,\n".$message.$hashA);
     mymail($EmailB,"You are invited to a game of DoKo","Hello $PlayerB,\n".$message.$hashB);
     
     mymail($EmailA,"You are invited to a game of DoKo","Hello $PlayerA,\n".$message.$hashA);
     mymail($EmailB,"You are invited to a game of DoKo","Hello $PlayerB,\n".$message.$hashB);
@@ -192,7 +192,7 @@ else if(myisset("cancle","me"))
        foreach($userids as $user)
          {
            $To = DB_get_email_by_userid($user);
        foreach($userids as $user)
          {
            $To = DB_get_email_by_userid($user);
-           mymail($To,$EmailName."game cancled (timed out)",$message);
+           mymail($To,$EmailName."game $gameid cancled (timed out)",$message);
          }
        
        /* delete everything from the dB */
          }
        
        /* delete everything from the dB */
@@ -230,18 +230,8 @@ else if(myisset("me"))
     $myhand   = DB_get_handid_by_hash($me);
 
     /* get prefs and save them */
     $myhand   = DB_get_handid_by_hash($me);
 
     /* 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";
+    DB_get_PREF($myid);
+    /* end set pref */
       
       
     /* get rule set for this game */
       
       
     /* get rule set for this game */
@@ -325,7 +315,7 @@ else if(myisset("me"))
                foreach($userids as $user)
                  {
                    $To = DB_get_email_by_userid($user);
                foreach($userids as $user)
                  {
                    $To = DB_get_email_by_userid($user);
-                   mymail($To,$EmailName."game canceled",$message);
+                   mymail($To,$EmailName."game $gameid canceled",$message);
                  }
                
                /* delete everything from the dB */
                  }
                
                /* delete everything from the dB */
@@ -414,6 +404,29 @@ else if(myisset("me"))
 
       /* move on to the next stage*/
       DB_set_hand_status_by_hash($me,'poverty');
 
       /* move on to the next stage*/
       DB_set_hand_status_by_hash($me,'poverty');
+
+      /* check if everyone has reached this stage, send out email */
+      $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)
+       foreach($userids as $user)
+         {
+           $To = DB_get_email_by_userid($user);
+           $userhash =DB_get_hash_from_gameid_and_userid($gameid,$user);
+           if($userhash!=$me)
+             {
+               $message = "Everyone finish the questionary in game $gameid, please visit this link now to continue: \n".
+                 " ".$host."?me=".$userhash."\n\n" ;
+               mymail($To,$EmailName." finished setup",$message);
+             }
+         };
+
       break;
 
     case 'poverty':
       break;
 
     case 'poverty':
@@ -437,7 +450,7 @@ else if(myisset("me"))
       if(!$ok)
        {
          echo "This step can only be handled after everyone finished the last step. ".
       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....<br />";
+           "Seems like this is not the case, so you need to wait a bit... you will get an email once that is the case, please use the link in that email to continue the game.<br />";
        }
       else
        {
        }
       else
        {
@@ -503,7 +516,7 @@ else if(myisset("me"))
              foreach($userids as $user)
                {
                  $To = DB_get_email_by_userid($user);
              foreach($userids as $user)
                {
                  $To = DB_get_email_by_userid($user);
-                 mymail($To,$EmailName."game canceled",$message);
+                 mymail($To,$EmailName."game $gameid canceled",$message);
                }
              
              /* delete everything from the dB */
                }
              
              /* delete everything from the dB */
@@ -551,6 +564,7 @@ else if(myisset("me"))
          else if($wedding> 0)
            {
              DB_set_gametype_by_gameid($gameid,"wedding");
          else if($wedding> 0)
            {
              DB_set_gametype_by_gameid($gameid,"wedding");
+             DB_set_sickness_by_gameid($gameid,'-1'); /* wedding not resolved yet */
              $gametype = "wedding";
            };
 
              $gametype = "wedding";
            };
 
@@ -610,9 +624,11 @@ else if(myisset("me"))
              $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
              if($usersick == "wedding")
                DB_set_party_by_hash($me,"re");
              $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
              if($usersick == "wedding")
                DB_set_party_by_hash($me,"re");
+             else
+               DB_set_party_by_hash($me,"contra");
              
              
-             echo "Don't know who will be Re and Contra, you need to ".
-               "figure that out at the end of the game yourself <br />\n";
+             echo "Whoever will make the first trick will be on the re team. <br />\n";
+             echo " Ok, the game can start now, please finish <a href=\"$host?me=$me\">the setup</a>.<br />";       
              DB_set_hand_status_by_hash($me,'play');
              break;
 
              DB_set_hand_status_by_hash($me,'play');
              break;
 
@@ -630,7 +646,7 @@ else if(myisset("me"))
              /* check if poverty resolved (e.g. DB.Game who set to NULL)
               *   yes? =>trump was taken, start game; break; 
               */
              /* 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);
+             $who = DB_get_sickness_by_gameid($gameid);
              if($who<0)
                { /* trump has been taken */
                  DB_set_hand_status_by_hash($me,'play');
              if($who<0)
                { /* trump has been taken */
                  DB_set_hand_status_by_hash($me,'play');
@@ -638,12 +654,12 @@ else if(myisset("me"))
                };
              
              if($who>9) /*= two people still have trump on the table*/
                };
              
              if($who>9) /*= two people still have trump on the table*/
-               $add=10;
+               $add = 10;
              else
              else
-               $add=1;
+               $add = 1;
 
              /* check if we are being asked now
 
              /* check if we are being asked now
-              *    no, display wait message, e.g. player X is asked at the moment 
+              *    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))
               */
              $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
              if(myisset("trump") && $_REQUEST["trump"]=="no" && ($who==$mypos || $who==$mypos*10))
@@ -663,6 +679,20 @@ else if(myisset("me"))
                  else
                    DB_set_sickness_by_gameid($gameid,$who+$add);
 
                  else
                    DB_set_sickness_by_gameid($gameid,$who+$add);
 
+                 /* email next player */
+                 $who = DB_get_sickness_by_gameid($gameid);
+                 if($who>9) $who = $who/10;
+                 
+                 if($who<=4)
+                   {
+                     $To       = DB_get_email_by_pos_and_gameid($who,$gameid);
+                     $userhash = DB_get_hash_from_game_and_pos($gameid,$who);
+                     
+                     $message = "Someone has poverty, it's your turn to decide, if you want to take the trump. Please visit:".
+                       " ".$host."?me=".$userhash."\n\n" ;
+                     mymail($To,$EmailName." poverty",$message);
+                   }
+
                  /* this user is done */
                  DB_set_hand_status_by_hash($me,'play');
                  break;                
                  /* this user is done */
                  DB_set_hand_status_by_hash($me,'play');
                  break;                
@@ -673,23 +703,10 @@ else if(myisset("me"))
                  $trump = $_REQUEST["trump"];
 
                  /* get hand id for user $trump */
                  $trump = $_REQUEST["trump"];
 
                  /* get hand id for user $trump */
-                 $userhand=DB_get_handid_by_gameid_and_userid($gameid,$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'" );
                  
                  /* 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 "<form action=\"index.php\" method=\"post\">\n";
                  echo "  <input type=\"hidden\" name=\"exchange\" value=\"-1\" />\n";
                  /* add hidden button with trump in it to get to the next point */
                  echo "<form action=\"index.php\" method=\"post\">\n";
                  echo "  <input type=\"hidden\" name=\"exchange\" value=\"-1\" />\n";
@@ -726,11 +743,13 @@ else if(myisset("me"))
                        }
                      else /* reduce poverty count by one, that is go to single digits $who */
                        {
                        }
                      else /* reduce poverty count by one, that is go to single digits $who */
                        {
-                         $add=1;
-                         $who=$who/10;
+                         $add = 1;
+                         $who = $who/10;
 
 
+                         /* whom to ask next */
                          $firstsick  = DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid);
                          $secondsick = DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid);
                          $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($firstsick!="poverty")
                            DB_set_sickness_by_gameid($gameid,$who+$add);
                          else
@@ -740,6 +759,19 @@ else if(myisset("me"))
                              else
                                DB_set_sickness_by_gameid($gameid,$who+$add*3);
                            };
                              else
                                DB_set_sickness_by_gameid($gameid,$who+$add*3);
                            };
+
+                         /* email next player */
+                         $who = DB_get_sickness_by_gameid($gameid);
+                         if($who<=4)
+                           {
+                             $To       = DB_get_email_by_pos_and_gameid($who,$gameid);
+                             $userhash = DB_get_hash_from_game_and_pos($gameid,$who);
+                             
+                             $message = "Someone has poverty, it's your turn to decide, if you want to take the trump. Please visit:".
+                               " ".$host."?me=".$userhash."\n\n" ;
+                             mymail($To,$EmailName." poverty",$message);
+                           }
+
                        }
                      
                      /* this user is done */
                        }
                      
                      /* this user is done */
@@ -748,6 +780,33 @@ else if(myisset("me"))
                      $hash = DB_get_hash_from_gameid_and_userid($gameid,$trump);
                      DB_set_hand_status_by_hash($hash,'play');
 
                      $hash = DB_get_hash_from_gameid_and_userid($gameid,$trump);
                      DB_set_hand_status_by_hash($hash,'play');
 
+                     /* set party to re, unless we had dpoverty, in that case check if we need to set re/contra*/
+                     $re_set=0;
+                     foreach($userids as $user)
+                       {
+                         $userhash =DB_get_hash_from_gameid_and_userid($gameid,$user);
+                         $party=DB_get_party_by_hash($userhash);
+                         if($party=="re")
+                           $re_set=1;
+                       }
+                     if($re_set)
+                       {
+                         DB_set_party_by_hash($me,"contra");
+                         DB_set_party_by_hash($hash,"contra");
+                       }
+                     else
+                       {
+                         foreach($userids as $user)
+                           {
+                             $userhash =DB_get_hash_from_gameid_and_userid($gameid,$user);
+                             if($userhash==$hash||$userhash==$me)
+                               DB_set_party_by_hash($userhash,"re");
+                             else
+                               DB_set_party_by_hash($userhash,"contra");
+                           }
+                       }
+
+
                      break;
                    }
                  else
                      break;
                    }
                  else
@@ -789,10 +848,22 @@ else if(myisset("me"))
                    }
                  echo "I don't want to take any trump: ".
                    "<a href=\"index.php?me=$me&amp;trump=no\">yes</a> <br />";
                    }
                  echo "I don't want to take any trump: ".
                    "<a href=\"index.php?me=$me&amp;trump=no\">yes</a> <br />";
+
+                 echo "Your cards are: <br />\n";
+                 $mycards = DB_get_hand($me);
+                 sort($mycards);
+                 echo "<p class=\"mycards\" style=\"margin-top:8em;\">your cards are: <br />\n";
+                 foreach($mycards as $card) 
+                   display_card($card,$PREF["cardset"]);
+                 echo "</p>\n";   
                }
              else
                {
                }
              else
                {
-                 echo "it's not your turn yet to decide if you want to take the trump or not.";
+                 $mysick = DB_get_sickness_by_userid_and_gameid($myid,$gameid);
+                 if($mysick=="poverty")
+                   echo "The others are asked if they want to take your trump, you have to wait (you'll get an email).";
+                 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 
                }
              /*
               *    yes, display number of trump and user's hand, ask if he wants to take it 
@@ -803,8 +874,8 @@ else if(myisset("me"))
               */
            };
        }
               */
            };
        }
-      /* 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);
+      /* check if no one 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".
       if($who==5 || $who==50)
        {
          $message = "Hello, \n\n".
@@ -814,7 +885,7 @@ else if(myisset("me"))
          foreach($userids as $user)
            {
              $To = DB_get_email_by_userid($user);
          foreach($userids as $user)
            {
              $To = DB_get_email_by_userid($user);
-             mymail($To,$EmailName."game cancled (poverty not resolved)",$message);
+             mymail($To,$EmailName."game $gameid cancled (poverty not resolved)",$message);
            }
          
          /* delete everything from the dB */
            }
          
          /* delete everything from the dB */
@@ -844,7 +915,7 @@ else if(myisset("me"))
          if($hash!=$me)
            {
              /* email startplayer) */
          if($hash!=$me)
            {
              /* email startplayer) */
-             $message = "It's your turn now.\n".
+             $message = "It's your turn now in game $gameid.\n".
                "Use this link to play a card: ".$host."?me=".$hash."\n\n" ;
              mymail($email,$EmailName."ready, set, go... ",$message);
            }
                "Use this link to play a card: ".$host."?me=".$hash."\n\n" ;
              mymail($email,$EmailName."ready, set, go... ",$message);
            }
@@ -852,7 +923,7 @@ else if(myisset("me"))
            echo " Please, <a href=\"$host?me=$me\">start</a> the game.<br />";  
        }
       else
            echo " Please, <a href=\"$host?me=$me\">start</a> the game.<br />";  
        }
       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 :( <br />";      
+       echo "\n <br />";        
 
       break;
     case 'play':
 
       break;
     case 'play':
@@ -895,7 +966,7 @@ else if(myisset("me"))
       /* has the game started? No, then just wait here...*/
       if($gamestatus == 'pre')
        {
       /* 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... <br />";
+         echo "You finished the setup, but not everyone else finished it...so you need to wait for the others. Just wait for the an email... <br />";
          break; /* not sure this works... the idea is that you can 
                  * only  play a card after everyone is ready to play */
        }
          break; /* not sure this works... the idea is that you can 
                  * only  play a card after everyone is ready to play */
        }
@@ -903,7 +974,10 @@ else if(myisset("me"))
       /* display the table and the names */
       $result = mysql_query("SELECT  User.fullname as name,".
                            "        Hand.position as position, ".
       /* display the table and the names */
       $result = mysql_query("SELECT  User.fullname as name,".
                            "        Hand.position as position, ".
-                           "        User.id ".
+                           "        User.id, ".
+                           "        Hand.party as party, ".
+                           "        Hand.sickness as sickness, ".
+                           "        Hand.point_call ".
                            "FROM Hand ".
                            "LEFT JOIN User ON User.id=Hand.user_id ".
                            "WHERE Hand.game_id='".$gameid."' ".
                            "FROM Hand ".
                            "LEFT JOIN User ON User.id=Hand.user_id ".
                            "WHERE Hand.game_id='".$gameid."' ".
@@ -913,16 +987,48 @@ else if(myisset("me"))
        "  <img src=\"pics/table.png\" alt=\"table\" />\n";
       while($r = mysql_fetch_array($result,MYSQL_NUM))
        {
        "  <img src=\"pics/table.png\" alt=\"table\" />\n";
       while($r = mysql_fetch_array($result,MYSQL_NUM))
        {
-         $name = $r[0];
-         $pos  = $r[1];
-         $user = $r[2];
-
+         $name  = $r[0];
+         $pos   = $r[1];
+         $user  = $r[2];
+         $party = $r[3];
+         $sickness= $r[4];
+         $call  = $r[5];
+         
          $offset = DB_get_user_timezone($user);
          $zone   = return_timezone($offset);
          date_default_timezone_set($zone);
 
          echo " <span class=\"table".($pos-1)."\">\n";
          $offset = DB_get_user_timezone($user);
          $zone   = return_timezone($offset);
          date_default_timezone_set($zone);
 
          echo " <span class=\"table".($pos-1)."\">\n";
-         echo " $name <br />\n";
+         echo " $name ";
+         /* add hints for poverty, wedding, solo, etc */
+         if($GT=="poverty" && $party=="re")
+           if($sickness=="poverty")
+             echo "(poverty <)";
+           else
+             echo "(poverty >)";
+
+         if($GT=="dpoverty")
+           if($party=="re")
+             if($sickness=="poverty")
+               echo "(poverty A <)";
+             else
+               echo "(poverty A >)";
+           else
+             if($sickness=="poverty")
+               echo "(poverty B <)";
+             else
+               echo "(poverty B >)";
+             
+         if($GT=="wedding" && $party=="re")
+             if($sickness=="wedding")
+               echo "(wedding  +)";
+             else
+               echo "(wedding)";
+         /* add point calls */
+         if($call!=NULL)
+           echo " $party $call ";
+
+         echo "<br />\n";
          echo " local time: ".date("Y-m-d H:i:s")."\n";
          echo " </span>\n";
 
          echo " local time: ".date("Y-m-d H:i:s")."\n";
          echo " </span>\n";
 
@@ -1047,7 +1153,7 @@ else if(myisset("me"))
          $r = mysql_fetch_array($result,MYSQL_NUM);
          $handcardid = $r[0];
          
          $r = mysql_fetch_array($result,MYSQL_NUM);
          $handcardid = $r[0];
          
-         if($handcardid)
+         if($handcardid) /* everything ok, play card  */
            {
              $comment = "";
 
            {
              $comment = "";
 
@@ -1058,6 +1164,19 @@ else if(myisset("me"))
              /* update Game timestamp */
              DB_update_game_timestamp($gameid);
 
              /* update Game timestamp */
              DB_update_game_timestamp($gameid);
 
+             /* check if a call was made */
+             if(myisset("call120") && $_REQUEST["call120"] == "yes")
+               $result = mysql_query("UPDATE Hand SET point_call='120' WHERE hash='$me' ");
+             if(myisset("call90")  && $_REQUEST["call90"]  == "yes")
+               $result = mysql_query("UPDATE Hand SET point_call='90'  WHERE hash='$me' ");
+             if(myisset("call60")  && $_REQUEST["call60"]  == "yes")
+               $result = mysql_query("UPDATE Hand SET point_call='60'  WHERE hash='$me' ");
+             if(myisset("call30")  && $_REQUEST["call30"]  == "yes")
+               $result = mysql_query("UPDATE Hand SET point_call='30'  WHERE hash='$me' ");
+             if(myisset("call0")   && $_REQUEST["call0"]   == "yes")
+               $result = mysql_query("UPDATE Hand SET point_call='0'   WHERE hash='$me' ");
+               
+
              /* check for schweinchen */
              //echo "schweinchen = ".$GAME["schweinchen"]." --$card-<br />";
              if($card == 19 || $card == 20 )
              /* check for schweinchen */
              //echo "schweinchen = ".$GAME["schweinchen"]." --$card-<br />";
              if($card == 19 || $card == 20 )
@@ -1067,16 +1186,53 @@ else if(myisset("me"))
                    $comment="Schweinchen! ";
                  if($RULES["schweinchen"]=="both" )
                    $comment="Schweinchen! ";
                    $comment="Schweinchen! ";
                  if($RULES["schweinchen"]=="both" )
                    $comment="Schweinchen! ";
-                 echo "schweinchen = ".$GAME["schweinchen"]." ---<br />";
+                 if ($debug) echo "schweinchen = ".$GAME["schweinchen"]." ---<br />";
                }
 
              /* get trick id or start new trick */
              $a = DB_get_current_trickid($gameid);
              $trickid  = $a[0];
              $sequence = $a[1];
                }
 
              /* 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);
              
              
              $playid = DB_play_card($trickid,$handcardid,$sequence);
              
+             /* 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'); 
+                       }
+                   }
+               }
+             
              /* check for coment */
              if(myisset("comment"))
                {
              /* check for coment */
              if(myisset("comment"))
                {
@@ -1146,11 +1302,27 @@ else if(myisset("me"))
                  $message .= "\n";
                  while( $r = mysql_fetch_array($result,MYSQL_NUM))
                    $message .= " FINAL SCORE: ".$r[0]." ".$r[1]."\n";
                  $message .= "\n";
                  while( $r = mysql_fetch_array($result,MYSQL_NUM))
                    $message .= " FINAL SCORE: ".$r[0]." ".$r[1]."\n";
+                 
+                 /* check who wants to be CC'ed on the email */
+                 $h = array();
+                 $header = "";
+                 foreach($userids as $user)
+                   {
+                     $result = mysql_query("SELECT value from User_Prefs".
+                                           " WHERE user_id='$user' AND pref_key='ccemail'" );
+                     $r = mysql_fetch_array($result,MYSQL_NUM);
+                     if($r && $r[0]=="yes")
+                       $h[]   = DB_get_email_by_userid($user);
+                   }
+                 if(sizeof($h))
+                   $header = "CC: ".join(",",$h)."\r\n";
 
                  foreach($userids as $user)
                    {
 
                  foreach($userids as $user)
                    {
-                     $To = DB_get_email_by_userid($user);
-                     mymail($To,$EmailName."game over",$message);
+                     $To   = DB_get_email_by_userid($user);
+                     $hash = DB_get_hash_from_gameid_and_userid($gameid,$user)
+                     $mymessage = $message."Use this link to have a look at the game: ".$host."?me=".$hash."\n\n" ;
+                     mymail($To,$EmailName."game over (game $gameid)",$mymessage,$header);
                    }
                }
              
                    }
                }
              
@@ -1191,14 +1363,10 @@ else if(myisset("me"))
                  $next_hash = DB_get_hash_from_game_and_pos($gameid,$next);
                  $email     = DB_get_email_by_hash($next_hash);
                  
                  $next_hash = DB_get_hash_from_game_and_pos($gameid,$next);
                  $email     = DB_get_email_by_hash($next_hash);
                  
-                 $message = "It's your turn  now.\n".
+                 $message = "A card has been played in game $gameid.\n\n".
+                   "It's your turn  now.\n".
                    "Use this link to play a card: ".$host."?me=".$next_hash."\n\n" ;
                    "Use this link to play a card: ".$host."?me=".$next_hash."\n\n" ;
-                 mymail($email,$EmailName."a card has been played",$message);
-                 
-                 if($debug)
-                   echo "DEBUG:<a href=\"index.php?me=".DB_get_hash_from_game_and_pos($gameid,$next).
-                     "\"> next player </a> <br />\n";
-                 
+                 mymail($email,$EmailName."a card has been played",$message);            
                }
            }
          else
                }
            }
          else
@@ -1234,6 +1402,22 @@ else if(myisset("me"))
                display_link_card($card,$PREF["cardset"]);
            }
          
                display_link_card($card,$PREF["cardset"]);
            }
          
+         if( can_call(120,$me) )
+             echo " re/contra (120):".
+               " <input type=\"radio\" name=\"call120\" value=\"yes\" /> ";
+         if( can_call(90,$me) )
+             echo " 90:".
+               " <input type=\"radio\" name=\"call90\" value=\"yes\" /> ";
+         if( can_call(60,$me) )
+             echo " 60:".
+               " <input type=\"radio\" name=\"call60\" value=\"yes\" /> ";
+         if( can_call(30,$me) )
+             echo " 30:".
+               " <input type=\"radio\" name=\"call30\" value=\"yes\" /> ";
+         if( can_call(0,$me) )
+             echo " 0:".
+               " <input type=\"radio\" name=\"call0\" value=\"yes\" /> ";
+
          echo "<br />\nA short comments:<input name=\"comment\" type=\"text\" size=\"30\" maxlength=\"50\" />\n";
          echo "<input type=\"hidden\" name=\"me\" value=\"$me\" />\n";
          echo "<input type=\"submit\" value=\"move\" />\n";
          echo "<br />\nA short comments:<input name=\"comment\" type=\"text\" size=\"30\" maxlength=\"50\" />\n";
          echo "<input type=\"hidden\" name=\"me\" value=\"$me\" />\n";
          echo "<input type=\"submit\" value=\"move\" />\n";
@@ -1314,6 +1498,7 @@ else if(myisset("me"))
      /* test id and password, should really be done in one step */
      $email     = $_REQUEST["email"];
      $password  = $_REQUEST["password"];
      /* test id and password, should really be done in one step */
      $email     = $_REQUEST["email"];
      $password  = $_REQUEST["password"];
+     
 
      if(myisset("forgot"))
        {
 
      if(myisset("forgot"))
        {
@@ -1350,6 +1535,8 @@ else if(myisset("me"))
        
        if($ok)
         {
        
        if($ok)
         {
+          DB_get_PREF($uid);
+
           if(myisset("setpref"))
             {
               $setpref=$_REQUEST["setpref"];
           if(myisset("setpref"))
             {
               $setpref=$_REQUEST["setpref"];
@@ -1366,6 +1553,21 @@ else if(myisset("me"))
                     $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;
                     $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;
+                case "ccemail":
+                  $result = mysql_query("SELECT * from User_Prefs".
+                                        " WHERE user_id='$uid' AND pref_key='ccemail'" );
+                  if( mysql_fetch_array($result,MYSQL_NUM))
+                    if($PREF["ccemail"]=="yes")
+                      $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart("no").
+                                            " WHERE user_id='$uid' AND pref_key='ccemail'" );
+                    else
+                      $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart("yes").
+                                            " WHERE user_id='$uid' AND pref_key='ccemail'" );
+                  else
+                    $result = mysql_query("INSERT INTO User_Prefs VALUES(NULL,'$uid','ccemail',".DB_quote_smart("yes").")");
+                  echo "Ok, changed you preferences for being CC'ed on emails.\n";
+                  break;
+
                 }
             }
           else /* output default user page */
                 }
             }
           else /* output default user page */
@@ -1384,10 +1586,25 @@ else if(myisset("me"))
               
               DB_update_user_timestamp($uid);
               
               
               DB_update_user_timestamp($uid);
               
+              echo "<p>these are your games that haven't started yet:<br />\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='pre'" );
+              while( $r = mysql_fetch_array($result,MYSQL_NUM))
+                {
+                  echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a>";
+                  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? <a href=\"$host?cancle=1&amp;me=".$r[0]."\">yes</a>".
+                      " (clicking here is final and can't be restored)";
+                  echo "<br />";
+                }
+              echo "</p>\n";
+
               echo "<p>these are the games you are playing in:<br />\n";
               $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.mod_date from Hand".
                                     " LEFT JOIN Game On Hand.game_id=Game.id".
               echo "<p>these are the games you are playing in:<br />\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'" );
+                                    " WHERE Hand.user_id='$uid' AND Game.status='play'" );
               while( $r = mysql_fetch_array($result,MYSQL_NUM))
                 {
                   echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a>";
               while( $r = mysql_fetch_array($result,MYSQL_NUM))
                 {
                   echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a>";
Email/Web based Dopppelkopf server