event.php

<?php
	require "lib/common.php";

	$meta['noindex'] = true;
	
	$_GET['id'] 	= filter_int($_GET['id']);
	$_GET['action'] = filter_string($_GET['action']);

	if (!$loguser['id']) {
		errorpage("You are not logged in.",'login.php', 'log in (then try again)');
	}
	if ($banned) {
		errorpage("You are banned and cannot create or edit events.",'calendar.php', 'return to the calendar');
	}
	//if (!$_GET['id']) {
	//	errorpage("No event ID specified.",'calendar.php', 'return to the calendar');
	//}

	// Editing an event?
	if ($_GET['id']) {
		$event     = $sql->fetchq("SELECT * FROM events WHERE id = {$_GET['id']}");
		if (!$event) {
			errorpage("Event ID #{$_GET['id']} doesn't exist.",'calendar.php', 'return to the calendar');
		}
		if (!$isadmin && $event['user'] != $loguser['id']) {
			errorpage("This isn't your event.",'calendar.php', 'return to the calendar');
		}
	} else {
		$date = getdate(time());
		$event = array('title'=>'','text'=>'','private'=>'','m'=>$date['mon'],'d'=>$date['mday'],'y'=>$date['year']);
	}
	
	
	if ($_GET['action'] == "delete") {
		if (!$_GET['id']) {
			errorpage("No event selected for deletion.",'calendar.php', 'return to the calendar',0);
		}
		
		if (confirmed($msgkey = 'del-event')) {
			$sql->query("DELETE FROM events WHERE id = {$_GET['id']}");
			errorpage("Thank you, ".htmlspecialchars($loguser['name']).", for deleting the event.","calendar.php","return to the calendar",0);
		}
		
		$title     = "Delete event";
		$message   = "Are you sure you want to <b>DELETE</b> this event?";
		$form_link = "event.php?action=delete&id={$_GET['id']}";
		$buttons       = array(
			[BTN_SUBMIT, "Delete event"],
			[BTN_URL   , "Cancel", "calendar.php?event={$_GET['id']}"]
		);
		confirm_message($msgkey, $message, $title, $form_link, $buttons);
	}
	
	
		
	if (isset($_POST['submit'])) {
		
		check_token($_POST['auth']);
		
		$title 		= filter_string($_POST['title'], true);
		$message	= filter_string($_POST['message'], true);
		$private	= filter_int($_POST['private']);
		$m = filter_int($_POST['m']);
		$d = filter_int($_POST['d']);
		$y = filter_int($_POST['y']);
		
		if (!$title) 				errorpage("The title of the event cannot be blank.",'calendar.php', 'return to the calendar');
		if (!$message) 				errorpage("The message of the event cannot be blank.",'calendar.php', 'return to the calendar');
		if (!checkdate($m,$d,$y))	errorpage("The date you have selected is invalid.",'calendar.php', 'return to the calendar');
		
		$values = array (
			'title'		=> $title,
			'text'		=> $message,
			'private'	=> $private,
			'm' => $m,
			'd' => $d,
			'y' => $y,
		);
		if (!$_GET['id']) 
			$q = "INSERT INTO events SET d=:d,m=:m,y=:y,title=:title,text=:text,private=:private,user={$loguser['id']}";
		else 
			$q = "UPDATE events SET d=:d,m=:m,y=:y,title=:title,text=:text,private=:private WHERE id = {$_GET['id']}";
		
		$sql->queryp($q, $values);

		if (!$_GET['id']) {
			$_GET['id'] = $sql->insert_id();
		}
		return header("Location: calendar.php?event={$_GET['id']}");
	} else {
		
		pageheader();
		?>
	<form method="POST" action="event.php?action=edit&id=<?=$_GET['id']?>">
	<table class="table">
		<tr><td class="tdbgh center" colspan=2><b><?=(!$_GET['id'] ? "New Event" : "Editing Event #{$_GET['id']}")?></b></td></tr>
		<tr>
			<td class='tdbg1 center b'>Event title:</td>
			<td class='tdbg2'><input type="text" name="title" size=80 maxlength=200 value="<?=htmlspecialchars($event['title'])?>"></td>
		</tr>
		<tr>
			<td class='tdbg1 center b'>Message:</td>
			<td class='tdbg2'><textarea name="message" rows="6"><?=htmlspecialchars($event['text'])?></textarea></td>
		</tr>
		<tr>
			<td class='tdbg1 center b'>Event date:</td>
			<td class='tdbg2'>
				<input type="text" name="m" value="<?=$event['m']?>" size=1 maxlength=2 style='text-align: right'>- 
				<input type="text" name="d" value="<?=$event['d']?>" size=1 maxlength=2 style='text-align: right'>- 
				<input type="text" name="y" value="<?=$event['y']?>" size=3 maxlength=4 style='text-align: right'>
				<span class="fonts">(mm/dd/yyyy)</span>
			</td>
		</tr>
		<tr>
			<td class='tdbg1 center'>&nbsp;</td>
			<td class='tdbg2'>
				<?= auth_tag() ?>
				<input type='submit' name=submit VALUE="Edit event">
			</td>
		</tr>		
		<tr>
			<td class='tdbg1 center b'>Options:</td>
			<td class='tdbg2'>
				<input type='checkbox' name="private" id="private" value="1" <?=($event['private'] ? "checked" : "")?>><label for="private">Private</label>
			</td>
		</tr>
		
	</table>
	</form>
		<?php
	}
	
	pagefooter();

?>