Example #1
0
 protected function Insert()
 {
     $gCms = cmsms();
     global $debug_errors;
     $db = $gCms->GetDb();
     $config = $gCms->GetConfig();
     $result = false;
     #Figure out the item_order
     if ($this->mItemOrder < 1) {
         $query = "SELECT max(item_order) as new_order FROM " . cms_db_prefix() . "content WHERE parent_id = ?";
         $row = $db->Getrow($query, array($this->mParentId));
         if ($row) {
             if ($row['new_order'] < 1) {
                 $this->mItemOrder = 1;
             } else {
                 $this->mItemOrder = $row['new_order'] + 1;
             }
         }
     }
     $newid = $db->GenID(cms_db_prefix() . "content_seq");
     $this->mId = $newid;
     $this->mModifiedDate = $this->mCreationDate = trim($db->DBTimeStamp(time()), "'");
     $query = "INSERT INTO " . $config["db_prefix"] . "content (content_id, content_name, content_alias, type, owner_id, parent_id, template_id, item_order, hierarchy, id_hierarchy, active, default_content, show_in_menu, cachable, secure, page_url, menu_text, markup, metadata, titleattribute, accesskey, tabindex, last_modified_by, create_date, modified_date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
     $dbresult = $db->Execute($query, array($newid, $this->mName, $this->mAlias, strtolower($this->mType), $this->mOwner, $this->mParentId, $this->mTemplateId, $this->mItemOrder, $this->mHierarchy, $this->mIdHierarchy, $this->mActive == true ? 1 : 0, $this->mDefaultContent == true ? 1 : 0, $this->mShowInMenu == true ? 1 : 0, $this->mCachable == true ? 1 : 0, $this->mSecure, $this->mURL, $this->mMenuText, $this->mMarkup, $this->mMetadata, $this->mTitleAttribute, $this->mAccessKey, $this->mTabIndex, $this->mLastModifiedBy, $this->mModifiedDate, $this->mCreationDate));
     if (!$dbresult) {
         die($db->sql . '<br/>' . $db->ErrorMsg());
         if ($config["debug"] == true) {
             # :TODO: Translate the error message
             $debug_errors .= "<p>Error inserting content</p>\n";
         }
     }
     if (is_array($this->_props) && count($this->_props)) {
         // :TODO: There might be some error checking there
         debug_buffer('save from ' . __LINE__);
         $this->_save_properties();
     } else {
         if (true == $config["debug"]) {
             # :TODO: Translate the error message
             $debug_errors .= "<p>Error inserting : the content has no properties</p>\n";
         }
     }
     if (isset($this->mAdditionalEditors)) {
         foreach ($this->mAdditionalEditors as $oneeditor) {
             $new_addt_id = $db->GenID(cms_db_prefix() . "additional_users_seq");
             $query = "INSERT INTO " . cms_db_prefix() . "additional_users (additional_users_id, user_id, content_id) VALUES (?,?,?)";
             $db->Execute($query, array($new_addt_id, $oneeditor, $this->Id()));
         }
     }
     if ($this->mURL != '') {
         $route = CmsRoute::new_builder($this->mURL, '__CONTENT__', $this->mId, '', TRUE);
         cms_route_manager::add_static($route);
     }
 }
 /**
  * Reset the static route table.
  *
  * @since 1.11
  * @author Robert Campbell
  * @internal
  */
 public static function rebuild_static_routes()
 {
     // clear the route table.
     $db = cmsms()->GetDb();
     $query = 'TRUNCATE TABLE ' . cms_db_prefix() . 'routes';
     $db->Execute($query);
     // get content routes
     $query = 'SELECT content_id,page_url FROM ' . cms_db_prefix() . "content \n             WHERE active=1 AND COALESCE(page_url,'') != ''";
     $tmp = $db->GetArray($query);
     if (is_array($tmp) && count($tmp)) {
         for ($i = 0; $i < count($tmp); $i++) {
             $route = CmsRoute::new_builder($tmp[$i]['page_url'], '__CONTENT__', $tmp[$i]['content_id'], '', TRUE);
             cms_route_manager::add_static($route);
         }
     }
     // get the module routes
     $installed = ModuleOperations::get_instance()->GetInstalledModules();
     foreach ($installed as $module_name) {
         $modobj = cms_utils::get_module($module_name);
         if (!$modobj) {
             continue;
         }
         $routes = $modobj->CreateStaticRoutes();
     }
 }
 public static function register_static_route($news_url, $news_article_id, $detailpage = '')
 {
     if ($detailpage <= 0) {
         $gCms = cmsms();
         $module = cms_utils::get_module('News');
         $detailpage = $module->GetPreference('detail_returnid', -1);
         if ($detailpage == -1) {
             $detailpage = $gCms->GetContentOperations()->GetDefaultContent();
         }
     }
     $parms = array('action' => 'detail', 'returnid' => $detailpage, 'articleid' => $news_article_id);
     $route = CmsRoute::new_builder($news_url, 'News', $news_article_id, $parms, TRUE);
     return cms_route_manager::add_static($route);
 }