basic user page, list available users and link to start a new game
[e-DoKo.git] / index.php
index ff9af4622b2ee35b4d88e2b61e4f7da68a516122..7db439913a9bf7c7bccd4c0bbb7f6bb3ba919655 100644 (file)
--- a/index.php
+++ b/index.php
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
   <head>
      <title>e-Doko</title>
-     <link rel="stylesheet" type="text/css" href="standard.css"/>      
+     <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type" />
+     <link rel="stylesheet" type="text/css" href="standard.css" />     
+     <script type="text/javascript">
+       function hl(num) {
+         if(document.getElementById){
+          var i;
+          for(i=1;i<13;i++){
+            if(document.getElementById("trick"+i))
+              document.getElementById("trick"+i).style.display = 'none';
+          }
+          document.getElementById("trick"+num).style.display = 'block';
+        }
+       }
+       function high_last(){
+        if(document.getElementById){
+          var i;
+          for(i=12;i>0;i--) {
+            if(document.getElementById("trick"+i))
+              {
+                hl(i);
+                break;
+              }
+          }
+        }
+       }
+     </script>
   </head>
-<body>
+<body onload="high_last();">
+<div class="header">
 <h1> Welcome to E-Doko </h1>
+</div>
 
 <?php
-/*
- * config 
- */
-
-$host  = "http://doko.nubati.net/index.php";
-$debug = 1;
-
-/*
- * end config
- */    
-                                       
-
-/* helper function */
-function mymail($To,$Subject,$message)
-{  
-  global $debug;
-
-  if($debug)
-    {
-      str_replace("\n","<br />",$message);
-      echo "<br>To: $To<br>Subject: $Subject <br>$message<br>";
-    }
-  else
-    mail($To,$Subject,$message);
-  return;
-}
-
-function parse_status()
-{
-  global $game,$history,$player,$hash,$lines;
-  
-  $game["init"]        = 0;
-  $game["solo-who"]    = -1;
-  $game["solo-what"]   = "todo";
-  $game["wedding"]     = -1;
-  $game["poverty"]     = -1;
-  $game["nines"]       = -1;
-  $game["startplayer"] = 0;
-
-  for($i=0;$i<4;$i++)
-    {
-      $tmp = explode( ":",$lines[$i]);
-      $hash[$i]   = $tmp[0];
-      $player[$tmp[0]]["number"] = $i;
-      $player[$tmp[0]]["hash"]   = $tmp[0];
-      $player[$tmp[0]]["name"]   = $tmp[1];
-      $player[$tmp[0]]["email"]  = $tmp[2];
-      $player[$tmp[0]]["option"] = $tmp[3];
-      $player[$tmp[0]]["points"] = $tmp[4]; 
-      $player[$tmp[0]]["cards"]  = $tmp[5];
-      if(ereg("s",$tmp[3])) $game["init"]++;
-      if(ereg("P",$tmp[3])) $game["poverty"] = $i;
-      if(ereg("N",$tmp[3])) $game["nines"]   = $i;
-      if(ereg("W",$tmp[3])) $game["wedding"] = $i;
-      if(ereg("[OSQJCAH]",$tmp[3]) && ($game["solo-who"]<0) )
-       {
-         $game["solo-who"]    = $i;     
-         $game["startplayer"] = $i;
-       }
-  
-    }  
-  /* save the game history */
-  for($i=4;$i<sizeof($lines);$i++)
-    {
-      if(!ereg("^[[:space:]]*$",trim($lines[$i])))
-       {
-         $history[] = $lines[$i];
-       }
-    }
-  
-  if(sizeof($history)==0 || (sizeof($history)==1 && strlen($history[0])==3 ))
-    $history[0] = $game["startplayer"].":";
-  
-  return;
-}
-
-function count_nines($cards)
-{
-  $card = explode(";",$cards);
-  
-  $nines =0;
-
-  foreach($card as $c)
-    {
-      if($c == "25" || $c == "26") $nines++;
-      else if($c == "33" || $c == "34") $nines++;
-      else if($c == "41" || $c == "42") $nines++;
-      else if($c == "47" || $c == "48") $nines++;
-    }
-  
-  return $nines;
-}
-
-function check_wedding($cards)
-{
-  $card = explode(";",$cards);
-  
-  $count =0;
-
-  if( in_array("3",$card) && in_array("2",$card) )
-    $count=1;
-
-  return $count;
-}
-
-function count_trump($cards)
-{
-  $card = explode(";",$cards);
-  
-  $trump =0;
-
-  /* count each trump */
-  foreach($card as $c)
-    {
-      if( (int)($c) <27) $trump++;
-    }
-
-  /* subtract one, in case player has both foxes */
-  if( in_array("19",$card) && in_array("20",$card) )
-    $trump--;
-
-  return $trump;
-}
-
-
-
-function card_to_name($card)
-{
-  switch($card)
-    {
-      case 1:
-      case 2:
-        return "ten of hearts";
-      case 3:
-      case 4:
-      return "queen of clubs";
-      case 5:
-      case 6:
-      return "queen of spades";
-      case 7:
-      case 8:
-      return "queen of hearts";
-      case 9:
-      case 10:
-      return "queen of diamonds";
-      case 11:
-      case 12:
-      return "jack of clubs";
-      case 13:
-      case 14:
-      return "jack of spades";
-      case 15:
-      case 16:
-      return "jack of hearts";
-      case 17:
-      case 18:
-      return "jack of diamonds";
-      case 19:
-      case 20:
-      return "ace of diamonds";
-      case 21:
-      case 22:
-      return "ten of diamonds";
-      case 23:
-      case 24:
-      return "king of diamonds";
-      case 25:
-      case 26:
-      return "nine of diamonds";;
-      case 27:
-      case 28:
-      return "ace of clubs";
-      case 29:
-      case 30:
-      return "ten of clubs";
-      case 31:
-      case 32:
-      return "king of clubs";
-      case 33:
-      case 34:
-      return "nine of clubs";
-      case 35:
-      case 36:
-      return "ace of spades";
-      case 37:
-      case 38:
-      return "ten of spades";
-      case 39:
-      case 40:
-      return "king of spades";
-      case 41:
-      case 42:
-      return "nine of spades";
-      case 43:
-      case 44:
-      return "ace of hearts";
-      case 45:
-      case 46:
-      return "ace of diamonds";
-      case 47:
-      case 48:
-      return "nine of diamonds";
-      default:
-      return "something went wrong, please contact the admin";
-    }
-}
-
-function card_value($card)
-{
-  switch($card-1)
-    {
-      case 0:
-      case 1:
-        return 10;
-      case 2:
-      case 3:
-      case 4:
-      case 5:
-      case 6:
-      case 7:
-      case 8:
-      case 9:
-        return 3;
-      case 10:
-      case 11:
-      case 12:
-      case 13:
-      case 14:
-      case 15:
-      case 16:
-      case 17:
-        return 2;
-      case 18:
-      case 19:
-        return 11;
-      case 20:
-      case 21:
-        return 10;
-      case 22:
-      case 23:
-        return 4;
-      case 24:
-      case 25:
-      return 0;
-      case 26:
-      case 27:
-      return 11;
-      case 28:
-      case 29:
-      return 10;
-      case 30:
-      case 31:
-      return 4;
-      case 32:
-      case 33:
-      return 0;
-      case 34:
-      case 35:
-      return 11;
-      case 36:
-      case 37:
-      return 10;
-      case 38:
-      case 39:
-      return 4;
-      case 40:
-      case 41:
-      return 0;
-      case 42:
-      case 43:
-      return 11;
-      case 44:
-      case 45:
-      return 4;
-      case 46:
-      case 47:
-      return 0;
-      default:
-      echo "something went wrong, please contact the admin <br>";
-      return 0;
-    }
-}
-
-function display_card($card)
-{
-  if( $card/2 - (int)($card/2) == 0.5)
-    echo "<img src=\"cards/".$card.".png\" height=\"100\">";
-  else
-    echo "<img src=\"cards/".($card-1).".png\" height=\"100\">";
-  return;
-}
-   function display_link_card($card,$me)
-{
-  if( $card/2 - (int)($card/2) == 0.5)
-    echo "<a href=\"index.php?me=$me&card=$card\"><img src=\"cards/".$card.".png\" height=\"100\"></a>";
-  else
-    echo "<a href=\"index.php?me=$me&card=$card\"><img src=\"cards/".($card-1).".png\" height=\"100\"></a>";
-  return;
-}
-
-function save_status()
-{
-  global $player,$game,$hash,$history;
-
-  $output = fopen("status.txt","w");
-  if ($output)
-    {
-      foreach($hash as $key)
-       {
-         /* sorting the options, not sure why I do that actually */
-         $tmp="";
-         if( ereg("i",$player[$key]["option"]) )
-           $tmp.="i";
-         if( ereg("s",$player[$key]["option"]) )
-           $tmp.="s";
-         if( ereg("t",$player[$key]["option"]) )
-           $tmp.="t";
-         if( ereg("c",$player[$key]["option"]) )
-           $tmp.="c";
-         if( ereg("N",$player[$key]["option"]) )
-           $tmp.="N";
-         if( ereg("W",$player[$key]["option"]) )
-           $tmp.="W";
-         if( ereg("P",$player[$key]["option"]) )
-           $tmp.="P";
-         if( ereg("O",$player[$key]["option"]) ) 
-           $tmp.="O";
-         if( ereg("S",$player[$key]["option"]) )
-           $tmp.="S";
-         if( ereg("Q",$player[$key]["option"]) )
-           $tmp.="Q";
-         if( ereg("J",$player[$key]["option"]) )
-           $tmp.="J";
-         if( ereg("C",$player[$key]["option"]) )
-           $tmp.="C";
-         if( ereg("A",$player[$key]["option"]) )
-           $tmp.="A";
-         if( ereg("H",$player[$key]["option"]) )
-           $tmp.="H";
-         $player[$key]["option"]=$tmp;
+error_reporting(E_ALL);
+     
+include_once("functions.php");
+include_once("db.php");
 
-         /* saving the player stats */
-         fwrite($output,"".$player[$key]["hash"].":" );
-         fwrite($output,"".$player[$key]["name"].":" );
-         fwrite($output,"".$player[$key]["email"].":" );
-         fwrite($output,"".$player[$key]["option"].":" );
-         fwrite($output,"".$player[$key]["points"].":" );
-         fwrite($output,"".$player[$key]["cards"] .":");
-         fwrite($output,"\n");
-       }
-      fwrite($output,"\n");
-      foreach($history as $line)
-       fwrite($output,$line);
+DB_open();
 
-      fwrite($output,"\n");
-      fclose($output);
-    }
-  else
-    echo "can't open file for writing, please inform the admin.";
-  
-  return;
-}
+/* end header */
 
