Top Guild Kills Gesior Acc

<?PHP

    $main_content .= '<div style="text-align: center; font-weight: bold;"><h2>Top 15 guilds on ' . $config['server']['serverName'] . '</h2></div>

<center><table border="0" cellspacing="1" cellpadding="4" width="80%">

    <tr bgcolor="'.$config['site']['vdarkborder'].'">

        <td width="10%"><b><font color=white><center>Pos</font></center></b></td>

        <td width="20%"><b><font color=white><center>Logo</center></b></font></td>

        <td width="30%"><b><font color=white><center>Guild Name</center></b></font></td>

        <td width="20%"><b><font color=white><center>Kills</center></b></font></td>

    </tr>';

$i = 0;

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, 15;') as $guild)

{

    $i++;

    $main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']). '">

        <td>            

            <center>'.$i.'</center>

        </td>

        <td>            

            <center><img src="guilds/' . ((!empty($guild['logo']) && file_exists('guilds/' . $guild['logo'])) ? $guild['logo'] : 'default_logo.gif') . '" width="64" height="64" border="0"/></center>

        </td>

        <td>

            <center><a href="?subtopic=guilds&action=show&guild=' . $guild['id'] . '">' . $guild['name'] . '</a></center>

        </td>

        <td>

            <center>' . $guild['frags'] . ' kills</center>

        </td>

    </tr>';

}

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

$main_content .= '<div style="text-align: right; font-size: 10;">Based on <a href=http://otland.net/members/elf>Elf\'s</a>code. System  made by <a href='http://otland.net/members/kekox>Kekox.</a></div>;'>

?>

Bom eu quero coloca esse top guild pra ganha o kills com qualquer tipo de morte. exemplo mator pk,red skull e backskull ganha um kills. pq esse ai so ganha quando eu viro pk e mato um pessoa, e eu quero coloca pra quando mata pk, red, qualquer player ganhe tb.

Editado Abril 12, 2015 10 anos por ZwhiteDog (veja o histórico de edições)