<?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 (news.php)
|+===================================================+
||
|| # Usage of this page:
|| # News management.
||
|+===================================================*/

include('inc/header.php');
if(min_fuse('housekeeping_news', $my_id)){
	if(isset($_GET['new'])){
		if(isset($_POST['submit'])){
			if(!empty($_POST['comments'])){
				mysql_query("INSERT INTO cms_news (id, date, content) VALUES ('', '".endate(date("F j, Y"))."', '".beveilig($_POST['comments'])."')");
				echo 'Your news has been added';
			}else{
				echo 'Vul nieuws in!';
			}
		}else{
			echo '<form method="post" action="news.php?new">';
			echo 'Date: <input value="'.endate(date("F j, Y")).'" readonly="readonly">';
			echo '<br><br>';
			echo 'News:<br>';
			echo '<textarea name="comments" rows="3" cols="40"></textarea>';
			echo '<br>';
			echo '<input type="submit" name="submit" value="News Added">';
			echo '</form>';
		}
	}elseif(isset($_GET['delete'])){
		if(isset($_GET['id'])){
			$a = mysql_query("SELECT * FROM cms_news WHERE id = '".beveilig($_GET['id'])."'");
			if(mysql_num_rows($a) > 0){
				mysql_query("DELETE FROM cms_news WHERE id = '".beveilig($_GET['id'])."'");
				echo 'News Deleted';
			}
		}else{
			$a = mysql_query("SELECT * FROM cms_news ORDER BY id DESC");
			echo '<table border="1">';
			echo '<tr>';
			echo '<td><b>#</b></td>';
			echo '<td><b>Name</b></td>';
			echo '<td><b>Delete</b></td>';
			echo '</tr>';
			while($b = mysql_fetch_assoc($a)){
				echo '<tr>';
				echo '<td>'.$b['id'].'</td>';
				echo '<td>'.$b['content'].'</td>';
				echo '<td><a href="./news.php?delete=&id='.$b['id'].'" target="_self"><img src="images/delete.gif" border="0"></a></td>';
				echo '</tr>';
			}
			echo '</table>';
		}
	}else{
		echo '<a href="news.php?new">Add News</a>';
		echo '<br>';
		echo '<a href="news.php?delete">Delete News</a>';
	}
}else{
	echo $acc_denied;
}
include('inc/footer.php');
?>