only ask for a new game in a session, if it was the latest game
[e-DoKo.git] / index.php
index ff9af4622b2ee35b4d88e2b61e4f7da68a516122..216a431b50ecc11e556fedc7138c055b431c88db 100644 (file)
--- a/index.php
+++ b/index.php
-<!DOCTYPE html PUBLIC
-    "-//W3C//DTD XHTML 1.1 plus MathML 2.0 plus SVG 1.1//EN"
-    "http://www.w3.org/2002/04/xhtml-math-svg/xhtml-math-svg.dtd">
-<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"/>      
-  </head>
-<body>
-<h1> Welcome to E-Doko </h1>
-
 <?php
-/*
- * config 
- */
+error_reporting(E_ALL);
 
-$host  = "http://doko.nubati.net/index.php";
-$debug = 1;
+global $REV;
+$REV  ="\$Rev$";
 
-/*
- * end config
- */    
-                                       
+include_once("config.php");      
+include_once("output.php");      /* html output only */
+include_once("db.php");          /* database only */
+include_once("functions.php");   /* the rest */
 
-/* helper function */
-function mymail($To,$Subject,$message)
-{  
-  global $debug;
+/* check if some variables are set in the config file, else set defaults */
+if(!isset($EmailName))
+     $EmailName="[DoKo] ";
 
-  if($debug)
-    {
-      str_replace("\n","<br />",$message);
-      echo "<br>To: $To<br>Subject: $Subject <br>$message<br>";
-    }
-  else
-    mail($To,$Subject,$message);
-  return;
+if(0)
+{
+  output_header();
+  echo "Working on the database...please check back in a few mintues";
+  output_footer();
+  exit();
 }
 
-function parse_status()
+DB_open();
+output_header();
+
+/* check if we want to start a new game */
+if(myisset("new"))
+{
+  $names = DB_get_all_names();
+  output_form_for_new_game($names);
+}
+/*check if everything is ready to set up a new game */
+else if( myisset("PlayerA", "PlayerB","PlayerC","PlayerD" ))
 {
-  global $game,$history,$player,$hash,$lines;
+  $PlayerA = $_REQUEST["PlayerA"];
+  $PlayerB = $_REQUEST["PlayerB"];
+  $PlayerC = $_REQUEST["PlayerC"];
+  $PlayerD = $_REQUEST["PlayerD"];
   
-  $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++)
+  $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=="")
     {
-      $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;
-       }
+      echo "couldn't find one of the names, please start a new game";
+      exit();
+    }
   
-    }  
-  /* save the game history */
-  for($i=4;$i<sizeof($lines);$i++)
+  $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(myisset("followup") )
     {
-      if(!ereg("^[[:space:]]*$",trim($lines[$i])))
+      $followup= $_REQUEST["followup"];
+      $session = DB_get_session_by_gameid($followup);
+      if($session)
+       mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre','$session' ,NULL)");
+      else
        {
-         $history[] = $lines[$i];
+         /* get max session */
+         $max = DB_get_max_session();
+         $max++;
+         mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre','$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', NULL ,NULL)");
+  $game_id = mysql_insert_id();
   
-  if(sizeof($history)==0 || (sizeof($history)==1 && strlen($history[0])==3 ))
-    $history[0] = $game["startplayer"].":";
+  /* 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);
   
-  return;
-}
-
-function count_nines($cards)
-{
-  $card = explode(";",$cards);
+  /* 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();
   
-  $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++;
-    }
+  /* 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')");
   
-  return $nines;
-}
-
-function check_wedding($cards)
-{
-  $card = explode(";",$cards);
+  /* send out email, TODO: check for error with email */
+  $message = "\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."?me=";
   
-  $count =0;
-
-  if( in_array("3",$card) && in_array("2",$card) )
-    $count=1;
-
-  return $count;
-}
-
-function count_trump($cards)
-{
-  $card = explode(";",$cards);
+  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);
   
-  $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)
+  echo "You started a new game. The emails have been sent out!";    
+}    /* end set up a new game */
+else if(myisset("cancle","me"))
 {
-  switch($card)
+  $me = $_REQUEST["me"];
+  
+  /* test for valid ID */
+  $myid = DB_get_userid_by_hash($me);
+  if(!$myid)
     {
-      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";
+      echo "Can't find you in the database, please check the url.<br />\n";
+      echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
+      exit();
     }
-}
-
-function card_value($card)
-{
-  switch($card-1)
+  
+  DB_update_user_timestamp($myid);
+  
+  /* get some information from the DB */
+  $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);
+  
+  /* check if game really is old enough */
+  $result = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " );
+  $r = mysql_fetch_array($result,MYSQL_NUM);
+  if(time()-strtotime($r[0]) > 60*60*24*30)
     {
-      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;
+      $message = "Hello, \n\n".
+       "Game $gameid has been cancled since nothing happend for a while and $myname requested it.\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 (timed out)",$message);
+       }
+      
+      /* delete everything from the dB */
+      DB_cancel_game($me);
+      
+      echo "<p style=\"background-color:red\";>Game $gameid has been cancled.<br /><br /></p>";
     }
