X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=index.php;h=f8bb305cf80957fc7e277139724e631539876cb5;hp=8b567fd90efd5a5f2395a769740d2509aad5ca7c;hb=651d44e67499ec7cae07c60c5351f65424c93279;hpb=d57105094a2e224bd7f4f03b11ab96a45383fea2

diff --git a/index.php b/index.php
index 8b567fd..f8bb305 100644
--- a/index.php
+++ b/index.php
@@ -1,6 +1,9 @@
 <?php
 error_reporting(E_ALL);
 
+global $REV;
+$REV  ="\$Rev$";
+
 include_once("config.php");      
 include_once("output.php");      /* html output only */
 include_once("db.php");          /* database only */
@@ -107,7 +110,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 +157,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,8 +191,10 @@ else if(myisset("me"))
 	break;
 	
       case 'check':
-	echo "checking for solo...<br /> if you have a wedding or poverty you need to play a normal game,sorry...<br />".
-	  " At the moment you need to reload this page to finish the setup.<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 />".
+	  " 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,
@@ -204,12 +212,13 @@ else if(myisset("me"))
 	      {
 		DB_set_solo_by_hash($me,$_REQUEST["solo"]);
 		DB_set_sickness_by_hash($me,"solo");
-		echo "Seems like you want to play a ".$_REQUEST["solo"]." solo. Got it.\n";
+		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"]);
@@ -244,7 +253,8 @@ 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 />".
+	  " 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');
@@ -258,8 +268,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;
@@ -286,7 +359,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 */
@@ -304,7 +379,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'" );
@@ -316,7 +392,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 />";
@@ -356,15 +431,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";
@@ -461,7 +534,9 @@ else if(myisset("me"))
 	    
 	    if($handcardid)
 	      {
-		mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".DB_quote_smart($card));
+		/* mark card as played */
+		mysql_query("UPDATE Hand_Card SET played='true' WHERE hand_id='$handid' AND card_id=".
+			    DB_quote_smart($card));
 		
 		/* get trick id or start new trick */
 		$a = DB_get_current_trickid($gameid);
@@ -470,17 +545,17 @@ else if(myisset("me"))
 		
 		$playid = DB_play_card($trickid,$handcardid,$sequence);
 
-		/*check for coment */
+		/* 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)
@@ -489,16 +564,52 @@ else if(myisset("me"))
 		    $mystatus='gameover';
 		  }
 		
-		/* if all players are done, set game status to game over */
+		/* if all players are done, set game status to game over, 
+		 * get the points of the last trick and send out an email 
+		 * to all players
+		 */
 		$userids = DB_get_all_userid_by_gameid($gameid);
+
 		$done=1;
 		foreach($userids as $user)
 		  if(DB_get_hand_status_by_userid_and_gameid($user,$gameid)!='gameover')
 		    $done=0;
 
 		if($done)
-		  DB_set_game_status_by_gameid($gameid,"gameover");
+		  {
+		    DB_set_game_status_by_gameid($gameid,"gameover");
+		    /* get score for last trick 
+		     * all other tricks are handled a few lines further down*/
+		    $play   = DB_get_cards_by_trick($trickid);
+		    $winner = get_winner($play,$gametype); /* returns the position */
+		    /* get points of last trick and save it */
+		    $points = 0;
+		    foreach($play as $card)
+		      $points = $points + card_value($card);
+		    $winnerid = DB_get_handid_by_gameid_and_position($gameid,$winner);
+		    if($winnerid>0)
+		      mysql_query("INSERT INTO Score VALUES (NULL, '$gameid', '$winnerid', '$points')");
+		    else
+		      echo "ERROR during scoring";
+
+		    /* email all players */
+		    $result = mysql_query("SELECT fullname, SUM(score) FROM Score".
+					  " LEFT JOIN Hand ON Hand.id=hand_id".
+					  " LEFT JOIN User ON Hand.user_id=User.id".
+					  " WHERE Hand.game_id=$gameid".
+					  " GROUP BY fullname" );
+		    $message = "The game is over. Thanks for playing :)\n";
+		    while( $r = mysql_fetch_array($result,MYSQL_NUM))
+		      $message .= " FINAL SCORE: ".$r[0]." ".$r[1]."\n";
+		    $message .= "\nIf your not in the list above your score is zero...\n";
+		    foreach($userids as $user)
+		      {
+			$To = DB_get_email_by_userid($user);
+			mymail($To,"[DoKo] game over",$message);
+		      }
+		  }
 		
+
 		/* email next player */
 		if(DB_get_game_status_by_gameid($gameid)=='play')
 		  {
@@ -506,6 +617,23 @@ else if(myisset("me"))
 		      {
 			$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
@@ -548,7 +676,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;
@@ -585,8 +713,16 @@ else if(myisset("me"))
 	  }
 	else
 	  {
-	    echo "the game is over now... guess the final score should be displayed here...<br />\n";
+	    echo "the game is over now...<br />\n";
 	    
+	    $result = mysql_query("SELECT fullname, SUM(score) FROM Score".
+				  " LEFT JOIN Hand ON Hand.id=hand_id".
+				  " LEFT JOIN User ON Hand.user_id=User.id".
+				  " WHERE Hand.game_id=$gameid".
+				  " GROUP BY fullname" );
+	    while( $r = mysql_fetch_array($result,MYSQL_NUM))
+	      echo " FINAL SCORE: ".$r[0]." ".$r[1]."<br />";
+
 	    /* suggest a new game with the same people in it, just rotated once */
 	    $names = DB_get_all_names_by_gameid($gameid);
 	    output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid);
@@ -631,6 +767,12 @@ else if(myisset("me"))
 	  echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a><br />";
 	echo "</p>\n";
 
+	echo "<p>and these are your games that are already done:<br />\n";
+	$result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status='gameover'" );
+	while( $r = mysql_fetch_array($result,MYSQL_NUM))
+	  echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a><br />";
+	echo "</p>\n";
+
 	$names = DB_get_all_names();
 	echo "<p>registered players:<br />\n";
 	foreach ($names as $name)