problem with sql syntax: used a reserverd word
[e-DoKo.git] / index.php
index d135474612fde9d7cd0a7a292c5c42583af350ff..687f15dc5b58d86a6ee218cb4f720b2b1c1135f8 100644 (file)
--- a/index.php
+++ b/index.php
@@ -25,7 +25,14 @@ if(0)
     exit(); 
   }
 
-DB_open();
+if(DB_open()<0)
+  {
+    output_header();
+    echo "Database error, can't connect...";
+    output_footer(); 
+    exit(); 
+  }
+
 output_header();
 
 /* check if we want to start a new game */
@@ -84,41 +91,42 @@ if(myisset("new"))
        $ruleset = DB_get_ruleset_by_gameid($followup); /* just copy ruleset from old game, 
                                                         this way no manipulation is possible */
        if($session)
-         mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre',".
+         mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre',".
                      "'$ruleset','$session' ,NULL)");
        else
          {
            /* get max session */
            $max = DB_get_max_session();
            $max++;
-           mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre',".
+           mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre',".
                        "'$ruleset','$max' ,NULL)");
            mysql_query("UPDATE Game SET session='".$max."' WHERE id=".DB_quote_smart($followup));
          }
       }
     else
-      mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre', ".
+      mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre', ".
                  "'$ruleset',NULL ,NULL)");
     $game_id = mysql_insert_id();
     
     /* create hash */
-    $hashA = md5("AGameOfDoko".$game_id.$PlayerA.$EmailA);
-    $hashB = md5("AGameOfDoko".$game_id.$PlayerB.$EmailB);
-    $hashC = md5("AGameOfDoko".$game_id.$PlayerC.$EmailC);
-    $hashD = md5("AGameOfDoko".$game_id.$PlayerD.$EmailD);
+    $TIME  = (string) time(); /* to avoid collisions */
+    $hashA = md5("AGameOfDoko".$game_id.$PlayerA.$EmailA.$TIME);
+    $hashB = md5("AGameOfDoko".$game_id.$PlayerB.$EmailB.$TIME);
+    $hashC = md5("AGameOfDoko".$game_id.$PlayerC.$EmailC.$TIME);
+    $hashD = md5("AGameOfDoko".$game_id.$PlayerD.$EmailD.$TIME);
     
     /* 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).
-               ", ".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).
-               ", ".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).
-               ", ".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 */
@@ -142,7 +150,7 @@ if(myisset("new"))
       "$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);
@@ -219,8 +227,23 @@ else if(myisset("me"))
     $myname   = DB_get_name_by_hash($me);
     $mystatus = DB_get_status_by_hash($me);
     $mypos    = DB_get_pos_by_hash($me);
-    
+    $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";
+      
+      
     /* get rule set for this game */
     $result = mysql_query("SELECT * FROM Rulesets".
                          " LEFT JOIN Game ON Game.ruleset=Rulesets.id ".
@@ -287,7 +310,7 @@ else if(myisset("me"))
         */
        if( !myisset("in") )
          {
-           echo "you need to answer the <a href=\"$host?me=$me\">question</a>.";
+           echo "<p> you need to answer the <a href=\"$host?me=$me\">question</a>.</p>";
            DB_set_hand_status_by_hash($me,'start');
          }
        else
@@ -316,7 +339,7 @@ else if(myisset("me"))
                sort($mycards);
                echo "<p class=\"mycards\" style=\"margin-top:8em;\">your cards are: <br />\n";
                foreach($mycards as $card) 
-                 display_card($card);
+                 display_card($card,$PREF["cardset"]);
                echo "</p>\n";   
                
                check_for_sickness($me,$mycards);
@@ -376,9 +399,7 @@ else if(myisset("me"))
            }
          else if($_REQUEST["poverty"] == "yes")
            {
-             echo "So you got poverty. You might as well have said nothing, since this is not implemented yet,".
-               " you need to play a normal game...to make it a bit harder, I'll tell the other people that".
-               " you only have a few trump... should make the game more interesting (although perhaps not for you:))<br />\n";
+             echo "Don't think you can win with just a few trump...? ok, poverty chosen <br />\n";
              DB_set_sickness_by_hash($me,"poverty");
            }
          else if($_REQUEST["nines"] == "yes")
