[Help] Banlist+Acc+IP

значи няма проблеми с общи усилия го направихме как то си му е реда :)
 
Nice One Ban List. Can somebody give me code and for GameMasters Link? because my muweb 0.9 php code not work. somebody help?
 
айде който може да добави и Reason много ми трябва :(


PHP:
<?
		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>

Работи с Админ панела на @Damain
 
PHP:
<?
		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>

Работи с Админ панела на @Damain

10x много бро :)