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('SELECTname
,frags_all
,level
,experience
FROMplayers
WHEREgroup_id
< ' . $config['highscore']['ignoreGroupId'] . ' ANDaccount_id
!= 1 ORDER BYexperience
DESC LIMIT 10;');
// $v = mysql_select_multi('SELECT (SELECT COUNT(death_id
) FROMkillers
k LEFT JOINplayer_killers
pk ONk
.id
=pk
.kill_id
LEFT JOINplayers
p ONpk
.player_id
=p
.id
WHEREk
.unjustified
>= 0 ANDplayer_id
= ' . $player->getId() . '), COUNT(player_id
) FROMplayer_deaths
WHEREplayer_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("SELECTp
.name
ASname
,p
.level
ASlevel
,p
.vocation
ASvocation
,g
.name
ASgname
,za
.flag
ASflag
$outfitQuery FROMplayers_online
ASo
INNER JOINplayers
ASp
ONo
.player_id
=p
.id
INNER JOINznote_accounts
ASza
ONp
.account_id
=za
.account_id
LEFT JOINguild_membership
ASgm
ONo
.player_id
=gm
.player_id
LEFT JOINguilds
ASg
ONgm
.guild_id
=g
.id
;") : mysql_select_multi("SELECTp
.name
ASname
,p
.level
ASlevel
,p
.vocation
ASvocation
,g
.name
ASgname
$outfitQuery FROMplayers_online
ASo
INNER JOINplayers
ASp
ONo
.player_id
=p
.id
LEFT JOINguild_membership
ASgm
ONo
.player_id
=gm
.player_id
LEFT JOINguilds
ASg
ONgm
.guild_id
=g
.id
;");
} else {
$array = ($loadFlags === true) ? mysql_select_multi("SELECTp
.name
asname
,p
.level
aslevel
,p
.vocation
asvocation
,g
.name
asgname
,za
.flag
asflag
$outfitQuery FROMplayers
asp
INNER JOINznote_accounts
asza
ONza
.account_id
=p
.account_id
LEFT JOINguild_ranks
asgr
ONgr
.id
=p
.rank_id
LEFT JOINguilds
asg
ONgr
.guild_id
=g
.id
WHEREp
.online
= '1' ORDER BYp
.name
DESC;") : mysql_select_multi("SELECTp
.name
asname
,p
.level
aslevel
,p
.vocation
asvocation
,g
.name
asgname
$outfitQuery FROMplayers
asp
LEFT JOINguild_ranks
asgr
ONgr
.id
=p
.rank_id
LEFT JOINguilds
asg
ONgr
.guild_id
=g
.id
WHEREp
.online
= '1' ORDER BYp
.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
-
redeem.png26.8 KB · Views: 9 · VirusTotal