db->database_query($this->_build_get_records_query($criteria)); while($row = $this->db->database_fetch_assoc($res)) { $row['page_updated_ts'] = strtotime($row['page_updated_at']); $row['page_content_body'] = nl2br($row['page_desc']); if ($key) { $rows[$row[$this->pk]] = $row; } else { $rows[$index++] = $row; } } return $rows; } function clean_data($data) { $keys = array('page_id','page_name','page_key','page_type','page_status','page_content','page_updated_at','page_script','page_levels','page_pagecat_id','page_desc', 'page_subnets','page_include_header','page_include_footer' ); foreach ($data as $k=>$v) { if (!in_array($k, $keys)) { unset($data[$k]); } } return $data; } function insert($data) { if (!$data['page_key']) { $data['page_key'] = rc_toolkit::strip_text($data['page_name']); } $data['page_updated_at'] = rc_toolkit::db_to_datetime(); $data = $this->clean_data($data); return parent::insert($data); } function update($id, $data) { $data['page_updated_at'] = rc_toolkit::db_to_datetime(); $data = $this->clean_data($data); return parent::update($id, $data); } function get_page_by_key($key) { return $this->get_record_by_criteria("page_key = '$key'"); } function clear_quick_pages_cache() { if (class_exists('SESession')) { $session_object =& SESession::getInstance(); $session_object->clear('rc_page_menu_pages'); } } function get_quick_pages() { if (class_exists('SESession')) { $session_object =& SESession::getInstance(); $items = $session_object->get('rc_page_menu_pages'); } if ($items === null) { $items = array(); $query = "SELECT page_id, page_name, page_key FROM se_pages ORDER BY page_name ASC"; //rc_toolkit::debug($query,"sql"); $res = $this->db->database_query($query); while ($r = $this->db->database_fetch_assoc($res)) { $items[$r['page_id']] = $r; } if ($session_object) { $session_object->set('rc_page_menu_pages', $items); } } //rc_toolkit::debug($items); return $items; } function get_menu_pages($pids) { global $setting; static $items; $items = $this->get_quick_pages(); $pages = array(); if (!is_array($pids)) { $pids = explode(",", str_replace(" ","",$pids)); } foreach ($pids as $pid) { $pages[$pid] = $items[$pid]; } return $pages; } function get_usermenu_items() { global $setting; return $this->get_menu_pages($setting['setting_page_usermenu_ids']); } function get_topmenu_items() { global $setting; return $this->get_menu_pages($setting['setting_page_topmenu_ids']); } function get_bottommenu_items() { global $setting; return $this->get_menu_pages($setting['setting_page_bottommenu_ids']); } function page_categories() { static $cats; if ($cats === null) { $field = new se_field("page"); $field->cat_list(); $cats = $field->cats; } return $cats; } function page_cat_languages() { global $database; static $cats; if (!is_array($cats)) { $cs = $this->page_categories(); //rc_toolkit::debug($cs,'cs'); foreach ($cs as $c) { $cats[$c['cat_id']] = $c['cat_title']; foreach ($c['subcats'] as $s) { $cats[$s['subcat_id']] = $s['subcat_title']; } } //rc_toolkit::debug($cats,'cats'); foreach ($cats as $id => $title) { SELanguage::_preload($title); } } return $cats; } // page_cat_languages }