@@ -393,6 +414,29 @@ else if(myisset("me"))
 
       /* 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, please visit this link now to continue: \n".
+                 " ".$host."?me=".$userhash."\n\n" ;
+               mymail($To,$EmailName." finished setup",$message);
+             }
+         };
+
       break;
 
     case 'poverty':
@@ -401,7 +445,7 @@ else if(myisset("me"))
        * set that one in the Game table
        * tell people about it.
        */
-      echo "<br /> Checking if someone else selected solo, nines or wedding... Poverty not handled at the moment<br />";
+      echo "<br /> Checking if someone else selected solo, nines or wedding or poverty.<br />";
       
       /* check if everyone has reached this stage */
       $userids = DB_get_all_userid_by_gameid($gameid);
@@ -416,7 +460,7 @@ else if(myisset("me"))
       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
        {
@@ -429,49 +473,34 @@ else if(myisset("me"))
 
          /* check for different sickness and just output a general info */
 
-         /* check for nines */
+         
          $nines = 0;
-         foreach($userids as $user)
-           if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'nines')
-             {
-               $nines = $user;
-               $name = DB_get_name_by_userid($user);
-               echo "$name has a Vorbehalt. <br />";
-               break;
-             }
-                 
-         /* check players for poverty */
          $poverty = 0;
+         $wedding = 0;
+         $solo = 0;
          foreach($userids as $user)
            {
-             if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'poverty')
+             $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. <br />";
+                 break;
+               }
+             else if($usersick == 'poverty')
                {
                  $poverty++;
-                 $name = DB_get_name_by_userid($user);
                  echo "$name has a Vorbehalt. <br />";
                }
-           }
-
-         /* check players for wedding */
-         $wedding = 0;
-         foreach($userids as $user)
-           {
-             if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'wedding')
+             else if($usersick == 'wedding')
                {
                  $wedding=$user;
-                 $name = DB_get_name_by_userid($user);
                  echo "$name has a Vorbehalt. <br />"  ;
                }
-           };
-
-         /* check for solo, output vorbehalt */
-         $solo = 0;
-         foreach($userids as $user)
-           {
-             if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'solo')
+             else if($usersick == 'solo')
                {
                  $solo++;
-                 $name = DB_get_name_by_userid($user);
                  echo "$name has a Vorbehalt. <br />"  ;
                }
            }
@@ -508,19 +537,44 @@ else if(myisset("me"))
              output_footer();
              exit();
            }
-         else if($poverty==1 && $gametype !="poverty")
+         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 && $gametype !="dpoverty")
+         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 && $gametype !="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";
            };
 
@@ -541,7 +595,7 @@ else if(myisset("me"))
              $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid);
 
              if($usersick)
-               echo "$name has $usersick <br />"; /*TODO: perhaps save this in a string and store in Game? */
+               echo "$name has $usersick. <br />"; /*TODO: perhaps save this in a string and store in Game? */
 
              if($usersick=="poverty")
                $poverty++;
@@ -580,9 +634,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");
+             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;
 
@@ -596,26 +652,206 @@ else if(myisset("me"))
              DB_set_hand_status_by_hash($me,'play');
              break;
            case "poverty":
