new sort function; should sorrt correctly for solos,etc
[e-DoKo.git] / index.php
index c849f69c4cbb068a3bc2297f9650ae83b8fb1012..ef047be0f0983f169174417b78b240a810ca9d07 100644 (file)
--- a/index.php
+++ b/index.php
@@ -1,26 +1,31 @@
 <?php
 error_reporting(E_ALL);
 
-include_once("config.php");     
+global $REV;
+$REV  ="\$Rev$";
+
+include_once("config.php");      
 include_once("output.php");      /* html output only */
 include_once("db.php");          /* database only */
 include_once("functions.php");   /* the rest */
 
-DB_open();
+if(0)
+{
+  output_header();
+  echo "Working on the database...please check back in a few mintues";
+  output_footer();
+  exit();
+}
 
-/*****************  M A I N **************************/
+DB_open();
 output_header();
 
-
 /* check if we want to start a new game */
-if(isset($_REQUEST["new"]))
-     output_form_for_new_game();
+if(myisset("new"))
+  output_form_for_new_game();
 
 /*check if everything is ready to set up a new game */
-else if( isset($_REQUEST["PlayerA"]) && 
-    isset($_REQUEST["PlayerB"]) && 
-    isset($_REQUEST["PlayerC"]) && 
-    isset($_REQUEST["PlayerD"]) )
+else if( myisset("PlayerA", "PlayerB","PlayerC","PlayerD" ))
   {
     $PlayerA = $_REQUEST["PlayerA"];
     $PlayerB = $_REQUEST["PlayerB"];
@@ -49,13 +54,13 @@ else if( isset($_REQUEST["PlayerA"]) &&
     
     /* create game */
     $followup = NULL;
-    if(isset($_REQUEST["followup"])) 
+    if(myisset("followup") )
       {
        $followup= $_REQUEST["followup"];
-       mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre','$followup' ,NULL)");
+       mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre','$followup' ,NULL)");
       }
     else
-      mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre', NULL ,NULL)");
+      mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre', NULL ,NULL)");
     $game_id = mysql_insert_id();
     
     /* create hash */
@@ -105,16 +110,17 @@ else if( isset($_REQUEST["PlayerA"]) &&
     mymail($EmailB,"You are invited to a game of DoKo","Hello $PlayerB,\n".$message.$hashB);
     mymail($EmailC,"You are invited to a game of DoKo","Hello $PlayerC,\n".$message.$hashC);
     mymail($EmailD,"You are invited to a game of DoKo","Hello $PlayerD,\n".$message.$hashD);
-        
+
+    
+    echo "You started a new game. The emails have been sent out!";    
   }    
 /* end set up a new game */
 
-else if(isset($_REQUEST["me"]))
+else if(myisset("me"))
   {
-     /* handle request from one specifig player,
-      * the hash is set on a per game base, so first just handle this game
-      * perhaps also show links to other games in a sidebar
-      */
+    /* handle request from one specific player,
+     * the hash is set on a per game base
+     */
     
     $me = $_REQUEST["me"];
 
@@ -123,7 +129,7 @@ else if(isset($_REQUEST["me"]))
     if(!$myid)
       {
        echo "Can't find you in the database, please check the url.<br />\n";
-       echo "perhaps the game has been cancled.";
+       echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
        exit();
       }
     
@@ -133,6 +139,7 @@ else if(isset($_REQUEST["me"]))
     $gameid   = DB_get_gameid_by_hash($me);
     $myname   = DB_get_name_by_hash($me);
     $mystatus = DB_get_status_by_hash($me);
+    $mypos    = DB_get_pos_by_hash($me);
     
     switch($mystatus)
       {
@@ -141,7 +148,7 @@ else if(isset($_REQUEST["me"]))
        DB_set_hand_status_by_hash($me,'init');
        break;
       case 'init':
-       if( !isset($_REQUEST["in"]) || !isset($_REQUEST["update"]))
+       if( !myisset("in","update") )
          {
            DB_set_hand_status_by_hash($me,'start');
            echo "you need to answer both question";
@@ -150,15 +157,16 @@ else if(isset($_REQUEST["me"]))
          {
            if($_REQUEST["in"] == "no")
              {
-               echo "TODO: email everyone that the game has been canceled.<br />";
-                /*something like need to modify for DB backend
-                for($i=0;$i<4;$i++)
-                  {
-                    $message = "Hello ".$player[$hash[$i]]["name"].",\n\n".
-                      "the game has been canceled due to the request of one of the players.\n";
-                    mymail($player[$hash[$i]]["email"],"[DoKo-Debug] the game has been canceled",$message); 
-                  }
-                */
+               $message = "Hello, \n\n".
+                 "the game has been canceled due to the request of one of the players.\n";
+               
+               $userids = DB_get_all_userid_by_gameid($gameid);
+               foreach($userids as $user)
+                 {
+                   $To = DB_get_email_by_userid($user);
+                   mymail($To,"[DoKo] game cancled",$message);
+                 }
+               
                /* delete everything from the dB */
                DB_cancel_game($me);
              }
@@ -183,27 +191,42 @@ else if(isset($_REQUEST["me"]))
        break;
        
       case 'check':
-       echo "no checking at the moment... you need to play a normal game. At the moment you need to reload this page to finish the setup.";
-       if(!isset($_REQUEST["solo"])    || 
-          !isset($_REQUEST["wedding"]) ||
-          !isset($_REQUEST["poverty"]) ||
-          !isset($_REQUEST["nines"]) )
+       echo "checking if you selected solo or nines...<br />".
+         " if you have a wedding, please send an email to the other players. <br />".
+         " if you have poverty you need to play a normal game,sorry...<br />".
+         " Please click <a href=\"$host?me=$me\">here</a> to finish the setup.<br />";
+       if(!myisset("solo","wedding","poverty","nines") )
          {
-           DB_set_hand_status_by_hash($me,'init');
-           /* problem: by setting it back to init, variables "in" and "update" are 
-            * not set, so the player will be send back to the start, after seeing his hand
-            */
-           echo "you need to fill out the form";
+           /* all these variables have a pre-selected default,
+            * so we should never get here,
+            * unless a user tries to cheat ;) */
+           echo "something went wrong...please contact the admin.";
          }
        else
          {
+           /* check if this sickness needs to be handled first */
+           $gametype    = DB_get_gametype_by_gameid($gameid);
+           $startplayer = DB_get_startplayer_by_gameid($gameid);
+
            if( $_REQUEST["solo"]!="No")
              {
                DB_set_solo_by_hash($me,$_REQUEST["solo"]);
                DB_set_sickness_by_hash($me,"solo");
+               echo "<br />Seems like you want to play a ".$_REQUEST["solo"]." solo. Got it.<br />\n";
+               
+               if($gametype == "solo" && $startplayer<$mypos)
+                 {}/* do nothing */
+               else
+                 {
+                   /* this solo comes first */
+                   DB_set_gametype_by_gameid($gameid,"solo");
+                   DB_set_startplayer_by_gameid($gameid,$mypos);
+                   DB_set_solo_by_gameid($gameid,$_REQUEST["solo"]);
+                 };
              }
            else if($_REQUEST["wedding"] == "yes")
              {
+               /* TODO: add silent solo somewhere*/
                echo "wedding was chosen<br />\n";
                DB_set_sickness_by_hash($me,"wedding");
              }
@@ -218,36 +241,129 @@ else if(isset($_REQUEST["me"]))
                 DB_set_sickness_by_hash($me,"nines");
              }
          }
+
        DB_set_hand_status_by_hash($me,'poverty');
-       
+
        /* check all players and set game to final result, e.g. solo, wedding, povert, redeal */
-       
-       /* reset solo, etc from players who did say something, but it didn't matter? */
+
        break;
       case 'poverty':
-       /* here we need to check if there is a solo or some other form o sickness.
+       /* here we need to check if there is a solo or some other form of sickness.
         * If so, which one counts
         * set that one in the Game table, delete other ones form Hand table 
         * tell people about it.
         */
-       echo "<br />poverty not handeled at the moment... you need to play a normal game<br />";
+       echo "<br />checking if someone else selected solo or nines... wedding and poverty not handled at the moment<br />".
+         " Please click <a href=\"$host?me=$me\">here</a> to finish the setup.<br />";  
        
        /* only set this after all poverty, etc. are handeled*/
        DB_set_hand_status_by_hash($me,'play');
 
        /* check if the game can start  */
        $userids = DB_get_all_userid_by_gameid($gameid);
-       $done=1;
+       $ok=1;
        foreach($userids as $user)
-         if(DB_get_hand_status_by_userid($user)!='play')
-           $done=0;
+         if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='play')
+           $ok=0;
+
+       if($ok)
+         {
+           DB_set_game_status_by_gameid($gameid,'play');
+
+           /* check what kind of game we are playing */
+           $gametype    = DB_get_gametype_by_gameid($gameid);
+           $startplayer = DB_get_startplayer_by_gameid($gameid);
+
+           /* nines? */
+           $nines = 0;
+           /* check for nines */
+           foreach($userids as $user)
+             {
+               if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'nines')
+                 $nines = 1;
+             }
+           
+           /* gamestatus == normal, => cancel game */
+           if($nines && $gamestatus == "normal")
+             {
+               /* TODO: set game type to nines to be able to keep statistics */
+               
+               $message = "Hello, \n\n".
+                 "the game has been cancled becausee someone has five or more nines.\n";
+               
+               $userids = DB_get_all_userid_by_gameid($gameid);
+               foreach($userids as $user)
+                 {
+                   $To = DB_get_email_by_userid($user);
+                   mymail($To,"[DoKo] game cancled",$message);
+                 }
+               
+               /* delete everything from the dB */
+               DB_cancel_game($me);
+
+             }
 
-       if($done)
-         DB_set_game_status_by_gameid($gameid,'play');
+           /* poverty? */
+           $poverty = 0;
 
+           /* check players for poverty */
+           foreach($userids as $user)
+             {
+               if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'poverty')
+                 {
+                   $poverty++;
+                   $name = DB_get_name_by_userid($user);
+                   echo "$name has a Vorbehalt. <br />";
+                 }
+             }
+           /* if gamestatus == normal, set poverty or dpovert (in case two people have poverty) */
+
+           /* wedding? */
+           $wedding = 0;
+           /* check players for wedding */
+           foreach($userids as $user)
+             {
+               if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'wedding')
+                 {
+                   $wedding++;
+                   $name = DB_get_name_by_userid($user);
+                   echo "$name has a Vorbehalt. <br />"  ;
+                 }
+             }
+
+           /* if gamestatus == normal, set wedding  */
+           
+         }
+       
        break;
       case 'play':
-      case 'gameover': /*both entries here,  so that the tricks are visible for both in case of 'play' there is a break later that skips the last part*/
+      case 'gameover': 
+       /* both entries here,  so that the tricks are visible for both.
+        * in case of 'play' there is a break later that skips the last part
+        */
+
+       /* figure out what kind of game we are playing, 
+        * set the global variables $TRUMP,$DIAMONDS,$HEARTS,$CLUBS,$SPADES
+        * accordingly
+        */
+       
+       $gametype = DB_get_gametype_by_gameid($gameid);
+       $GT = $gametype;
+       if($gametype=="solo")
+         {
+           $gametype = DB_get_solo_by_gameid($gameid);
+           $GT = $gametype." ".$GT;
+         }
+       else
+         $gametype="normal";
+       
+       set_gametype($gametype);
+
+       /* get some infos about the game */
+       $gamestatus = DB_get_game_status_by_gameid($gameid);
+
+       /* display useful things in divs */
+       
        /* display local time */
        echo "<div class=\"time\">\n Local times:<table>";
        $users = array();
@@ -255,103 +371,118 @@ else if(isset($_REQUEST["me"]))
        foreach($users as $user)
          {
            $offset = DB_get_user_timezone($user);
-           $zone = return_timezone($offset);
+           $zone   = return_timezone($offset);
            date_default_timezone_set($zone);
-           $name = DB_get_name_by_userid($user);
+           $name   = DB_get_name_by_userid($user);
            
            echo "<tr> <td>$name</td> <td>".date("Y-m-d H:i:s")."</td></tr>\n";
          };
        echo "</table>\n</div>\n";
-       display_status();
 
-       /* display links to other games */
-       echo "<div class=\"over\">\n";
-       $result = mysql_query("SELECT email,password from User WHERE id='$myid'" );
-       $r = mysql_fetch_array($result,MYSQL_NUM);
-       echo "<form action=\"index.php\" method=\"post\">\n";
-       echo "  <input type=\"hidden\" name=\"email\" value=\"".$r[0]."\" />\n";
-       echo "  <input type=\"hidden\" name=\"password\" value=\"".$r[1]."\" />\n";
-       echo "  <input type=\"submit\" value=\"go to my user page\" />\n";
-       echo "</form>\n";
-       echo "</div>\n";
+       if($gamestatus != 'pre')
+         display_status($GT);
 
+       /* display links to the users status page */
+       $result = mysql_query("SELECT email,password from User WHERE id='$myid'" );
+       $r      = mysql_fetch_array($result,MYSQL_NUM);
+       output_link_to_user_page($r[0],$r[1]);
+         
        display_news();
 
-       $gamestatus = DB_get_game_status_by_gameid($gameid);
+       /* end display useful things*/
+
+       /* has the game started? No, then just wait here...*/
        if($gamestatus == 'pre')
          {
            echo "you need to wait for the others... <br />";
-           break;
+           break; /* not sure this works... the idea is that you can 
+                   * only  play a card after everyone is ready to play */
          }
-       /* get everythin relevant to display the tricks */
+       
+       /* display the table and the names */
+       $result = mysql_query("SELECT  User.fullname as name,".
+                             "        Hand.position as position ".
+                             "FROM Hand ".
+                             "LEFT JOIN User ON User.id=Hand.user_id ".
+                             "WHERE Hand.game_id='".$gameid."' ".
+                             "ORDER BY position ASC");
+       
+       echo "<div class=\"table\">\n".
+         "  <img src=\"pics/table.png\" alt=\"table\" />\n";
+       while($r = mysql_fetch_array($result,MYSQL_NUM))
+         {
+           $name = $r[0];
+           $pos  = $r[1];
+           
+           echo " <span class=\"table".($pos-1)."\">$name</span>\n";
+         }
+       echo  "</div>\n";
+       
+       /* get everything relevant to display the tricks */
        $result = mysql_query("SELECT Hand_Card.card_id as card,".
-                             "       User.fullname as name,".
                              "       Hand.position as position,".
                              "       Play.sequence as sequence, ".
-                             "       Hand.hash     as hash,     ".
                              "       Trick.id, ".
                              "       Comment.comment ".
                              "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 User ON User.id=Hand.user_id ".
                              "LEFT JOIN Comment ON Play.id=Comment.play_id ".
                              "WHERE Trick.game_id='".$gameid."' ".
                              "ORDER BY Trick.id,sequence ASC");
-       
-       
        $trickNR = 1;
        
        $lasttrick = DB_get_max_trickid($gameid);
        
        $play = array(); /* needed to calculate winner later  */
        $seq  = 1;          
-       $pos  = 0;
+       $pos  = DB_get_startplayer_by_gameid($gameid)-1; 
+       $firstcard = ""; /* first card in a trick */
        
-       echo "\n<ul class=\"oldtrick\">\n";
+       echo "\n<ul class=\"tricks\">\n";
        echo "  <li> Hello $myname!   History: </li>\n";
        
        while($r = mysql_fetch_array($result,MYSQL_NUM))
          {
-           $seq     = $r[3];
-           $pos     = $r[2];
-           $trick   = $r[5];
-           $comment = $r[6];
+           $pos     = $r[1];
+           $seq     = $r[2];
+           $trick   = $r[3];
+           $comment = $r[4];
+
+           /* save card to be able to find the winner of the trick later */
+           $play[$pos] = $r[0]; 
            
-           if($trick!=$lasttrick && $seq==1)
+           if($seq==1)
              {
-               /* start of an old trick? */
-               echo "  <li onclick=\"hl('$trickNR');\"><a href=\"#\">Trick $trickNR</a>\n".
-                 "    <div class=\"table\" id=\"trick".$trickNR."\">\n".
-                 "      <img class=\"table\" src=\"pics/table".($pos-1).".png\" alt=\"table\" />\n";
-             }
-           else if($trick==$lasttrick && $seq==1)
-             {
-               /* start of a last trick? */
-               echo "  <li onclick=\"hl('$trickNR');\"><a href=\"#\">Current Trick</a>\n".
-                 "    <div class=\"table\" id=\"trick".$trickNR."\">\n".
-                 "      <img class=\"table\" src=\"pics/table".($pos-1).".png\" alt=\"table\" />\n";
-             }
+               /* first card in a trick, output some html */
+               if($trick!=$lasttrick)
+                 {
+                   /* start of an old trick? */
+                   echo "  <li onclick=\"hl('$trickNR');\"><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');\"><a href=\"#\">Current Trick</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";
            
-           $play[$pos]=$r[0];
-           
+           /* display comments */
            if($comment!="")
-             echo "        <span class=\"comment\">";
-           else
-             echo "        <span>";
-           
-           /* print name */
-           echo $r[1];
-           
-           /* check for comment */
-           if($comment!="")
-             echo "<span>".$comment."</span>";
-           echo "</span>\n        ";
+             echo "        <span class=\"comment\">".$comment."</span>\n";
            
+           echo "        ";
            display_card($r[0]);
            
            echo "      </div>\n"; /* end div card */
@@ -372,14 +503,15 @@ else if(isset($_REQUEST["me"]))
        /* whos turn is it? */
        if($seq==4)
          {
-            $winner = get_winner($play,"normal"); /* returns the position */
+            $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;
          }
-       if($next==5) $next=1;
        
        /* my turn?, display cards as links, ask for comments*/
        if(DB_get_pos_by_hash($me) == $next)
@@ -388,7 +520,7 @@ else if(isset($_REQUEST["me"]))
          $myturn = 0;
 
        /* do we want to play a card? */
-       if(isset($_REQUEST["card"]) && $myturn)
+       if(myisset("card") && $myturn)
          {
            $card   = $_REQUEST["card"];
            $handid = DB_get_handid_by_hash($me); 
@@ -402,7 +534,9 @@ else if(isset($_REQUEST["me"]))
            
            if($handcardid)
              {
-               mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".DB_quote_smart($card));
+               /* 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);
@@ -411,17 +545,17 @@ else if(isset($_REQUEST["me"]))
                
                $playid = DB_play_card($trickid,$handcardid,$sequence);
 
-               /*check for coment */
-               if(isset($_REQUEST["comment"]))
+               /* check for coment */
+               if(myisset("comment"))
                  {
                    DB_insert_comment($_REQUEST["comment"],$playid,$myid);
                  };  
 
+               /* display played card */
                echo "<div class=\"card\">";
                echo " you played  <br />";
                display_card($card);
                echo "</div>\n";
-               
 
                /*check if we still have cards left, else set status to gameover */
                if(sizeof(DB_get_hand($me))==0)
@@ -430,23 +564,76 @@ else if(isset($_REQUEST["me"]))
                    $mystatus='gameover';
                  }
                
-               /* if all players are done, set game status also to game over */
+               /* 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($user)!='gameover')
+                 if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='gameover')
                    $done=0;
 
                if($done)
-                 DB_set_game_status_by_gameid($gameid,"gameover");
+                 {
+                   DB_set_game_status_by_gameid($gameid,"gameover");
+                   /* get score for last trick 
+                    * all other tricks are handled a few lines further down*/
+                   $play   = DB_get_cards_by_trick($trickid);
+                   $winner = get_winner($play,$gametype); /* returns the position */
+                   /* get points of last trick and save it */
+                   $points = 0;
+                   foreach($play as $card)
+                     $points = $points + card_value($card);
+                   $winnerid = DB_get_handid_by_gameid_and_position($gameid,$winner);
+                   if($winnerid>0)
+                     mysql_query("INSERT INTO Score VALUES (NULL, '$gameid', '$winnerid', '$points')");
+                   else
+                     echo "ERROR during scoring";
+
+                   /* email all players */
+                   $result = mysql_query("SELECT fullname, SUM(score) FROM Score".
+                                         " LEFT JOIN Hand ON Hand.id=hand_id".
+                                         " LEFT JOIN User ON Hand.user_id=User.id".
+                                         " WHERE Hand.game_id=$gameid".
+                                         " GROUP BY fullname" );
+                   $message = "The game is over. Thanks for playing :)\n";
+                   while( $r = mysql_fetch_array($result,MYSQL_NUM))
+                     $message .= " FINAL SCORE: ".$r[0]." ".$r[1]."\n";
+                   $message .= "\nIf your not in the list above your score is zero...\n";
+                   foreach($userids as $user)
+                     {
+                       $To = DB_get_email_by_userid($user);
+                       mymail($To,"[DoKo] game over",$message);
+                     }
+                 }
                
+
                /* email next player */
                if(DB_get_game_status_by_gameid($gameid)=='play')
                  {
                    if($sequence==4)
                      {
                        $play   = DB_get_cards_by_trick($trickid);
-                       $winner = get_winner($play,"normal"); /* returns the position */
+                       $winner = get_winner($play,$gametype); /* returns the position */
+
+                       /* get points of last trick and save it, last trick is handled 
+                        * a few lines further up  */
+                       $points = 0;
+                       foreach($play as $card)
+                         $points = $points + card_value($card);
+
+                       $winnerid = DB_get_handid_by_gameid_and_position($gameid,$winner);
+                       if($winnerid>0)
+                         mysql_query("INSERT INTO Score VALUES (NULL, '$gameid', '$winnerid', '$points')");
+                       else
+                         echo "ERROR during scoring";
+                       
+                       if($debug)
+                         echo "DEBUG: $winner got $points <br />";
+                       
+                       /* who is the next player? */
                        $next = $winner;
                      }
                    else
@@ -471,31 +658,41 @@ else if(isset($_REQUEST["me"]))
              }
            else
              {
-               echo "couldn't find card <br />\n";
+               echo "can't find that card?! <br />\n";
              }
          }
-       else if(isset($_REQUEST["card"]) && !$myturn )
+       else if(myisset("card") && !$myturn )
          {
-           echo "please wait until it is your turn! <br />\n";
+           echo "please wait until it's your turn! <br />\n";
          }
        
        $mycards = DB_get_hand($me);
-       sort($mycards);
+       mysort($mycards,$gametype);
        echo "<div class=\"mycards\">\n";
        
-       if($myturn && !isset($_REQUEST["card"]))
+       if($myturn && !myisset("card"))
          {
            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";
+
+           /* do we have to follow suite? */
+           $followsuit = 0;
+           if(have_suit($mycards,$firstcard))
+             $followsuit = 1;
+
            foreach($mycards as $card) 
-             display_link_card($card);
-?>
-    <br />A short comments:<input name="comment" type="text" size="30" maxlength="50" /> 
-    <input type="hidden" name="me" value="<?php echo $me; ?>" />
-    <input type="submit" value="move" />
- </form>
- <?php
+             {
+               if($followsuit && !same_type($card,$firstcard))
+                 display_card($card);
+               else
+                 display_link_card($card);
+             }
+
+           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 "</form>\n";
          }
        else if($mystatus=='play')
          {
@@ -508,7 +705,7 @@ else if(isset($_REQUEST["me"]))
        /* check if we need to set status to 'gameover' is done during playing of the card */
        if($mystatus=='play')
          break;
-   /* the following happens only when the gamestatus is 'gameover' */
+       /* the following happens only when the gamestatus is 'gameover' */
        /* check if game is over, display results */
        if(DB_get_game_status_by_gameid($gameid)=='play')
          {
@@ -516,20 +713,19 @@ else if(isset($_REQUEST["me"]))
          }
        else
          {
-           echo "the game is over now... guess the final score should be displayed here...<br />\n";
+           echo "the game is over now...<br />\n";
            
+           $result = mysql_query("SELECT fullname, SUM(score) FROM Score".
+                                 " LEFT JOIN Hand ON Hand.id=hand_id".
+                                 " LEFT JOIN User ON Hand.user_id=User.id".
+                                 " WHERE Hand.game_id=$gameid".
+                                 " GROUP BY fullname" );
+           while( $r = mysql_fetch_array($result,MYSQL_NUM))
+             echo " FINAL SCORE: ".$r[0]." ".$r[1]."<br />";
+
            /* suggest a new game with the same people in it, just rotated once */
            $names = DB_get_all_names_by_gameid($gameid);
-           
-           echo "Do you want to continue playing?(This will start a new game, with the next person as dealer.)\n";
-           echo "<form action=\"index.php\" method=\"post\">\n";
-           echo "  <input type=\"hidden\" name=\"PlayerA\" value=\"".($names[1])."\" />\n";
-           echo "  <input type=\"hidden\" name=\"PlayerB\" value=\"".($names[2])."\" />\n";
-           echo "  <input type=\"hidden\" name=\"PlayerC\" value=\"".($names[3])."\" />\n";
-           echo "  <input type=\"hidden\" name=\"PlayerD\" value=\"".($names[0])."\" />\n";
-           echo "  <input type=\"hidden\" name=\"followup\" value=\"".($gameid)."\" />\n";
-           echo "  <input type=\"submit\" value=\"keep playing\" />\n";
-           echo "</form>\n";
+           output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
          }
        break;
       default:
@@ -538,7 +734,7 @@ else if(isset($_REQUEST["me"]))
     exit();
   } 
 /* user status page */ 
else if(isset($_REQUEST["email"]) && isset($_REQUEST["password"]))
   else if(myisset("email","password"))
   {
     /* test id and password, should really be done in one step */
     $email     = $_REQUEST["email"];
@@ -571,11 +767,18 @@ else if(isset($_REQUEST["me"]))
          echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a><br />";
        echo "</p>\n";
 
+       echo "<p>and these are your games that are already done:<br />\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]."\">game #".$r[1]." </a><br />";
+       echo "</p>\n";
+
        $names = DB_get_all_names();
        echo "<p>registered players:<br />\n";
        foreach ($names as $name)
          echo "$name <br />\n";
        echo "</p>\n";
+
        echo "<p>Want to start a new game? remember 4 names from the list above and visit ".
          "<a href=\"".$host."?new\">this page.</a></p>";
       }
@@ -586,42 +789,12 @@ else if(isset($_REQUEST["me"]))
     exit();
   }
 /* page for registration */
-else if(isset($_REQUEST["register"]) )
+else if(myisset("register") )
   {
-    echo "IMPORTANT: passwords are going over the net as clear text, so pick an easy password. No need to pick anything complicated here ;)<br /><br />";
-    echo "TODO: convert timezone into a menu<br />\n";
-    echo "TODO: figure out a way to handle passwrods <br />\n";
-?>
-        <form action="index.php" method="post">
-          <fieldset>
-            <legend>Register</legend>
-             <table>
-              <tr>
-               <td><label for="Rfullname">Full name:</label></td>
-              <td><input type="text" id="Rfullname" name="Rfullname" size="20" maxsize="30" /> </td>
-              </tr><tr>
-               <td><label for="Remail">Email:</label></td>
-              <td><input type="text" id="Remail" name="Remail" size="20" maxsize="30" /></td>
-              </tr><tr>
-              <td><label for="Rpassword">Password(will be displayed in cleartext on the next page):</label></td>
-               <td><input type="password" id="Rpassword" name="Rpassword" size="20" maxsize="30" /></td>
-              </tr><tr>
-              <td><label for="Rtimezone">Timezone:</label></td>
-               <td>
-                  <input type="text" id="Rtimezone" name="Rtimezone" size="4" maxsize="4" value="+1" />
-              </td>
-              </tr><tr>
-               <td colspan="2"> <input type="submit" value="register" /></td>
-             </table>
-          </fieldset>
-        </form>
-<?php
+    output_register();
   }
 /* new user wants to register */
-else if(isset($_REQUEST["Rfullname"]) && 
-       isset($_REQUEST["Remail"]   ) && 
-       isset($_REQUEST["Rpassword"]) && 
-       isset($_REQUEST["Rtimezone"]) )
+ else if(myisset("Rfullname","Remail","Rpassword","Rtimezone") )
   {
        $ok=1;
        if(DB_get_userid_by_name($_REQUEST["Rfullname"]))
@@ -642,15 +815,15 @@ else if(isset($_REQUEST["Rfullname"]) &&
                      ",".DB_quote_smart($_REQUEST["Rtimezone"]).",NULL)"); 
            
            if($r)
-             echo "  added you to the database";
+             echo " added you to the database";
            else
              echo " something went wrong";
          }
   }
 /* default login page */
 else
-  { /* no new game, not in a game */
-    home_page();
+  { 
+    output_home_page();
   }
 
 output_footer();