<?
$banned1 = mysql_query("SELECT * FROM `ipbans` ORDER BY `IP` DESC");
      while($banned = mysql_fetch_object($banned1))
{
$user1 = mysql_query("SELECT * FROM `users` WHERE `ban`='1'");
$user = mysql_fetch_object($user1);
if($user->login != ""){
?>
<tr><td><?echo$user->login;?></td><td><?echo$user->IP;?></td><td><?echo$user->banreden;?></td></tr>
<?
}}
?>

<?
$banned1 = mysql_query("SELECT * FROM `ipbans` ORDER BY `IP` DESC");
      while($banned = mysql_fetch_object($banned1))
{
$user1 = mysql_query("SELECT * FROM `users` WHERE `ban`='1' LIMIT 1");
$user = mysql_fetch_object($user1);
if($user->login != ""){
?>
<tr><td><?echo$user->login;?></td><td><?echo$user->IP;?></td><td><?echo$user->banreden;?></td></tr>
<?
}}
?>

<?
if($data->login == $admin || $data->hulpadmin == 1 || $data->admin == 1) { 
?>	


<div id="contentbar_main">
<div id="notice_container"></div>


<div id="cbs"><div class="cb">


<h1>Account verbannen</h1><p></p>








<table width=100%><form method=post>
<tr><td class=listtitle colspan=2>&nbsp;</td></tr>


<?
if(isset($_POST['submit'])) {
$select = mysql_query("SELECT id FROM `users` WHERE `login`='$_POST[login]'");
$aantal = mysql_num_rows($select);
if($_POST['login'] == "") {
echo "<tr><td class=list2 colspan=2>Je moet een gebruikersnaam opgeven</td></tr>";
} else if($aantal == "0") {
echo "<tr><td class=list2 colspan=2>Deze gebruikersnaam bestaat niet</td></tr>";
} else {
if($_POST['straf'] == "2") {
mysql_query("UPDATE `users` SET `ban`='1', `ban2`='$_POST[reden]', `ban3`='$_POST[vrij]' WHERE `login`='$_POST[login]'");
mysql_query("INSERT INTO ipbans(ip) VALUES('$user2->IP')");
mysql_query("UPDATE `users` SET `ban`='1' WHERE `login`='$_POST[login]'");
mysql_query("UPDATE `users` SET `banreden`='{$_POST['reden']}' WHERE `login`='$_POST[login]'");




mysql_query("UPDATE `users` SET `strafpunten`='3' WHERE `login`='$_POST[login]'");
echo "<tr><td class=list colspan=2>Dit account is nu verbannen</td></tr>";
} else {
echo "<tr><td class=list colspan=2>undefined</td></tr>";
}
}
}
?>


<tr><td class=list width=125>Slachtoffer:</td>
<td class=list><input class="mod_submit" type=text name=login></td></tr>
<tr><td class=list>Straf:</td>
<td class=list><select class="mod_submit" name=straf>
<option value=2>Bannen</option>
</select></td></tr>
<tr><td class=list width=125>Wanneer "vrij":</td>
<td class=list><input type=text class="mod_submit" name=vrij value=12-24-2010></td></tr>
<tr><td class=list width=125>Reden:</td>
<td class=list><input type=text class="mod_submit" name=reden></td></tr>
<tr><td class=listtitle align=left colspan=2><input class="mod_submit" type=submit name=submit value=Uitvoeren class=boton><br /><br /></td></tr></form>








<tr>
<td><b>Naam</b></td>
<td><b>IP</b></td>
<td><b>Reden</b></td>
</tr>


<?
$banned1 = mysql_query("SELECT * FROM `ipbans` ORDER BY `IP` DESC");
      while($banned = mysql_fetch_object($banned1))
{
$user1 = mysql_query("SELECT * FROM `users` WHERE `ban`='1' LIMIT 1");
$user = mysql_fetch_object($user1);
if($user->login != ""){
?>
<tr><td><?echo$user->login;?></td><td><?echo$user->IP;?></td><td><?echo$user->banreden;?></td></tr>
<?
}}
?>










<? 
}?></table></table>