Help me in highscores

[Ravemixers]

I'm trying to create a rank for the guild, I want to tell the level of all players and rank a list with the guild that has more level or with a guild that has more top level players.I realized that this topic http://otland.net/f118/gesior-aac-guild-statisctic-extras-91643/ has a list of the level of all players of the guild, I tried to do some system based on top frags please someone help me?


i using this code for base

<?php
$main_content .= '<div class="NewsHeadline">
<div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
<table border="0">
<tr>
<td style="text-align: center; font-weight: bold;">
<font color="white">Most powerfull guilds</font>
</td>
</tr>
</table>
</div>
</div>
<table border="0" cellspacing="3" cellpadding="4" width="100%">
<tr>';
$allM1 = $SQL->query ('SELECT SUM(`level`) as `level` FROM `players` LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`')->fetch();
$i++;
$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '">
<td><a href="?subtopic=characters&name=' . urlencode($allM1['id']) . '">' . $allM1['name'] . '</a></td>
<td style="text-align: center;">' . $allM1['frags'] . '</td>
</tr>';


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

?>

 

[cronoxhere]

Remplace you guild.php
for this

ohh
1. The text that you have entered is too long (155462 characters). Please shorten it to 75000 characters long.

download here.
and remplace.

guilds php

 

[Ravemixers]

No man I want to do a TOP guilds, such as TOP frags and that counts is the level of the guild and not the frags, thus creating a higher score in the guild up and down, depending on the lowest level of each player within the Guild


so this code needs to be modified to return the name of the guild and the level of all players within it

ps:I will create a new file called topguilds.php and I will add the site to count the level of all players in the guild.

<?php
$main_content .= '<div class="NewsHeadline">
<div class="NewsHeadlineBackground" style="background-image:url(' . $layout_name . '/images/news/newsheadline_background.gif)">
<table border="0">
<tr>
<td style="text-align: center; font-weight: bold;">
<font color="white">Most powerfull guilds</font>
</td>
</tr>
</table>
</div>
</div>
<table border="0" cellspacing="3" cellpadding="4" width="100%">
<tr>';
$allM1 = $SQL->query ('SELECT SUM(`level`) as `level` FROM `players` LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id`')->fetch();
$i++;
$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '">
<td><a href="?subtopic=characters&name=' . urlencode($allM1['id']) . '">' . $allM1['name'] . '</a></td>
<td style="text-align: center;">' . $allM1['frags'] . '</td>
</tr>';


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

?>

Sorry for my english =(