<?php
-# This form requires wfpl. See: http://jasonwoof.org/wfpl
+# This form requires wfpl. See: http://sametwice.com/wfpl
define('ADMIN_PAGES_DB_FIELDS', 'title,filename,navbar,nav_title,content,description,keywords');
-require_once('code/wfpl/format.php');
-require_once('code/wfpl/email.php');
-
function format_cms_filename($str) {
$str = format_filename($str);
$str = str_replace('.', '_', $str);
function admin_pages_main() {
- if(!logged_in_as_admin()) {
- $_REQUEST['url'] = this_url();
- return 'admin_login';
- }
+ session_auth_must('edit_page');
$id = _REQUEST_cut('edit_id');
if($id) {
return './admin_pages';
}
+# get all images from admin_images (for cms)
function admin_pages_get_images() {
- $images = db_get_assocs('cms_images', 'image,name,caption,sizes', 'order by name, caption, image');
- $id = 0;
- foreach($images as &$image) {
- $image['id'] = '' . $id;
- $id += 1;
+ $out = [];
+ $rows = db_get_assocs('cms_images', 'image,name,caption,sizes', 'order by name, caption, image');
+ if ($rows) {
+ $id = 0;
+ foreach($rows as &$row) {
+ $parts = explode(' ', $row['image'] . ' ', 7);
+ $out[] = [
+ 'id' => '' . $id,
+ 'thumb' => $parts[3],
+ 'image' => $parts[0],
+ 'image_width' => (int)$parts[1],
+ 'image_height' => (int)$parts[2],
+ 'sizes' => $row['sizes'],
+ 'name' => $row['name'],
+ 'caption' => $row['caption']
+ ];
+ $id += 1;
+ } unset($row);
}
- return $images;
+ return $out;
}
function admin_pages_main_listing() {
- $listing_rows = db_get_assocs('cms_pages', 'id,filename,coalesce(nullif(nav_title,\'\'), title) as title', 'order by concat(nav_title,title)');
- tem_set('listings', $listing_rows);
+ $data = array();
+ $desc = '';
+ $sort = _REQUEST_cut('sort');
+ if ($sort && substr($sort, 0, 1) === '-') {
+ $sort = substr($sort, 1);
+ $desc = ' DESC ';
+ } else {
+ $data["sorting-by-$sort"] = '-';
+ }
+ $legal_sorts = explode(',', ADMIN_PAGES_DB_FIELDS);
+ if (!$sort || !in_array($sort, $legal_sorts)) {
+ $sort = 'filename';
+ }
+
+ $data['rows'] = db_get_assocs('cms_pages', 'id,coalesce(nullif(nav_title,\'\'), title) as title,filename', "order by $sort $desc limit 1000");
+ tem_set('listing', $data);
}
function admin_pages_main_form($id = false) {
tem_set('id', $id);
}
+ tem_set('$basename', 'admin_pages');
$navbar_options = array(array('ignored', 'Not at all'), array('0', 'First'));
$rows = db_get_rows('cms_pages', 'id,coalesce(nullif(nav_title,\'\'), title) as title,navbar', 'where navbar != 0 order by navbar');
$data = array('filename' => format_cms_filename($_REQUEST['new_filename']));
}
- tem_set('wfpl_images', admin_pages_get_images());
+ tem_set('wfpl_images_json', json_encode(admin_pages_get_images()));
tem_set('form', $data);
tem_set('$head'); # wysiwyg init goes in <head>
}