public static function update_page($pageInfo) { $ID = $pageInfo['ID']; $uri = $pageInfo['uri']; $module = $pageInfo['module']; $function = $pageInfo['function']; $template = $pageInfo['template']; $title = $pageInfo['title']; $keywords = $pageInfo['keywords']; $description = $pageInfo['description']; $pass_parameters_via_uri = isset($pageInfo['pass_parameters_via_uri']) ? 1 : 0; if (empty($uri) || empty($module) || empty($function)) { return false; } $previousPage = self::getPageById($ID); $serialized_parameters = serialize($pageInfo['parameters']); $sql_result = SJB_DB::query("UPDATE `pages` SET `uri`=?s, `module`=?s, `function`=?s," . " `template`=?s, `title`=?s, `parameters`=?s, `keywords`=?s," . " `description`=?s, `pass_parameters_via_uri`=?n" . " WHERE `ID`=?s", $uri, $module, $function, $template, $title, $serialized_parameters, $keywords, $description, $pass_parameters_via_uri, $ID); if ($sql_result != false) { if ($previousPage['function'] == 'browse') { SJB_BrowseDBManager::deleteBrowseByUri($previousPage['uri']); } if ($function == 'browse') { SJB_BrowseDBManager::addBrowseByUri($uri); } return $sql_result; } return false; }