<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>Сайт WoW GAME ин dager</title>
<style type="text/css">
<!--
#Layer1 {
position:absolute;
left:1px;
top:0px;
width:1032px;
height:272px;
z-index:1;
}
#Layer2 {
position:absolute;
left:245px;
top:309px;
width:720px;
height:122px;
z-index:2;
}
#Layer3 {
position:absolute;
left:8px;
top:301px;
width:208px;
height:145px;
z-index:3;
}
#Layer4 {
position:absolute;
left:970px;
top:309px;
width:98px;
height:14px;
z-index:4;
}
#Layer5 {
position:absolute;
left:245px;
top:757px;
width:727px;
height:29px;
z-index:5;
}
#Layer6 {
position:absolute;
left:244px;
top:309px;
width:721px;
height:74px;
z-index:6;
}
#Layer7 {
position:absolute;
left:7px;
top:730px;
width:233px;
height:76px;
z-index:7;
}
#Layer8 {
position:absolute;
left:969px;
top:733px;
width:222px;
height:82px;
z-index:8;
}
#Layer9 {
position:absolute;
left:44px;
top:704px;
width:72px;
height:47px;
z-index:9;
}
#Layer10 {
position:absolute;
left:17px;
top:742px;
width:206px;
height:79px;
z-index:10;
}
#Layer11 {
position:absolute;
left:1003px;
top:715px;
width:180px;
height:35px;
z-index:10;
}
#Layer12 {
position:absolute;
left:224px;
top:736px;
width:34px;
height:82px;
z-index:11;
}
#Layer13 {
position:absolute;
left:6px;
top:275px;
width:43px;
height:23px;
z-index:12;
}
#Layer14 {
position:absolute;
left:226px;
top:563px;
width:33px;
height:114px;
z-index:13;
}
#Layer15 {
position:absolute;
left:52px;
top:271px;
width:35px;
height:26px;
z-index:14;
}
#Layer16 {
position:absolute;
left:952px;
top:569px;
width:25px;
height:106px;
z-index:15;
}
#Layer17 {
position:absolute;
left:1000px;
top:746px;
width:181px;
height:72px;
z-index:15;
}
#Layer18 {
position:absolute;
left:71px;
top:764px;
width:91px;
height:34px;
z-index:9;
}
#Layer19 {
position:absolute;
left:284px;
top:277px;
width:356px;
height:16px;
z-index:10;
}
#Layer20 {
position:absolute;
left:46px;
top:329px;
width:160px;
height:30px;
z-index:10;
}
#Layer21 {
position:absolute;
left:46px;
top:375px;
width:160px;
height:30px;
z-index:11;
}
#Layer22 {
position:absolute;
left:46px;
top:421px;
width:160px;
height:29px;
z-index:12;
}
#Layer23 {
position:absolute;
left:46px;
top:469px;
width:160px;
height:31px;
z-index:13;
}
#Layer24 {
position:absolute;
left:46px;
top:517px;
width:159px;
height:23px;
z-index:14;
}
#Layer25 {
position:absolute;
left:44px;
top:563px;
width:161px;
height:30px;
z-index:15;
}
#Layer26 {
position:absolute;
left:44px;
top:610px;
width:162px;
height:29px;
z-index:16;
}
#Layer27 {
position:absolute;
left:991px;
top:337px;
width:179px;
height:24px;
z-index:17;
}
#Layer28 {
position:absolute;
left:403px;
top:334px;
width:376px;
height:26px;
z-index:18;
}
.стиль1 {color: #FF0000}
#Layer29 {
position:absolute;
left:259px;
top:383px;
width:684px;
height:148px;
z-index:19;
}
#Layer30 {
position:absolute;
left:261px;
top:390px;
width:46px;
height:26px;
z-index:19;
}
#Layer31 {
position:absolute;
left:277px;
top:389px;
width:626px;
height:167px;
z-index:20;
}
#Layer32 {
position:absolute;
left:282px;
top:566px;
width:619px;
height:30px;
z-index:21;
}
#Layer33 {
position:absolute;
left:275px;
top:611px;
width:626px;
height:184px;
z-index:22;
}
-->
</style>
</head>
<body>
<div id="Layer1"></div>
<div id="Layer2"><img src="img/new_1.png" width="718" height="466" /></div>
<div id="Layer3"><img src="img/blok_1.png" /></div>
<div id="Layer4"><img src="img/blok_1.png" /></div>
<div id="Layer5"><img src="img/niz_1.png" width="718" height="63" /></div>
<div id="Layer6"><img src="img/verx_1.png" width="717" height="62" /></div>
<div id="Layer7"><img src="img/wow_game.jpg" /></div>
<div id="Layer8"><img src="img/wow_pro.jpg" /></div>
<div id="Layer18"><a href="http://www.wow-game.ru"><img src="img/knopki/wow_game.gif" border="0" /></a></div>
<div id="Layer20"><a href="index.php"><img src="img/knopki/glav2.png" width="160" height="30" border="0" /></a></div>
<div id="Layer21"><a href="reg.php"><img src="img/knopki/reg2.png" border="0" /></a></div>
<div id="Layer22"><a href="forum.php"><img src="img/knopki/forum2.png" border="0" /></a></div>
<div id="Layer23"><a href="new.php"><img src="img/knopki/new2.png" border="0" /></a></div>
<div id="Layer24"><a href="onlain.php"><img src="img/knopki/onlin2.png" border="0" /></a></div>
<div id="Layer25"><a href="banlist.php"><img src="img/knopki/ban2.png" border="0" /></a></div>
<div id="Layer26"><img src="img/knopki/lk2.png" /></div>
<div id="Layer27"><?
$fp = @fsockopen ("$ip","$gameport",$errno,$errstr,1);
if ($fp)
echo '<span style="color:green">Статус сервера:</span> <img src="img/races/on2.gif" alt="Online" /> ';
else
echo '<span style="color:red">Статус сервера:</span> <img src="img/races/off.gif" alt="Offline" /> ';
?></div>
<div class="стиль1" id="Layer28">
<div align="center">Бан по IP </div>
</div>
<div id="Layer31"><?php
// Скрипт показа забанненных аккаунтов и IP адресов by WoW-Ultimate
require_once "config.php";
//подключение к базе
$ConnectDB = mysql_connect("$host", "$user", "$password") or die ("Нет соединения с MySQL");
mysql_select_db("$dbr") or die ("Нет соединения с базой $dbr");
echo "<h2>Забаненные аккаунты</h2>";
echo "<table width=\"100%\" border=\"1\" align=\"center\"><tr>
<td align=\"center\" width=\"20%\">забанен:</td>
<td align=\"center\" width=\"20%\">Бан установлен:</td>
<td align=\"center\" width=\"20%\">Забанил:</td>
<td align=\"center\" width=\"20%\">Причина:</td>
<td align=\"center\" width=\"20%\">Бан до:</td>
</tr></table>";
$i=0;
$data = mysql_query("SELECT * FROM account_banned WHERE active = 1 ORDER BY bandate DESC LIMIT 100",$ConnectDB);
$row = mysql_fetch_array($data[$i]); {
while($row = mysql_fetch_array($data)) {
$banid = $row['id'];
$usern = mysql_query("SELECT * FROM account WHERE id= $banid LIMIT 1",$ConnectDB);
$rowuser = mysql_fetch_array($usern);
$banuser = $rowuser['username'];
$bandate = date("H:i:s d.m.Y", $row['bandate']);
$bannedby = $row['bannedby'];
$banreason = $row['banreason'];
$unbandate = date("H:i:s d.m.Y", $row['unbandate']);
echo "<font color=\"beer\">
<table width=\"100%\" border=\"1\" align=\"center\"><tr>
<td align=\"center\" width=\"20%\">$banuser</td>
<td align=\"center\" width=\"20%\">$bandate г.</td>
<td align=\"center\" width=\"20%\">$bannedby</td>
<td align=\"center\" width=\"20%\">$banreason</td>
<td align=\"center\" width=\"20%\">$unbandate г.</td>
</tr></table></font>";
$i++;
}
}
//теперь выборка по IP адресам
echo "<h2>БАНЫ по IP </h2><br>";
echo "<table width=\"100%\" border=\"1\" align=\"center\"><tr>
<td align=\"center\" width=\"20%\">IP:</td>
<td align=\"center\" width=\"20%\">Бан установлен:</td>
<td align=\"center\" width=\"20%\">Забанил:</td>
<td align=\"center\" width=\"20%\">Причина:</td>
<td align=\"center\" width=\"20%\">Бан до:</td>
</tr></table>";
$u=0;
$bannedip = mysql_query("SELECT * FROM ip_banned ORDER BY bandate DESC LIMIT 100");
$row = mysql_fetch_array($bannedip[$u]); {
while($row = mysql_fetch_array($bannedip)) {
$banip = $row['ip'];
$bandate = date("H:i:s d.m.Y", $row['bandate']);
$bannedby = $row['bannedby'];
$banreason = $row['banreason'];
$unbandate = date("H:i:s d.m.Y", $row['unbandate']);
echo "<font color=\"beer\">
<table width=\"100%\"border=\"1\" align=\"center\"><tr>
<td align=\"center\" width=\"20%\">$banip</td>
<td align=\"center\" width=\"20%\">$bandate г.</td>
<td align=\"center\" width=\"20%\">$bannedby</td>
<td align=\"center\" width=\"20%\">$banreason</td>
<td align=\"center\" width=\"20%\">$unbandate г.</td>
</tr></table></font>";
$u++;
}
}
?></div>
<div id="Layer32">
<div align="center" class="стиль1">Бан по аккаунту</div>
</div>
<div id="Layer33"><?php
// You Should Write here your MySQL Server information !
echo "<center><table border=1><tr><th><font color=#00FFFF>№ Аккаунта:</font></th><th><font color=#00FFFF>Логин Аккаунта:</th><th><font color=#00FFFF>Причина:</font></th><th><font color=#00FFFF>Начало Бана</font></th><th><font color=#00FFFF>Конец Бана</font></th></tr>";
$connection = mysql_connect($host, $user, $password) or die ("Can't connect with $host");
mysql_select_db($realmdb, $connection);
$sqle = "SELECT `id`,`banreason`, `bandate`, `unbandate` FROM `account_banned`";
$sql = "SELECT `ab`.*, `a`.`username` FROM `account_banned` as `ab` "
."LEFT JOIN `account` as `a` ON `a`.`id` = `ab`.`id`;";
$result = mysql_query($sql, $connection);
while ($vystup = mysql_fetch_array($result))
{
echo "<tr><td align=\"center\">".$vystup["id"]."</td>";
echo "<td align=\"center\">".$vystup["username"]."</td>";
echo "<td align=\"center\">".$vystup["banreason"]."</td>";
echo "<td align=\"center\">".date("d.m.Y H:m",$vystup["bandate"])."</td>";
echo "<td align=\"center\">".date("d.m.Y H:m",$vystup["unbandate"])."</td>";
echo "</tr>";
}
mysql_close($connection);
echo "</table></center>";
?></div>
</body>
</html>
Legion
