-
- /* display the table and the names */
- $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\" />";
- }