-$history=array();
+/*****************  M A I N **************************/
 
-/* check for status file and read it, if possible */
+/* check if we want to start a new game */
+if(isset($_REQUEST["new"]))
+  {
+?>
+    <p>Please add 4 names, please make sure that the names are correct! </p>
+       <form action="index.php" method="post">
+   Name:  <input name="PlayerA" type="text" size="10" maxlength="20" /> 
+   Name:  <input name="PlayerB" type="text" size="10" maxlength="20" /> 
+   Name:  <input name="PlayerC" type="text" size="10" maxlength="20" /> 
+   Name:  <input name="PlayerD" type="text" size="10" maxlength="20" /> 
 
-if(file_exists("status.txt"))
-  $lines = file("status.txt");
- else
-   die("no file");
+   <input type="submit" value="start game" />
+ </form>
+<?php
+  } 
+/* end start a new game */
 
-/* check if we want to start a new game */
-if( isset($_REQUEST["PlayerA"]) && 
+/*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"]) && 
-    isset($_REQUEST["EmailA"]) && 
-    isset($_REQUEST["EmailB"]) && 
-    isset($_REQUEST["EmailC"]) && 
-    isset($_REQUEST["EmailD"]) && sizeof($lines<2))
+    isset($_REQUEST["PlayerD"]) )
   {
     $PlayerA = $_REQUEST["PlayerA"];
     $PlayerB = $_REQUEST["PlayerB"];
     $PlayerC = $_REQUEST["PlayerC"];
     $PlayerD = $_REQUEST["PlayerD"];
-    $EmailA  = $_REQUEST["EmailA"] ;
-    $EmailB  = $_REQUEST["EmailB"] ;
-    $EmailC  = $_REQUEST["EmailC"] ;
-    $EmailD  = $_REQUEST["EmailD"] ;
     
-    $hashA = md5("AGameOfDoko".$PlayerA.$EmailA);
-    $hashB = md5("AGameOfDoko".$PlayerB.$EmailB);
-    $hashC = md5("AGameOfDoko".$PlayerC.$EmailC);
-    $hashD = md5("AGameOfDoko".$PlayerD.$EmailD);
+    $EmailA  = DB_get_email_by_name($PlayerA);
+    $EmailB  = DB_get_email_by_name($PlayerB);
+    $EmailC  = DB_get_email_by_name($PlayerC);
+    $EmailD  = DB_get_email_by_name($PlayerD);
+    
+    if($EmailA=="" || $EmailB=="" || $EmailC=="" || $EmailD=="")
+      {
+       echo "couldn't find one of the names, please start a new game";
+       exit();
+      }
+    
+    $useridA  = DB_get_userid_by_name($PlayerA);
+    $useridB  = DB_get_userid_by_name($PlayerB);
+    $useridC  = DB_get_userid_by_name($PlayerC);
+    $useridD  = DB_get_userid_by_name($PlayerD);
+    
+    /* create random numbers */
+    $randomNR       = create_array_of_random_numbers();
+    $randomNRstring = join(":",$randomNR);
+    
+    /* create game */
+    $followup = NULL;
+    if(isset($_REQUEST["followup"])) $followup= $_REQUEST["followup"];
+    mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre',$followup ,NULL)");
+    $game_id = mysql_insert_id();
+    
+    
+    $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);
+    
+    /* 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)");
+    $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)");
+    $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)");
+    $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)");
+    $hand_idD = mysql_insert_id();
+    
+    /* save cards */
+    for($i=0;$i<12;$i++)
+      mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idA', '".$randomNR[$i]."', 'false')");
+    for($i=12;$i<24;$i++)
+      mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idB', '".$randomNR[$i]."', 'false')");
+    for($i=24;$i<36;$i++)
+      mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idC', '".$randomNR[$i]."', 'false')");
+    for($i=36;$i<48;$i++)
+      mysql_query("INSERT INTO Hand_Card VALUES (NULL, '$hand_idD', '".$randomNR[$i]."', 'false')");
 
     /* send out email, check for error with email */
