\n";
- while($r = DB_fetch_array($result))
- {
+ $row0 = DB_fetch_array($result);
+ $row1 = DB_fetch_array($result);
+ $row2 = DB_fetch_array($result);
+ $row3 = DB_fetch_array($result);
+
+ echo "
\n";
+ display_single_user($row1);
+ echo "\n
\n";
+ display_single_user($row0);
+ echo "
\n";
+ display_single_user($row2);
+
+ return;
+}
+function display_table_end ()
+{
+ global $gameid, $GT, $debug,$INDEX,$defaulttimezone,$session;
+ global $RULES,$GAME,$gametype;
+
+ $result = DB_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, ".
+ " User.timezone, ".
+ " User.email ".
+ "FROM Hand ".
+ "LEFT JOIN User ON User.id=Hand.user_id ".
+ "WHERE Hand.game_id='".$gameid."' ".
+ "ORDER BY position ASC");
+
+ $row0 = DB_fetch_array($result);
+ $row1 = DB_fetch_array($result);
+ $row2 = DB_fetch_array($result);
+ $row3 = DB_fetch_array($result);
+
+ echo "
\n";
+ display_single_user($row3);
+ echo "
\n";
+
+ return;
+}
+
+function display_single_user($r)
+{
+ global $gameid, $GT, $debug,$INDEX,$defaulttimezone,$session;
+ global $RULES,$GAME,$gametype;
+
$name = $r[0];
$pos = $r[1];
$user = $r[2];
@@ -994,8 +1056,8 @@ function display_table ()
$lastlogin = strtotime($r[6]);
date_default_timezone_set($timezone);
$timenow = strtotime(date("Y-m-d H:i:s"));
- $gravatar = "$name
\n";
@@ -1013,7 +1075,7 @@ function display_table ()
else
echo " $gravatar \n";
if($debug)
- echo"\n";
+ echo" \n";
/* add hints for poverty, wedding, solo, etc */
if( $gametype != "solo")
@@ -1027,12 +1089,15 @@ function display_table ()
$cards = DB_get_all_hand($userhash);
$trumpNR = count_trump($cards,'all');
if($trumpNR)
- echo "
";
+ echo "
\n";
else
- echo "
";
+ echo "
\n";
}
else
- echo "
";
+ echo "
\n";
if($GT=="dpoverty")
if($party=="re")
@@ -1042,12 +1107,15 @@ function display_table ()
$cards = DB_get_all_hand($userhash);
$trumpNR = count_trump($cards,'all');
if($trumpNR)
- echo "
";
+ echo "
\n";
else
- echo "
";
+ echo "
\n";
}
else
- echo "
\" title=\"poverty partner\" />";
+ echo "
\" title=\"poverty partner\" />\n";
else
if($sickness=="poverty" || ($RULES['lowtrump']=='poverty' && $sickness=='lowtrump'))
{
@@ -1055,67 +1123,70 @@ function display_table ()
$cards = DB_get_all_hand($userhash);
$trumpNR = count_trump($cards,'all');
if($trumpNR)
- echo "
";
+ echo "
\n";
else
- echo "
";
+ echo "
\n";
}
else
- echo "
\" title=\"poverty2 partner\" />";
+ echo "
\" title=\"poverty2 partner\" />\n";
if($GT=="wedding" && $party=="re")
if($sickness=="wedding")
- echo "
";
+ echo "
\n";
else
- echo "
";
+ echo "
\n";
if( (strpos($GT,"solo")!==false) && $party=="re")
{
if(strpos($GT,"queen")!==false)
- echo "
";
+ echo "
\n";
else if(strpos($GT,"jack")!==false)
- echo "
";
+ echo "
\n";
else if(strpos($GT,"club")!==false)
- echo "
";
+ echo "
\n";
else if(strpos($GT,"spade")!==false)
- echo "
";
+ echo "
\n";
else if(strpos($GT,"heart")!==false)
- echo "
";
+ echo "
\n";
else if(strpos($GT,"trumpless")!==false)
- echo "
";
+ echo "
\n";
else if(strpos($GT,"trump")!==false)
- echo "
";
+ echo "
\n";
}
/* add point calls */
if($call!=NULL)
{
if($party=="re")
- echo "
";
+ echo "
\n";
else
- echo "
";
+ echo "
\n";
switch($call)
{
case "0":
- echo "
";
+ echo "
\n";
break;
case "30":
- echo "
";
+ echo "
\n";
break;
case "60":
- echo "
";
+ echo "
\n";
break;
case "90":
- echo "
";
+ echo "
\n";
break;
}
}
- echo "
\n";
- echo "
".
- "".
- "\n";
+ echo "
";
+ echo "
";
/* show how many tricks the person made */
switch($wins)
{
@@ -1130,49 +1201,56 @@ function display_table ()
default:
echo "#tricks many"; break;
}
-
- echo "