3 # This form requires wfpl. See: http://sametwice.com/wfpl
5 define('ADMIN_PAGES_DB_FIELDS', 'title,filename,navbar,nav_title,content,description,keywords');
8 function format_cms_filename($str) {
9 $str = format_filename($str);
10 $str = str_replace('.', '_', $str);
15 function admin_pages_get_fields() {
18 $data['title'] = format_oneline(_REQUEST_cut('title'));
19 $data['filename'] = format_cms_filename(_REQUEST_cut('filename'));
20 $data['navbar'] = format_options(_REQUEST_cut('navbar'), 'navbar');
21 $data['nav_title'] = format_oneline(_REQUEST_cut('nav_title'));
22 $data['content'] = format_unix(_REQUEST_cut('content'));
23 $data['description'] = format_unix(_REQUEST_cut('description'));
24 $data['keywords'] = format_unix(_REQUEST_cut('keywords'));
30 function admin_pages_main() {
31 session_auth_must('edit_page');
33 $id = _REQUEST_cut('edit_id');
35 return admin_pages_main_form($id);
38 $id = _REQUEST_cut('admin_pages_delete_id');
40 return admin_pages_main_delete($id);
43 if(_REQUEST_cut('new')) {
44 return admin_pages_main_form();
47 if(_REQUEST_cut('list')) {
48 return admin_pages_main_listing();
51 $id = _REQUEST_cut('id');
53 return admin_pages_main_display($id);
56 if(isset($_POST['title'])) {
57 return admin_pages_main_form();
61 return admin_pages_main_listing();
64 # admin-only access to view pages with no filename
65 function admin_pages_main_display($id) {
66 cms_display_content($GLOBALS['wfpl_main_template'], 'where id=%i', $id);
69 function admin_pages_main_delete($id) {
70 db_delete('cms_pages', 'where id=%i', $id);
71 message('Page deleted.');
72 return './admin_pages';
75 # get all images from admin_images (for cms)
76 function admin_pages_get_images() {
78 $rows = db_get_assocs('cms_images', 'image,name,caption,sizes', 'order by name, caption, image');
81 foreach($rows as &$row) {
82 $parts = explode(' ', $row['image'] . ' ', 7);
87 'image_width' => (int)$parts[1],
88 'image_height' => (int)$parts[2],
89 'sizes' => $row['sizes'],
90 'name' => $row['name'],
91 'caption' => $row['caption']
99 function admin_pages_main_listing() {
102 $sort = _REQUEST_cut('sort');
103 if ($sort && substr($sort, 0, 1) === '-') {
104 $sort = substr($sort, 1);
107 $data["sorting-by-$sort"] = '-';
109 $legal_sorts = explode(',', ADMIN_PAGES_DB_FIELDS);
110 if (!$sort || !in_array($sort, $legal_sorts)) {
114 $data['rows'] = db_get_assocs('cms_pages', 'id,coalesce(nullif(nav_title,\'\'), title) as title,filename', "order by $sort $desc limit 1000");
115 tem_set('listing', $data);
118 function admin_pages_main_form($id = false) {
123 tem_set('$basename', 'admin_pages');
125 $navbar_options = array(array('ignored', 'Not at all'), array('0', 'First'));
126 $rows = db_get_rows('cms_pages', 'id,coalesce(nullif(nav_title,\'\'), title) as title,navbar', 'where navbar != 0 order by navbar');
127 if($rows) for($i = 0; $i < count($rows); ++$i) {
128 list($other_id, $other_title, $other_ord) = $rows[$i];
129 if($other_id != $id) { # don't display ourselves
130 $navbar_options[] = array($i + 1, "After \"$other_title\"");
133 pulldown('navbar', $navbar_options, PULLDOWN_2D);
135 if(isset($_POST['title'])) {
136 $data = admin_pages_get_fields();
138 # We'll save anything (no required fields)
140 $data['navbar'] = db_reposition('cms_pages', $id, $data['navbar'], 'navbar', 'page');
142 if($data['navbar'] && $data['filename'] == '') {
143 message('This page was removed from the navigation column because it does not have a filename. (Pages without filenames are visible only to admins.)');
148 db_update_assoc('cms_pages', $data, 'where id=%i', $id);
150 message('Page updated.');
152 db_insert_assoc('cms_pages', $data);
154 message('Page saved.');
156 if($data['filename']) {
157 return "./$data[filename]";
159 return "./admin_pages?id=$id";
162 # we've recieved an edit id, but no data. So we grab the values to be edited from the database
163 $data = db_get_assoc('cms_pages', ADMIN_PAGES_DB_FIELDS, 'where id=%i', $id);
164 if($data['navbar']) {
165 $data['navbar'] = db_count('cms_pages', 'where navbar!=0 && navbar<%i', $data['navbar']);
167 $data['navbar'] = 'ignored';
170 # form not submitted, set default values:
171 $data = array('filename' => format_cms_filename($_REQUEST['new_filename']));
174 tem_set('wfpl_images_json', json_encode(admin_pages_get_images()));
175 tem_set('form', $data);
176 tem_set('$head'); # wysiwyg init goes in <head>