$num = mysql_num_rows($result);
$compteur = 1;
$col = "color:#555555";
$oldPoints = -1;
while (10 >= $compteur) {
$row = mysql_fetch_array($result);
if (!empty($row["nationality"])) {
$nationality = $row["nationality"];
} else {
$nationality = 'No country';
}
$name = $row['playerName'];
$nameClass = colorNameClass($name, $row['approved']);
$points = $row['points'];
$profileId = $row['profileId'];
$wins = GetSixserverWins($profileId);
$losses = GetSixserverLosses($profileId);
$draws = GetSixserverDraws($profileId);
$pos = "";
if ($oldPoints != $points) {
$pos = $compteur;
$oldPoints = $points;
}
echo "<tr style='height:19px;'>";
if (!empty($row)) {
echo "<td style='text-align:right;cursor:hand;'>" . $pos . ".</td>";
echo "<td><img src='{$directory}/flags/{$nationality}.bmp' width='18' height='15' border='1'></td>";
echo "<td width='180' {$nameClass} style='white-space:nowrap;'><a href='{$directory}/profile.php?name={$name}' title='view profile'>{$name}</a> <span style='cursor:help;' class='darkgrey-small' title='server profile'>(" . $row['profileName'] . ")</span></td>";
echo "<td align=\"right\" width='80'>";
echo "<b>" . $points . "</b> <span style='{$col}'>points</span> ";
echo "</td>";
}
?>
<?
if (strlen($serial6)>0) {
$sql = "SELECT name, id AS profileId, disconnects, points, rating FROM six_profiles WHERE six_profiles.user_id=".$player_id.
" ORDER BY points DESC";
$result = mysql_query($sql);
while ($rowProfiles = mysql_fetch_array($result)) {
$sixName = $rowProfiles['name'];
$sixProfileId = $rowProfiles['profileId'];
$sixName = '<span title="#'.$sixProfileId.'">'.$sixName.'</span>';
$pointsSix = $rowProfiles['points'];
$ratingSix = $rowProfiles['rating'];
$sixWins = GetSixserverWins($sixProfileId);
$sixLosses = GetSixserverLosses($sixProfileId);
$sixDraws = GetSixserverDraws($sixProfileId);
$sixDC = $rowProfiles['disconnects'];
$sixGames = $sixWins + $sixLosses + $sixDraws + $sixDC;
if ($sixGames <= 0) {
$sixPercentage = 0.000;
} else {
$sixPercentage = $sixWins / $sixGames;
}
if ($sixGames <= 0) {
$DCPercentage = 0.000;
} else {
$DCPercentage = $sixDC / $sixGames * 100;
}
$DCDisplay = formatDC($DCPercentage, $sixGames);