-             /* use extra column in DB.Game to store whom to ask, 
-              * should be set for poverty and dpoverty(use two digits for dpoverty?) earlier*/
-
+           case "dpoverty":
              /* check if poverty resolved (e.g. DB.Game who set to NULL)
               *   yes? =>trump was taken, start game; break; 
-              *   
-              * check if we are being asked now
-              *    no, display wait message, e.g. player X is asked at the moment
+              */
+             $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<'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";
+                 echo "  <input type=\"hidden\" name=\"trump\" value=\"".$trump."\" />\n";
+                 echo "  <input type=\"hidden\" name=\"me\" value=\"".$me."\" />\n";
+                 echo "  <input type=\"submit\" class=\"submitbutton\" value=\"select cards to give back\" />\n";
+                 echo "</form>\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<br />\n";
+                     
+                     set_gametype($gametype); /* this sets the $CARDS variable */
+                     $mycards = DB_get_hand($me);
+                     $mycards = mysort($mycards,$gametype);
+
+                     echo "<form class=\"exchange\" action=\"index.php\" method=\"post\">\n";
+                     $type="exchange";
+                     foreach($mycards as $card) 
+                       display_link_card($card,$PREF["cardset"],$type);
+                     echo "  <input type=\"hidden\" name=\"trump\" value=\"".$trump."\" />\n";
+                     echo "  <input type=\"hidden\" name=\"me\" value=\"".$me."\" />\n";
+                     echo "  <input type=\"submit\" class=\"submitbutton\" value=\"select one card to give back\" />\n";
+                     echo "</form>\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?".
+                             "<a href=\"index.php?me=$me&amp;trump=$user\">yes</a> <br />";
+                       }
+                   }
+                 echo "I don't want to take any trump: ".
+                   "<a href=\"index.php?me=$me&amp;trump=no\">yes</a> <br />";
+               }
+             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 
               *        
               */
-           case "dpoverty":
-             echo "TODO: handle poverty here (almost done in my developing version)";
-             DB_set_hand_status_by_hash($me,'play');
            };
        }
-      
+      /* 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".
+           "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 "<p style=\"background-color:red\";>Game $gameid has been cancled.<br /><br /></p>";
+         output_footer();
+         exit();
+       }
+
       /* check if all players are ready to play */
       $ok=1;
       foreach($userids as $user)
@@ -643,7 +879,7 @@ else if(myisset("me"))
            echo " Please, <a href=\"$host?me=$me\">start</a> the game.<br />";  
        }
       else
-       echo "You finished the setup, once everyone else has done the same you'll get an email when it is your turn..<br />";    
+       echo "\n <br />";        
 
       break;
     case 'play':
@@ -686,7 +922,7 @@ else if(myisset("me"))
       /* 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 */
        }
@@ -694,7 +930,10 @@ else if(myisset("me"))
       /* 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."' ".
@@ -704,16 +943,48 @@ else if(myisset("me"))
        "  <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";
-         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";
 
@@ -789,7 +1060,7 @@ else if(myisset("me"))
            echo "        <span class=\"comment\">".$comment."</span>\n";
          
          echo "        ";
-         display_card($r[0]);
+         display_card($r[0],$PREF["cardset"]);
          
          echo "      </div>\n"; /* end div card */
          
@@ -838,16 +1109,30 @@ else if(myisset("me"))
          $r = mysql_fetch_array($result,MYSQL_NUM);
          $handcardid = $r[0];
          
-         if($handcardid)
+         if($handcardid) /* everything ok, play card  */
            {
              $comment = "";
 
              /* mark card as played */
              mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".
                          DB_quote_smart($card));
+
              /* 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 )
@@ -857,16 +1142,53 @@ else if(myisset("me"))
                    $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];
+             $tricknr  = $a[2];
              
              $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"))
                {
@@ -878,7 +1200,7 @@ else if(myisset("me"))
              /* display played card */
              echo "<div class=\"card\">";
              echo " you played  <br />";
-             display_card($card);
+             display_card($card,$PREF["cardset"]);
              echo "</div>\n";
              
              /*check if we still have cards left, else set status to gameover */
@@ -983,12 +1305,7 @@ else if(myisset("me"))
                  
                  $message = "It's your turn  now.\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