-
     $message = "\n".
-      "you are invited to play a game of DoKo.\n".
+      "you are invited to play a game of DoKo (that is to debug the program ;).\n".
+      "Place comments and bug reports here:\n".
+      "http://wiki.nubati.net/index.php?title=EmailDoko\n\n".
       "The whole round would consist of the following players:\n".
       "$PlayerA\n".
       "$PlayerB\n".
       "$PlayerC\n".
       "$PlayerD\n\n".
       "If you want to join this game, please follow this link:\n\n".
-      " ".$host."?a=";
+      " ".$host."?me=";
     
-    mymail($EmailA,"Invite for a game of DoKo","Hello $PlayerA,\n".$message.$hashA);
-    mymail($EmailB,"Invite for a game of DoKo","Hello $PlayerB,\n".$message.$hashB);
-    mymail($EmailC,"Invite for a game of DoKo","Hello $PlayerC,\n".$message.$hashC);
-    mymail($EmailD,"Invite for a game of DoKo","Hello $PlayerD,\n".$message.$hashD);
+    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($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);
+        
+  }    
+/* end set up a new game */
+
+else if(isset($_REQUEST["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
+      */
     
-    /* read in random.txt */
-    if(file_exists("random.txt"))
-      $random = file("random.txt");
-    else
-      die("no random file");
-    $randomNR = explode( ":", $random[1] );
+    $me = $_REQUEST["me"];
+    
+    $myid = DB_get_userid_by_hash($me);
     
-    /* write initial status into file */
-    $output = fopen("status.txt","w");
-    if ($output)
+    if(!$myid)
       {
-       fwrite($output, "$hashA:$PlayerA:$EmailA:::" );
-       for($i=0;$i<11;$i++)
-         fwrite($output,"$randomNR[$i];" );
-       fwrite($output,"$randomNR[11]:" ); $i++;
-       fwrite($output,"\n");
+       echo "Can't find you in the database, please check the url.<br />\n";
+       echo "perhaps the game has been cancled.";
+        exit();
+      }
+    
+    $myname   = DB_get_name_by_hash($me);
+    $mystatus = DB_get_status_by_hash($me);
+
+    /* get game id */
+    $gameid = DB_get_gameid_by_hash($me);
+    
+    switch($mystatus)
+      {
+      case 'start':
+       check_want_to_play($me);
+       DB_set_hand_status_by_hash($me,'init');
+       break;
+       
+      case 'init':
+       if( !isset($_REQUEST["in"]) || !isset($_REQUEST["update"]))
+         {
+           DB_set_hand_status_by_hash($me,'start');
+           echo "you need to answer both question";
+         }
+       else
+         {
+           if($_REQUEST["in"] == "no")
+             {
+               echo "TODO: email everyone that the game has been canceld<br />";
+                /*something like
+                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); 
+                  }
+                */
+               DB_cancel_game($me);
+             }
+           else
+             {
+               echo "thanks for joining the game... please scroll down";
+               echo "TODO: make this page nicer<br />";
+               echo "TODO: set card pref<br />";
+               
+               $mycards = DB_get_hand($me);
+               sort($mycards);
+               echo "<p class=\"mycards\">your cards are: <br />\n";
+               foreach($mycards as $card) 
+                 display_card($card);
+               echo "</p>\n";   
+               
+               check_for_sickness($me,$mycards);
+               
+               DB_set_hand_status_by_hash($me,'check');
+             }
+          }
+       break;
+       
+      case 'check':
+       echo "no checking at the moment... you need to play a normal game";
+       if(!isset($_REQUEST["solo"])    || 
+          !isset($_REQUEST["wedding"]) ||
+          !isset($_REQUEST["poverty"]) ||
+          !isset($_REQUEST["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";
+         }
+       else
+         {
+           if( $_REQUEST["solo"]!="No")
+             {
+               DB_set_solo_by_hash($me,$_REQUEST["solo"]);
+               DB_set_sickness_by_hash($me,"solo");
+             }
+           else if($_REQUEST["wedding"] == "yes")
+             {
+               echo "wedding was chosen<br />\n";
+               DB_set_sickness_by_hash($me,"wedding");
+             }
+           else if($_REQUEST["poverty"] == "yes")
+             {
+               echo "poverty was chosen<br />\n";
+               DB_set_sickness_by_hash($me,"poverty");
+             }
+           else if($_REQUEST["nines"] == "yes")
+             {
+               echo "nines was chosen<br />\n";
+                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':
+       echo "<br />poverty not handeled at the moment... you need to play a normal game<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;
+       foreach($userids as $user)
+         if(DB_get_hand_status_by_userid($user)!='play')
+           $done=0;
+
+       if($done)
+         DB_set_game_status_by_gameid($gameid,'play');
+
+       break;
+      case 'play':
+      case 'gameover': /* gameover and play, so that the tricks are visible for both */
+       display_news();
+       display_status();
+               
+       /* get trick ids */
+       $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 ".
+                             "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 ".
+                             "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;
+       
+       echo "\n<ul class=\"oldtrick\">\n";
+       echo "  <li> Hello $myname!   History: </li>\n";
        
-       fwrite($output, "$hashB:$PlayerB:$EmailB:::" );
-       for(;$i<23;$i++)
-         fwrite($output,"$randomNR[$i];" );
-       fwrite($output,"$randomNR[23]:" ); $i++;
-       fwrite($output,"\n");
+       while($r = mysql_fetch_array($result,MYSQL_NUM))
+         {
+           $seq   = $r[3];
+           $pos   = $r[2];
+           $trick = $r[5];
+           
+           if($trick!=$lasttrick && $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\" />";
+             }
+           
+           /* display card */
+           echo "      <div class=\"card".($pos-1)."\">\n";
+           
+           $play[$pos]=$r[0];
+           
+           $comment=0;
+           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        ";
+           
+           display_card($r[0]);
+           
+           echo "      </div>\n"; /* end div card */
+           
+           /* end of trick? */
+           if($seq==4)
+             {
+               $trickNR++;
+               echo "    </div>\n  </li>\n";  /* end div table, end li table */
+             }
+         }
+       if($seq!=4) 
+         echo "    </div>\n  </li>\n";  /* end div table, end li table */
        
-       fwrite($output, "$hashC:$PlayerC:$EmailC:::" );
-       for(;$i<35;$i++)
-         fwrite($output,"$randomNR[$i];" );
-       fwrite($output,"$randomNR[35]:" ); $i++;
-       fwrite($output,"\n");
+       echo "</ul>\n";
        
-       fwrite($output, "$hashD:$PlayerD:$EmailD:::");
-       for(;$i<47;$i++)
-         fwrite($output,"$randomNR[$i];" );
-       fwrite($output,"$randomNR[47]:" );
-       fwrite($output,"\n");
+       /* whos turn is it? */
+       if($seq==4)
+         {
+            $winner = get_winner($play); /* returns the position */
+            $next = $winner;
+         }
+       else
+         {
+           $next = $pos+1;
+         }
+       if($next==5) $next=1;
        
-       fclose($output);
+       /* my turn?, display cards as links, ask for comments*/
+       if(DB_get_pos_by_hash($me) == $next)
+         $myturn = 1;
+       else
+         $myturn = 0;
+
+       if(isset($_REQUEST["comment"]))
+         {
+       
+         }  
+       /* do we want to play a card? */
+       if(isset($_REQUEST["card"]) && $myturn)
+         {
+           $card   = $_REQUEST["card"];
+           $handid = DB_get_handid_by_hash($me); 
+           
+           /* check if we have card and that we haven't played it yet*/
+           /* set played in hand_card to true where hand_id and card_id*/
+           $result = mysql_query("SELECT id FROM Hand_Card WHERE played='false' and ".
+                                 "hand_id='$handid' AND card_id=".DB_quote_smart($card));
+           $r = mysql_fetch_array($result,MYSQL_NUM);
+           $handcardid = $r[0];
+           
+           if($handcardid)
+             {
+               mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".DB_quote_smart($card));
+               
+               /* get trick id or start new trick */
+               $a = DB_get_current_trickid($gameid);
+               $trickid  = $a[0];
+               $sequence = $a[1];
+               
+               DB_play_card($trickid,$handcardid,$sequence);
+               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)
+                 {
+                   DB_set_hand_status_by_hash($me,'gameover');
+                   $mystatus='gameover';
+                 }
+               
+               /* if all players are done, set game status also to game over */
+               $userids = DB_get_all_userid_by_gameid($gameid);
+               $done=1;
+               foreach($userids as $user)
+                 if(DB_get_hand_status_by_userid($user)!='gameover')
+                   $done=0;
+
+               if($done)
+                 DB_set_game_status_by_gameid($gameid,"gameover");
+               
+               /* 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); /* returns the position */
+                       $next = $winner;
+                     }
+                   else
+                     {
+                       $next = DB_get_pos_by_hash($me)+1;
+                     }
+                   if($next==5) $next=1;
+
+                   echo "TODO: email next player at pos $next <br />";
+                   if($debug)
+                     echo "DEBUG:<a href=\"index.php?me=".DB_get_hash_from_game_and_pos($gameid,$next).
+                       "\"> next player </a> <br />\n";
+
+                 }
+             }
+           else
+             {
+               echo "couldn't find card <br />\n";
+             }
+         }
+       else if(isset($_REQUEST["card"]) && !$myturn )
+         {
+           echo "please wait until it is your turn! <br />\n";
+         }
+       
+       $mycards = DB_get_hand($me);
+       sort($mycards);
+       echo "<div class=\"mycards\">\n";
+       
+       if($myturn && !isset($_REQUEST["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";
+           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
+         }
+       else if($mystatus=='play')
+         {
+           echo "Your cards are: <br />\n";
+           foreach($mycards as $card) 
+             display_card($card);
+         }
+       echo "</div>\n";
+
+       /* 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' */
+       /* check if game is over, display results */
+       if(DB_get_game_status_by_gameid($gameid)=='play')
+         {
+           echo "the game is over for you.. other people still need to play though";
+         }
+       else
+         {
+           echo "the game is over now... guess the final score should be displayed here...<br />\n";
+           
+           /* 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\" methog=\"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";
+         }
+       break;
+      default:
+       echo "error in testing the status";
+      }
+    exit();
+  } 
+ else if(isset($_REQUEST["email"]) && isset($_REQUEST["password"]))
+  {
+    $ok=1;
+    $uid = DB_get_userid_by_email($_REQUEST["email"]);
+    if(!$uid)
+      $ok=0;
+    if(!DB_get_userid_by_passwd(md5($_REQUEST["password"])))
+      $ok=0;
+
+    if($ok)
+      {
+       echo "ok. your logged in, now what? :)<br />";
+       $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=\"http://doko.nubati.net/database/index.php?new\">this page.</a></p>";
       }
     else
-      echo "can't open file for writing";
-  };
-
-/* test if a game is running, else output everything for a new game */
-if(sizeof($lines)<2)
+      {
+       echo "sorry email and password don't match <br />";
+      }
+    exit();
+  }
+else if(isset($_REQUEST["register"]) )
   {
+    echo "TODO: convert timezone into a menu<br />\n";
+    echo "TODO: figure out a way to handle passwrods <br />\n";
 ?>
-    <p> no game in progress, please input 4 names and email addresses, please make sure that the addresses are correct! </p>
- <form action="index.php" method="post">
-   Name:  <input name="PlayerA" type="text" size="10" maxlength="20" /> 
-   Email: <input name="EmailA"  type="text" size="10" maxlength="20" /> <br />
-
-   Name:  <input name="PlayerB" type="text" size="10" maxlength="20" /> 
-   Email: <input name="EmailB"  type="text" size="10" maxlength="20" /> <br />
-
-   Name:  <input name="PlayerC" type="text" size="10" maxlength="20" /> 
-   Email: <input name="EmailC"  type="text" size="10" maxlength="20" /> <br />
-
-   Name:  <input name="PlayerD" type="text" size="10" maxlength="20" /> 
-   Email: <input name="EmailD"  type="text" size="10" maxlength="20" /> <br />
-
-   <input type="submit" value="start game" />
- </form>
+        <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
-   }
- else
-   { /* load game status */
-     parse_status();
-/*     **
- *    *  *
- *    ****
- *    *  *
- *
- * check if a player wants to accept a game 
- */
-     
-     if(isset($_REQUEST["a"]))
-       {
-        $a=$_REQUEST["a"];
-        
-        if( ereg("[is]",$player[$a]["option"]) &&  $game["init"]<4)
-          {
-            echo "just wait for the game to start";
-          }
-        else  if( !ereg("[is]",$player[$a]["option"]) )
-          {
-
- ?>
- <form action="index.php" method="post">
-   Do you want to play a game of DoKo?
-   yes<input type="radio" name="in" value="yes" />
-   no<input type="radio" name="in" value="no" /> <br />
-
-   Do you want to get an email for every card played or only if it your move?
-   every card<input type="radio" name="update" value="card" />
-   only on my turn<input type="radio" name="update" value="turn" /> <br />
-<?php   
-            echo "<input type=\"hidden\" name=\"b\" value=\"$a\" />\n";
-            echo "\n";
-            echo "<input type=\"submit\" value=\"count me in\" />\n";
-            echo " </form>\n";
-          }
-       }
-
-/*   ***
- *   *  *
- *   ***
- *   *  *
- *   ***
- * yes? email him his hand, ask for solo, poverty, email every move or every card? 
- */
-     if(isset($_REQUEST["b"]))
-       {
-        $b=$_REQUEST["b"];
-        
-        if( ereg("s",$player[$b]["option"])  && $game["init"]<4)
-          {
-            echo "just wait for the game to start";
-          }
-        else if( (!isset($_REQUEST["in"])|| !isset($_REQUEST["update"])) && !ereg("i",$player[$b]["option"]))
-          {
-            echo "go back to ";
-            echo "<a href=\"index.php?a=$b\"> here and fill out the form </a> <br />";
-          }
-        else
-          { /* show the hand */
-            if($_REQUEST["in"]=="no")
-              {
-                for($i=0;$i<4;$i++)
-                  {
-                    $message = "Hello ".$player[$hash[$i]]["name"].",\n\n".
-                      "the game has been cancled due to the request of one of the players.\n";
-                    mymail($player[$hash[$i]]["email"],"[DoKo] the game has been cancled",$message); 
-                  }
-                  $output = fopen("status.txt","w");
-                  if($output)
-                    fclose($output);
-                  else
-                    echo "problem opening file";
-              }
-            else
-              {
-                if($_REQUEST["update"]=="card") $player[$b]["option"].="c";
-                if($_REQUEST["update"]=="turn") $player[$b]["option"].="t";
-                
-                $player[$b]["option"].="i";
-                
-                save_status();
-                
-                $allcards = $player[$b]["cards"];
-                $mycards = explode(";",$allcards);
-                
-                sort($mycards);
-                echo "your cards are <br>";
-                foreach($mycards as $card) 
-                  {
-                    display_card($card);
-                  }
-                echo "<br />\n";   
- ?>
- <p>aehm... at the moment please just answer everything with no, still need to implement this</p>                
- <form action="index.php" method="post">
-   
-   do you want to play solo? 
-   <select name="solo" size="1">
-     <option>No</option>
-     <option>No trump</option>
-     <option>Normal solo</option>
-     <option>Queen solo</option>
-     <option>Jack solo</option>
-     <option>Club solo</option>
-     <option>Spade solo</option>
-     <option>Heart solo</option>
-   </select>     
-   <br />
-
-<?php   
-     
-                 echo "wedding?";
-                if(check_wedding($player[$b]["cards"]))
-                  {
-                    echo " yes<input type=\"radio\" name=\"wedding\" value=\"yes\" />";
-                    echo " no <input type=\"radio\" name=\"wedding\" value=\"no\" /> <br />";
-                  }
-                else
-                  {
-                    echo " no <input type=\"hidden\" name=\"wedding\" value=\"no\" /> <br />";
-                  };
-
-                 echo "do you have poverty?";
-                if(count_trump($player[$b]["cards"])<4)
-                  {
-                    echo " yes<input type=\"radio\" name=\"poverty\" value=\"yes\" />";
-                    echo " no <input type=\"radio\" name=\"poverty\" value=\"no\" /> <br />";
-                  }
-                else
-                  {
-                    echo " no <input type=\"hidden\" name=\"poverty\" value=\"no\" /> <br />";
-                  };
-
-                 echo "do you have too many nines?";
-                if(count_nines($player[$b]["cards"])>4)
-                  {
-                    echo " yes<input type=\"radio\" name=\"nines\" value=\"yes\" />";
-                    echo " no <input type=\"radio\" name=\"nines\" value=\"no\" /> <br />";
-                  }
-                else
-                  {
-                    echo " no <input type=\"hidden\" name=\"nines\" value=\"no\" /> <br />";
-                  };
-
-                 echo "<input type=\"hidden\" name=\"c\" value=\"$b\" />\n";
-                echo "<input type=\"submit\" value=\"count me in\" />\n";
-                
-                echo "</form>\n";
-              }
-          }
-       }
-     if(isset($_REQUEST["c"]))
-       {
-        $c=$_REQUEST["c"];
-        
-        if(!isset($_REQUEST["solo"])|| !isset($_REQUEST["wedding"])|| !isset($_REQUEST["poverty"]) || !isset($_REQUEST["nines"]) )
-          {
-            echo "go back to ";
-            echo "<a href=\"index.php?b=$c\"> here and fill out the form </a> <br />";
-          }
-        else if(  ereg("s",$player[$c]["option"]) && $game["init"]<4 )
-          {
-            echo "just wait for the game to start";
-          }
-        else if($game["init"]<4)
-          { 
-            if( $_REQUEST["solo"]!="No")
-              {
-                switch($_REQUEST["solo"])
-                  {
-                  case "No trump":
-                    $player[$c]["option"].="O";
-                    break;
-                  case "Normal solo":
-                    $player[$c]["option"].="S";
-                    break;
-                  case "Queen solo":
-                    $player[$c]["option"].="Q";
-                    break;
-                  case "Jack solo":
-                    $player[$c]["option"].="J";
-                    break;
-                  case "Club solo":
-                    $player[$c]["option"].="C";
-                    break;
-                  case "Spade solo":
-                    $player[$c]["option"].="A";
-                    break;
-                  case "Hear solo":
-                    $player[$c]["option"].="H";
-                    break;
-                  }
-              }
-            else if($_REQUEST["wedding"] == "yes")
-              {
-                echo "wedding was chosen<br>";
-                $player[$c]["option"].="W";
-              }
-            else if($_REQUEST["poverty"] == "yes")
-              {
-                echo "poverty was chosen<br>";
-                $player[$c]["option"].="P"; 
-              }
-            else if($_REQUEST["nines"] == "yes")
-              {
-                echo "nines was chosen<br>";
-                $player[$c]["option"].="N";
-              }
-            
-            $message = "you're in. once everyone has filled out the form,".
-              "the game will start and you'll get an eamil on your turn\n";
-            mymail($player[$c]["email"],"[DoKo] the game will start soon",$message); 
-
-            $player[$c]["option"].="s";
-            save_status();
-            if(file_exists("status.txt"))
-              $lines = file("status.txt");
-            else
-              die("no file");
-            parse_status();
-
-            if($game["init"]==4)
-3             {
-                $message = "The game can start now, it's your turn, please use this link to play a card:\n".
-                  $host."?me=".$hash[$game["startplayer"]]."\n";
-                mymail($player[$hash[$game["startplayer"]]]["email"],"[DoKo] let's go",$message);
-              }
-            
-          }
-       }
-     if($game["init"]==4)
-       {
-        /* check for sickness*/
-        /***** someone has 5 nines and no one is playing solo=> cancel game */
-        if($game["nines"]>=0 && $game["solo-who"]<0)
-          {
-            $message = $player[$hash[$game["poverty"]]]["nines"]." has more than 4 nines. Game aborted!\n";
-            for($i=0;$i<4;$i++)
-              {
-                mymail($player[$hash[$i]]["email"],"[DoKo] the game has been canceled",$message); 
-              }
-            $output = fopen("status.txt","w");
-            if($output)
-              fclose($output);
-            else
-              echo "problem opening file";
-          }
-
-        /* who is requesting this*/
-        if(!isset($_REQUEST["me"]))
-          echo "a game is in progress, but you are not playing";
-        else
-          {
-            $me = $_REQUEST["me"];
-
-            echo "game in progress and you are in it<br />";
-            if($game["solo-who"]>=0)
-              echo $player[$hash[$game["solo-who"]]]["name"]." is playing a ".$game["solo-what"]." solo!<br />";
-            else if($game["wedding"]>=0)
-              echo $player[$hash[$game["wedding"]]]["name"]." is playing a wedding!<br />";
-            
-            foreach($history as $play) 
-              {
-                echo "<br />";
-
-                $trick = explode(":",$play);
-                
-                $last=-2;
-                /* found old trick, display it */
-                for($i=0;$i<sizeof($trick)-1;$i++)
-                  {
-                    $card=$trick[$i];
-                    if(ereg("->",$card))
-                      {
-                        $tmp = explode("->",$card);
-                        echo $player[$hash[$tmp[0]]]["name"]." played ";
-                        display_card($tmp[1]);
-                        $last=$tmp[0];
-                      }
-                  }
-              }
-            
-            $next = $last + 1;
-            if ($next>=4) 
-              $next -= 4 ;
-            if($last<0)
-              {
-                $next=$history[sizeof($history)-1][0];
-              }
-
-
-            if(isset($_REQUEST["card"]))
-              {
-                if($hash[$next]==$me)
-                  {
-                    $card=$_REQUEST["card"];
-                    $mycards = explode(";",$player[$me]["cards"]);
-                    if(in_array($card,$mycards))
-                      {
-                        $tmp=array();
-                        foreach($mycards as $m)
-                          if($m!=$card)
-                            $tmp[]=$m;
-                        $tmp2="";
-                        for($i=0;$i<sizeof($tmp)-1;$i++)
-                          {
-                            $tmp2.=$tmp[$i].";";
-                          }
-                        $tmp2.=$tmp[$i];
-                        $player[$me]["cards"]=$tmp2;
-                        
-                        if($last<0)
-                          {
-                            $history[sizeof($history)-1]="".$player[$me]["number"]."->".$card.":\n";
-                          }
-                        else
-                          {
-                            $tmp = explode(":",$history[sizeof($history)-1]);
-                            $tmp[sizeof($tmp)-1] = "".$player[$me]["number"]."->".$card.":";
-                            $history[sizeof($history)-1]=join(":",$tmp);
-                          }
-                        save_status();
-
-                        echo " you played ";
-                        display_card($card);
-                        /* send out email to players who want/need to get informed */
-                        for($i=0;$i<4;$i++)
-                          {
-                            $mynext=$next+1; if($mynext>3)$mynext-=4;
-                            if((ereg("c",$player[$hash[$i]]["option"]) || $i==$mynext) && $hash[$i]!=$me)
-                              {
-                                $message = " Hello ".$player[$hash[$i]]["name"].",\n\n";
-                                  
-                                if($i==$mynext)
-                                  $message .= "it's your turn  now.\n";
-                                $message .= $player[$me]["name"]. "has played the following card ".card_to_name($card)."\n";
-                                
-                                if($game["solo-who"]<=0)
-                                  $message.= $player[$hash[$game["solo-who"]]]." is playing a ".$game["solo-what"]." solo!\n";
-
-                                mymail($player[$hash[$i]]["email"],"[DoKo] a card has been played",$message);
-                                echo "<a href=\"index.php?me=".$hash[$mynext]."\"> next player </a> <br />";
-                              }
-                          }
-                      }
-                    else
-                      echo "seems like you don't have that card<br>";
-                         
-                  }
-                
-              }
-            else if(isset($_REQUEST["win"]) && strlen($history[sizeof($history)-1])>3)
-              {
-                $win=$_REQUEST["win"];
-                $history[]=$win.":\n";
-                /* count points of the last trick */
-                $points=0;
-
-                $tmp = explode(":",$history[sizeof($history)-2]);
-                for($i=0;$i<4;$i++)
-                  {
-                    $tmp2 = explode("->",$tmp[$i]);
-                    $c = $tmp2[1];
-                    $points += card_value($c);
-                  }
-                $player[$hash[$win]]["points"]+=$points;
-                echo "<br> ".$player[$hash[$win]]["name"]." won: $points Points <br>";
-
-                save_status();
-              }
-            echo "<br />";
+  }
+else if(isset($_REQUEST["Rfullname"]) && 
+       isset($_REQUEST["Remail"]   ) && 
+       isset($_REQUEST["Rpassword"]) && 
+       isset($_REQUEST["Rtimezone"]) )
+  {
+       $ok=1;
+       if(DB_get_userid_by_name($_REQUEST["Rfullname"]))
+         {
+           echo "please chose another name<br />";
+           $ok=0;
+         }
+       if(DB_get_userid_by_email($_REQUEST["Remail"]))
+         {
+           echo "this email address is already used ?!<br />";
+           $ok=0;
+         }
+       if($ok)
+         {
+           $r=mysql_query("INSERT INTO User VALUES(NULL,".DB_quote_smart($_REQUEST["Rfullname"]).
+                     ",".DB_quote_smart($_REQUEST["Remail"]).
+                     ",".DB_quote_smart(md5($_REQUEST["Rpassword"])).
+                     ",".DB_quote_smart($_REQUEST["Rtimezone"]).",NULL)"); 
+           
+           if($r)
+             echo "  added you to the database";
+           else
+             echo " something went wrong";
+         }
+  }
+else
+  { /* no new game, not in a game */
+?>
+    <p> If you want to play a game of Doppelkopf, you found the right place ;) </p>
+    <p> Please <a href="index.php?register">register</a>, in case you haven't done yet  <br />
+        or login with you email-address or name and password here:
+        <form action="index.php" method="post">
+          <fieldset>
+            <legend>Login</legend>
+             <table>
+              <tr>
+               <td><label for="email">Email:</label></td><td><input type="text" id="email" name="email" size="20" maxsize="30" /> </td>
+              </tr><tr>
+               <td><label for="password">Password:</label></td><td><input type="password" id="password" name="password" size="20" maxsize="30" /></td>
+              </tr><tr>
+               <td> <input type="submit" value="login" /></td>
+             </table>
+          </fieldset>
+        </form>
+    </p>
 
-            $tmp = explode(":",$history[sizeof($history)-1]);
 
-            if(sizeof($tmp)==5)
-              {
-                ?>
-<form action="index.php" method="post">
-who won?
-<?php 
-   for($i=0;$i<4;$i++)
-     echo $player[$hash[$i]]["name"]." <input type=\"radio\" name=\"win\" value=\"$i\" />";
-   echo "<input type=\"hidden\" name=\"me\" value=\"$me\" />";
+<?php
+  }
 ?>
-<input type="submit" value="submit" />
+</body>
+</html>
 
-</form>
 <?php
-              }
-            else if(sizeof($tmp)<5 && 1<sizeof($tmp) && !isset($_REQUEST["card"]))
-              {                 
-                if(sizeof($tmp)==2 && strlen($tmp[0])==1)
-                  {
-                    $next=$tmp[0];
-
-                    if($debug)
-                      echo "DEBUG: the next move is for <a href=\"index.php?me=".$hash[$next]."\">the next player</a><br>";
-                     
-                    if(strlen(trim($player[$me]["cards"]))==0)
-                      {
-                        echo "<br> game over, count points <br>";
-                        for($i=0;$i<4;$i++)
-                          {
-                            echo $player[$hash[$i]]["name"]." got ".$player[$hash[$i]]["points"]."<br>";
-                          }
-                      }
-                  }
-                if($hash[$next]==$me && strlen(trim($player[$me]["cards"]))>0 )
-                  {
-                    
-                    echo "ITS YOUR TURN<br>";
-                    $allcards = trim($player[$me]["cards"]);
-                    $mycards = explode(";",$allcards);
-                    
-                    sort($mycards);
-                    echo "your cards are <br>";
-                    foreach($mycards as $card) 
-                      {
-                        display_link_card($card,$me);
-                      }
-                    echo "<br />\n";   
-                  }
-                echo "<br />";
-                
-              }
-          }
-       }
 
- } 
+DB_close();
 
+/*
+ *Local Variables: 
+ *mode: php
+ *mode: hs-minor
+ *End:
+ */
 ?>
 
-</body>
-</html>
+