Moy-web 2.2 Под L2rebellion
Так решыл выложыть модули для L2Rebellion под Moy-Web 2.2.
Все написаные коды заменнять на радные. Для того что, бы ишло вместе с Л2рб
Castle:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms5)==1) {
#######################
# Configuration #
#######################
$noneed=1;
include("../../config/config.php");
if (Isset($_GET['server']))
{
include("../../config/config_".$serb[$_GET['server']].".php");}
else
{ include("../../config/config_".$serb[1].".php");}
$serverName=$htitle;
$databaseHost=$L2JBS_config["mysql_host"];
$databaseName=$L2JBS_config["mysql_db"];
$databaseLogin=$L2JBS_config["mysql_login"];
$databasePassword=$L2JBS_config["mysql_password"];
// Print top of page
/******** GIRAN *************/
$giranOwner = "Нет хозяина";
$giranSiegeDate = " ... ";
$giranTax ="";
/********* OREN **************/
$orenOwner = "Нет хозяина";
$orenSiegeDate = " ... ";
$orenTax ="";
/********** ADEN **************/
$adenOwner = "Нет хозяина";
$adenSiegeDate = " ... ";
$adenTax ="";
/******** 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 castle.name, clan_data.clan_name FROM castle,clan_data WHERE clan_data.hasCastle=castle.id");
while($row= mysql_fetch_array($result,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;
}
}
$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;
}
}
?>
<table cellpadding=0 cellspacing=0 width="100%" align=center>
<?php /******************************* Aden ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Aden Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/aden.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $adenSiegeDate;?><td><?php print$adenOwner;?><td><?php print$adenTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='5' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='5' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Dion ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Dion Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/dion.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $dionSiegeDate;?><td><?php print$dionOwner;?><td><?php print$dionTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='2' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='2' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Giran ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Giran Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/giran.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $giranSiegeDate;?><td><?php print$giranOwner;?><td><?php print$giranTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='3' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='3' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Gludio ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Gludio Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/gludio.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $gludioSiegeDate;?><td><?php print$gludioOwner;?><td><?php print$gludioTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='1' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='1' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/?>
<?php /******************************* Goddard ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Goddard Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/goddard.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $goddardSiegeDate;?><td><?php print$goddardOwner;?><td><?php print$goddardTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='7' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='7' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/?>
<?php /******************************* Innadril ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Innadril Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/innadril.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $innadrilSiegeDate;?><td><?php print$innadrilOwner;?><td><?php print$innadrilTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='6' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='6' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/?>
<?php /******************************* Oren ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Oren Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/oren.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $orenSiegeDate;?><td><?php print$orenOwner;?><td><?php print$orenTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='4' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='4' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Rune ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Rune Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/rune.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $runeSiegeDate;?><td><?php print$runeOwner;?><td><?php print$runeTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='8' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='8' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Schuttgart ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="95%" align=center>
<Tr align=center><td colspan=2><p class=zag>Schuttgart Castle<br><br>
<tr valign=top><td width=200><img src="module/castle/schuttgart.jpg"><td>
<table cellpadding=0 cellspacing=7 width=95% border=0 align=center>
<tr class=date><td>Дата осады<td>Хозяин замка<td>Налог
<tr class=text><td><?php print $SchuttgartSiegeDate;?><td><?php print$schuttgartOwner;?><td><?php print$SchuttgartTax;?>
<tr class=text><td colspan=2><br>
<tr class=date><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr class=text><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='9' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='9' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table></td></tr>';
/********************************************************************************
*/
?></table>
<?php
}
else
{
echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';
}
?>
clantop:
<?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>';}?>
darc_elf:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms19)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0 AND T.RaceId = 2
ORDER BY S.level DESC LIMIT $top", $link) or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ темных эльфов ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
elf:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms18)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0 AND T.RaceId = 1
ORDER BY S.level DESC LIMIT $top", $link) or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ эльфов ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
gm:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms9)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT * FROM characters WHERE $where AND accesslevel>50 LIMIT $top") or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Список ГМов ::..</b></center><br><hr>';
echo "<center><table><thead><tr><th>№ |</th><th>Лицо |</th><th><center>Ник |</center></th><th>Статус |</th><th>";
if (($ms29)==1) { echo 'Написать ГМу'; }
echo "</th><tr></thead>\n";
//Выводим содержимое таблицы
$result2 = mysql_query("SELECT clan_id,clan_name FROM clan_data", $link)
or die ("Error: ".mysql_error());
while ($row2=mysql_fetch_row($result2))
$clans_array[$row2[0]]=$row2[1];
$clans_array[0]="";
$n=1;
while ($top=mysql_fetch_array($data))
{
if ($top['sex']==0) { $name=''.$top[char_name].'</font>'; } else { $name='<font color=#FF8080>'.$top[char_name].'</font>'; }
$class=mysql_fetch_array(mysql_query("select ClassName from char_templates where ClassId=$top[classid]"));
if (($top['sex']==0) && ($top['race']==4)) { $img='./module/face/dwarf_male.gif'; }
if (($top['sex']==1) && ($top['race']==4)) { $img='./module/face/dwarf_female.gif'; }
if (($top['sex']==0) && ($top['race']==2)) { $img='./module/face/darkelf_male.gif'; }
if (($top['sex']==1) && ($top['race']==2)) { $img='./module/face/darkelf_female.gif'; }
if (($top['sex']==0) && ($top['race']==0)) { $img='./module/face/human_male.gif'; }
if (($top['sex']==1) && ($top['race']==0)) { $img='./module/face/human_female.gif'; }
if (($top['sex']==0) && ($top['race']==1)) { $img='./module/face/elf_male.gif'; }
if (($top['sex']==1) && ($top['race']==1)) { $img='./module/face/elf_female.gif'; }
if (($top['sex']==0) && ($top['race']==3)) { $img='./module/face/orc_male.gif'; }
if (($top['sex']==1) && ($top['race']==3)) { $img='./module/face/orc_female.gif'; }
if ($top['online']==1) {$online='<font color=green>Online</font>'; }
else {$online='<font color=red>Offline</font>'; }
echo "<tr><td><b><center>$n</center></b></td><td><img src='$img'></td><td> $name</td><td>$online</td><td>";
if (($ms29)==1) { echo '<a href=index.php?id=msg>Cообщение</a>'; }
echo " </td></tr>\n";
$n++;
}
//Закрываем таблицу
echo '</table>';
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?></center>
gnom:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms21)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0 AND T.RaceId = 4
ORDER BY S.level DESC LIMIT $top", $link) or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ гномов ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
human:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms17)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0 AND T.RaceId = 0
ORDER BY S.level DESC LIMIT $top", $link) or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ людей ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
Kam:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms30)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0 AND T.RaceId = 5
ORDER BY S.level DESC LIMIT $top", $link) or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ орков ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
online:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");if (($ms2)==1) {
//Получаем данные из базы
$data=mysql_query ("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0
AND C.online = 1
ORDER BY S.exp DESC" )
or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Сейчас в игре ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
orc:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms20)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0 AND T.RaceId = 3
ORDER BY S.level DESC LIMIT $top", $link) or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ орков ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
rich:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");if (($ms10)==1) {
$sql = mysql_query("SELECT obj_Id, char_name, accesslevel, IFNULL(c_w,0) AS weapon, IFNULL(c_ar,0) AS armor, IFNULL(c_e,0) AS etcitem, IFNULL(c_ad,0) AS adena, IFNULL(c_w,0)+IFNULL(c_ar,0)+IFNULL(c_e,0)+IFNULL(c_ad,0) AS summary FROM characters LEFT JOIN (SELECT owner_id,SUM(count*price) AS c_w FROM items,weapon WHERE items.item_id=weapon.item_id GROUP BY owner_id) AS t_w ON characters.obj_Id=t_w.owner_id LEFT JOIN (SELECT owner_id,SUM(count*price) AS c_ar FROM items,armor WHERE items.item_id=armor.item_id GROUP BY owner_id) AS t_ar ON characters.obj_Id=t_ar.owner_id LEFT JOIN (SELECT owner_id,SUM(count*price) AS c_e FROM items,etcitem WHERE items.item_id != 57 AND items.item_id=etcitem.item_id GROUP BY owner_id) AS t_e ON characters.obj_Id=t_e.owner_id LEFT JOIN (SELECT owner_id,SUM(count) AS c_ad FROM items WHERE items.item_id=57 GROUP BY owner_id) AS t_ad ON characters.obj_Id=t_ad.owner_id WHERE accesslevel=0 ORDER BY summary DESC LIMIT $top");
print '
<br><b><center>..:: Богатейшие игроки ::..</center></b><br><hr>
<table>
<thead>
<tr >
<th>№</th>
<th>Имя</th>
<th>Оружие</th>
<th>Броня</th>
<th>Вещи</th>
<th>Адена</th>
<th class="sortedColumn">Итого</th>
</tr>
</thead>
<tbody id="TblBdy">
';
$i=1;
while ($row = @mysql_fetch_array($sql))
{
print ' <tr><td width="4%">'.$i.'</td><td width="30%">' .$row["char_name"]. '</td><td class="numeric" width="14%">' .$row["weapon"]. '</td><td class="numeric" width="14%">' .$row["armor"]. '</td><td class="numeric" width="14%">'.$row["etcitem"]. '</td><td class="numeric" width="14%">'.$row["adena"]. '</td><td class="numeric sortedColumn" width="30%">'.$row["summary"]. '</td></tr>
';
$i++;
}
print "</tbody>\n</table>\n";
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
ss:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms6)==1) { ?>
<br><br>
<table>
<?php
$dawn=0;
$dusk=0;
$query_chars = "select * from seven_signs where cabal like '%dusk%' limit 0,1200;";
$link = mysql_query($query_chars);
while ( $row=mysql_fetch_row($link) )
{
$dawn++;
}
$query_chars = "select * from seven_signs where cabal like '%dawn%' limit 0,1200;";
$link = mysql_query($query_chars);
while ( $row=mysql_fetch_row($link) )
{
$dusk++;
}
$query_status = "select * from seven_signs_status";
$link = mysql_query($query_status);
$row=mysql_fetch_row($link);
$current_cycle = $row[1];
$festivall_cycle = $row[2];
$active_period = $row[3];
$date = $row[4];
$avarice = $row[13]+$row[16];
$gnosis = $row[14]+$row[17];
$strife = $row[15]+$row[18];
?>
<title>Server Signs Status</title>
<script language=javascript>
var nthDay = <?php echo $date-1 ?>;
var currTime = 'we are at work ...';
var ssStatus = <?php echo $current_cycle ?>;
var dawnPoint = <?php echo $dawn ?>;
var twilPoint = <?php echo $dusk ?>;
var maxPointWidth = 300;
var seal1 = <?php echo $avarice ?>;
var seal2 = <?php echo $gnosis ?>;
var seal3 = <?php echo $strife ?>;
var seal4 = 0;
var seal5 = 0;
var seal6 = 0;
var seal7 = 1;
</SCRIPT>
<TABLE style="MARGIN-TOP:0px; width:500px;" cellSpacing=0 cellPadding=0 border=0 align=center>
<TBODY>
<TR vAlign=top>
<TD style="BACKGROUND: url(/module/ss/ssqViewBg.jpg)" height=225><TABLE>
<TBODY>
<TR vAlign=top>
<TD><TABLE style="MARGIN: 18px 0px 0px 54px" cellSpacing=0 cellPadding=0 border=0 width=141>
<TBODY>
<TR align=middle height=26>
<TD style="BACKGROUND: url(/module/ss/ssqViewimg1.gif); COLOR:#fff; font-size:11px;"><!-- Subject selection + number of day Start -->
<script language=javascript>
if (0 == ssStatus) {
document.write('Подготовка');
}
else if (1 == ssStatus) {
document.write('Соревнование <b style="color:#E10000"> День ' + nthDay + '</b>');
}
else if (2 == ssStatus) {
document.write('вычисление');
}
else if (3 == ssStatus) {
document.write('Действие печати <b style="color:#E10000"> День ' + nthDay + '</b>');
}
//-->
</SCRIPT>
<!-- Subject selection + number of day E n d -->
</TD>
</TR>
</TBODY>
</TABLE>
<TABLE style="MARGIN: 3px 0px 0px 10px"
cellSpacing=0 cellPadding=0 width=141 border=0>
<TBODY>
<TR>
<TD></TD>
<TD><IMG height=16 src="/module/ss/timeBox1.jpg" width=140 border=0></TD>
<TD></TD>
</TR>
<TR>
<TD vAlign=bottom rowSpan=2><IMG height=125 src="/module/ss/timeBox2.jpg" width=45 border=0></TD>
<TD><!-- Clock Image Start
--><script language=javascript>
var timeImage;
var tempImageNum;
if (1 == ssStatus) {
tempImageNum = nthDay;
}
else if (0 == ssStatus) {
tempImageNum = 0;
}
else if (3 == ssStatus || 2 == ssStatus) {
tempImageNum = nthDay + 7; <!-- Adding one week to show img with seal effect -->
}
timeImage = 'time'+tempImageNum+'.jpg';
document.write('<img src="/module/ss/time/'+ timeImage +'" width="140" height="139" border="0">');
</SCRIPT><!--
Clock Image E n d --></TD>
<TD vAlign=bottom rowSpan=2><IMG height=125 src="/module/ss/timeBox3.jpg" width=66 border=0></TD>
</TR>
<TR>
<TD><IMG height=12 src="/module/ss/timeBox4.jpg" width=140 border=0></TD>
</TR>
</TBODY>
</TABLE></TD>
<TD><TABLE style="MARGIN: 27px 0px 0px 22px" cellSpacing=0 cellPadding=0 width=200 border=0>
<TBODY>
<TR align=middle bgColor=#606d6f height=17>
<TD style="COLOR:#fff; font-size:11px;"><!-- Current Time start - Not Real Time but the time of query -->
<?php
$timezone = 3; //(GMT -5:00) EST (U.S. & Canada)
echo gmdate("Y/m/j H:i:s", time() + 3600*($timezone+date("I")));
?>
<!-- Current Time E n d -->
</TD>
</TR>
</TBODY>
</TABLE>
<TABLE style="MARGIN: 21px 0px 0px 22px" cellSpacing=0 cellPadding=0 border=0>
<COLGROUP>
<COL width=74>
<COL width=*>
<TBODY>
<TR>
<TD style="font-size:11px; color:#000;"><IMG style="MARGIN: 0px 6px 5px 0px" height=1 src="/ssq/ssq_image/dot.gif" width=1 border=0>Dawn</TD>
<TD style="COLOR: #000; font-size:11px;"><!-- Twilight Bar Graph Start -->
<script language=javascript>
var twilPointWidth = maxPointWidth * twilPoint / 100;
document.write('<img src="/module/ss/ssqbar2.gif" width="' + twilPointWidth + '" height="9" border="0"> ' + twilPoint);
</SCRIPT>
<!-- Twilight Bar Graph E n d -->
</TD>
</TR>
<TR>
<TD colSpan=2 height=7></TD>
</TR>
<TR>
<TD style="font-size:11px; color:#000;"><IMG style="MARGIN: 0px 6px 5px 0px" height=1 src="/ssq/ssq_image/dot.gif" width=1 border=0>Dusk</TD>
<TD style="COLOR: #000; font-size:11px;"><!-- Dawn Bar Graph Start -->
<script language=javascript>
var dawnPointWidth = maxPointWidth * dawnPoint / 100;
document.write('<img src="/module/ss/ssqbar1.gif" width="' + dawnPointWidth + '" height="9" border="0"> ' + dawnPoint);
</SCRIPT>
<!-- Dawn Bar Graph E n d -->
</TD>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR vAlign=bottom align=middle height=95>
<TD><!-- It not 3 then seal must be shown as grey.Seal Status 0 = closed, 1 or 2 = opened -->
<!-- Seal #1 -->
<script language=javascript>
if (3 == ssStatus) {
if (0 == seal1)
document.write('<img src="/module/ss/Seals/SOA/bongin1close.gif" width="85" height="86" border="0">');
else
document.write('<img src="/module/ss/Seals/SOA/bongin1open.gif" width="85" height="86" border="0">');
} else {
document.write('<img src="/module/ss/Seals/SOA/bongin1.gif" width="85" height="86" border="0">');
}
</SCRIPT>
</TD>
<TD><!-- Seal #2 -->
<script language=javascript>
if (3 == ssStatus) {
if (0 == seal2)
document.write('<img src="/module/ss/Seals/SOG/bongin2close.gif" width="85" height="86" border="0">');
else
document.write('<img src="/module/ss/Seals/SOG/bongin2open.gif" width="85" height="86" border="0">');
} else {
document.write('<img src="/module/ss/Seals/SOG/bongin2.gif" width="85" height="86" border="0">');
}
</SCRIPT>
</TD>
<TD><!-- Seal #3 -->
<script language=javascript>
if (3 == ssStatus) {
if (0 == seal3)
document.write('<img src="/module/ss/Seals/SOS/bongin3close.gif" width="85" height="86" border="0">');
else
document.write('<img src="/module/ss/Seals/SOS/bongin3open.gif" width="85" height="86" border="0">');
} else {
document.write('<img src="/module/ss/Seals/SOS/bongin3.gif" width="85" height="86" border="0">');
}
</SCRIPT>
</TD>
</TR>
<TR>
<TD colSpan=3><div align="center" style="margin-left:10px;"><IMG height=16 src="/module/ss/bonginName.gif" width=258 border=0> </div></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE>
<?php } else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}?>
stat:
<?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 " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$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 " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$tfg."%";
?>
</td><td valign="top">
<b>Процентное соотношение расс:</b><br>
<table><tr><td><left>
Люди:
</left><br>
Эльфы:
<br>
Тёмные эльфы:
<br>
Орки:
<br>
Гномы:
<br>
Камаэли:
</td><td width="50%">
<?php
$sql = mysql_query("SELECT COUNT(S.char_obj_id ) FROM character_subclasses AS S INNER JOIN char_templates AS T ON (S.class_id = T.ClassId) WHERE S.isBase = 1 AND T.RaceId = 0");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$tfg."%";
?><br>
<?php
$sql = mysql_query("SELECT COUNT(S.char_obj_id ) FROM character_subclasses AS S INNER JOIN char_templates AS T ON (S.class_id = T.ClassId) WHERE S.isBase = 1 AND T.RaceId = 1");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$tfg."%";
?><br>
<?php
$sql = mysql_query("SELECT COUNT(S.char_obj_id ) FROM character_subclasses AS S INNER JOIN char_templates AS T ON (S.class_id = T.ClassId) WHERE S.isBase = 1 AND T.RaceId = 2");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$tfg."%";
?><br>
<?php
$sql = mysql_query("SELECT COUNT(S.char_obj_id ) FROM character_subclasses AS S INNER JOIN char_templates AS T ON (S.class_id = T.ClassId) WHERE S.isBase = 1 AND T.RaceId = 3");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$tfg."%";
?><br>
<?php
$sql = mysql_query("SELECT COUNT(S.char_obj_id ) FROM character_subclasses AS S INNER JOIN char_templates AS T ON (S.class_id = T.ClassId) WHERE S.isBase = 1 AND T.RaceId = 4");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$tfg."%";
?><br>
<?php
$sql = mysql_query("SELECT COUNT(S.char_obj_id ) FROM character_subclasses AS S INNER JOIN char_templates AS T ON (S.class_id = T.ClassId) WHERE S.isBase = 1 AND T.RaceId = 5");
$tfg = round(mysql_result($sql, 0, 0)/($charnum/100));
echo " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$tfg."%";
?>
</td></tr></table>
</td><td valign="top">
<b>Семь печатей:</b><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 " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$tfg."%";
?><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 " <img src=\"module/stat/sexline.jpg\" height=\"10px\" width=\"".$tfg."px\">   ".$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 ="";
/******** 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>';
}
?>
table:
<?php
//Создаем начало таблицы
echo "<table><thead><tr><th>№</th><th>Лицо</th><th><center>Ник</center></th><th>";
if (($ms22)==1) { echo 'уровень'; }
echo "</th><th> <center>";
if (($ms23)==1) { echo 'Профессия'; }
echo "</center></th><th><center>";
if (($ms24)==1) { echo 'Клан'; }
echo " </center></th><th>";
if (($ms25)==1) { echo 'PvP/'; }
if (($ms26)==1) { echo 'PK'; }
echo "</th><th><center>";
if (($ms27)==1) { echo 'Время в игре'; }
echo "</center></th><th>";
if (($ms28)==1) { echo 'Статус'; }
echo "</th><tr></thead>\n";
//Выводим содержимое таблицы
$n=1;
while ($top=mysql_fetch_array($data))
{
if(!isset($char["{$top["char_name"]}"]))
{
$onlinetimeH=round(($top[onlinetime]/60/60)-0.5);
$onlinetimeM=round(((($top[onlinetime]/60/60)-$onlinetimeH)*60)-0.5);
if ($top[clan_name]=='') { $top[clan_name]="Не в клане"; }
if ($top['sex']==0) { $name='<font color=#8080FF>'.$top[char_name].'</font>'; } else { $name='<font color=#FF8080>'.$top[char_name].'</font>'; }
if (($top['sex']==0) && ($top['race']==4)) { $img='./module/face/dwarf_male.gif'; }
if (($top['sex']==1) && ($top['race']==4)) { $img='./module/face/dwarf_female.gif'; }
if (($top['sex']==0) && ($top['race']==2)) { $img='./module/face/darkelf_male.gif'; }
if (($top['sex']==1) && ($top['race']==2)) { $img='./module/face/darkelf_female.gif'; }
if (($top['sex']==0) && ($top['race']==0)) { $img='./module/face/human_male.gif'; }
if (($top['sex']==1) && ($top['race']==0)) { $img='./module/face/human_female.gif'; }
if (($top['sex']==0) && ($top['race']==1)) { $img='./module/face/elf_male.gif'; }
if (($top['sex']==1) && ($top['race']==1)) { $img='./module/face/elf_female.gif'; }
if (($top['sex']==0) && ($top['race']==3)) { $img='./module/face/orc_male.gif'; }
if (($top['sex']==1) && ($top['race']==3)) { $img='./module/face/orc_female.gif'; }
if (($top['sex']==0) && ($top['race']==5)) { $img='./module/face/kam_male.gif'; }
if (($top['sex']==1) && ($top['race']==5)) { $img='./module/face/kam_female.gif'; }
if ($top['online']==1) {$online='<font color=green>Online</font>'; }
else {$online='<font color=red>Offline</font>'; }
echo "<tr><td><b><center>$n</center></b></td><td><img src='$img'></td><td> $name</td><td><center>";
if (($ms22)==1) { echo "$top[level]"; }
echo "</center></td><td><center>";
if (($ms23)==1) { echo "$top[classname]"; }
echo "</center></td><td><center><a href=index.php?id=clantop>";
if (($ms24)==1) { echo "$top[clan_name]"; }
echo "</a></center></td><td><center><b>";
if (($ms25)==1) { echo "$top[pvpkills]"; }
echo "</b>/<b><font color=red>";
if (($ms26)==1) { echo "$top[pkkills]"; }
echo "</font></b></center></td><td><center>";
if (($ms27)==1) { echo "$onlinetimeH часов $onlinetimeM мин."; }
echo "</center></td><td>";
if (($ms28)==1) { echo "$online"; }
echo "</td></tr>\n"; $n++;
}
}
//Закрываем таблицу
echo '</table>';
?>
top100:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms16)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0
ORDER BY S.level DESC LIMIT $top") or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ игроков ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
TOP_HP:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");if (($ms14)==1) {
mysql_connect($L2JBS_config["mysql_host"],$L2JBS_config["mysql_login"],$L2JBS_config["mysql_password"]) or die('Не удалось подключится к MySQL серверу. Проверьте настройки.');
mysql_select_db($L2JBS_config["mysql_db"]) or dir('Не удалось выбрать базу данных. Проверьте настойки.');
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0
ORDER BY S.maxHP DESC LIMIT $top") or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ ХП ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
TOP_MP:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms15)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0
ORDER BY S.maxMP DESC LIMIT $top") or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ МП ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
TOP_PK:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms12)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0
AND C.pkkills > 0
ORDER BY C.pkkills DESC LIMIT $top") or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ ПК ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
TOP_PVP:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms11)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0
AND C.pvpkills > 0
ORDER BY C.pvpkills DESC LIMIT $top") or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ ПвП ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
TOP_TIME:
<?php
if(empty($mw))
{
header ("Location: ..");
exit;
}
include("module/stat-menu.php");
if (($ms13)==1) {
//Получаем данные из базы
$data=mysql_query("SELECT C.obj_id AS char_id,C.char_name,C.sex,S.class_id,P.clan_name,C.clanid AS clan_id, C.pvpkills,C.pkkills,C.onlinetime,C.online,T.classname AS classname, S.level
FROM characters AS C
INNER JOIN character_subclasses AS S ON (S.char_obj_id = C.obj_id AND S.isBase = 1)
LEFT OUTER JOIN clan_data AS P ON(P.clan_id = C.clanid)
INNER JOIN char_templates AS T ON(T.classid = S.class_id)
WHERE C.accesslevel = 0
ORDER BY C.onlinetime DESC LIMIT $top") or die('Не удалось получить данные из базы.');
//Заголовок
echo '<br><center><b>..:: Топ время в игре ::..</b></center><br><hr>';
include("module/table.php");
} else {echo '<center><font color=red size=4><b>Этот модуль отключен администратором !!!</b></font></center>';}
?>
Ето ещо не все 
заслужил спс :) хотя хз нормально ли оно работает :)
У мення работает! +1 Сразу говорю.
Moy-Web and L2Dream smile.gif
+полностью рабочая статистика
+исправленая дыра sheash.php
+установлен CuteNews v1.4.6.
http://www.filefactory.com/file/6754ba/n/Web_rar
Felixx: Moy-Web and L2Dream smile.gif
+полностью рабочая статистика
+исправленая дыра sheash.php
+установлен CuteNews v1.4.6.
http://www.filefactory.com/file/6754ba/n/Web_rar
Sorry, this file is no longer available. It may have been deleted by the uploader, or has expired.
поправь ссылочку