$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>"; echo "<td align=\"right\"><b>" . $wins . "</b><span style='{$col}'> W</span><td>"; echo "<td align=\"right\"><b>" . $draws . "</b><span style='{$col}'> D</span><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); $sixWinsTeam = GetSixserverWinsTeam($sixProfileId);