- $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();
+
+ $rows = db_get_assocs('cms_pages', 'id,coalesce(nullif(nav_title,""), title) as title,filename', 'order by coalesce(nullif(nav_title,""), title), filename limit 2000');
+ $have_home_page = false;
+ if (count($rows) !== 0) {
+ $data['rows'] = $rows;
+ foreach ($rows as &$row) {
+ if ($row['filename'] === 'index') {
+ $have_home_page = true;
+ break;
+ }
+ } unset($row);
+ }
+ if ($have_home_page === false) {
+ $data['no_home'] = true;
+ }
+ tem_set('listing', $data);
+}
+
+function admin_pages_main_page_history ($id) {
+ $data = array();
+
+ $rows = db_get_assocs('history_cms_pages left join users on history_cms_pages.history_user_id = users.id', 'history_cms_pages.id as page_id,history_cms_pages.history_id,history_cms_pages.filename,coalesce(nullif(history_cms_pages.nav_title,""), history_cms_pages.title) as title,history_when as timestamp,coalesce(nullif(users.name,""), users.username) as who', 'where history_cms_pages.id=%i order by history_id desc', $id);
+ if (count($rows) !== 0) {
+ $data['title'] = $rows[0]['title'];
+ $rows[0]['first'] = true;
+ if ($rows[0]['filename'] === 'index') {
+ $rows[0]['filename'] = './';
+ }
+ $data['rows'] = $rows;
+ }
+ tem_set('page_history', $data);