-}
-
-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;
+    echo "<p>You need to wait longer before you can cancle a game...</p>\n";
 }
-   function display_link_card($card,$me)
+else if(myisset("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)
+  /* handle request from one specific player,
+`  * the hash is set on a per game base
+   */
+  
+  $me = $_REQUEST["me"];
+  
+  /* test for valid ID */
+  $myid = DB_get_userid_by_hash($me);
+  if(!$myid)
     {
-      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;
-
-         /* 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);
-
-      fwrite($output,"\n");
-      fclose($output);
+      echo "Can't find you in the database, please check the url.<br />\n";
+      echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
+      exit();
     }
-  else
-    echo "can't open file for writing, please inform the admin.";
   
-  return;
-}
-
-$history=array();
-
-/* check for status file and read it, if possible */
+  DB_update_user_timestamp($myid);
+  
+  /* get some information from the DB */
+  $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);
+  
+  echo "<p class=\"gamenumber\"> Game $gameid </p>\n";
+       
+    switch($mystatus)
+      {
+      case 'start':
+       check_want_to_play($me);
+       DB_set_hand_status_by_hash($me,'init');
+       break;
+      case 'init':
+       if( !myisset("in","update") )
+         {
+           DB_set_hand_status_by_hash($me,'start');
+           echo "you need to answer both question";
+         }
+       else
+         {
+           if($_REQUEST["in"] == "no")
+             {
+               $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,$EmailName."game cancled",$message);
+                 }
+               
+               /* delete everything from the dB */
+               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 "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") )
+         {
+           /* 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");
+             }
+           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 */
+
+       break;
+      case 'poverty':
+       /* 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 />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);
+       $ok=1;
+       foreach($userids as $user)
+         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,$EmailName."game cancled",$message);
+                 }
+               
+               /* delete everything from the dB */
+               DB_cancel_game($me);
+
+             }
+
+           /* 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
+        */
+
+       /* 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);
 
-if(file_exists("status.txt"))
-  $lines = file("status.txt");
- else
-   die("no file");
+       /* get some infos about the game */
+       $gamestatus = DB_get_game_status_by_gameid($gameid);
 
-/* check if we want to start a new game */
-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))
-  {
-    $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);
-
-    /* send out email, check for error with email */
-
-    $message = "\n".
-      "you are invited to play a game of DoKo.\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=";
-    
-    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);
-    
-    /* read in random.txt */
-    if(file_exists("random.txt"))
-      $random = file("random.txt");
-    else
-      die("no random file");
-    $randomNR = explode( ":", $random[1] );
-    
-    /* write initial status into file */
-    $output = fopen("status.txt","w");
-    if ($output)
-      {
-       fwrite($output, "$hashA:$PlayerA:$EmailA:::" );
-       for($i=0;$i<11;$i++)
-         fwrite($output,"$randomNR[$i];" );
-       fwrite($output,"$randomNR[11]:" ); $i++;
-       fwrite($output,"\n");
+       /* display useful things in divs */
+       
+       /* display local time */
+       echo "<div class=\"time\">\n Local times:<table>";
+       $users = array();
+       $users = DB_get_all_userid_by_gameid($gameid);
+       foreach($users as $user)
+         {
+           $offset = DB_get_user_timezone($user);
+           $zone   = return_timezone($offset);
+           date_default_timezone_set($zone);
+           $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";
+
+       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();
+
+       /* 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; /* not sure this works... the idea is that you can 
+                   * only  play a card after everyone is ready to play */
+         }
+       
+       /* 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,".
+                             "       Hand.position as position,".
+                             "       Play.sequence as sequence, ".
+                             "       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 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  = DB_get_startplayer_by_gameid($gameid)-1; 
+       $firstcard = ""; /* first card in a trick */
+       
+       echo "\n<ul class=\"tricks\">\n";
+       echo "  <li> Hello $myname!   History: </li>\n";
+       
+       while($r = mysql_fetch_array($result,MYSQL_NUM))
+         {
+           $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($seq==1)
+             {
+               /* 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";
+           
+           /* display comments */
+           if($comment!="")
+             echo "        <span class=\"comment\">".$comment."</span>\n";
+           
+           echo "        ";
+           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 && $trickNR>1) 
+         echo "    </div>\n  </li>\n";  /* end div table, end li table */
+       
+       echo "</ul>\n";
        
-       fwrite($output, "$hashB:$PlayerB:$EmailB:::" );
-       for(;$i<23;$i++)
-         fwrite($output,"$randomNR[$i];" );
-       fwrite($output,"$randomNR[23]:" ); $i++;
-       fwrite($output,"\n");
+       /* whos turn is it? */
+       if($seq==4)
+         {
+            $winner = get_winner($play,$gametype); /* returns the position */
+            $next = $winner;
+            $firstcard = ""; /* new trick, no first card */
+         }
+       else
+         {
+           $next = $pos+1;
+           if($next==5) $next=1;
+         }
        
-       fwrite($output, "$hashC:$PlayerC:$EmailC:::" );
-       for(;$i<35;$i++)
-         fwrite($output,"$randomNR[$i];" );
-       fwrite($output,"$randomNR[35]:" ); $i++;
-       fwrite($output,"\n");
+       /* my turn?, display cards as links, ask for comments*/
+       if(DB_get_pos_by_hash($me) == $next)
+         $myturn = 1;
+       else
+         $myturn = 0;
+
+       /* do we want to play a card? */
+       if(myisset("card") && $myturn)
+         {
+           $card   = $_REQUEST["card"];
+           $handid = DB_get_handid_by_hash($me); 
+           
+           /* check if we have card and that we haven't played it yet*/
+           /* set played in hand_card to true where hand_id and card_id*/
+           $result = mysql_query("SELECT id FROM Hand_Card WHERE played='false' and ".
+                                 "hand_id='$handid' AND card_id=".DB_quote_smart($card));
+           $r = mysql_fetch_array($result,MYSQL_NUM);
+           $handcardid = $r[0];
+           
+           if($handcardid)
+             {
+               /* mark card as played */
+               mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".
+                           DB_quote_smart($card));
+               
+               /* get trick id or start new trick */
+               $a = DB_get_current_trickid($gameid);
+               $trickid  = $a[0];
+               $sequence = $a[1];
+               
+               $playid = DB_play_card($trickid,$handcardid,$sequence);
+
+               /* 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)
+                 {
+                   DB_set_hand_status_by_hash($me,'gameover');
+                   $mystatus='gameover';
+                 }
+               
+               /* if all players are done, set game status to game over, 
+                * get the points of the last trick and send out an email 
+                * to all players
+                */
+               $userids = DB_get_all_userid_by_gameid($gameid);
+
+               $done=1;
+               foreach($userids as $user)
+                 if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='gameover')
+                   $done=0;
+
+               if($done)
+                 {
+                   DB_set_game_status_by_gameid($gameid,"gameover");
+                   /* 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,$EmailName."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,$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
+                     {
+                       $next = DB_get_pos_by_hash($me)+1;
+                     }
+                   if($next==5) $next=1;
+
+                   /* email next player */
+                   $next_hash = DB_get_hash_from_game_and_pos($gameid,$next);
+                   $email     = DB_get_email_by_hash($next_hash);
+
+                   $message = "It's your turn  now.\n".
+                     "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";
+
+                 }
+             }
+           else
+             {
+               echo "can't find that card?! <br />\n";
+             }
+         }
+       else if(myisset("card") && !$myturn )
+         {
+           echo "please wait until it's your turn! <br />\n";
+         }
        
