<?
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=#2641A1 size=2><center><b></b></center></font>
<br></br>
<table id="mutable" class="alt5" height=10 border="1" bordercolor="666666" cellpadding="0" cellspacing="1" width=450>
<tr>
<td align=left><font color=#2641A1><b><center>ID</center></b></font></td>
<td align=left><font color=#2641A1><b><center>Име</center></b></font></td>
<td align=left><font color=#2641A1><b><center>Дата</center></b></font></td>
<td align=left><font color=#2641A1><b><center>Банат за</center></b></font></td>
<td align=left><font color=#2641A1><b><center>Време</center></b></font></td>
<td align=left><font color=green><b><center>Причина</center></b></font></td>
<td align=left><font color=#2641A1><b><center>Банат от</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><font color=#666666><b><center>$nr</center></b></td>
<td align=left><font color=#666666><center>$row[0]</center></b></td>
<td align=left><font color=#666666><center>$row1[1]</center></b></td>
<td align=left><font color=#666666><center>$row1[4] Days</center></b></td>
<td align=left><font color=#666666><center>$re[0] Hours</center></b></td>
<td align=left><font color=#666666><center>$row1[3]</center></b></td>
<td align=left><font color=#666666><center>$row1[7]</center></b></td>
</tr>
";
}
?>
</table>
:
