X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=functions.php;h=3726cf115f00888f37fbdc6aafe98d72a368c066;hp=c6a4a098e70824a56866fbb8cdc0788dec2e1c3e;hb=a7ab5e63c5558a72d5ca56f96b406dc41108cce9;hpb=304fe579fe0d084d73e7e959223cfeb70a50e37a

diff --git a/functions.php b/functions.php
index c6a4a09..3726cf1 100644
--- a/functions.php
+++ b/functions.php
@@ -658,4 +658,176 @@ 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 "  <div 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>\n";
+      echo "    <span title=\"".date("Y-m-d H:i:s",$lastlogin)."\">last login</span>\n";
+      echo "   </div>\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 ".DB_format_gameid($r[1])." </a><br />\n";
+    }
+  
+  echo "<hr /> <a href=\"".$host."?new\">start a new game</a>\n";
+	       
+
+  echo
+    "<hr />Report bugs in the <a href=\"". $wiki."\">wiki</a>\n";
+  echo  "</div>\n";
+  return;
+}
+
 ?>