<?php

class Page
{
	public $url_name;
	public $status;
	public $title;
	public $body;
	public $style;
}

function savepage($page)
{
	if ($page->url_name)
		return updatepage($page);
	else
		return insertpage($page);
}

function insertpage($page)
{
	if ( !$page->url_name ) return false;
	global $dbConnection;

	$sql = 'INSERT INTO static_page (url_name, status, title, body, style) VALUES (:slug, :status, :title, :body, :style)';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue('slug',   $page->url_name);
	$stmt->bindValue('status', $page->status);
	$stmt->bindValue('title',  trim($page->title));
	$stmt->bindValue('body',   trim($page->body));
	$stmt->bindValue('style',  trim($page->style));

	adminlog("Page '" . $page->url_name . "' has been added.", MTS_PAGE, MTA_ADD);
	return $stmt->execute();
}

function updatepage($page)
{
	if ( !$page->url_name ) return false;
	global $dbConnection;

	$sql = 'UPDATE static_page SET url_name = :slug, status = :status, title = :title, body = :body, style = :style WHERE url_name = :slug';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue('slug',   $page->url_name);
	$stmt->bindValue('status', $page->status);
	$stmt->bindValue('title',  trim($page->title));
	$stmt->bindValue('body',   trim($page->body));
	$stmt->bindValue('style',  trim($page->style));

	adminlog("Page '" . $page->url_name . "' has been updated.", MTS_PAGE, MTA_MODIFY);
	return $stmt->execute();
}

function deletepage($url_name)
{
	if ( !$url_name ) return false;
	global $dbConnection;

	$sql = 'DELETE FROM static_page WHERE url_name = :slug';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue('slug', $url_name);

	adminlog("Page '" . $page->url_name . "' has been deleted.", MTS_PAGE, MTA_DELETE);
	return $stmt->execute();
}

function getpage($url_name)
{
	if ( !$url_name ) return false;
	global $dbConnection;

	$sql = 'SELECT url_name, status, title, body, style FROM static_page WHERE url_name = :slug';
	$stmt = $dbConnection->prepare($sql);

	$stmt->bindValue('slug', $url_name);

	$stmt->execute();
	return $stmt->fetch();
}

?>