• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Znote Acc - small problem header

asdzx123

Member
Joined
Jul 1, 2019
Messages
37
Reaction score
8
Can you add me in foreach flags and death
<?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>';
}
?>
 

Attachments

Back
Top