<center><I><B><SPAN style="color:red">Аккаунт баны</SPAN></B></I><center>
<?php

$host = 'localhost'; // Host adress
$user = 'trinity'; //Username
$password = 'trinity'; //Password
$realmdb = 'auth'; // the name of realmd database

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>";
?><br> <br>

<center><I><B><SPAN style="color:red">Ip баны</SPAN></B></I><center>
<meta http-equiv="Content-Type" content="text/html; charset= ansi" />

<?php

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>";
?>