\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 "
\n";
if(!$debug)
echo " $name \n";
else
echo "
$name\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 "
![\"poverty](\"pics/button/poverty_trump_button.png\")
";
else
echo "
![\"poverty](\"pics/button/poverty_notrump_button.png\")
";
}
else
echo "
![\"poverty](\"pics/button/poverty_partner_button.png\")
\" />";
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 "
![\"poverty](\"pics/button/poverty_trump_button.png\")
";
else
echo "
![\"poverty](\"pics/button/poverty_notrump_button.png\")
";
}
else
echo "
![\"poverty](\"pics/button/poverty_partner_button.png\")
\" />";
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 "
![\"poverty2](\"pics/button/poverty2_trump_button.png\")
";
else
echo "
![\"poverty2](\"pics/button/poverty2_notrump_button.png\")
";
}
else
echo "
![\"poverty2](\"pics/button/poverty2_partner_button.png\")
\" />";
if($GT=="wedding" && $party=="re")
if($sickness=="wedding")
echo "
![\"wedding\"](\"pics/button/wedding_button.png\")
";
else
echo "
![\"wedding](\"pics/button/wedding_partner_button.png\")
";
if(ereg("solo",$GT) && $party=="re")
{
if(ereg("queen",$GT))
echo "
![\"$GT\"](\"pics/button/queensolo_button.png\")
";
else if(ereg("jack",$GT))
echo "
![\"$GT\"](\"pics/button/jacksolo_button.png\")
";
else if(ereg("club",$GT))
echo "
![\"$GT\"](\"pics/button/clubsolo_button.png\")
";
else if(ereg("spade",$GT))
echo "
![\"$GT\"](\"pics/button/spadesolo_button.png\")
";
else if(ereg("heart",$GT))
echo "
![\"$GT\"](\"pics/button/heartsolo_button.png\")
";
else if(ereg("trumpless",$GT))
echo "
![\"$GT\"](\"pics/button/notrumpsolo_button.png\")
";
else if(ereg("trump",$GT))
echo "
![\"$GT\"](\"pics/button/trumpsolo_button.png\")
";
}
/* add point calls */
if($call!=NULL)
{
if($party=="re")
echo "
![\"re\"](\"pics/button/re_button.png\")
";
else
echo "
![\"contra\"](\"pics/button/contra_button.png\")
";
switch($call)
{
case "0":
echo "
![\"0\"](\"pics/button/0_button.png\")
";
break;
case "30":
echo "
![\"30\"](\"pics/button/30_button.png\")
";
break;
case "60":
echo "
![\"60\"](\"pics/button/60_button.png\")
";
break;
case "90":
echo "
![\"90\"](\"pics/button/90_button.png\")
";
break;
}
}
echo "
\n";
echo "
local time\n";
echo "
last login\n";
echo "