Tibia Tools

<?PHP
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD><font color=gold><B>Most Powerfulls Guilds</B></font></TD></TR></TABLE>
<table border="0" cellspacing="3" cellpadding="4" width="100%">
';

foreach($SQL->query('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags`
FROM `killers` k
LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id`
LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id`
LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id`
LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
GROUP BY `name`
ORDER BY `frags` DESC, `name` ASC
LIMIT 0, 100;') as $guild)

if ($guild['frags']>0)
{
$main_content .= '
<tr BGCOLOR="'.$config['site']['lightborder'].'"><td style="width: 25%; text-align: center;">
<a href="/?subtopic=guilds&action=show&guild=' . $guild['name'] . '">' . $guild['name'] . '<br><img src="/guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/></a>
</td><td><br />' . $guild['frags'] . ' Players kills</td> </tr>';}

$main_content .= '    
</table>';?>