[manual]Русские Ники,Кланы в Moy-web

<?php
  $link = mysql_connect($L2JBS_config['mysql_host'].":".$L2JBS_config['mysql_port'], $L2JBS_config['mysql_login'], $L2JBS_config['mysql_password']);
mysql_query("SET CHARACTER SET cp1251");
  if (!$link)
die("Couldn't connect to MySQL");
  @mysql_select_db($L2JBS_config['mysql_db'], $link);
error_reporting(0);

?>

echo '<center><h4>Статистика сервера '.$server[$show_server][0].'</H4><hr>';

mysql_query("SET CHARACTER SET cp1251");

<?PHP
if (!defined('_FLAGINDEX')) { die('Stop!'); }
global $server,$module_c;
if (count($server) == 0) {

}else{
    $return    = "<B>Выберите интересующий вас cервер:</B><BR>";
    $i = 1;
    foreach ($server as $return_server) {
        $return .= "<B>:.</B> <a href=\"?id=stats&server=".$i."\">".$return_server[0]."</a><br>";
        $i++;
    }
    echo $return;
    $show_server = intval($mw->getParam($_REQUEST, 'server', 0));
    $type_server = intval($mw->getParam($_REQUEST, 'type', 0));
    if ($type_server == 0) { $type_server = 1;}
    if ($show_server !=0) {
        if (!$mwdb->sql_db(
        $server[$show_server][1].':'.$server[$show_server][2],
        $server[$show_server][4],
        $server[$show_server][5],
        $server[$show_server][3],
        false)) {
            echo "Ошибка подключения к серверу";
        }else{

            echo '<center><h4>Статистика сервера '.$server[$show_server][0].'</H4><hr>';
            mysql_query("SET CHARACTER SET cp1251");
            if ($module_c[0] != 0) { echo '  | <a href="?id=stats&server='.$show_server.'&type=1">Общая</a>';}
            if ($module_c[1] != 0) {    echo '  | <a href="?id=stats&server='.$show_server.'&type=10"\">Онлайн</a>';}
            if ($module_c[2] != 0) {    echo '  | <a href="?id=stats&server='.$show_server.'&type=5">Замки</a>';}
            if ($module_c[3] != 0) {    echo '  | <a href="?id=stats&server='.$show_server.'&type=6">Семь печатей</a>';}
            if ($module_c[4] != 0) {    echo '  | <a href="?id=stats&server='.$show_server.'&type=7">Top кланов</a>';}
            if ($module_c[5] != 0) {    echo '  | <a href="?id=stats&server='.$show_server.'&type=8">ГМы</a>';}
            if ($module_c[6] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=9">Богачи</a>';}
            if ($module_c[7] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=6">Top игроков</a>';}
            if ($module_c[8] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=1">Дуэлянты</a>';}
            if ($module_c[9] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=2">Убийцы</a>';}
            if ($module_c[10] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=3">Время в игре</a>';}
            if ($module_c[11] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=4">Толстокожие</a>';}
            if ($module_c[12] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=5">Мудрые</a>';}
            if ($module_c[13] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=7">Люди</a>';}
            if ($module_c[14] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=8">Эльфы</a>';}
            if ($module_c[18] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=9">Темные эльфы</a>';}
            if ($module_c[15] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=10">Орки</a>';}
            if ($module_c[16] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=11">Гномы</a>';}
            if ($module_c[17] != 0) {    echo ' | <a href="?id=stats&server='.$show_server.'&type=10&show=12">Камаэль</a>|<br>';}
            echo '<hr></center> ';

<?php
if (!defined('_FLAGINDEX')) { die('Stop!'); }
$sql = "SELECT clan_data.*,char_name,csum,ccount,cavg FROM clan_data INNER JOIN characters ON clan_data.leader_id=characters.obj_Id LEFT JOIN (SELECT clanid, SUM(level) AS csum, count(level) AS ccount, AVG(level) AS cavg FROM characters WHERE clanid GROUP BY clanid) AS levels ON clan_data.clan_id=levels.clanid ORDER BY clan_level DESC, csum DESC";
if (!($result = $mwdb->sql_query($sql))) {

}
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 ($show_result = $mwdb->sql_fetchrow($result))
{
    if(!isset($clan["{$show_result["clan_name"]}"]))
    {
        switch ($show_result["hasCastle"])
        {
            case 1: $show_result["hasCastle"]="<font color=#008000><b>Gludio</b></font>"; break;
            case 2: $show_result["hasCastle"]="<font color=#008000><b>Dion</b></font>"; break;
            case 3: $show_result["hasCastle"]="<font color=#008000><b>Giran</b></font>"; break;
            case 4: $show_result["hasCastle"]="<font color=#008000><b>Oren</b></font>"; break;
            case 5: $show_result["hasCastle"]="<font color=#008000><b>Aden</b></font>"; break;
            case 6: $show_result["hasCastle"]="<font color=#008000><b>Innadril</b></font>"; break;
            case 7: $show_result["hasCastle"]="<font color=#008000><b>Goddard Castle</b></font>"; break;
            case 8: $show_result["hasCastle"]="<font color=#008000><b>Rune Castle</b></font>"; break;
            case 9: $show_result["hasCastle"]="<font color=#008000><b>Schuttgart Castle</b></font>"; break;
            default: $show_result["hasCastle"]="<font color=#FF0000>Нет</font>";
        }
        print "<tr". (($i++ % 2) ? "" : " class=\"alternateRow\"") ."><td><a href=\"index.php?id=clanview&clan_name=". $show_result["clan_name"]."\">". htmlspecialchars($show_result["clan_name"]). "</a></td><td>". $show_result["char_name"]. "</td><td class=\"numeric sortedColumn\">".$show_result["clan_level"]. "</td><td>".$show_result["hasCastle"]. "</td><td class=\"numeric\">".$show_result["csum"]. "</td><td class=\"numeric\">".$show_result["ccount"]. "</td><td class=\"numeric\">".$show_result["cavg"]. "</td></tr>\n";
    }}
    print "</tbody>\n</table>\n";
?>
</body>
</html>

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in T:\home\virtual\absoluteworld.ath.cx\sources\component\mw_stats\stats_clantop.php on line 21