megazx
Graphic designer
this is the php script
and this is how it looks
PHP:
<div id="menu-top2">» Top guilds «</div>
<ul>
<?
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, 5;') as $guild)
echo '<li><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">' . $guild['name'] . ' (' . $guild['frags'] . ' kills)</a></li>';
?>
</ul>
</div>
</div>
and this is how it looks