[web]Ошибка в срипте

[/code]
<?php
if(empty($mw))
{
  header ("Location: ..");
  exit;
}
include("module/stat-menu.php");
if (($ms1)==1) { ?>
<br><b><center>..:: Рейты нашего сервера ::..</center></b><br>
<table  width="100%"border="1" >
<tr><td>

EXP: <?php echo $exp;?><br>
SP: <?php echo $sp;?><br></td><td valign="top">
Adena: <?php echo $adena;?><br></td><td>
Items: <?php echo $items;?><br>
Spoil: <?php echo $spoil;?><br>

</td></tr></table>



<br><b><center>..:: Общая ::..</center></b><br>
<table  width="100%"border="1" >
<tr><td width="25%" valign="top">


Логин сервер: <?php echo $loginonline; ?><br>
Гейм сервер: <?php echo $gameonline; ?><?php echo $gm; ?><br>
Онлайн: <?php echo $playsonline; ?><br> из них ГМов: <?php echo $gmonline; ?> <br>
Аккаунтов: <?php echo $accountsnum; ?><br>
Чаров: <?php echo $charnum; ?> из них ГМов: <?php echo $gmnum; ?><br>
Кланов: <?php echo $clannum; ?><br>
<img src="module/stat/sex.jpg">
<?php
$sql = mysql_query("select count(*) from characters where sex = 0");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?>
<br>
<img src="module/stat/sex1.jpg">
<?php
$sql = mysql_query("select count(*) from characters where sex = 1");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?>
</td><td valign="top">
<b>Процентное соотношение расс:</b><br>
<table><tr><td><left>
Люди:
</left><br>
Эльфы:
<br>
Тёмные эльфы:
<br>
Орки:
<br>
Гномы:
</td><td width="50%">
<?php
$sql = mysql_query("select count(*) from characters where race = 0");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?><br>
<?php
$sql = mysql_query("select count(*) from characters where race = 1");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?><br>
<?php
$sql = mysql_query("select count(*) from characters where race = 2");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?><br>
<?php
$sql = mysql_query("select count(*) from characters where race = 3");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?><br>
<?php
$sql = mysql_query("select count(*) from characters where race = 4");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?>
</td></tr></table>
</td><td valign="top">
<b>Семь печатей:</b><br><br>
<?php
$sql = mysql_query("select count(*) from seven_signs where cabal like '%dusk%'");
echo "Игроков за сумрак(dusk): ".mysql_result($sql, 0, 0)."<br>";
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?><br><br>

<?php
$sql = mysql_query("select count(*) from seven_signs where cabal like '%dawn%'");
echo "Игроков за рассвет(dawn): " . mysql_result($sql, 0, 0) . "<br>";
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo "&nbsp<img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">&nbsp&nbsp ".$tfg."%";
?>

</td></tr></table>
<br><b><center>..:: Замки ::..</center></b><br><hr>

<table width="100%; border="1" >
<tr>
<td width="20%">Замок:<br>Aden<br>Goddard<br>Giran<br>Oren<br>Gludio<br>Dion<br>Innadril<br>Rune<br>Schuttgart</td>
<td width="30%">Владелец:<br>
<?php

/********  GIRAN  *************/
$giranOwner = "Нет хозяина";
$giranSiegeDate = " ... ";
$giranTax ="";
/*********  OREN  **************/
$orenOwner = "Нет хозяина";
$orenSiegeDate = " ... ";
$orenTax ="";
/**********  ADEN  **************/
$adenOwner = "Нет хозяина";
$adenSiegeDate = " ... ";
$adenTax ="15%";
/********  Gludio  **************/
$gludioOwner = "Нет хозяина";
$gludioSiegeDate = " ... ";
$gludioTax ="";
/**********  DION  ***************/
$dionOwner = "Нет хозяина";
$dionSiegeDate = " ... ";
$dionTax ="";
/********  INNADRIL  *************/
$innadrilOwner = "Нет хозяина";
$innadrilSiegeDate = " ... ";
$innadrilTax ="";
/********  GODDARD  *************/
$goddardOwner = "Нет хозяина";
$goddardSiegeDate = " ... ";
$goddardTax ="";
/*********************************/
/********  RUNE  *************/
$runeOwner = "Нет хозяина";
$runeSiegeDate = " ... ";
$runeTax ="";
/*********************************/
/********  SCHUTTGART  *************/
$schuttgartOwner = "Нет хозяина";
$schuttgartSiegeDate = " ... ";
$schuttgartTax ="";
/*********************************/
$result = mysql_query("SELECT name,taxPercent,siegeDate FROM castle");
while($row=mysql_fetch_array($result,MYSQL_ASSOC)){
        switch($row['name']){
            case 'Giran':$giranTax=$row['taxPercent'].'%';
                $giranSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
            case 'Oren':$orenTax=$row['taxPercent'].'%';
                $orenSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
            case 'Aden':$adenTax=$row['taxPercent'].'%';
                $adenSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
            case 'Gludio':$gludioTax=$row['taxPercent'].'%';
                $gludioSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
            case 'Dion':$dionTax=$row['taxPercent'].'%';
                $dionSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
            case 'Innadril':$innadrilTax=$row['taxPercent'].'%';
                $innadrilSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
            case 'Goddard':$goddardTax=$row['taxPercent'].'%';
                $goddardSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
            case 'Rune':$runeTax=$row['taxPercent'].'%';
                $runeSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
            case 'Schuttgart':$schuttgartTax=$row['taxPercent'].'%';
                $schuttgartSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;

            }
    }
$sql = mysql_query("SELECT castle.name, clan_data.clan_name FROM castle,clan_data WHERE clan_data.hasCastle=castle.id");
    while($row= mysql_fetch_array($sql,MYSQL_ASSOC)){
        switch($row['name']){
            case 'Giran':$giranOwner=$row['clan_name'];break;
            case 'Oren':$orenOwner=$row['clan_name'];break;
            case 'Aden':$adenOwner=$row['clan_name'];break;
            case 'Gludio':$gludioOwner=$row['clan_name'];break;
            case 'Dion':$dionOwner=$row['clan_name'];break;
            case 'Innadril':$innadrilOwner=$row['clan_name'];break;
            case 'Goddard':$goddardOwner=$row['clan_name'];break;
            case 'Rune':$runeOwner=$row['clan_name'];break;
            case 'Schuttgart':$schuttgartOwner=$row['clan_name'];break;




            }
    }
echo $adenOwner."<br>";
echo $goddardOwner."<br>";
echo $giranOwner."<br>";
echo $orenOwner."<br>";
echo $gludioOwner."<br>";
echo $dionOwner."<br>";
echo $innadrilOwner."<br>";
echo $runeOwner."<br>";
echo $schuttgartOwner."<br>";



?>
</td>
<td width="35%">Дата осады:<br>
<?php
echo $adenSiegeDate."<br>";
echo $goddardSiegeDate."<br>";
echo $giranSiegeDate."<br>";
echo $orenSiegeDate."<br>";
echo $gludioSiegeDate."<br>";
echo $dionSiegeDate."<br>";
echo $innadrilSiegeDate."<br>";
echo $runeSiegeDate."<br>";
echo $schuttgartSiegeDate."<br>";


?>
</td>
<td width="15%">Налог:<br>
<?php
echo $adenTax."<br>";
echo $goddardTax."<br>";
echo $giranTax."<br>";
echo $orenTax."<br>";
echo $gludioTax."<br>";
echo $dionTax."<br>";
echo $innadrilTax."<br>";
echo $runeTax."<br>";
echo $schuttgartTax."<br>";


?>
</td>
</tr>
</table>
<hr>
<?php
}
else
{
echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';
}
?>
[code]

