fixed: correct startplayer for solos
[e-DoKo.git] / index.php
index e25b7208f570bb20c2b645c4f3774a14802c0561..157c7bdc8a30b7fdce115e8bef76a36ccafa053d 100644 (file)
--- a/index.php
+++ b/index.php
@@ -107,7 +107,9 @@ else if( myisset("PlayerA", "PlayerB","PlayerC","PlayerD" ))
     mymail($EmailB,"You are invited to a game of DoKo","Hello $PlayerB,\n".$message.$hashB);
     mymail($EmailC,"You are invited to a game of DoKo","Hello $PlayerC,\n".$message.$hashC);
     mymail($EmailD,"You are invited to a game of DoKo","Hello $PlayerD,\n".$message.$hashD);
-        
+
+    
+    echo "You started a new game. The emails have been sent out!";    
   }    
 /* end set up a new game */
 
@@ -152,15 +154,16 @@ else if(myisset("me"))
          {
            if($_REQUEST["in"] == "no")
              {
-               echo "TODO: email everyone that the game has been canceled.<br />";
-                /*something like need to modify for DB backend
-                for($i=0;$i<4;$i++)
-                  {
-                    $message = "Hello ".$player[$hash[$i]]["name"].",\n\n".
-                      "the game has been canceled due to the request of one of the players.\n";
-                    mymail($player[$hash[$i]]["email"],"[DoKo-Debug] the game has been canceled",$message); 
-                  }
-                */
+               $message = "Hello, \n\n".
+                 "the game has been canceled due to the request of one of the players.\n";
+               
+               $userids = DB_get_all_userid_by_gameid($gameid);
+               foreach($userids as $user)
+                 {
+                   $To = DB_get_email_by_userid($user);
+                   mymail($To,"[DoKo] game cancled",$message);
+                 }
+               
                /* delete everything from the dB */
                DB_cancel_game($me);
              }
@@ -185,9 +188,9 @@ else if(myisset("me"))
        break;
        
       case 'check':
-       echo "checking for solo...<br />".
+       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 />".
+         " if you have poverty you need to play a normal game,sorry...<br />".
          " At the moment you need to reload this page to finish the setup.<br />";
        if(!myisset("solo","wedding","poverty","nines") )
          {
@@ -212,6 +215,7 @@ else if(myisset("me"))
                  {}/* 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"]);
@@ -246,7 +250,7 @@ else if(myisset("me"))
         * set that one in the Game table, delete other ones form Hand table 
         * tell people about it.
         */
-       echo "<br />poverty not handeled at the moment... you need to play a normal game<br />".
+       echo "<br />checking if someone else selected solo or nines... wedding and poverty not handled at the moment<br />".
           "reload this page to finish the setup <br />";
        
        /* only set this after all poverty, etc. are handeled*/
@@ -261,8 +265,71 @@ else if(myisset("me"))
 
        if($ok)
          {
-           /* TODO: check what kind of game we are playing */
            DB_set_game_status_by_gameid($gameid,'play');
+
+           /* check what kind of game we are playing */
+           $gametype    = DB_get_gametype_by_gameid($gameid);
+           $startplayer = DB_get_startplayer_by_gameid($gameid);
+
+           /* nines? */
+           $nines = 0;
+           /* check for nines */
+           foreach($userids as $user)
+             {
+               if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'nines')
+                 $nines = 1;
+             }
+           
+           /* gamestatus == normal, => cancel game */
+           if($nines && $gamestatus == "normal")
+             {
+               /* TODO: set game type to nines to be able to keep statistics */
+               
+               $message = "Hello, \n\n".
+                 "the game has been cancled becausee someone has five or more nines.\n";
+               
+               $userids = DB_get_all_userid_by_gameid($gameid);
+               foreach($userids as $user)
+                 {
+                   $To = DB_get_email_by_userid($user);
+                   mymail($To,"[DoKo] game cancled",$message);
+                 }
+               
+               /* delete everything from the dB */
+               DB_cancel_game($me);
+
+             }
+
+           /* 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;
@@ -289,7 +356,9 @@ else if(myisset("me"))
        
        set_gametype($gametype);
 
-       
+       /* get some infos about the game */
+       $gamestatus = DB_get_game_status_by_gameid($gameid);
+
        /* display useful things in divs */
        
        /* display local time */
@@ -307,7 +376,8 @@ else if(myisset("me"))
          };
        echo "</table>\n</div>\n";
 
-       display_status($GT);
+       if($gamestatus != 'pre')
+         display_status($GT);
 
        /* display links to the users status page */
        $result = mysql_query("SELECT email,password from User WHERE id='$myid'" );
@@ -319,7 +389,6 @@ else if(myisset("me"))
        /* 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 />";
@@ -359,15 +428,13 @@ else if(myisset("me"))
                              "LEFT JOIN Comment ON Play.id=Comment.play_id ".
                              "WHERE Trick.game_id='".$gameid."' ".
                              "ORDER BY Trick.id,sequence ASC");
-       
-       
        $trickNR = 1;
        
        $lasttrick = DB_get_max_trickid($gameid);
        
        $play = array(); /* needed to calculate winner later  */
        $seq  = 1;          
-       $pos  = 0;
+       $pos  = DB_get_startplayer_by_gameid($gameid)-1; 
        $firstcard = ""; /* first card in a trick */
        
        echo "\n<ul class=\"tricks\">\n";
@@ -526,6 +593,7 @@ else if(myisset("me"))
                    $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))
@@ -605,7 +673,7 @@ else if(myisset("me"))
            echo "Your cards are: <br />\n";
            echo "<form action=\"index.php?me=$me\" method=\"post\">\n";
 
-           /* do we have to follow suit? */
+           /* do we have to follow suite? */
            $followsuit = 0;
            if(have_suit($mycards,$firstcard))
              $followsuit = 1;
@@ -647,6 +715,7 @@ else if(myisset("me"))
            $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 />";