Статистика - Топ кланов
module/clantop.php
PHP код:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");if (($ms7)==1) {
$result = mysql_query("SELECT
C.clan_id,C.clan_name,C.clan_level, L.char_name AS clan_leader,
SUM(S.level) AS level_sum, COUNT(S.level) AS clan_count, AVG(S.level) AS clan_avg
FROM clan_data AS C
LEFT OUTER JOIN characters AS L ON (L.obj_id = C.leader_id)
LEFT OUTER JOIN characters AS P ON (P.clanid = C.clan_id)
LEFT OUTER JOIN character_subclasses AS S ON (S.char_obj_id = P.obj_id AND S.isBase = 1)
WHERE
clan_level >= 0
GROUP BY clan_name
ORDER BY clan_level DESC", $link)
or die ("Error: ".mysql_error());
print '<table>
<caption><br><b>..:: Топ кланов ::..</b><br><br><hr></caption>
<thead>
<tr style="vertical-align: bottom;">
<th>Имя клана</th>
<th>Лидер</th>
<th class="sortedColumn">Уровень</th>
<th>Замок</th>
<th>Сумма уровней</th>
<th>Членов</th>
<th>Средний уровень</th>
</tr>
</thead>
<tfoot>
<tr><td colspan="7" style="text-align: right;"><hr>Всего кланов на сервере: '.mysql_num_rows($result).'</td></tr>
</tfoot>
<tbody id="TblBdy">
';
$i=1;
while ($row=mysql_fetch_array($result))
{
if(!isset($clan["{$row["clan_name"]}"]))
{
switch ($row["hasCastle"])
{
case 1: $row["hasCastle"]="<font color=#008000><b>Gludio</b></font>"; break;
case 2: $row["hasCastle"]="<font color=#008000><b>Dion</b></font>"; break;
case 3: $row["hasCastle"]="<font color=#008000><b>Giran</b></font>"; break;
case 4: $row["hasCastle"]="<font color=#008000><b>Oren</b></font>"; break;
case 5: $row["hasCastle"]="<font color=#008000><b>Aden</b></font>"; break;
case 6: $row["hasCastle"]="<font color=#008000><b>Innadril</b></font>"; break;
case 7: $row["hasCastle"]="<font color=#008000><b>Goddard Castle</b></font>"; break;
case 8: $row["hasCastle"]="<font color=#008000><b>Rune Castle</b></font>"; break;
case 9: $row["hasCastle"]="<font color=#008000><b>Schuttgart Castle</b></font>"; break;
default: $row["hasCastle"]="<font color=#FF0000>Нет</font>";
}
print "<tr". (($i++ % 2) ? "" : " class=\"alternateRow\"") ."><td><a href=\"index.php?id=clanview&clan_name=". $row["clan_name"]."\">". htmlspecialchars($row["clan_name"]). "</a></td><td>". $row["clan_leader"]. "</td><td class=\"numeric sortedColumn\">".$row["clan_level"]. "</td><td>".$row["hasCastle"]. "</td><td class=\"numeric\">".$row["level_sum"]. "</td><td class=\"numeric\">".$row["clan_count"]. "</td><td class=\"numeric\">".(int)$row["clan_avg"]. "</td></tr>\n";
}}
print "</tbody>\n</table>\n";
mysql_close($link);
?>
</body>
</html>
<?php } else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}?>
что было сделано: исправлен mysql запрос под структуру базы rebellion, удалены лишние запросы, исправлены переменные под новый запрос.
пысы: чуть позже будут еще странички.