|
|
<?php
|
|
|
|
|
|
class Page {
|
|
|
var $url_name, $status, $title, $body, $style;
|
|
|
}
|
|
|
|
|
|
function savepage($page) {
|
|
|
if($page->url_name)
|
|
|
return updatepage($page);
|
|
|
else
|
|
|
return insertpage($page);
|
|
|
}
|
|
|
|
|
|
function insertpage($page) {
|
|
|
global $mtdb;
|
|
|
$sql = 'INSERT INTO static_page ( url_name, status, title, body, style ) VALUES ('
|
|
|
. ' "' . mysqli_real_escape_string($mtdb->link, $page->url_name)
|
|
|
. '", "' . mysqli_real_escape_string($mtdb->link, $page->status)
|
|
|
. '", "' . mysqli_real_escape_string( $mtdb->link, trim( $page->title ) )
|
|
|
. '", "' . mysqli_real_escape_string( $mtdb->link, trim( $page->body ) )
|
|
|
. '", "' . mysqli_real_escape_string( $mtdb->link, trim( $page->style ) )
|
|
|
. '")';
|
|
|
adminlog("Page '".$page->url_name."' has been added.", MTS_PAGE, MTA_ADD);
|
|
|
return $mtdb->query($sql);
|
|
|
}
|
|
|
|
|
|
function updatepage($page) {
|
|
|
if ( !$page->url_name ) return false;
|
|
|
global $mtdb;
|
|
|
|
|
|
$sql = 'UPDATE static_page SET url_name = "' . mysqli_real_escape_string($mtdb->link, $page->url_name)
|
|
|
. '", status = "' . mysqli_real_escape_string($mtdb->link, $page->status)
|
|
|
. '", title = "' . mysqli_real_escape_string( $mtdb->link, trim( $page->title ) )
|
|
|
. '", body = "' . mysqli_real_escape_string( $mtdb->link, trim( $page->body ) )
|
|
|
. '", style = "' . mysqli_real_escape_string( $mtdb->link, trim( $page->style ) )
|
|
|
. '" WHERE url_name = "' . mysqli_real_escape_string($mtdb->link, $page->url_name) . '"';
|
|
|
adminlog("Page '".$page->url_name."' has been updated.", MTS_PAGE, MTA_MODIFY);
|
|
|
return $mtdb->query( $sql );
|
|
|
}
|
|
|
|
|
|
function deletepage($url_name) {
|
|
|
if ( !$url_name ) return false;
|
|
|
global $mtdb;
|
|
|
adminlog("Page '".$page->url_name."' has been deleted.", MTS_PAGE, MTA_DELETE);
|
|
|
return $mtdb->query( 'DELETE FROM static_page WHERE url_name = "' . mysqli_real_escape_string($mtdb->link, $url_name) . '"' );
|
|
|
}
|
|
|
|
|
|
function getpage($url_name) {
|
|
|
global $mtdb;
|
|
|
return $mtdb->getRow( 'SELECT url_name, status, title, body, style FROM static_page WHERE url_name = "'. mysqli_real_escape_string($mtdb->link, $url_name) . '"' );
|
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
