added third candle (a bit late)
[e-DoKo.git] / index.php
index ea5724a1ffc80ae6f49f48b7bec3944fce0e292c..29b3eb13898411cc516c4e9a651ee583329a7325 100644 (file)
--- a/index.php
+++ b/index.php
@@ -1,66 +1,21 @@
-<!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>
-     <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 onload="high_last();">
-<div class="header">
-<h1> Welcome to E-Doko </h1>
-</div>
-
 <?php
 error_reporting(E_ALL);
 
-include_once("config.php");     
-include_once("functions.php");
-include_once("db.php");
+include_once("config.php");      
+include_once("output.php");      /* html output only */
+include_once("db.php");          /* database only */
+include_once("functions.php");   /* the rest */
 
 DB_open();
 
-/* end header */
-
-/*****************  M A I N **************************/
+output_header();
 
 /* check if we want to start a new game */
-if(isset($_REQUEST["new"]))
-  {
-    output_form_for_new_game();
-  } 
-/* end start a new game */
+if(myisset("new"))
+  output_form_for_new_game();
 
 /*check if everything is ready to set up a new game */
-else if( isset($_REQUEST["PlayerA"]) && 
-    isset($_REQUEST["PlayerB"]) && 
-    isset($_REQUEST["PlayerC"]) && 
-    isset($_REQUEST["PlayerD"]) )
+else if( myisset("PlayerA", "PlayerB","PlayerC","PlayerD" ))
   {
     $PlayerA = $_REQUEST["PlayerA"];
     $PlayerB = $_REQUEST["PlayerB"];
@@ -89,7 +44,7 @@ else if( isset($_REQUEST["PlayerA"]) &&
     
     /* create game */
     $followup = NULL;
-    if(isset($_REQUEST["followup"])) 
+    if(myisset("followup") )
       {
        $followup= $_REQUEST["followup"];
        mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', NULL, NULL,'pre','$followup' ,NULL)");
@@ -149,20 +104,20 @@ else if( isset($_REQUEST["PlayerA"]) &&
   }    
 /* end set up a new game */
 
-else if(isset($_REQUEST["me"]))
+else if(myisset("me"))
   {
-     /* handle request from one specifig player,
-      * the hash is set on a per game base, so first just handle this game
-      * perhaps also show links to other games in a sidebar
-      */
+    /* handle request from one specific player,
+     * the hash is set on a per game base
+     */
     
     $me = $_REQUEST["me"];
-    
+
+    /* test for valid ID */
     $myid = DB_get_userid_by_hash($me);
     if(!$myid)
       {
        echo "Can't find you in the database, please check the url.<br />\n";
-       echo "perhaps the game has been cancled.";
+       echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
        exit();
       }
     
@@ -180,7 +135,7 @@ else if(isset($_REQUEST["me"]))
        DB_set_hand_status_by_hash($me,'init');
        break;
       case 'init':
-       if( !isset($_REQUEST["in"]) || !isset($_REQUEST["update"]))
+       if( !myisset("in","update") )
          {
            DB_set_hand_status_by_hash($me,'start');
            echo "you need to answer both question";
@@ -190,7 +145,7 @@ else if(isset($_REQUEST["me"]))
            if($_REQUEST["in"] == "no")
              {
                echo "TODO: email everyone that the game has been canceled.<br />";
-                /*something like
+                /*something like need to modify for DB backend
                 for($i=0;$i<4;$i++)
                   {
                     $message = "Hello ".$player[$hash[$i]]["name"].",\n\n".
@@ -198,6 +153,7 @@ else if(isset($_REQUEST["me"]))
                     mymail($player[$hash[$i]]["email"],"[DoKo-Debug] the game has been canceled",$message); 
                   }
                 */
+               /* delete everything from the dB */
                DB_cancel_game($me);
              }
            else
@@ -221,17 +177,14 @@ else if(isset($_REQUEST["me"]))
        break;
        
       case 'check':
-       echo "no checking at the moment... you need to play a normal game. At the moment you need to reload this page to finish the setup.";
-       if(!isset($_REQUEST["solo"])    || 
-          !isset($_REQUEST["wedding"]) ||
-          !isset($_REQUEST["poverty"]) ||
-          !isset($_REQUEST["nines"]) )
+       echo "no checking at the moment... you need to play a normal game.".
+         " At the moment you need to reload this page to finish the setup.";
+       if(!myisset("solo","wedding","poverty","nines") )
          {
-           DB_set_hand_status_by_hash($me,'init');
-           /* problem: by setting it back to init, variables "in" and "update" are 
-            * not set, so the player will be send back to the start, after seeing his hand
-            */
-           echo "you need to fill out the form";
+           /* all these variables have a pre-selected default,
+            * so we should never get here,
+            * unless a user tries to cheat ;) */
+           echo "something went wrong...please contact the admin.";
          }
        else
          {
@@ -263,6 +216,11 @@ else if(isset($_REQUEST["me"]))
        /* reset solo, etc from players who did say something, but it didn't matter? */
        break;
       case 'poverty':
+       /* here we need to check if there is a solo or some other form o sickness.
+        * If so, which one counts
+        * set that one in the Game table, delete other ones form Hand table 
+        * tell people about it.
+        */
        echo "<br />poverty not handeled at the moment... you need to play a normal game<br />";
        
        /* only set this after all poverty, etc. are handeled*/
@@ -270,27 +228,59 @@ else if(isset($_REQUEST["me"]))
 
        /* check if the game can start  */
        $userids = DB_get_all_userid_by_gameid($gameid);
-       $done=1;
+       $ok=1;
        foreach($userids as $user)
-         if(DB_get_hand_status_by_userid($user)!='play')
-           $done=0;
+         if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='play')
+           $ok=0;
 
-       if($done)
+       if($ok)
          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();
+      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
+        */
+
+       /* 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";
+
        display_status();
 
+       /* 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...*/
        $gamestatus = DB_get_game_status_by_gameid($gameid);
        if($gamestatus == 'pre')
          {
            echo "you need to wait for the others... <br />";
-           break;
+           break; /* not sure this works... the idea is that you can 
+                   * only  play a card after everyone is ready to play */
          }
-       /* get trick ids */
+       
+       /* get everything relevant to display the tricks */
        $result = mysql_query("SELECT Hand_Card.card_id as card,".
                              "       User.fullname as name,".
                              "       Hand.position as position,".
@@ -338,7 +328,7 @@ else if(isset($_REQUEST["me"]))
                /* 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\" />";
+                 "      <img class=\"table\" src=\"pics/table".($pos-1).".png\" alt=\"table\" />\n";
              }
            
            /* display card */
@@ -370,7 +360,8 @@ else if(isset($_REQUEST["me"]))
                echo "    </div>\n  </li>\n";  /* end div table, end li table */
              }
          }
-       if($seq!=4) 
+
+       if($seq!=4 && $trickNR>1) 
          echo "    </div>\n  </li>\n";  /* end div table, end li table */
        
        echo "</ul>\n";
@@ -378,7 +369,7 @@ else if(isset($_REQUEST["me"]))
        /* whos turn is it? */
        if($seq==4)
          {
-            $winner = get_winner($play); /* returns the position */
+            $winner = get_winner($play,"normal"); /* returns the position */
             $next = $winner;
          }
        else
@@ -394,7 +385,7 @@ else if(isset($_REQUEST["me"]))
          $myturn = 0;
 
        /* do we want to play a card? */
-       if(isset($_REQUEST["card"]) && $myturn)
+       if(myisset("card") && $myturn)
          {
            $card   = $_REQUEST["card"];
            $handid = DB_get_handid_by_hash($me); 
@@ -418,7 +409,7 @@ else if(isset($_REQUEST["me"]))
                $playid = DB_play_card($trickid,$handcardid,$sequence);
 
                /*check for coment */
-               if(isset($_REQUEST["comment"]))
+               if(myisset("comment"))
                  {
                    DB_insert_comment($_REQUEST["comment"],$playid,$myid);
                  };  
@@ -436,11 +427,11 @@ else if(isset($_REQUEST["me"]))
                    $mystatus='gameover';
                  }
                
-               /* if all players are done, set game status also to game over */
+               /* if all players are done, set game status to game over */
                $userids = DB_get_all_userid_by_gameid($gameid);
                $done=1;
                foreach($userids as $user)
-                 if(DB_get_hand_status_by_userid($user)!='gameover')
+                 if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='gameover')
                    $done=0;
 
                if($done)
@@ -452,7 +443,7 @@ else if(isset($_REQUEST["me"]))
                    if($sequence==4)
                      {
                        $play   = DB_get_cards_by_trick($trickid);
-                       $winner = get_winner($play); /* returns the position */
+                       $winner = get_winner($play,"normal"); /* returns the position */
                        $next = $winner;
                      }
                    else
@@ -465,10 +456,10 @@ else if(isset($_REQUEST["me"]))
                    $next_hash = DB_get_hash_from_game_and_pos($gameid,$next);
                    $email     = DB_get_email_by_hash($next_hash);
 
-                   $message .= "It's your turn  now.\n".
+                   $message = "It's your turn  now.\n".
                      "Use this link to play a card: ".$host."?me=".$next_hash."\n\n" ;
                    mymail($email,"[DoKo-debug] 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";
@@ -480,7 +471,7 @@ else if(isset($_REQUEST["me"]))
                echo "couldn't find card <br />\n";
              }
          }
-       else if(isset($_REQUEST["card"]) && !$myturn )
+       else if(myisset("card") && !$myturn )
          {
            echo "please wait until it is your turn! <br />\n";
          }
@@ -489,19 +480,18 @@ else if(isset($_REQUEST["me"]))
        sort($mycards);
        echo "<div class=\"mycards\">\n";
        
-       if($myturn && !isset($_REQUEST["card"]))
+       if($myturn && !myisset("card"))
          {
            echo "Hello ".$myname.", it's your turn!  <br />\n";
            echo "Your cards are: <br />\n";
            echo "<form action=\"index.php?me=$me\" method=\"post\">\n";
            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
+
+           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')
          {
@@ -514,7 +504,7 @@ else if(isset($_REQUEST["me"]))
        /* check if we need to set status to 'gameover' is done during playing of the card */
        if($mystatus=='play')
          break;
-   /* the following happens only when the gamestatus is 'gameover' */
+       /* the following happens only when the gamestatus is 'gameover' */
        /* check if game is over, display results */
        if(DB_get_game_status_by_gameid($gameid)=='play')
          {
@@ -526,16 +516,7 @@ else if(isset($_REQUEST["me"]))
            
            /* 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";
+           output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
          }
        break;
       default:
@@ -543,14 +524,20 @@ else if(isset($_REQUEST["me"]))
       }
     exit();
   } 
- else if(isset($_REQUEST["email"]) && isset($_REQUEST["password"]))
+/* user status page */ 
+    else if(myisset("email","password"))
   {
+    /* test id and password, should really be done in one step */
+    $email     = $_REQUEST["email"];
+    $password  = $_REQUEST["password"];
+
+    if(strlen($password)!=32)
+      $password = md5($password);
+
     $ok=1;
-    $uid = DB_get_userid_by_email($_REQUEST["email"]);
+    $uid = DB_get_userid_by_email_and_password($email,$password);
     if(!$uid)
       $ok=0;
-    if(!DB_get_userid_by_passwd(md5($_REQUEST["password"])))
-      $ok=0;
 
     if($ok)
       {
@@ -561,15 +548,14 @@ else if(isset($_REQUEST["me"]))
        $zone = return_timezone($offset);
        date_default_timezone_set($zone);
 
-       echo "ok. your logged in, now what? :) <br />last login: ";
-       echo date("r",$unixtime)."<br />";
+       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 hash,game_id from Hand WHERE user_id='$uid' AND status<>'gameover'" );
        while( $r = mysql_fetch_array($result,MYSQL_NUM))
-         echo "<a href=\"http://doko.nubati.net/database/index.php?me=".$r[0]."\">game #".$r[1]." </a><br />";
+         echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a><br />";
        echo "</p>\n";
 
        $names = DB_get_all_names();
@@ -577,8 +563,9 @@ else if(isset($_REQUEST["me"]))
        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>";
+         "<a href=\"".$host."?new\">this page.</a></p>";
       }
     else
       {
@@ -586,40 +573,13 @@ else if(isset($_REQUEST["me"]))
       }
     exit();
   }
-else if(isset($_REQUEST["register"]) )
+/* page for registration */
+else if(myisset("register") )
   {
-    echo "TODO: convert timezone into a menu<br />\n";
-    echo "TODO: figure out a way to handle passwrods <br />\n";
-?>
-        <form action="index.php" method="post">
-          <fieldset>
-            <legend>Register</legend>
-             <table>
-              <tr>
-               <td><label for="Rfullname">Full name:</label></td>
-              <td><input type="text" id="Rfullname" name="Rfullname" size="20" maxsize="30" /> </td>
-              </tr><tr>
-               <td><label for="Remail">Email:</label></td>
-              <td><input type="text" id="Remail" name="Remail" size="20" maxsize="30" /></td>
-              </tr><tr>
-              <td><label for="Rpassword">Password(will be displayed in cleartext on the next page):</label></td>
-               <td><input type="password" id="Rpassword" name="Rpassword" size="20" maxsize="30" /></td>
-              </tr><tr>
-              <td><label for="Rtimezone">Timezone:</label></td>
-               <td>
-                  <input type="text" id="Rtimezone" name="Rtimezone" size="4" maxsize="4" value="+1" />
-              </td>
-              </tr><tr>
-               <td colspan="2"> <input type="submit" value="register" /></td>
-             </table>
-          </fieldset>
-        </form>
-<?php
+    output_register();
   }
-else if(isset($_REQUEST["Rfullname"]) && 
-       isset($_REQUEST["Remail"]   ) && 
-       isset($_REQUEST["Rpassword"]) && 
-       isset($_REQUEST["Rtimezone"]) )
+/* new user wants to register */
+ else if(myisset("Rfullname","Remail","Rpassword","Rtimezone") )
   {
        $ok=1;
        if(DB_get_userid_by_name($_REQUEST["Rfullname"]))
@@ -640,41 +600,18 @@ else if(isset($_REQUEST["Rfullname"]) &&
                      ",".DB_quote_smart($_REQUEST["Rtimezone"]).",NULL)"); 
            
            if($r)
-             echo "  added you to the database";
+             echo " added you to the database";
            else
              echo " something went wrong";
          }
   }
+/* default login page */
 else
-  { /* no new game, not in a game */
-?>
-    <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>
-
-
-<?php
+  { 
+    output_home_page();
   }
-?>
-</body>
-</html>
 
-<?php
+output_footer();
 
 DB_close();