@@ -1009,7 +1326,7 @@ else if(myisset("me"))
        {
          echo "Hello ".$myname.", it's your turn!  <br />\n";
          echo "Your cards are: <br />\n";
-         echo "<form action=\"index.php?me=$me\" method=\"post\">\n";
+         echo "<form  action=\"index.php?me=$me\" method=\"post\">\n";
          
          /* do we have to follow suite? */
          $followsuit = 0;
@@ -1019,11 +1336,27 @@ else if(myisset("me"))
          foreach($mycards as $card) 
            {
              if($followsuit && !same_type($card,$firstcard))
-               display_card($card);
+               display_card($card,$PREF["cardset"]);
              else
-               display_link_card($card);
+               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";
@@ -1033,7 +1366,7 @@ else if(myisset("me"))
        {
          echo "Your cards are: <br />\n";
          foreach($mycards as $card) 
-           display_card($card);
+           display_card($card,$PREF["cardset"]);
        }
       else if($mystatus=='gameover')
        {
@@ -1041,7 +1374,7 @@ else if(myisset("me"))
          $oldcards = mysort($oldcards,$gametype);
          echo "Your cards were: <br />\n";
          foreach($oldcards as $card) 
-           display_card($card);
+           display_card($card,$PREF["cardset"]);
        }
       echo "</div>\n";
       
@@ -1129,6 +1462,7 @@ else if(myisset("me"))
        }
      else 
      {
+       /* verify password and email */
        if(strlen($password)!=32)
         $password = md5($password);
        
@@ -1139,46 +1473,70 @@ else if(myisset("me"))
        
        if($ok)
         {
-          $time = DB_get_user_timestamp($uid);
-          $unixtime =strtotime($time);
-          
-          $offset = DB_get_user_timezone($uid);
-          $zone = return_timezone($offset);
-          date_default_timezone_set($zone);
-          
-          echo "last login: ".date("r",$unixtime)."<br />";
-          
-          DB_update_user_timestamp($uid);
-          
-          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'" );
-          while( $r = mysql_fetch_array($result,MYSQL_NUM))
+          if(myisset("setpref"))
+            {
+              $setpref=$_REQUEST["setpref"];
+              switch($setpref)
+                {
+                case "germancards":
+                case "englishcards":
+                  $result = mysql_query("SELECT * from User_Prefs".
+                                        " WHERE user_id='$uid' AND pref_key='cardset'" );
+                  if( mysql_fetch_array($result,MYSQL_NUM))
+                    $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart($setpref).
+                                          " WHERE user_id='$uid' AND pref_key='cardset'" );
+                  else
+                    $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;
+                }
+            }
+          else /* output default user page */
             {
-              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 />";
+              $time = DB_get_user_timestamp($uid);
+              $unixtime =strtotime($time);
+              
+              $offset = DB_get_user_timezone($uid);
+              $zone = return_timezone($offset);
+              date_default_timezone_set($zone);
+              
+              /* display links to settings */
+              output_user_settings($email,$password);
+              
+              echo "last login: ".date("r",$unixtime)."<br />";
+              
+              DB_update_user_timestamp($uid);
+              
+              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'" );
+              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>and these are your games that are already done:<br />Game: \n";
+              $result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status='gameover'" );
+              while( $r = mysql_fetch_array($result,MYSQL_NUM))
+                echo "<a href=\"".$host."?me=".$r[0]."\">#".$r[1]." </a>, ";
+              echo "</p>\n";
+              
+              $names = DB_get_all_names();
+              echo "<p>registered players:<br />\n";
+              foreach ($names as $name)
+                echo "$name, \n";
+              echo "</p>\n";
+              
+              echo "<p>Want to start a new game? Visit <a href=\"".$host."?new\">this page.</a></p>";
             }
-          echo "</p>\n";
-          
-          
-          echo "<p>and these are your games that are already done:<br />Game: \n";
-          $result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status='gameover'" );
-          while( $r = mysql_fetch_array($result,MYSQL_NUM))
-            echo "<a href=\"".$host."?me=".$r[0]."\">#".$r[1]." </a>, ";
-          echo "</p>\n";
-          
-          $names = DB_get_all_names();
-          echo "<p>registered players:<br />\n";
-          foreach ($names as $name)
-            echo "$name, \n";
-          echo "</p>\n";
-          
-          echo "<p>Want to start a new game? Visit <a href=\"".$host."?new\">this page.</a></p>";
         }
        else
         {