<?
$host="";
$username="";
$password="";
$database="";

mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM bans order by UNBAN ASC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>
<center><style type="text/css">
            table.fancy {
              margin: 1em 1em 1em 0;
              background: whitesmoke;
              border-collapse: collapse;
            }
            table.fancy tr:hover {
               background: lightsteelblue !important;
            }
            table.fancy th, table.fancy td {
              border: 1px silver solid;
              padding: 0.2em;
            }
            table.fancy th {
              background: gainsboro;
              text-align: left;
            }
            table.fancy caption {
              margin-left: inherit;
              margin-right: inherit;
            }
</style>
<table class="fancy"><center>
<tr>
            <th width="20%"><center>Banned User</center></th>
            <th width="15%"><center>SteamID</center></th>
            <th width="20%"><center>Unbanned</center></th>
            <th width="15%"><center>Banner</center></th>
            <th width="25%"><center>Reason</center></th>
</tr></center>

<?
$i=0;
while ($i < $num) {

$ID=mysql_result($result,$i,"ID");
$NAME=mysql_result($result,$i,"NAME");
$UNBAN=mysql_result($result,$i,"UNBAN");
$BANNER=mysql_result($result,$i,"BANNER");
$REASON=mysql_result($result,$i,"REASON");
?>

<tr>
                        <td><font face="Arial, Helvetica, sans-serif"><center><? echo $NAME; ?></center></font></td>
                        <td><font face="Arial, Helvetica, sans-serif"><center><? echo $ID; ?></center></font></td>
                        <td><font face="Arial, Helvetica, sans-serif"><center><?
                            $my_t=getdate(date("$UNBAN"));
                        if ( $UNBAN == 0 ){
                            echo "<font color=\"red\">Permanent</font>";
                        }
                        else{
                            echo "$my_t[weekday], $my_t[month] $my_t[mday], $my_t[year]";
                        } ?></center></td>
                        <td><font face="Arial, Helvetica, sans-serif"><center><? echo $BANNER; ?></center></font></td>
                        <td><font face="Arial, Helvetica, sans-serif"><center><? echo $REASON; ?></center></font></td>
</tr>

</center>

<?
$i++;
}


echo "</table>";
?>