Search the Community
Showing results for tags 'top guilds'.
Found 1 result
-
Abra o arquivo topguilds.php, apague tudo e coloque lá: <?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>'; ?> Créditos: Kekox
- 3 replies
-
- 1
-
-
- top guilds
- gesior acc
- (and 2 more)
