Here is how its shown at this time...
Code: Select all
$currentUser = $row['userid'];
echo '<table cellpadding="0" cellspacing="1">
<tr>
<td width="10%" valign="middle" bgcolor="#669900"><div style="padding:3px;color:#FFFFFF;text-align:center;">P</div></td>
<td width="80%" align="left" valign="middle" bgcolor="#669900"><div style="padding:3px;color:#FFFFFF;">'._PLAYER.'</div></td>
<td width="10%" align="center" valign="middle" bgcolor="#669900"><div style="padding:3px;color:#FFFFFF;text-align:center;">'._POINTS.'</div></td>
</tr>';
$sql = "SELECT u.fname, u.lname, u.country, user_points.points FROM ".$prefix."_users cu
INNER JOIN ".$prefix."_users u ON u.new_userid = cu.new_userid
INNER JOIN ".$prefix."_GA_users ON u.new_userid = ".$prefix."_GA_users.userid
INNER JOIN ( SELECT AVG(point) points, userid FROM ".$prefix."_GA_leaderboard
WHERE seasonid = $seasonid
GROUP BY userid ) user_points ON cu.new_userid = user_points.userid
WHERE ".$prefix."_GA_users.aproved = 1 ORDER BY user_points.points DESC LIMIT 25";
$result = mysql_query($sql);
$x = 0;
$i = 0;
$prev = 0;
$r_count = 0;
while($row = mysql_fetch_array($result)){
$fname = $row['fname'];
$lname = $row['lname'];
$ucountry = $row['country'];
$sql2 = "SELECT * FROM ".$prefix."_geo_countries WHERE con_id='$ucountry'";
$result2 = mysql_query($sql2);
$row2 = mysql_fetch_array($result2);
$curr = $row['points'];
if ($curr != $prev)
{
$i = $x + 1;
}
echo '<tr style="background-color:#' .((++$r_count %2 == 0) ? 'FFFFFF' : 'EEEEEE'). '">';
echo '<td align="center" valign="middle"><input name="placement[]" type="text" readonly="true" value="'.$i.'" style="font-size:11px;width:16px;text-align:center;border:none;background-color:transparent;font-family:lucida grande,tahoma,verdana,arial,sans-serif;"/></td>';
echo '<td align="left" valign="middle"> ';
if(!$row['country']) {
echo '<img src="http://www.golfacross.com/facebook/images/lang/nocountry.png"> ';
} else {
echo '<img src="http://www.golfacross.com/facebook/images/lang/'.$row2['iso'].'.png"> ';
}
echo ''.$fname.' '.$lname.'</td>';
echo '<td align="center" valign="middle"><div style="text-align:center;">' . number_format($row['points'], 2) . '</div></td>';
echo '</tr>';
$prev = $curr;
$x++;
}
echo '</table>';
echo '</div>';Any help please...