• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC top guild side par problem

megazx

Graphic designer
Joined
Mar 4, 2013
Messages
443
Solutions
2
Reaction score
32
Location
Egypt
this is the php script

PHP:
                            <div id="menu-top2">&raquo; Top guilds &laquo;</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'] . '&nbsp;&nbsp;&nbsp;(' . $guild['frags'] . ' kills)</a></li>';
                                    ?>
                                </ul>
                        </div>
                    </div>

and this is how it looks

JAnDKs.jpg
 
Back
Top