|
|
<?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();
|
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
