Thank you very much![MyAAC][Plugin] Most powerful guilds (TFS 0.3/4 and 1.0)
This is most powerful guilds plugin for MyAAC. It displays guilds that have most unjustified kills. Requirements: Any version of MyAAC. Installation: Go to Admin Panel, select 'Plugins', and then select powerful-guilds.zip and click upload. That's all! In config.local.php, optionally add...otland.net
Status:
<?php
if($status['online']): ?>
<span style="color: green"><b>ONLINE</b></span>
<?php else: ?>
<span style="color: red"><b>OFFLINE</b></span>
<?php endif;
echo date('l j F, Y');
?>
<?php
foreach(getTopPlayers(5) as $player)
{
echo '<li class="bg6"><h3><em class="style2"><b>(' . $player['level'] . ')</b> <a href="' . getPlayerLink($player['name'], false) . '" class="link2">' . $player['name'] . '</a></em></h3>';
echo '<em class="style2">
' . number_format($player['experience']) . ' exp</em></li>';
}
?>
function getTopPowergamers($limit = 5) {
global $db;
$cache = Cache::getInstance();
if($cache->enabled()) {
$tmp = '';
if($cache->fetch('toppow_' . $limit . '_level', $tmp)) {
$players = unserialize($tmp);
}
}
if (!isset($players)) {
$deleted = 'deleted';
if($db->hasColumn('players', 'deletion'))
$deleted = 'deletion';
$is_tfs10 = $db->hasTable('players_online');
$players = $db->query('SELECT `id`, `name`, `level`, `exphist1` as `experience`, `looktype`' . ($db->hasColumn('players', 'lookaddons') ? ', `lookaddons`' : '') . ', `lookhead`, `lookbody`, `looklegs`, `lookfeet`' . ($is_tfs10 ? '' : ', `online`') . ' FROM `players` WHERE `group_id` < ' . config('highscores_groups_hidden') . ' AND `id` NOT IN (' . implode(', ', config('highscores_ids_hidden')) . ') AND `' . $deleted . '` = 0 AND `account_id` != 1 ORDER BY `exphist1` DESC LIMIT ' . (int)$limit)->fetchAll();
if($is_tfs10) {
foreach($players as &$player) {
$query = $db->query('SELECT `player_id` FROM `players_online` WHERE `player_id` = ' . $player['id']);
$player['online'] = ($query->rowCount() > 0 ? 1 : 0);
}
unset($player);
}
$i = 0;
foreach($players as &$player) {
$player['rank'] = ++$i;
}
unset($player);
if($cache->enabled()) {
$cache->set('toppow_' . $limit . '_level', serialize($players), 120);
}
}
return $players;
}
foreach(getTopPlayers(5) as $player)
Thank you very much. My hero.Here's the function: (paste in system/functions.php)
PHP:function getTopPowergamers($limit = 5) { global $db; $cache = Cache::getInstance(); if($cache->enabled()) { $tmp = ''; if($cache->fetch('toppow_' . $limit . '_level', $tmp)) { $players = unserialize($tmp); } } if (!isset($players)) { $deleted = 'deleted'; if($db->hasColumn('players', 'deletion')) $deleted = 'deletion'; $is_tfs10 = $db->hasTable('players_online'); $players = $db->query('SELECT `id`, `name`, `level`, `exphist1` as `experience`, `looktype`' . ($db->hasColumn('players', 'lookaddons') ? ', `lookaddons`' : '') . ', `lookhead`, `lookbody`, `looklegs`, `lookfeet`' . ($is_tfs10 ? '' : ', `online`') . ' FROM `players` WHERE `group_id` < ' . config('highscores_groups_hidden') . ' AND `id` NOT IN (' . implode(', ', config('highscores_ids_hidden')) . ') AND `' . $deleted . '` = 0 AND `account_id` != 1 ORDER BY `exphist1` DESC LIMIT ' . (int)$limit)->fetchAll(); if($is_tfs10) { foreach($players as &$player) { $query = $db->query('SELECT `player_id` FROM `players_online` WHERE `player_id` = ' . $player['id']); $player['online'] = ($query->rowCount() > 0 ? 1 : 0); } unset($player); } $i = 0; foreach($players as &$player) { $player['rank'] = ++$i; } unset($player); if($cache->enabled()) { $cache->set('toppow_' . $limit . '_level', serialize($players), 120); } } return $players; }
Just replace in your code:
PHP:foreach(getTopPlayers(5) as $player)
getTopPlayers with getTopPowergamers