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