<?
$host = "127.0.0.1";	    		// Adresse oder IP des Servers
$user = 'ROOT'; 				// MySQL User
$pass = 'PASS';				// MySQL Passwort
$RealmDatabase = 'REALM';		// Realmlist Datenbankname

$connection = mysql_connect($host, $user, $pass) or die ("Can't connect with $host");
mysql_select_db($RealmDatabase, $connection);
$sql = "SELECT id,bannedby,banreason,bandate,active FROM account_banned WHERE active=1 ORDER BY bandate";
$result = mysql_query($sql, $connection);
$maxbanned_count = mysql_query($sql);
$maxbanned = mysql_num_rows($maxbanned_count);

echo "<br><center>Gesamt verbannte Accounts: ". $maxbanned ."<br><br>";

echo "<center><table border=1><tr>
	<th>Account</th>
	<th>Gebannt von</th>
	<th>Bangrund</th>
	<th>Gebannt am</th></tr>";
	
while ($vystup = mysql_fetch_array($result))
{
$sql = "SELECT id,username FROM account WHERE id='".$vystup['id']."'";
$query = mysql_query($sql);
$fetch = mysql_fetch_assoc($query);
echo "<tr>";
echo "<td align='center'><b>".$fetch["username"]."</td>";
echo "<td align='center'>".$vystup["bannedby"]."</td>";
echo "<td align='center'>".$vystup["banreason"]."</td>";
echo "<td align='center'>".date("d.M.Y",$vystup["bandate"])."</td>";
echo "</tr>";
} 
mysql_close($connection);
echo "</table></center>";
?>