<?
require("config.php");
$time=time();
$run=mssql_query("update dbo.desban set bantime='$time'");
$query=mssql_query("select name,bantime,unbantime from desban");
while($row = mssql_fetch_row($query)) {
if($row[1]>=$row[2]){
$run1=mssql_query("delete from dbo.desban where name='$row[0]'");
$run2=mssql_query("update dbo.character set ctlcode='0' where name='$row[0]'");
$run3=mssql_query("delete from dbo.warnings where name='$row[0]'");
}
}
?>
<?
require("config.php");
$query = "Select Name,Class,cLevel,resets,MapNumber,AccountID,strength,dexterity,vitality,energy,PKcount from Character where ctlcode ='1' order by resets desc ,clevel desc";
$result = mssql_query($query);
echo '<br><font color=black size=2><center><b>Banned Players</b></center></font>
<br></br>
<table id="mutable" class="alt5" height=30 border="0" bordercolor="black" cellpadding="0" cellspacing="1" width=550>
<tr>
<td align=left bgcolor=#2192e6><font color=black><b><center>ID</center></b></font></td>
<td align=left bgcolor=#2192e6><font color=black><b><center>Name</center></b></font></td>
<td align=left bgcolor=#2192e6><font color=black><b><center>Reason</center></b></font></td>
</tr>';
$ban=mssql_query("select Name from character where ctlcode='1'");
for($i=0;$i<mssql_num_rows($ban);++$i){
$row=mssql_fetch_row($ban);
$row1=mssql_fetch_row(mssql_query("select Name,vbantime,vunbantime,reason,bdays,bantime,unbantime,who from desban where name='$row[0]'"));
$nr=$i+1;
$rem=$row1[6]-$row1[5];
$ren=($rem/60/60);
$re=explode('.',$ren,'2');
echo "<tr>
<td align=left bgcolor=#2192e6><font color=black><b><center>$nr</center></b></td>
<td align=left bgcolor=#2192e6><font color=black><center>$row[0]</center></b></td>
<td align=left bgcolor=#2192e6><font color=black><center>$row1[3]</center></b></td>
</tr>
";
}
?>
</table>