function getTop100Players()
{
global $db, $players_group_and_order, $armory_url, $ALLIANCE, $HORDE, $ALLIANCE_RACES, $HORDE_RACES;
$query = sprintf("SELECT character_guid, count(character_guid) AS count, characters.name as character_name, characters.level as character_level FROM pvpstats_players INNER JOIN pvpstats_battlegrounds ON pvpstats_players.battleground_id = pvpstats_battlegrounds.id INNER JOIN characters ON pvpstats_players.character_guid = characters.guid WHERE characters.deleteDate IS NULL AND pvpstats_players.winner = 1 %s LIMIT 0,100", $players_group_and_order);
$result = $db->query($query);
if (!$result) {
die("Error querying: " . $query);
}
$row = $result->fetch_array();
if ($row == null) {
return;
}
$position = 1;
if (!isset($armory_url) || $armory_url == "") {
$player_name = sprintf("<span style=\"color: %s; \"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $row['character_name']);
} else {
$player_name = sprintf("<a style=\"color: %s; \" target=\"_blank\" href=\"%s%s\"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $armory_url, $row['character_name'], $row['character_name']);
}
$player_guild = getPlayerGuild($row['character_guid']);
$guild_name = getGuildName($player_guild);
printf("<tr><td>%d</td><td>%s</td><td style=\"min-width: 46px; padding-left: 0; padding-right: 0;\"><img src=\"img/class/%d.gif\"> <img src=\"img/race/%d-%d.gif\"></td><td>%s</td><td><strong><a href=\"#%s\"><span style=\"color: %s\">%s</span></a></strong></td><td>%d</td></tr>", $position, $player_name, getPlayerClass($row['character_guid']), getPlayerRace($row['character_guid']), getPlayerGender($row['character_guid']), $row['character_level'], $guild_name, getGuildColor($player_guild), $guild_name, $row['count']);
$prev_score = $row['count'];
if (!isset($armory_url) || $armory_url == "") {
while (($row = $result->fetch_array()) != null) {
if ($prev_score != $row['count']) {
$position++;
}
$player_name = sprintf("<span style=\"color: %s; \"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $row['character_name']);
$player_guild = getPlayerGuild($row['character_guid']);
$guild_name = getGuildName($player_guild);
printf("<tr><td>%d</td><td>%s</td><td style=\"min-width: 46px; padding-left: 0; padding-right: 0;\"><img src=\"img/class/%d.gif\"> <img src=\"img/race/%d-%d.gif\"></td><td>%s</td><td><strong><a href=\"#%s\"><span style=\"color: %s\">%s</span></a></strong></td><td>%d</td></tr>", $position, $player_name, getPlayerClass($row['character_guid']), getPlayerRace($row['character_guid']), getPlayerGender($row['character_guid']), $row['character_level'], $guild_name, getGuildColor($player_guild), $guild_name, $row['count']);
$prev_score = $row['count'];
}
} else {
while (($row = $result->fetch_array()) != null) {
if ($prev_score != $row['count']) {
$position++;
}
$player_name = sprintf("<a style=\"color: %s; \" target=\"_blank\" href=\"%s%s\"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $armory_url, $row['character_name'], $row['character_name']);
$player_guild = getPlayerGuild($row['character_guid']);
$guild_name = getGuildName($player_guild);
printf("<tr><td>%d</td><td>%s</td><td style=\"min-width: 46px; padding-left: 0; padding-right: 0;\"><img src=\"img/class/%d.gif\"> <img src=\"img/race/%d-%d.gif\"></td><td>%s</td><td><strong><a href=\"#%s\"><span style=\"color: %s\">%s</span></a></strong></td><td>%d</td></tr>", $position, $player_name, getPlayerClass($row['character_guid']), getPlayerRace($row['character_guid']), getPlayerGender($row['character_guid']), $row['character_level'], $guild_name, getGuildColor($player_guild), $guild_name, $row['count']);
$prev_score = $row['count'];
}
}
}
if ($attr_count > 3) {
printf("<td>%s</td>", $row['attr_4']);
if ($attr_count > 4) {
printf("<td>%s</td>", $row['attr_5']);
}
}
}
}
printf("</tr>");
}
} else {
while (($row = $result->fetch_array()) != null) {
printf("<tr>");
$player_name = sprintf("<a style=\"color: %s; \" target=\"_blank\" href=\"%s%s\"><strong>%s</strong></a>", getPlayerColor($row['character_guid']), $armory_url, getPlayerName($row['character_guid']), getPlayerName($row['character_guid']));
printf("<td>%s</td>", $player_name);
printf("<td style=\"min-width: 49px; padding-left: 0; padding-right: 0;\"><img src=\"img/class/%d.gif\"> <img src=\"img/race/%d-%d.gif\"></td>", getPlayerClass($row['character_guid']), getPlayerRace($row['character_guid']), getPlayerGender($row['character_guid']));
printf("<td>%s</td>", $row['score_killing_blows']);
printf("<td>%s</td>", $row['score_deaths']);
printf("<td>%s</td>", $row['score_honorable_kills']);
printf("<td>%s</td>", $row['score_bonus_honor']);
printf("<td>%s</td>", $row['score_damage_done']);
printf("<td>%s</td>", $row['score_healing_done']);
printf("<td>%s</td>", $row['attr_1']);
if ($attr_count > 1) {
printf("<td>%s</td>", $row['attr_2']);
if ($attr_count > 2) {
printf("<td>%s</td>", $row['attr_3']);
if ($attr_count > 3) {
printf("<td>%s</td>", $row['attr_4']);
if ($attr_count > 4) {
printf("<td>%s</td>", $row['attr_5']);