LAYOUT: started work on new layout

table is also shown during setup of the game
user menu on the left, game menu on the right
user menu shows games in which you have to move

1 files changed, 169 insertions, 0 deletions

diff --git a/functions.php b/functions.php
index c6a4a09..d738b00 100644
--- a/functions.php
+++ b/functions.php
@@ -658,4 +658,173 @@ function can_call($what,$hash)
   return 0;
 }
 
+function display_table ()
+{
+  global $gameid, $GT, $debug,$host;
+
+  $result = mysql_query("SELECT  User.fullname as name,".
+			"        Hand.position as position, ".
+			"        User.id, ".
+			"        Hand.party as party, ".
+			"        Hand.sickness as sickness, ".
+			"        Hand.point_call, ".
+			"        User.last_login, ".
+			"        Hand.hash        ".
+			"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];
+      $user  = $r[2];
+      $party = $r[3];
+      $sickness  = $r[4];
+      $call      = $r[5];
+      $lastlogin = strtotime($r[6]);
+      $hash      = $r[7];
+      
+      $offset = DB_get_user_timezone($user);
+      $zone   = return_timezone($offset);
+      date_default_timezone_set($zone);
+      
+      echo " <span class=\"table".($pos-1)."\">\n";
+      if(!$debug)
+	echo " $name \n";
+      else
+	echo "<a href=\"".$host."?me=".$hash."\">$name</a>\n";
+
+      /* add hints for poverty, wedding, solo, etc */
+      if($GT=="poverty" && $party=="re")
+	if($sickness=="poverty")
+	  {
+	    $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
+	    $cards    = DB_get_all_hand($userhash);
+	    $trumpNR  = count_trump($cards);
+	    if($trumpNR)
+	      echo "<img src=\"pics/button/poverty_trump_button.png\" class=\"button\" alt=\"poverty < trump back\" />";
+	    else
+	      echo "<img src=\"pics/button/poverty_notrump_button.png\" class=\"button\" alt=\"poverty <\" />";
+	  }
+	else
+	  echo "<img src=\"pics/button/poverty_partner_button.png\" class=\"button\" alt=\"poverty >\" />";
+      
+      if($GT=="dpoverty")
+	if($party=="re")
+	  if($sickness=="poverty")
+	    {
+	      $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
+	      $cards    = DB_get_all_hand($userhash);
+	      $trumpNR  = count_trump($cards);
+	      if($trumpNR)
+		echo "<img src=\"pics/button/poverty_trump_button.png\" class=\"button\" alt=\"poverty < trump back\" />";
+	      else
+		echo "<img src=\"pics/button/poverty_notrump_button.png\" class=\"button\" alt=\"poverty <\" />";
+	    }
+	  else
+	    echo "<img src=\"pics/button/poverty_partner_button.png\" class=\"button\" alt=\"poverty >\" />";
+	else
+	  if($sickness=="poverty")
+	    {
+	      $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user);
+	      $cards    = DB_get_all_hand($userhash);
+	      $trumpNR  = count_trump($cards);
+	      if($trumpNR)
+		echo "<img src=\"pics/button/poverty2_trump_button.png\" class=\"button\" alt=\"poverty2 < trump back\" />";
+	      else
+		echo "<img src=\"pics/button/poverty2_notrump_button.png\" class=\"button\" alt=\"poverty2 <\" />";
+	    }
+	  else
+	    echo "<img src=\"pics/button/poverty2_partner_button.png\" class=\"button\" alt=\"poverty2 >\" />";
+      
+      if($GT=="wedding" && $party=="re")
+	if($sickness=="wedding")
+	  echo "<img src=\"pics/button/wedding_button.png\" class=\"button\" alt=\"wedding\" />";
+	else
+	  echo "<img src=\"pics/button/wedding_partner_button.png\" class=\"button\" alt=\"wedding partner\" />";
+      
+      if(ereg("solo",$GT) && $party=="re")
+	{
+	  if(ereg("queen",$GT))
+	    echo "<img src=\"pics/button/queensolo_button.png\" class=\"button\" alt=\"$GT\" />";
+	  else if(ereg("jack",$GT))
+	    echo "<img src=\"pics/button/jacksolo_button.png\" class=\"button\" alt=\"$GT\" />";
+	  else if(ereg("club",$GT))
+	    echo "<img src=\"pics/button/clubsolo_button.png\" class=\"button\" alt=\"$GT\" />";
+	  else if(ereg("spade",$GT))
+	    echo "<img src=\"pics/button/spadesolo_button.png\" class=\"button\" alt=\"$GT\" />";
+	  else if(ereg("heart",$GT))
+	    echo "<img src=\"pics/button/heartsolo_button.png\" class=\"button\" alt=\"$GT\" />";
+	  else if(ereg("trumpless",$GT))
+	    echo "<img src=\"pics/button/notrumpsolo_button.png\" class=\"button\" alt=\"$GT\" />";
+	  else if(ereg("trump",$GT))
+	    echo "<img src=\"pics/button/trumpsolo_button.png\" class=\"button\" alt=\"$GT\" />";
+	}
+      
+      /* add point calls */
+      if($call!=NULL)
+	{
+	  if($party=="re")
+	    echo "<img src=\"pics/button/re_button.png\" class=\"button\" alt=\"re\" />";
+	  else
+	    echo "<img src=\"pics/button/contra_button.png\" class=\"button\" alt=\"contra\" />";
+	  switch($call)
+	    {
+	    case "0":
+	      echo "<img src=\"pics/button/0_button.png\" class=\"button\" alt=\"0\" />";
+	      break;
+	    case "30":
+	      echo "<img src=\"pics/button/30_button.png\" class=\"button\" alt=\"30\" />";
+	      break;
+	    case "60":
+	      echo "<img src=\"pics/button/60_button.png\" class=\"button\" alt=\"60\" />";
+	      break;
+	    case "90":
+	      echo "<img src=\"pics/button/90_button.png\" class=\"button\" alt=\"90\" />";
+	      break;
+	    }
+	}
+      
+      echo "<br />\n";
+      echo " <span title=\"".date("Y-m-d H:i:s")."\">local time</span>";
+      echo " <span title=\"".date("Y-m-d H:i:s",$lastlogin)."\">last login</span>";
+      echo " </span>\n";
+      
+    }
+  echo  "</div>\n"; /* end output table */
+  
+  
+  return;
+}
+
+
+function display_user_menu()
+{
+  global $wiki,$myid,$host;
+  echo "<div class=\"usermenu\">\n".
+    "<a href=\"index.php\"> go to my user page </a>";
+
+  $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.player from Hand".
+			" LEFT JOIN Game On Hand.game_id=Game.id".
+			" WHERE Hand.user_id='$myid'".
+			" AND Game.player='$myid'".
+			" AND Game.status<>'gameover'" );
+  if(mysql_num_rows($result))
+      echo "<hr />It's your turn in these games:<br />\n";
+
+  while( $r = mysql_fetch_array($result,MYSQL_NUM))
+    {
+      echo "<a href=\"".$host."?me=".$r[0]."\">game #".$r[1]." </a><br />\n";
+    }
+  
+  echo
+    "<hr />Report bugs in the <a href=\"". $wiki."\">wiki</a>\n";
+  echo  "</div>\n";
+  return;
+}
+
 ?>