-       fwrite($output, "$hashD:$PlayerD:$EmailD:::");
-       for(;$i<47;$i++)
-         fwrite($output,"$randomNR[$i];" );
-       fwrite($output,"$randomNR[47]:" );
-       fwrite($output,"\n");
+       $mycards = DB_get_hand($me);
+       $mycards = mysort($mycards,$gametype);
+       echo "<div class=\"mycards\">\n";
        
-       fclose($output);
+       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) 
+             {
+               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')
+         {
+           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...<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 />";
+
+
+           $session = DB_get_session_by_gameid($gameid);
+           $result  = mysql_query("SELECT id,create_date FROM Game".
+                                  " WHERE session=$session".
+                                  " ORDER BY create_date DESC".
+                                  " LIMIT 1");
+           $r=-1;
+           if($result)
+             $r = mysql_fetch_array($result,MYSQL_NUM);
+
+           if(!$session || $gameid==$r)
+             {
+               /* suggest a new game with the same people in it, just rotated once */
+               $names = DB_get_all_names_by_gameid($gameid);
+               output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
+             }
+         }
+       break;
+      default:
+       echo "error in testing the status";
       }
-    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)
+    exit();
+  } 
+/* user status page */ 
+    else if(myisset("email","password"))
   {
-?>
-    <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 />
+    /* test id and password, should really be done in one step */
+    $email     = $_REQUEST["email"];
+    $password  = $_REQUEST["password"];
 
-   Name:  <input name="PlayerB" type="text" size="10" maxlength="20" /> 
-   Email: <input name="EmailB"  type="text" size="10" maxlength="20" /> <br />
+    if(strlen($password)!=32)
+      $password = md5($password);
 
-   Name:  <input name="PlayerC" type="text" size="10" maxlength="20" /> 
-   Email: <input name="EmailC"  type="text" size="10" maxlength="20" /> <br />
+    $ok=1;
+    $uid = DB_get_userid_by_email_and_password($email,$password);
+    if(!$uid)
+      $ok=0;
 
-   Name:  <input name="PlayerD" type="text" size="10" maxlength="20" /> 
-   Email: <input name="EmailD"  type="text" size="10" maxlength="20" /> <br />
+    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))
+         {
+           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&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>";
+      }
+    else
+      {
+       echo "sorry email and password don't match <br />";
+      }
+    exit();
+  }
+/* page for registration */
+else if(myisset("register") )
+  {
+    output_register();
+  }
+/* new user wants to register */
+ else if(myisset("Rfullname","Remail","Rpassword","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";
+         }
+  }
+/* default login page */
+else
+  { 
+    output_home_page();
+  }
+
+output_footer();
+
+DB_close();
 
-   <input type="submit" value="start game" />
- </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? 
+/*
+ *Local Variables: 
+ *mode: php
+ *mode: hs-minor
+ *End:
  */
-     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 />";
-
-            $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\" />";
 ?>
-<input type="submit" value="submit" />
 
-</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 />";
-                
-              }
-          }
-       }
-
- } 
-
-?>
 
-</body>
-</html>