<?php
$loadFlags = ($config['country_flags']['enabled'] && $config['country_flags']) ? true : false;
$cache = new Cache('engine/cache/topPlayer');
if ($cache->hasExpired()) {
$players = mysql_select_multi('SELECT
name,
frags_all,
level,
experience FROM
players WHERE
group_id < ' . $config['highscore']['ignoreGroupId'] . ' AND
account_id != 1 ORDER BY
experience DESC LIMIT 10;');
// $v = mysql_select_multi('SELECT (SELECT COUNT(
death_id) FROM
killers k LEFT JOIN
player_killers pk ON
k.
id =
pk.
kill_id LEFT JOIN
players p ON
pk.
player_id =
p.
id WHERE
k.
unjustified >= 0 AND
player_id = ' . $player->getId() . '), COUNT(
player_id) FROM
player_deaths WHERE
player_id = '.$player->getId())->fetch();
$cache->setContent($players);
$cache->save();
} else {
$players = $cache->load();
}
$loadFlags = ($config['country_flags']['enabled'] && $config['country_flags']['onlinelist']) ? true : false;
if ($config['ServerEngine'] == 'TFS_10') {
$array = ($loadFlags === true) ? mysql_select_multi("SELECT
p.
name AS
name,
p.
level AS
level,
p.
vocation AS
vocation,
g.
name AS
gname,
za.
flag AS
flag $outfitQuery FROM
players_online AS
o INNER JOIN
players AS
p ON
o.
player_id =
p.
id INNER JOIN
znote_accounts AS
za ON
p.
account_id =
za.
account_id LEFT JOIN
guild_membership AS
gm ON
o.
player_id =
gm.
player_id LEFT JOIN
guilds AS
g ON
gm.
guild_id =
g.
id;") : mysql_select_multi("SELECT
p.
name AS
name,
p.
level AS
level,
p.
vocation AS
vocation,
g.
name AS
gname $outfitQuery FROM
players_online AS
o INNER JOIN
players AS
p ON
o.
player_id =
p.
id LEFT JOIN
guild_membership AS
gm ON
o.
player_id =
gm.
player_id LEFT JOIN
guilds AS
g ON
gm.
guild_id =
g.
id;");
} else {
$array = ($loadFlags === true) ? mysql_select_multi("SELECT
p.
name as
name,
p.
level as
level,
p.
vocation as
vocation,
g.
name as
gname,
za.
flag as
flag $outfitQuery FROM
players as
p INNER JOIN
znote_accounts as
za ON
za.
account_id =
p.
account_id LEFT JOIN
guild_ranks as
gr ON
gr.
id =
p.
rank_id LEFT JOIN
guilds as
g ON
gr.
guild_id =
g.
id WHERE
p.
online = '1' ORDER BY
p.
name DESC;") : mysql_select_multi("SELECT
p.
name as
name,
p.
level as
level,
p.
vocation as
vocation,
g.
name as
gname $outfitQuery FROM
players as
p LEFT JOIN
guild_ranks as
gr ON
gr.
id =
p.
rank_id LEFT JOIN
guilds as
g ON
gr.
guild_id =
g.
id WHERE
p.
online = '1' ORDER BY
p.
name DESC;");
}
if ($players) {
$count = 1;
// foreach ($array as $player) {
$flag = ($loadFlags === true && strlen($player['flag']) > 1) ? '<img src="' . $config['country_flags']['server'] . '/' . $player['flag'] . '.png"> ' : '';
foreach($players as $player) {
echo "
<li class='top-list'>
<span class='top-number'>$count.</span>
<span class='top-flag'>".$flag."</span>
<span class='top-name'><a href='characterprofile.php?name=". $player['name']. "'>". $player['name']. "</a></span>
<span class='top-lvl'>". bd_nice_number($player['level']) ."</span>
<span class='top-Res'>". $player['frags_all'] ."<sup>0</sup></span>
</li>";
$count++;
// }
}
} else {
echo '<center><b></h4>No players there.</h4></b></center>';
}
?>
