вообще-то надо учить php и sql запросы, но я сегодня что-то добрый, вот лови:
Code
<center><I><B><SPAN style="color:red">Ip баны</SPAN></B></I><center>
<meta http-equiv="Content-Type" content="text/html; charset= ansi" />
<?php
// You Should Write here your MySQL Server information !
$host = 'localhost'; // Host adress
$user = 'trinity'; //Username
$password = 'trinity'; //Password
$realmdb = 'realmd'; // the name of realmd database
echo "<center><table border=1><tr><th>IP:</th><th>Причина</th><th>Бан дал</th><th>Дата Бана</th><th>Дата Разбана</th></tr>";
$connection = mysql_connect($host, $user, $password) or die ("Can't connect with $host");
mysql_select_db($realmdb, $connection);
$sql = "SELECT `ip`,`banreason`, `bannedby`, `bandate`, `unbandate` FROM `ip_banned`";
$result = mysql_query($sql, $connection);
while ($vystup = mysql_fetch_array($result))
{
echo "<tr><td align=\"center\">".$vystup["ip"]."</td>";
echo "<td align=\"center\">".$vystup["banreason"]."</td>";
echo "<td align=\"center\">".$vystup["bannedby"]."</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>";
?>
<br>
<br>
<center><I><B><SPAN style="color:red">Аккаунт баны</SPAN></B></I><center>
<?php
// You Should Write here your MySQL Server information !
echo "<center><table border=1><tr><th>acc ID:</th><th>Аккаунт:</th><th>Причина:</th><th>Бан дал</th><th>Дата Бана</th><th>Дата Разбана</th></tr>";
$connection = mysql_connect($host, $user, $password) or die ("Can't connect with $host");
mysql_select_db($realmdb, $connection);
$sqle = "SELECT `id`,`banreason`, `bannedby`, `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\">".$vystup["bannedby"]."</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>";
?>
Автор Impas. Можешь переделать сам!!!