diff options
Diffstat (limited to 'functions.php')
| -rw-r--r-- | functions.php | 169 |
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; +} + ?> |