add('name', STATICPAGE_TITLE);
$propbag->add('description', STATICPAGE_TITLE_BLAHBLAH);
$propbag->add('website', 'http://board.s9y.org');
$propbag->add('event_hooks', array(
'backend_category_addNew' => true,
'backend_category_update' => true,
'backend_category_delete' => true,
'backend_category_showForm' => true,
'backend_sidebar_entries_event_display_staticpages' => true,
'backend_sidebar_entries' => true,
'entries_header' => true,
'entries_footer' => true,
'external_plugin' => true,
'entry_display' => true,
'genpage' => true,
'css_backend' => true,
'frontend_fetchentries' => true,
'backend_media_rename' => true,
'frontend_fetchentries' => true,
'frontend_rss' => true,
'frontend_header' => true
));
$propbag->add('page_configuration', $this->config);
$propbag->add('type_configuration', $this->config_types);
$propbag->add('author', 'Marco Rinck, Garvin Hicking, David Rolston, Falk Doering, Stephan Manske, Pascal Uhlmann, Ian, Don Chambers');
$propbag->add('version', '4.01');
$propbag->add('requirements', array(
'serendipity' => '1.3',
'smarty' => '2.6.7',
'php' => '4.1.0'
));
$propbag->add('stackable', false);
$propbag->add('groups', array('BACKEND_EDITOR', 'BACKEND_FEATURES'));
$propbag->add('configuration', array(
'markup',
'articleformat',
'show_childpages',
'pass',
'is_startpage',
'is_404_page',
'shownavi',
'show_breadcrumb',
'showonnavi',
'showtextorheadline',
'showmeta',
'use_quicksearch'
));
$this->cachefile = $serendipity['serendipityPath'] . PATH_SMARTY_COMPILE . '/staticpage_pagelist.dat';
}
function introspect_config_item($name, &$propbag)
{
global $serendipity;
switch ($name) {
case 'use_quicksearch':
$propbag->add('type', 'boolean');
$propbag->add('name', QUICKSEARCH);
$propbag->add('description', STATICPAGE_QUICKSEARCH_DESC);
$propbag->add('default', true);
break;
case 'shownavi':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWNAVI_DEFAULT);
$propbag->add('description', STATICPAGE_DEFAULT_DESC);
$propbag->add('default', '1');
break;
case 'showonnavi':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWONNAVI_DEFAULT);
$propbag->add('description', STATICPAGE_DEFAULT_DESC);
$propbag->add('default', '1');
break;
case 'showmeta':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWMETA_DEFAULT);
$propbag->add('description', STATICPAGE_DEFAULT_DESC);
$propbag->add('default', '1');
break;
case 'show_breadcrumb':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOW_BREADCRUMB_DEFAULT);
$propbag->add('description', STATICPAGE_DEFAULT_DESC);
$propbag->add('default', '1');
break;
case 'markup':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWMARKUP_DEFAULT);
$propbag->add('description', STATICPAGE_DEFAULT_DESC);
$propbag->add('default', '1');
break;
case 'articleformat':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWARTICLEFORMAT_DEFAULT);
$propbag->add('description', STATICPAGE_DEFAULT_DESC);
$propbag->add('default', '1');
break;
case 'show_childpages':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWCHILDPAGES_DEFAULT);
$propbag->add('description', STATICPAGE_DEFAULT_DESC);
$propbag->add('default', '1');
break;
case 'showtextorheadline':
$propbag->add('type', 'radio');
$propbag->add('name', STATICPAGE_SHOWTEXTORHEADLINE_NAME);
$propbag->add('description', '');
$propbag->add('radio', array(
'value' => array('true', 'false'),
'desc' => array(STATICPAGE_SHOWTEXTORHEADLINE_TEXT, STATICPAGE_SHOWTEXTORHEADLINE_HEADLINE)
));
$propbag->add('default', 'false');
break;
default:
return false;
}
return true;
}
function introspect_item($name, &$propbag)
{
global $serendipity;
switch ($name) {
case 'headline':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGE_HEADLINE);
$propbag->add('description', STATICPAGE_HEADLINE_BLAHBLAH);
$propbag->add('default', '');
break;
case 'filename':
$propbag->add('type', 'hidden');
$propbag->add('name', STATICPAGE_FILENAME_NAME);
$propbag->add('description', STATICPAGE_FILENAME_DESC);
$propbag->add('default', 'plugin_staticpage.tpl');
break;
case 'title_element':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGES_CUSTOM_META_TITLE);
$propbag->add('description', STATICPAGES_CUSTOM_META_TITLE_BLAH_BLAH);
$propbag->add('default', '');
break;
case 'meta_description':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGES_CUSTOM_META_DESC);
$propbag->add('description', STATICPAGES_CUSTOM_META_DESC_BLAH_BLAH);
$propbag->add('default', '');
break;
case 'meta_keywords':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGES_CUSTOM_META_KEYS);
$propbag->add('description', STATICPAGES_CUSTOM_META_KEYS_BLAH_BLAH);
$propbag->add('default', '');
break;
case 'content':
$propbag->add('type', 'html');
$propbag->add('name', CONTENT);
$propbag->add('description', CONTENT_BLAHBLAH);
$propbag->add('default', '');
break;
case 'permalink':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGE_PERMALINK);
$propbag->add('description', STATICPAGE_PERMALINK_BLAHBLAH);
$propbag->add('default', $serendipity['rewrite'] != 'none'
? $serendipity['serendipityHTTPPath'] . 'pages/pagetitle.html'
: $serendipity['serendipityHTTPPath'] . $serendipity['indexFile'] . '?/pages/pagetitle.html');
break;
case 'pagetitle':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGE_PAGETITLE);
$propbag->add('description', '');
$propbag->add('default', 'pagetitle');
break;
case 'timestamp':
$propbag->add('type', 'timestamp');
$propbag->add('name', DATE);
$propbag->add('description', GENERAL_PLUGIN_DATEFORMAT . ': ' . DATE_FORMAT_SHORT);
$propbag->add('default', '');
break;
case 'pass':
$propbag->add('type', 'string');
$propbag->add('name', PASSWORD);
$propbag->add('description', STATICPAGE_PASSWORD_NOTICE);
$propbag->add('default', '');
break;
case 'markup':
$propbag->add('type', 'boolean');
$propbag->add('name', DO_MARKUP);
$propbag->add('description', DO_MARKUP_DESCRIPTION);
$propbag->add('default', $this->get_config('markup', true));
break;
case 'articleformat':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_ARTICLEFORMAT);
$propbag->add('description', STATICPAGE_ARTICLEFORMAT_BLAHBLAH);
$propbag->add('default', $this->get_config('articleformat', true));
break;
case 'articleformattitle':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGE_ARTICLEFORMAT_PAGETITLE);
$propbag->add('description', STATICPAGE_ARTICLEFORMAT_PAGETITLE_BLAHBLAH);
$propbag->add('default', $serendipity['blogTitle'] . ' :: ' . $this->pagetitle);
break;
case 'parent_id':
$propbag->add('type', 'select');
$propbag->add('name', STATICPAGE_PARENTPAGES_NAME);
$propbag->add('description', STATICPAGE_PARENTPAGE_DESC);
$propbag->add('select_values', $this->selectPages());
$propbag->add('default', STATICPAGE_PARENTPAGE_PARENT);
break;
case 'authorid':
$propbag->add('type', 'select');
$propbag->add('name', STATICPAGE_AUTHORS_NAME);
$propbag->add('description', STATICPAGE_AUTHORS_DESC);
$propbag->add('select_values', $this->selectAuthors());
$propbag->add('default', $serendipity['authorid']);
break;
case 'show_childpages':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWCHILDPAGES_NAME);
$propbag->add('description', STATICPAGE_SHOWCHILDPAGES_DESC);
$propbag->add('default', $this->get_config('show_childpages','false'));
break;
case 'pre_content':
$propbag->add('type', 'html');
$propbag->add('name', STATICPAGE_PRECONTENT_NAME);
$propbag->add('description', STATICPAGE_PRECONTENT_DESC);
$propbag->add('default', '');
break;
case 'is_startpage':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_IS_STARTPAGE);
$propbag->add('description', STATICPAGE_IS_STARTPAGE_DESC);
$propbag->add('default', 'false');
break;
case 'is_404_page':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_IS_404_PAGE);
$propbag->add('description', STATICPAGE_IS_404_PAGE_DESC);
$propbag->add('default', 'false');
break;
case 'articletype':
$propbag->add('type', 'select');
$propbag->add('name', STATICPAGE_ARTICLETYPE);
$propbag->add('description', STATICPAGE_ARTICLETYPE_DESC);
$propbag->add('select_values', $this->selectPageTypes());
$propbag->add('default', $serendipity['POST']['articletype']);
break;
case 'shownavi':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWNAVI);
$propbag->add('description', STATICPAGE_SHOWNAVI_DESC);
$propbag->add('default', $this->get_config('shownavi'));
break;
case 'showonnavi':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOWONNAVI);
$propbag->add('description', STATICPAGE_SHOWONNAVI_DESC);
$propbag->add('default', $this->get_config('showonnavi'));
break;
case 'show_breadcrumb':
$propbag->add('type', 'boolean');
$propbag->add('name', STATICPAGE_SHOW_BREADCRUMB);
$propbag->add('description', STATICPAGE_SHOW_BREADCRUMB_DESC);
$propbag->add('default', $this->get_config('show_breadcrumb'));
break;
case 'publishstatus':
$propbag->add('type', 'select');
$propbag->add('name', STATICPAGE_PUBLISHSTATUS);
$propbag->add('description', STATICPAGE_PUBLISHSTATUS_DESC);
$propbag->add('select_values', array(DRAFT, PUBLISH));
$propbag->add('default', '');
break;
case 'language':
$propbag->add('type', 'select');
$propbag->add('name', INSTALL_LANG);
$propbag->add('description', STATICPAGE_LANGUAGE_DESC);
$propbag->add('select_values', $this->getLanguages());
$propbag->add('default', $serendipity['lang']);
break;
case 'related_category_id':
$propbag->add('type', 'select');
$propbag->add('name', STATICPAGE_RELATED_CATEGORY);
$propbag->add('description', STATICPAGE_RELATED_CATEGORY_DESCRIPTION);
$propbag->add('select_values', $this->getRelatedCategories());
$propbag->add('default', '');
break;
default:
return false;
}
return true;
}
function introspect_item_type($name, &$propbag)
{
global $serendipity;
switch ($name) {
case 'description':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGE_ARTICLETYPE_DESCRIPTION);
$propbag->add('description', STATICPAGE_ARTICLETYPE_DESCRIPTION_DESC);
$propbag->add('default', '');
break;
case 'template':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGE_ARTICLETYPE_TEMPLATE);
$propbag->add('description', STATICPAGE_ARTICLETYPE_TEMPLATE_DESC);
$propbag->add('default', '');
break;
case 'image':
$propbag->add('type', 'string');
$propbag->add('name', STATICPAGE_ARTICLETYPE_IMAGE);
$propbag->add('description', STATICPAGE_ARTICLETYPE_IMAGE_DESC);
$propbag->add('default', '');
break;
default:
return false;
}
return true;
}
/**
*
* get the realname form all authors
*
* @access private
* @return array key: userid, value: realname
*
*/
function selectAuthors()
{
global $serendipity;
$users = (array)serendipity_fetchUsers();
foreach ($users as $user) {
if ($this->checkUser($user)) {
$u[$user['authorid']] = $user['realname'];
}
}
return $u;
}
function getLanguages()
{
global $serendipity;
$lang['all'] = LANG_ALL;
$lang = array_merge($lang, $serendipity['languages']);
return $lang;
}
function getRelatedCategories()
{
global $serendipity;
$res = serendipity_fetchCategories($serendipity['authorid']);
$ret[0] = NONE;
if (is_array($res)) {
foreach ($res as $value) {
$ret[$value['categoryid']] = $value['category_name'];
}
}
return $ret;
}
/**
*
* get the realname from the author id
*
* @access private
* @return mixed realname if match, else false
*
*/
function selectAuthor($id)
{
global $serendipity;
$users = (array)serendipity_fetchUsers();
foreach ($users as $user) {
if($user['authorid'] == $id) {
return $user['realname'];
}
}
return false;
}
/**
*
* check if the user have the needed rights to do something by user array
*
* @access private
* @return boolean
*
*/
function checkUser(&$user)
{
global $serendipity;
return (($user['userlevel'] < $serendipity['serendipityUserlevel']) || ($user['authorid'] == $serendipity['authorid']) || ($serendipity['serendipityUserlevel'] >= USERLEVEL_ADMIN));
}
/**
*
* check if the user have the needed rights to do something by userid
*
* @see checkUser
* @access private
* @return boolean
*
*/
function checkPageUser($authorid)
{
global $serendipity;
if ((empty($authorid)) || ((int)$authorid === 0)) {
return true;
}
$user = (array)serendipity_fetchUsers($authorid);
return $this->checkUser($user[0]);
}
/**
*
* get all created staticpages
*
* @access private
* @return array array of pages
*
*/
function selectPages()
{
global $serendipity;
$p = array('0' => STATICPAGE_PARENTPAGE_PARENT);
$q = 'SELECT id, authorid, pagetitle, parent_id
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE content != \'plugin\'
ORDER BY parent_id, pageorder';
$pages = serendipity_db_query($q, false, 'assoc');
if (is_array($pages)) {
$pages = serendipity_walkRecursive($pages);
foreach ($pages as $page) {
if ($this->checkPageUser($page['authorid']) && $serendipity['POST']['staticpage'] != $page['id']) {
$p[$page['id']] = str_repeat('', $page['depth']) . $page['pagetitle'];
}
}
}
return $p;
}
/**
*
* get a list of all pagetypes
*
* @access private
* @return mixed array if pagetypes, else false
*
*/
function selectPageTypes()
{
global $serendipity;
$q = 'SELECT id, description
FROM '.$serendipity['dbPrefix'].'staticpages_types';
$types = serendipity_db_query($q, false, 'assoc');
if (is_array($types)) {
foreach ($types as $type) {
$t[$type['id']] = $type['description'];
}
return $t;
}
return false;
}
/**
* check if sidebar plugin is available for install
*/
function sb_plugin_status() {
$plugins = serendipity_plugin_api::enum_plugins('*', false, 'serendipity_plugin_staticpage');
if(is_array($plugins) && !empty($plugins[0]['name'])) {
return true;
}
return false;
}
/**
*
* are plugins installed, available or not
*
* @access private
*
*/
function pluginstatus()
{
global $serendipity;
$uplugs = array(
'serendipity_event_downloadmanager',
'serendipity_event_guestbook',
'serendipity_event_forum',
'serendipity_event_contactform',
'serendipity_event_thumbnails',
'serendipity_event_usergallery',
'serendipity_event_faq'
);
$plugins = serendipity_plugin_api::get_installed_plugins('event');
$classes = serendipity_plugin_api::enum_plugin_classes('event');
foreach ($uplugs as $plugin) {
if (in_array($plugin, $plugins)) {
$this->pluginstats[$plugin] = array(
'status' => STATICPAGE_PLUGINS_INSTALLED,
'color' => 'Green'
);
} elseif (isset($classes[$plugin])) {
$this->pluginstats[$plugin] = array(
'status' => STATICPAGE_PLUGIN_AVAILABLE,
'color' => 'Yellow'
);
} else {
$this->pluginstats[$plugin] = array(
'status' =>STATICPAGE_PLUGIN_NOTAVAILABLE,
'color' => 'Red'
);
}
}
}
/**
*
* prepare an list with available plugins for use in staticpage
*
* @access private
* @return array
*
*/
function selectPlugins()
{
global $serendipity;
$plugins = serendipity_plugin_api::get_installed_plugins('event');
foreach ($plugins as $plugin) {
switch ($plugin) {
case 'serendipity_event_downloadmanager':
if ($serendipity['rewrite'] == 'none') {
$q = 'SELECT value
FROM '.$serendipity['dbPrefix'].'config
WHERE name LIKE \'serendipity_event_downloadmanager%pageurl\'';
} else {
$q = 'SELECT value
FROM '.$serendipity['dbPrefix'].'config
WHERE name LIKE \'serendipity_event_downloadmanager%permalink\'';
}
$ret = serendipity_db_query($q, true, 'assoc');
if (is_array($ret)) {
if ($serendipity['rewrite'] == 'none') {
$page[$plugin]['link'] = $serendipity['serendipityHTTPPath'].$serendipity['indexFile'].'?serendipity[subpage]='.$ret['value'];
} else {
$page[$plugin]['link'] = $ret['value'];
}
$page[$plugin]['name'] = PLUGIN_DOWNLOADMANAGER_TITLE;
}
break;
case 'serendipity_event_guestbook':
$q = 'SELECT value
FROM '.$serendipity['dbPrefix'].'config
WHERE name LIKE \'serendipity_event_guestbook%'.(($serendipity['rewrite'] != 'none') ? 'permalink' : 'pagetitle').'\'';
$ret = serendipity_db_query($q, true, 'assoc');
if (is_array($ret)) {
$page[$plugin]['name'] = (defined('GUESTBOOK_TITLE') ? GUESTBOOK_TITLE : PLUGIN_GUESTBOOK_TITLE);
if ($serendipity['rewrite'] != 'none') {
$page[$plugin]['link'] = $ret['value'];
} else {
$page[$plugin]['link'] = $serendipity['serendipityHTTPPath'].$serendipity['indexFile'].'?serendipity[subpage]='.$ret['value'];
}
}
break;
case 'serendipity_event_forum':
$q = 'SELECT value
FROM '.$serendipity['dbPrefix'].'config
WHERE name LIKE \'serendipity_event_forum%pageurl\'';
$ret = serendipity_db_query($q, true, 'assoc');
if (is_array($ret)) {
$page[$plugin] = array(
'name' => PLUGIN_FORUM_TITLE,
'link' => $serendipity['serendipityHTTPPath'].$serendipity['indexFile'].'?serendipity[subpage]='.$ret['value']
);
}
break;
case 'serendipity_event_contactform':
$q = 'SELECT value
FROM '.$serendipity['dbPrefix'].'config
WHERE name LIKE \'serendipity_event_contactform%'.(($serendipity['rewrite'] != 'none') ? 'permalink' : 'pagetitle').'\'';
$ret = serendipity_db_query($q, true, 'assoc');
if (is_array($ret)) {
if ($serendipity['rewrite'] != 'none') {
$page[$plugin]['link'] = $ret['value'];
} else {
$page[$plugin]['link'] = $serendipity['serendipityHTTPPath'].$serendipity['indexFile'].'?serendipity[subpage]='.$ret['value'];
}
}
$page[$plugin]['name'] = PLUGIN_CONTACTFORM_TITLE;
break;
case 'serendipity_event_thumbnails':
$page[$plugin] = array(
'name' => THUMBPAGE_TITLE,
'link' => $serendipity['serendipityHTTPPath'].$serendipity['indexFile'].'?serendipity[page]=thumbs'
);
break;
case 'serendipity_event_usergallery':
if ($serendipity['rewrite'] == 'none') {
$q = 'SELECT value
FROM '.$serendipity['dbPrefix'].'config
WHERE name LIKE \'serendipity_event_usergallery%subpage\'';
} else {
$q = 'SELECT value
FROM '.$serendipity['dbPrefix'].'config
WHERE name LIKE \'serendipity_event_usergallery%permalink\'';
}
$ret = serendipity_db_query($q, true, 'assoc');
if (is_array($ret)) {
if ($serendipity['rewrite'] == 'none') {
$page[$plugin]['link'] = $serendipity['serendipityHTTPPath'].$serendipity['indexFile'].'?serendipity[subpage]='.$ret['value'];
} else {
$page[$plugin]['link'] = $ret['value'];
}
$page[$plugin]['name'] = PLUGIN_EVENT_USERGALLERY_TITLE;
}
break;
case 'serendipity_event_faq':
$q = 'SELECT value
FROM '.$serendipity['dbPrefix'].'config
WHERE name LIKE \'serendipity_event_faq%faqurl\'';
$ret = serendipity_db_query($q, true, 'assoc');
if (is_array($ret)) {
if ($serendipity['rewrite'] == 'none') {
$page[$plugin]['link'] = $serendipity['serendipityHTTPPath'].$serendipity['indexFile'].'?/'.$serendipity['permalinkPluginPath'].'/'.$ret['value'];
} else {
$page[$plugin]['link'] = $serendipity['serendipityHTTPPath'].$serendipity['permalinkPluginPath'].'/'.$ret['value'];
}
$page[$plugin]['name'] = FAQ_NAME;
}
break;
}
}
return $page;
}
/**
*
* Manage the database tables for staticpage
*
* @access private
* @return void
*
*/
function setupDB()
{
global $serendipity;
$built = $this->get_config('db_built', null);
$fresh = false;
if ((empty($built)) && (!defined('STATICPAGE_UPGRADE_DONE'))) {
serendipity_db_schema_import("CREATE TABLE {$serendipity['dbPrefix']}staticpages (
id {AUTOINCREMENT} {PRIMARY},
parent_id int(11) default '0',
articleformattitle varchar(255) not null default '',
articleformat int(1) default '1',
markup int(1) default '1',
pagetitle varchar(255) not null default '',
permalink varchar(255) not null default '',
is_startpage int(1) default '0',
is_404_page int(1) default '0',
show_childpages int(1) not null default '0',
content text,
pre_content text,
headline varchar(255) not null default '',
filename varchar(255) not null default '',
pass varchar(255) not null default '',
timestamp int(10) {UNSIGNED} default null,
last_modified int(10) {UNSIGNED} default null,
authorid int(11) default '0',
pageorder int(4) default '0',
articletype int(4) default '0',
related_category_id int(4) default 0,
shownavi int(4) default '1',
showonnavi int(4) default '1',
show_breadcrumb int(4) default '1',
publishstatus int(4) default '1',
language varchar(10) default '') {UTF_8}");
$old_stuff = serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}config WHERE name LIKE 'serendipity_event_staticpage:%'");
$import = array();
if (is_array($old_stuff)) {
foreach ($old_stuff as $item) {
$names = explode('/', $item['name']);
if (!isset($import[$names[0]])) {
$import[$names[0]] = array('authorid' => $item['authorid']);
}
$import[$names[0]][$names[1]] = serendipity_get_bool($item['value']);
}
}
foreach ($import AS $page) {
if (is_array($page)) {
serendipity_db_insert('staticpages', $page);
@unlink($this->cachefile);
}
}
serendipity_db_query("DELETE FROM {$serendipity['dbPrefix']}config WHERE name LIKE 'serendipity_event_staticpage:%'");
serendipity_db_query("DELETE FROM {$serendipity['dbPrefix']}plugins WHERE name LIKE 'serendipity_event_staticpage:%' AND name NOT LIKE '" . serendipity_db_escape_string($this->instance) . "'");
$this->set_config('db_built', '7');
$fresh = true;
@define('STATICPAGE_UPGRADE_DONE', true); // No further static pages may be called!
}
switch ($built) {
case 1: // password not included
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN pass varchar(255) not null default ''";
serendipity_db_schema_import($q);
case 2: // parent-id not included
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN parent_id int(11) default '0'";
serendipity_db_schema_import($q);
case 3:
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN show_childpages int(1) not null default '0'";
serendipity_db_schema_import($q); // list of child-pages on parent-page
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN pre_content text";
serendipity_db_schema_import($q); // content
case 4:
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN is_startpage int(1) default '0'";
serendipity_db_schema_import($q);
case 5: // enum to re-order staticpages
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN pageorder int(4) default '0'";
serendipity_db_schema_import($q);
case 6:
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN articletype int(4) default '0'";
serendipity_db_schema_import($q);
case 7:
$q = "CREATE TABLE {$serendipity['dbPrefix']}staticpages_types (
id {AUTOINCREMENT} {PRIMARY},
description varchar(100) not null default '',
template varchar(255) not null default '',
image varchar(255) not null default '') {UTF_8}";
serendipity_db_schema_import($q);
$existing = serendipity_db_query("SELECT * FROM {$serendipity['dbPrefix']}staticpages_types LIMIT 1");
if (!is_array($existing) || !isset($existing[0]['template'])) {
$this->pagetype = array(
'description' => 'Article',
'template' => 'plugin_staticpage.tpl'
);
serendipity_db_insert('staticpages_types', $this->pagetype);
$this->pagetype = array(
'description' => 'Overview',
'template' => 'plugin_staticpage_aboutpage.tpl'
);
serendipity_db_insert('staticpages_types', $this->pagetype);
$set = array(
'articletype' => 1,
'pageorder' => 0
);
serendipity_db_update('staticpages', array(), $set);
@unlink($this->cachefile);
}
case 8:
case 9:
case 10:
if (!$fresh) {
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN shownavi int(4) default '1';";
serendipity_db_schema_import($q);
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN showonnavi int(4) default '1'";
serendipity_db_schema_import($q);
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN publishstatus int(4) default '1';";
serendipity_db_schema_import($q);
$q = 'DROP TABLE '.$serendipity['dbPrefix'].'staticpages_plugins';
serendipity_db_schema_import($q);
$q = 'ALTER TABLE '.$serendipity['dbPrefix'].'staticpages ADD COLUMN language varchar(10) default \'\'';
serendipity_db_schema_import($q);
}
case 11:
serendipity_db_update('staticpages_types', array('description' => 'Aboutpage'), array('description' => 'Overview'));
case 12:
$q = "CREATE {FULLTEXT_MYSQL} INDEX staticentry_idx on {$serendipity['dbPrefix']}staticpages (headline, content);";
serendipity_db_schema_import($q);
case 13:
case 14:
if (!$fresh) {
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN last_modified int(10)";
serendipity_db_schema_import($q);
serendipity_db_query("UPDATE {$serendipity['dbPrefix']}staticpages SET last_modified = timestamp");
}
case 15:
if (!$fresh) {
$sql = 'ALTER TABLE '.$serendipity['dbPrefix'].'staticpages ADD COLUMN related_category_id int(4) default 0';
serendipity_db_schema_import($sql);
}
case 16:
$this->pagetype = array(
'description' => 'Staticpage with related category',
'template' => 'plugin_staticpage_related_category.tpl'
);
serendipity_db_insert('staticpages_types', $this->pagetype);
$sql = 'CREATE TABLE '.$serendipity['dbPrefix'].'staticpage_categorypage (
categoryid int(4) default 0,
staticpage_categorypage int(4) default 0
) {UTF_8}';
serendipity_db_schema_import($sql);
case 17:
$sql = 'CREATE TABLE '.$serendipity['dbPrefix'].'staticpage_custom (
staticpage int(11),
name varchar(128),
value text
) {UTF_8}';
serendipity_db_schema_import($sql);
case 18:
$sql = 'ALTER TABLE '.$serendipity['dbPrefix'].'staticpages ADD COLUMN is_404_page int(1) default 0';
if ($serendipity['dbType'] == 'mysql' || $serendipity['dbType'] == 'mysqli') {
$sql .= ' AFTER is_startpage';
}
serendipity_db_schema_import($sql);
case 19:
if (!$fresh) {
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN show_breadcrumb int(4) default '1'";
serendipity_db_schema_import($q);
}
case 20:
if (!$fresh) {
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN title_element varchar(255) not null default ''";
serendipity_db_schema_import($q);
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN meta_description varchar(255) not null default ''";
serendipity_db_schema_import($q);
$q = "ALTER TABLE {$serendipity['dbPrefix']}staticpages ADD COLUMN meta_keywords varchar(255) not null default ''";
serendipity_db_schema_import($q);
}
$this->set_config('db_built', 21);
break;
}
}
/**
*
* Walk throu the staticpage array and return the value by key
*
* @see var staticpage
* @access private
* @return string
*
*/
function &get_static($key, $default = null)
{
return (isset($this->staticpage[$key]) ? $this->staticpage[$key] : $default);
}
/**
*
* Walk throu the pagetype array and return the value by key
*
* @see var pagetype
* @access private
* @return string
*
*/
function &get_type($key, $default = null)
{
return (isset($this->pagetype[$key]) ? $this->pagetype[$key] : $default);
}
function getEditlinkData()
{
global $serendipity;
$adminlink = array(
'link_edit' => $serendipity['serendipityHTTPPath'].'serendipity_admin.php?serendipity[action]=admin&serendipity[adminModule]=event_display&serendipity[adminAction]=staticpages&serendipity[staticid]='.(int)$this->getPageID(),
'link_name' => STATICPAGE_LINKNAME,
'page_user' => $this->checkPageUser($this->staticpage['authorid'])
);
return $adminlink;
}
function getNavigationData()
{
global $serendipity;
$target = $this->cachefile;
$timeout = 86400; // One day
if (file_exists($target) && filemtime($target) > time()-$timeout) {
$pages = unserialize(file_get_contents($target));
} else {
$pages = $this->fetchPublishedStaticPages();
$pages = (is_array($pages) ? serendipity_walkRecursive($pages) : array());
$fp = fopen($target, 'w');
fwrite($fp, serialize($pages));
fclose($fp);
}
$thispage = (int)$this->getPageID();
for ($i = 0, $maxcount = count($pages); $i < $maxcount; $i++) {
if ($pages[$i]['depth'] == 0) {
$top['name'] = $pages[$i]['pagetitle'];
$top['permalink'] = $pages[$i]['permalink'];
$top['id'] = $pages[$i]['id'];
}
if ($pages[$i]['id'] == $thispage) {
$nav = array(
'prev' => array(
'name' => $this->get_config('showtextorheadline') ? STATICPAGE_PREV : $pages[$i-1]['pagetitle'],
'link' => $pages[$i-1]['permalink']
),
'next' => array(
'name' => $this->get_config('showtextorheadline') ? STATICPAGE_NEXT : $pages[$i+1]['pagetitle'],
'link' => $pages[$i+1]['permalink']
),
'top' => array(
'name' => (($top['id'] == $pages[$i-1]['id']) || ($this->get_config('showtextorheadline'))) ? STATICPAGE_TOP : $top['name'],
'link' => ($top['id'] == $pages[$i-1]['id'] ? $serendipity['serendipityHTTPPath'] : $top['permalink'])
)
);
if(empty($nav['prev']['link'])){
$nav['prev']['name'] = '';
}
if(empty($nav['next']['link'])){
$nav['next']['name'] = '';
}
if(empty($nav['top']['link'])){
$nav['top']['name'] = '';
}
// Include breadcrumbs
$crumbs = array();
// Add the current page
$j = $i;
$pages[$j]['name'] = $pages[$j]['pagetitle'];
$pages[$j]['link'] = $pages[$j]['permalink'];
$crumbs[] = $pages[$j];
$up = $pages[$j]['parent_id'];
while (($j >= 0) && ($up != 0)) {
// Find the parent page index! (Backwards for efficiency)
for (; ($j >= 0) && ($pages[$j]['id'] != $up); $j--) {}
if (($j >= 0) && ($pages[$j]['id'] == $up)) {
// Add the current page
$pages[$j]['name'] = $pages[$j]['pagetitle'];
$pages[$j]['link'] = $pages[$j]['permalink'];
$crumbs[] = $pages[$j];
$up = $pages[$j]['parent_id'];
}
}
// Reverse the breadcrumb array
$nav['crumbs'] = array_reverse($crumbs);
return $nav;
}
}
return false;
}
function getTemplate($id)
{
global $serendipity;
$q = "SELECT template
FROM {$serendipity['dbPrefix']}staticpages_types
WHERE id = '{$id}'";
$t = serendipity_db_query($q, true, 'assoc');
return $t['template'];
}
function getImage(&$id)
{
global $serendipity;
$q = "SELECT image
FROM {$serendipity['dbPrefix']}staticpages_types
WHERE id = '{$id}'";
$t = serendipity_db_query($q, true, 'assoc');
return $t['image'];
}
function smarty_init() {
global $serendipity;
if (!isset($this->smarty_init)) {
@include_once dirname(__FILE__) . '/smarty.inc.php';
if (isset($serendipity['smarty'])) {
$staticpage_cat = $this->fetchCatProp($serendipity['GET']['category']);
$serendipity['smarty']->assign('staticpage_categorypage', $this->fetchStaticPageForCat($staticpage_cat));
$serendipity['smarty']->assign('serendipityArchiveURL', getArchiveURL());
$serendipity['smarty']->register_function('getCategoryLinkByID', 'smarty_getCategoryLinkByID');
$serendipity['smarty']->register_function('staticpage_display', 'staticpage_display');
$serendipity['staticpage_plugin'] =& $this;
$this->smarty_init = true;
}
}
}
function &parseStaticPage($pagevar = 'staticpage_', $template = 'plugin_staticpage.tpl') {
global $serendipity;
$filename = $this->get_static('filename');
if (empty($filename) || $filename == 'none.html') {
$filename = $template;
}
if ($template != 'plugin_staticpage.tpl') {
$filename = $template;
} else if ($this->get_static('articletype')) {
$filename = $this->getTemplate($this->get_static('articletype'));
}
serendipity_smarty_init();
foreach($this->config as $staticpage_config) {
$serendipity['smarty']->assign($pagevar . $staticpage_config, $this->get_static($staticpage_config));
}
if (serendipity_db_bool($this->get_static('markup'))) {
$entry = array('body' => $this->get_static('content'));
$entry['staticpage'] =& $entry['body'];
serendipity_plugin_api::hook_event('frontend_display', $entry);
if (isset($entry['markup_staticpage'])) {
$staticpage_content = $entry['staticpage'];
} else {
$staticpage_content = $entry['body'];
}
$entry = array('body' => $this->get_static('pre_content'));
$entry['staticpage'] =& $entry['body'];
if (!empty($entry['body'])) {
serendipity_plugin_api::hook_event('frontend_display', $entry);
}
if (isset($entry['markup_staticpage'])) {
$staticpage_precontent = $entry['staticpage'];
} else {
$staticpage_precontent = $entry['body'];
}
} else {
$staticpage_content =& $this->get_static('content');
$staticpage_precontent =& $this->get_static('pre_content');
}
if ($cpids = $this->getChildPagesID()) {
foreach($cpids as $cpid) {
$cpages[] = $this->getStaticPage($cpid);
}
foreach($cpages as $cpage) {
if (strlen($cpage['pre_content'])) {
$precontent =& $cpage['pre_content'];
} else {
$precontent =& $cpage['content'];
}
if (serendipity_db_bool($cpage['markup'])) {
$entry = array('body' => $precontent);
$entry['staticpage'] =& $entry['body'];
if (!empty($entry['body'])) {
serendipity_plugin_api::hook_event('frontend_display', $entry);
}
if (isset($entry['markup_staticpage'])) {
$precontent = $entry['staticpage'];
} else {
$precontent = $entry['body'];
}
}
$imgid = ($cpage['articletype'] ? $cpage['articletype'] : 1);
$childpages[] = array(
'image' => $this->getImage($imgid),
'precontent' => $precontent,
'permalink' => $cpage['permalink'],
'pagetitle' => $cpage['pagetitle'],
'headline' => $cpage['headline']
);
}
}
/* this is probably unneeded for the solution with serendipity_fetchPrintEntries - see plugin_staticpage_related_category.tpl - so we can save the costs of a sql-query
$related_category_entries = null;
if ($this->get_static('related_category_id') >= 0) {
if ($this->get_static('related_category_id') > 0) {
$serendipity['GET']['category'] = $this->get_static('related_category_id');
}
$select_key = "ep_sticky.value AS orderkey, e.id, e.title, e.timestamp";
$related_category_entries = serendipity_fetchEntries(null,
false,
'',
false,
false,
'timestamp DESC',
'',
false,
false,
$select_key,
null,
'array');
unset($serendipity['GET']['category']);
if (is_array($related_category_entries)) {
for ($i = 0, $ii = count($related_category_entries); $i < $ii; $i++) {
$related_category_entries[$i]['link'] = serendipity_archiveURL($related_category_entries[$i]['id'],
$related_category_entries[$i]['title'],
'baseURL',
true);
}
}
}
*/
$serendipity['smarty']->assign(
array(
$pagevar . 'articleformat' => serendipity_db_bool($this->get_static('articleformat')),
$pagevar . 'form_pass' => isset($serendipity['POST']['pass']) ? $serendipity['POST']['pass'] : '',
$pagevar . 'form_url' => $serendipity['baseURL'] . $serendipity['indexFile'] . '?serendipity[subpage]=' . htmlspecialchars($this->get_static('pagetitle')),
$pagevar . 'content' => $staticpage_content,
$pagevar . 'childpages' => serendipity_db_bool($this->get_static('show_childpages')) ? $this->getChildPages() : false,
$pagevar . 'extchildpages' => $childpages,
$pagevar . 'pid' => $this->get_static('id'),
$pagevar . 'precontent' => $staticpage_precontent,
$pagevar . 'adminlink' => $this->getEditlinkData(),
$pagevar . 'navigation' => $this->getNavigationData(),
$pagevar . 'author' => $this->selectAuthor($this->staticpage['authorid']),
$pagevar . 'created_on' => $this->get_static('timestamp'),
$pagevar . 'lastchange' => $this->get_static('last_modified'),
$pagevar . 'shownavi' => $this->get_static('shownavi'),
$pagevar . 'show_breadcrumb' => $this->get_static('show_breadcrumb'),
$pagevar . 'custom' => $this->get_static('custom'),
$pagevar . 'title_element' => $this->get_static('title_element'),
$pagevar . 'meta_description' => $this->get_static('meta_description'),
$pagevar . 'meta_keywords' => $this->get_static('meta_keywords')
// same thing as above
// $pagevar . 'related_category_entries' => $related_category_entries
)
);
$filename = basename($filename);
$tfile = serendipity_getTemplateFile($filename, 'serendipityPath');
if (!$tfile || $tfile == $filename) {
$tfile = dirname(__FILE__) . '/' . $filename;
}
$inclusion = $serendipity['smarty']->security_settings[INCLUDE_ANY];
$serendipity['smarty']->security_settings[INCLUDE_ANY] = true;
$content = $serendipity['smarty']->fetch('file:'. $tfile);
$serendipity['smarty']->security_settings[INCLUDE_ANY] = $inclusion;
return $content;
}
function show() {
global $serendipity;
if ($this->selected()) {
if ($this->error_404 === FALSE) {
serendipity_header($_SERVER['SERVER_PROTOCOL'].' 200 OK');
serendipity_header('Status: 200 OK');
}
else {
serendipity_header($_SERVER['SERVER_PROTOCOL'].' 404 Not Found');
serendipity_header('Status: 404 Not Found');
}
echo $this->parseStaticPage();
}
}
function getPageID() {
global $serendipity;
if (isset($this->staticpage['id'])) {
return $this->staticpage['id'];
}
$q = "SELECT id
FROM {$serendipity['dbPrefix']}staticpages
WHERE pagetitle = '" . serendipity_db_escape_string($serendipity['GET']['subpage']) . "'
OR permalink = '" . serendipity_db_escape_string($serendipity['GET']['subpage']) . "'";
$page = serendipity_db_query($q, true, 'assoc');
return isset($page['id']) ? $page['id'] : false;
}
function getChildPages() {
global $serendipity;
$id = (int)$this->getPageID();
$q = 'SELECT pagetitle, permalink
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE parent_id = '.$id.'
AND publishstatus = 1
ORDER BY pageorder';
$pages = serendipity_db_query($q, false, 'assoc');
return is_array($pages) ? $pages : false;
}
function getChildPagesID() {
global $serendipity;
$id = (int)$this->getPageID();
$q = 'SELECT id
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE parent_id = '.$id.'
AND publishstatus = 1
ORDER BY pageorder';
$p = serendipity_db_query($q, false, 'assoc');
if(is_array($p)) {
foreach($p as $page) {
$pages[] = $page['id'];
}
return $pages;
}
return false;
}
function getChildPage(&$id)
{
global $serendipity;
$q = 'SELECT pagetitle, permalink
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE parent_id = '.(int)$id.'
AND publishstatus = 1';
$page = serendipity_db_query($q, false, 'assoc');
return is_array($page) ? $page : false;
}
function getSystersID(&$id)
{
global $serendipity;
$q = 'SELECT parent_id
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE id = '.(int)$id;
$parent_id = serendipity_db_query($q, true, 'assoc');
$q = 'SELECT id, pageorder
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE parent_id = '.$parent_id['parent_id'].'
AND publishstatus = 1
ORDER BY pageorder';
$pages = serendipity_db_query($q, false, 'assoc');
return is_array($pages) ? $pages : false;
}
function getStaticPage(&$id)
{
global $serendipity;
$q = 'SELECT *
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE id = '.(int)$id.'
LIMIT 1';
$page = serendipity_db_query($q, true, 'assoc');
return is_array($page) ? $page : false;
}
function selected()
{
global $serendipity;
static $cached = false;
if (empty($serendipity['GET']['subpage'])) {
return false;
}
if ($cached) {
return true;
}
$sql_where = '';
if (serendipity_userLoggedIn()) {
// User is authenticated; drafts and published pages are displayed as equals
// Previews will thus only work when being logged in.
} else {
// User is not authenticated. Only published documents shall be revealed.
$sql_where .= ' AND publishstatus = 1 ';
}
$q = "SELECT *
FROM {$serendipity['dbPrefix']}staticpages
WHERE (pagetitle = '" . serendipity_db_escape_string($serendipity['GET']['subpage']) . "'
OR permalink = '" . serendipity_db_escape_string($serendipity['GET']['subpage']) . "') $sql_where
LIMIT 1";
$page = serendipity_db_query($q, true, 'assoc');
if (is_array($page)) {
$this->staticpage =& $page;
$this->checkPage();
$cached = true;
$serendipity['is_staticpage'] = true;
return true;
}
return false;
}
function &fetchStaticPage($id)
{
global $serendipity;
$q = 'SELECT *
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE id = '.(int)$id.'
LIMIT 1';
$page = serendipity_db_query($q, true, 'assoc');
if (is_array($page)) {
$this->staticpage =& $page;
$this->checkPage();
}
}
function &fetchPageType($id)
{
global $serendipity;
$q = 'SELECT *
FROM '.$serendipity['dbPrefix'].'staticpages_types
WHERE id = '.(int)$id.'
LIMIT 1';
$type = serendipity_db_query($q, true, 'assoc');
if(is_array($type)) {
$this->pagetype =& $type;
}
}
// This function checks the values of a staticpage entry, and maybe adjusts the right values to use.
// Yeah. PostgreSQL is picky about this.
function checkPage() {
global $serendipity;
if (empty($this->staticpage['filename'])) {
$this->staticpage['filename'] = 'none.html';
}
if (empty($this->staticpage['timestamp'])) {
$this->staticpage['timestamp'] = time();
}
// Try to auto-detect a timestamp
if (preg_match('@[:\.]@i', $this->staticpage['timestamp'])) {
if (function_exists('date_parse_from_format')) {
// Need to convert strftime format (with %) to plain date format (without %)
$d = DATE_FORMAT_SHORT;
$d = str_replace('%M', 'i', $d); // Minute is %M in one and i in the other format
$d = str_replace('%', '', $d); // All other modifiers (%d, %m, %Y %H) stay the same
$t = date_parse_from_format($d, $this->staticpage['timestamp']);
$this->staticpage['timestamp'] = mktime($t['hour'], $t['minute'], $t['second'], $t['month'], $t['day'], $t['year']);
} elseif (function_exists('strptime')) {
$t = strptime($this->staticpage['timestamp'], DATE_FORMAT_SHORT);
$this->staticpage['timestamp'] = mktime($t['tm_hour'], $t['tm_min'], $t['tm_sec'], $t['tm_mon'], $t['tm_mday'], $t['tm_year']);
} else {
$this->staticpage['timestamp'] = strtotime($this->staticpage['timestamp']);
}
}
if (empty($this->staticpage['last_modified'])) {
$this->staticpage['last_modified'] = time();
}
if (empty($this->staticpage['show_childpages'])) {
$this->staticpage['show_childpages'] = '0';
}
if (empty($this->staticpage['is_startpage'])) {
$this->staticpage['is_startpage'] = '0';
}
if (empty($this->staticpage['is_404_page'])) {
$this->staticpage['is_404_page'] = '0';
}
if (!isset($this->staticpage['markup'])) {
$this->staticpage['markup'] = '1';
}
if (!isset($this->staticpage['publishstatus'])) {
$this->staticpage['publishstatus'] = '1';
}
if (!isset($this->staticpage['shownavi'])) {
$this->staticpage['shownavi'] = '1';
}
if (!isset($this->staticpage['showonnavi'])) {
$this->staticpage['showonnavi'] = '1';
}
if (!isset($this->staticpage['show_breadcrumb'])) {
$this->staticpage['show_breadcrumb'] = '1';
}
if (empty($this->staticpage['markup'])) {
$this->staticpage['markup'] = '0';
}
if (empty($this->staticpage['publishstatus'])) {
$this->staticpage['publishstatus'] = '0';
}
if (empty($this->staticpage['shownavi'])) {
$this->staticpage['shownavi'] = '0';
}
if (empty($this->staticpage['showonnavi'])) {
$this->staticpage['showonnavi'] = '0';
}
if (empty($this->staticpage['show_breadcrumb'])) {
$this->staticpage['show_breadcrumb'] = '0';
}
if (empty($this->staticpage['articletype'])) {
$this->staticpage['articletype'] = '0';
}
if (empty($this->staticpage['pageorder'])) {
$this->staticpage['pageorder'] = '0';
}
if (empty($this->staticpage['authorid'])) {
$this->staticpage['authorid'] = '0';
}
if (empty($this->staticpage['articleformat'])) {
$this->staticpage['articleformat'] = '0';
}
if (empty($this->staticpage['parent_id'])) {
$this->staticpage['parent_id'] = '0';
}
// Fetch Custom properties!
$q = 'SELECT *
FROM ' . $serendipity['dbPrefix'] . 'staticpage_custom
WHERE staticpage = ' . (int)$this->staticpage['id'];
$custom = serendipity_db_query($q, false, 'assoc');
if (is_array($custom)) {
foreach($custom AS $idx => $row) {
$parts = explode('~', $row['value']);
if (count($parts) > 1) {
$this->staticpage['custom'][$row['name']] = $parts;
} else {
$this->staticpage['custom'][$row['name']] = $row['value'];
}
}
}
}
function getStartpage()
{
global $serendipity;
$q = 'SELECT pagetitle
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE is_startpage = 1
AND (language = \'' . $serendipity['lang'] . '\'
OR language = \'all\'
OR language = \'\')
ORDER BY id DESC
LIMIT 1';
$page = serendipity_db_query($q, true, 'assoc');
return (is_array($page) && isset($page['pagetitle'])) ? $page['pagetitle'] : false;
}
function get404Errorpage()
{
global $serendipity;
$q = 'SELECT pagetitle
FROM '.$serendipity['dbPrefix'].'staticpages
WHERE is_404_page = 1
AND (language = \'' . $serendipity['lang'] . '\'
OR language = \'all\'
OR language = \'\')
ORDER BY last_modified DESC
LIMIT 1';
$page = serendipity_db_query($q, true, 'assoc');
return (is_array($page) && isset($page['pagetitle'])) ? $page['pagetitle'] : false;
}
function updateStaticPage()
{
global $serendipity;
$this->checkPage();
$this->staticpage['last_modified'] = time();
$insert_page = $this->staticpage;
unset($insert_page['custom']);
if (!isset($this->staticpage['id'])) {
$cpo = $this->getChildPage($insert_page['parent_id']);
if (is_bool($cpo)) {
$this->staticpage['pageorder'] = 1;
} else {
$this->staticpage['pageorder'] = count($cpo)+1;
}
@unlink($this->cachefile);
$result = serendipity_db_insert('staticpages', $insert_page);
$serendipity['POST']['staticpage'] = $pid = serendipity_db_insert_id('staticpages', 'id');
serendipity_plugin_api::hook_event('backend_staticpages_insert', $insert_page);
} else {
@unlink($this->cachefile);
$pid = $insert_page['id'];
$result = serendipity_db_update('staticpages', array('id' => $insert_page['id']), $insert_page);
serendipity_plugin_api::hook_event('backend_staticpages_update', $insert_page);
}
// Store custom properties
if (is_array($serendipity['POST']['plugin']['custom'])) {
foreach($serendipity['POST']['plugin']['custom'] AS $custom_name => $custom_value) {
if (is_array($custom_value)) {
$custom_value = implode('~', $custom_value);
}
// Delete first. Might not exist, but then we can safely issue an INSERT statement.
serendipity_db_query("DELETE FROM {$serendipity['dbPrefix']}staticpage_custom
WHERE staticpage = " . (int)$pid . "
AND name = '" . serendipity_db_escape_string($custom_name) . "'");
serendipity_db_query("INSERT INTO {$serendipity['dbPrefix']}staticpage_custom (staticpage, name, value)
VALUES (" . (int)$pid . ", '" . serendipity_db_escape_string($custom_name) . "', '" . serendipity_db_escape_string($custom_value) . "')");
}
$this->staticpage['custom'] = $serendipity['POST']['plugin']['custom'];
}
return $result;
}
function updatePageType()
{
global $serendipity;
if (!isset($this->pagetype['id'])) {
$result = serendipity_db_insert('staticpages_types', $this->pagetype);
if (is_string($result)) {
echo ' . ')
ERROR: ' . $result . '
ERROR: ' . $result . '
';
switch($serendipity['GET']['moveto']) {
case 'moveup':
$this->move_up($serendipity['GET']['pagetomove']);
break;
case 'movedown':
$this->move_down($serendipity['GET']['pagetomove']);
break;
}
$pages = $this->fetchStaticPages(true);
if(is_array($pages)) {
$pages = serendipity_walkRecursive($pages);
$sort_idx = 0;
echo ''."\n";
foreach($pages as $page) {
echo ''."\n";
echo '| ';
echo str_repeat(' ', $page['depth']).$page['pagetitle'];
echo ' | '."\n";
echo '';
if($sort_idx == 0) {
echo ' ';
} else {
echo ' .') ';
}
echo ' | '."\n";
echo '';
if ($sort_idx == (count($pages)-1)) {
echo ' ';
} else {
echo ($page['moveup']!= '' ? ' ' : '') . ' . ') ';
}
echo ' | '."\n";
echo '
'."\n";
$sort_idx++;
}
echo '
'."\n";
}
break;
case 'pagetype':
if($serendipity['POST']['pagetype'] != '__new') {
$this->fetchPageType($serendipity['POST']['pagetype']);
}
if($serendipity['POST']['typeSave'] == "true" && !empty($serendipity['POST']['SAVECONF'])) {
$serendipity['POST']['typeSubmit'] = true;
$bag = new serendipity_property_bag();
$this->introspect($bag);
$name = htmlspecialchars($bag->get('name'));
$desc = htmlspecialchars($bag->get('description'));
$config_t = $bag->get('type_configuration');
foreach($config_t as $config_item) {
$cbag = new serendipity_property_bag();
if($this->introspect_item_type($config_item, $cbag)) {
$this->pagetype[$config_item] = serendipity_get_bool($serendipity['POST']['plugin'][$config_item]);
}
}
echo ''. DONE .': '. sprintf(SETTINGS_SAVED_AT, serendipity_strftime('%H:%M:%S')) .'
';
$this->updatePageType();
}
if (!empty($serendipity['POST']['typeDelete']) && $serendipity['POST']['pagetype'] != '__new') {
serendipity_db_query("DELETE FROM {$serendipity['dbPrefix']}staticpages_types WHERE id = " . (int)$serendipity['POST']['pagetype']);
echo ''. DONE .': '. sprintf(RIP_ENTRY, $this->pagetype['description']) . '
';
}
echo '';
}
echo '' . STATICPAGE_PAGEADD_PLUGINS . '
';
$this->pluginstatus();
echo '';
echo '';
$i = 0;
foreach($this->pluginstats as $key => $value) {
echo '';
echo '| '.$key.' | ';
echo ''.$value['status'].' | ';
echo '
';
}
echo '
';
break;
case 'pages':
default:
if ($serendipity['POST']['staticpage'] != '__new') {
$this->fetchStaticPage($serendipity['POST']['staticpage']);
}
if ($serendipity['POST']['staticSave'] == "true" && !empty($serendipity['POST']['SAVECONF'])) {
$serendipity['POST']['staticSubmit'] = true;
$bag = new serendipity_property_bag;
$this->introspect($bag);
$name = htmlspecialchars($bag->get('name'));
$desc = htmlspecialchars($bag->get('description'));
$config_names = $bag->get('page_configuration');
foreach ($config_names as $config_item) {
$cbag = new serendipity_property_bag;
if ($this->introspect_item($config_item, $cbag)) {
$this->staticpage[$config_item] = serendipity_get_bool($serendipity['POST']['plugin'][$config_item]);
}
}
$result = $this->updateStaticPage();
if (is_string($result)) {
echo 'ERROR: ' . $result . '
'. DONE .': '. sprintf(SETTINGS_SAVED_AT, serendipity_strftime('%H:%M:%S')). '
';
}
}
if (!empty($serendipity['POST']['staticDelete']) && $serendipity['POST']['staticpage'] != '__new') {
if (!$this->getChildPage($serendipity['POST']['staticpage'])) {
serendipity_db_query("DELETE FROM {$serendipity['dbPrefix']}staticpages WHERE id = " . (int)$serendipity['POST']['staticpage']);
echo ''. DONE .': '. sprintf(RIP_ENTRY, $this->staticpage['pagetitle']) . '
';
} else {
echo ' . ')
'. IMPORT_NOTES . ': '. STATICPAGE_CANNOTDELETE_MSG . '