<?php
/*===================================================+
|| # Woodpecker Housekeeping
|+====================================================+
|| # Copyright © 2008 SuperFun. All rights reserved.
|| # http://www.superfunn.nl/
|+===================================================+
|| # Notice: This is free software.
|+===================================================+
|| # Versions.
|| # Housekeeping version: V3.5
|| # Version of this file: V1.1 (accesbans.php)
|+===================================================+
||
|| # Usage of this page:
|| # Management of bans and the blacklist
||
|+===================================================*/

include('inc/header.php');
if($_GET['do'] == "ban"){
	if(min_fuse('fuse_ban', $my_id)){
		if($_GET['delete']){
		$aa = mysql_query("SELECT * FROM moderation_bans WHERE userid = '".beveilig($_GET['delete'])."'");
		$bb = mysql_num_rows($aa);
			if($bb < 1){
			echo 'Deze ban bestaat niet!';
			}else{
			mysql_query("DELETE FROM moderation_bans WHERE userid = '".beveilig($_GET['delete'])."'");
			logboek("heeft een ban verwijderd(userid ".$_GET['delete'], "lol");
			echo 'De ban is verwijderd!';
			}
		}else{
		$a = mysql_query("SELECT * FROM moderation_bans ORDER by applied_by");
		echo '<table border="1">';
		echo '<tr>';
		echo '<td><b>User Banned</b></td>';
		echo '<td><b>IP</b></td>';
		echo '<td><b>MachineID</b></td>';
		echo '<td><b>Banned on</b></td>';
		echo '<td><b>Banned by</b></td>';
		echo '<td><b>Expires</b></td>';
		echo '<td><b>Remove Ban</b></td>';
		if(min_fuse('fuse_superban', $my_id)){
		echo '<td><b>Remove ban</b></td>';
		}
		echo '</tr>';
		while($b = mysql_fetch_assoc($a)){
			echo '<tr>';
			echo '<td>'.gebruiker($b['userid']).'</td>';
			echo '<td>'.$b['ip'].'</td>';
			echo '<td>'.$b['machineid'].'</td>';
			echo '<td>'.$b['applied_at'].'</td>';
			echo '<td>'.gebruiker($b['applied_by']).'</td>';
			echo '<td>'.$b['expires'].'</td>';
			echo '<td>'.$b['reason'].'</td>';
			if(min_fuse('fuse_superban', $my_id)){
				echo '<td><a href="./accesbans.php?do=ban&delete='.$b['userid'].'" target="_self"><img src="./images/delete.gif" border="0"></a></td>';
			}
			echo '</tr>';
		}
		echo '</table>';
		}
	}else{
		echo $acc_denied;
	}
}elseif($_GET['do'] == "blacklist"){
	if(min_fuse('housekeeping_blacklist', $my_id)){
		if($_GET['delete']){
			if(min_fuse('housekeeping_blacklist', $my_id)){
			$aad = mysql_query("SELECT * FROM connections_blacklist WHERE ip = '".beveilig($_GET['delete'])."'");
				if(mysql_num_rows($aad) < 1){
					echo 'The IP does not exist';
				}else{
				mysql_query("DELETE FROM connections_blacklist WHERE ip = '".beveilig($_GET['delete'])."' LIMIT 1");
				logboek("heeft een ip uit blacklist verwijderd (".$_GET['delete'].")", "lol");
				echo 'De IP: '.$_GET['delete'].' is verwijderd uit de blacklist';
				}
			}else{
				echo $acc_denied;
			}
		}elseif($_POST['submit']){
		$aad = mysql_query("SELECT * FROM connections_blacklist WHERE ip = '".beveilig($_POST['ip'])."'");
			if(empty($_POST['ip'])){
				echo 'Leeg IP veld?';
			}elseif(mysql_num_rows($aad) > 0){
				echo 'Dit IP is al op de blacklist';
			}else{
				mysql_query("INSERT INTO connections_blacklist (ip, added) VALUES('".beveilig($_POST['ip'])."', NOW())");
				logboek("heeft een IP toegevoegd op de blacklist (".$_POST['ip'].")", "lol");
				echo 'De IP: '.$_POST['ip'].' is toegevoegd op de blacklist.';
			}
		}else{
			$a = mysql_query("SELECT * FROM connections_blacklist ORDER by added");
			echo '<a href="./accesbans.php?do=addblacklist" target="_self">Add IP to blacklist</a><br><br>';
			echo '<table border="1">';
			echo '<tr>';
			echo '<td><b>IP</b></td>';
			echo '<td><b>Added</b></td>';
			echo '<td><b>Remove</b></td>';
			echo '</tr>';
			while($b = mysql_fetch_assoc($a)){
				echo '<tr>';
				echo '<td>'.$b['ip'].'</td>';
				echo '<td>'.$b['added'].'</td>';
				echo '<td><a href="./accesbans.php?do=blacklist&delete='.$b['ip'].'" target="_self"><img src="./images/delete.gif" border="0"></a></td>';
				echo '</tr>';
			}
			echo '</table>';
		}
	}else{
		echo $acc_denied;
	}
}elseif($_GET['do'] == "addblacklist"){
	if(min_fuse('housekeeping_blacklist', $my_id)){
		echo '<form method="post" action="./accesbans.php?do=blacklist">';
		echo 'IP: <input type="text" name="ip"><br>';
		echo '<input type="submit" name="submit" value="Add to list">';
		echo '</form>';
	}else{
		echo $acc_denied;
	}
}else{
	echo $acc_denied;
}
include('inc/footer.php');
?>