Tibia Tools

<?php

$main_content .= '<style>
.KL{background-color:none;}
.KL:hover{background-color:white;font-weight:bold;color:black;}
</style>

<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
<TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white colspan=100><B>Top 30 frags on ' . $config['server']['serverName'] . '</B></TD></TR>';

$i = 0;
foreach($SQL->query('SELECT description, `p`.`name` AS `name`, COUNT(`p`.`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`
WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1
    GROUP BY `name`
    ORDER BY `frags` DESC, `name` ASC
    LIMIT 0,30;') as $player)
{
    $i++;

    $main_content .= '<tr BGCOLOR="'.$config['site']['lightborder'].'">
        <td width=1%>'.$i.'</td><td> <a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td>
        <td style="text-align: center;">' . $player['frags'] . ' players killed</td>
    </tr>';
}
$main_content .= '</table>';?>