[/code]
<?php
$L2JBS_config["mysql_host"]="сюда данные свои"; // IP адрес MySQL-сервера ["localhost"]
$L2JBS_config["mysql_port"]="3306"; // Порт ["3306"]
$L2JBS_config["mysql_db"]="l2jdb"; // Имя игровой базы ["l2jdb"]
$L2JBS_config["mysql_login"]="сюда данные свои"; // Логин ["root"]
$L2JBS_config["mysql_password"]="сюда данные свои"; // Пароль ["root"]

$link = @mysql_connect($L2JBS_config['mysql_host'].":".$L2JBS_config['mysql_port'], $L2JBS_config['mysql_login'], $L2JBS_config['mysql_password']) or die ('Невозможно создать соеденение с базой ! Проверьте данные необходимые для соеденения с базой MySQL !<br>Impossible create connect with the base! Check given required for connect with base MySQL!<br><br>Возможно сервер сейчас на профилактике, попробуйте зайти позже.<br>Possible server on preventive maintenance presently, try to call at later.');
@mysql_select_db($L2JBS_config['mysql_db'], $link) or die ('Найти базу с таким именем не удалось!');
?>
<?php
$result = mysql_query("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", $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))
{
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["char_name"]. "</td><td class=\"numeric sortedColumn\">".$row["clan_level"]. "</td><td>".$row["hasCastle"]. "</td><td class=\"numeric\">".$row["csum"]. "</td><td class=\"numeric\">".$row["ccount"]. "</td><td class=\"numeric\">".$row["cavg"]. "</td></tr>\n";
}
print "</tbody>\n</table>\n";
mysql_close($link);
?>
</body>
</html>
[code]

<?php include "blocks/stats.php";?>