function convertToPage(&$logged_user, &$error) { db_begin_work(); $page = new Page(); $page->setProjectId($this->getProjectId()); $page->setName($this->getName()); $body = $this->getBody(); if (empty($body)) { $body = 'page Content missing'; } $page->setBody($body); $page->setState($this->getState()); $page->setVisibility($this->getVisibility()); $page->setPriority($this->getPriority()); $page->setCommentsCount($this->getCommentsCount()); $page->setIsLocked($this->getIsLocked()); $page->setCreatedById($logged_user->getId()); $page->setCreatedByName($logged_user->getName()); $page->setCreatedByEmail($logged_user->getEmail()); $save = $page->save(); if ($save && !is_error($save)) { db_commit(); $page->ready(); $link = mysql_connect(DB_HOST, DB_USER, DB_PASS); mysql_select_db(DB_NAME); $query = "update healingcrystals_project_objects set parent_id='" . $page->getId() . "', parent_type='Page' where parent_id='" . $this->getId() . "' and project_id='" . $this->getProjectId() . "' and type in ('Comment', 'Task')"; mysql_query($query); $query = "update healingcrystals_project_objects set parent_id=null, parent_type=null where parent_id='" . $this->getId() . "' and project_id='" . $this->getProjectId() . "' and type not in ('Comment', 'Task')"; mysql_query($query); $query = "select * from healingcrystals_assignments where object_id='" . $this->getId() . "'"; $result = mysql_query($query); while ($entry = mysql_fetch_assoc($result)) { $query = "insert into healingcrystals_assignments (user_id, object_id, is_owner) values ('" . $entry['user_id'] . "', '" . $page->getId() . "', '" . $entry['is_owner'] . "')"; mysql_query($query); } $query = "select * from healingcrystals_project_object_categories where object_id='" . $this->getId() . "'"; $result = mysql_query($query); while ($entry = mysql_fetch_assoc($result)) { $query = "insert ignore into healingcrystals_project_object_categories (object_id, category_id) values ('" . $page->getId() . "', '" . $entry['category_id'] . "')"; mysql_query($query); } mysql_close($link); $this->moveToTrash(); return $page->getId(); } else { db_rollback(); $error = $save; return ''; } }
$session = new Session(); if (!$session->isLogin) { redirect("../login.php"); } $user = new User(); $database = new Database(); $page = new Page(); // check the parameters if (isset($_GET['page']) && isset($_GET['active']) && $_GET['page'] != null && $_GET['active'] != null) { // set page id $pageId = $database->escapeString($_GET['page']); $page->setPageId($pageId); // change the visibility otherwise if ($_GET['active'] == 1) { $visibility = 0; $page->setVisibility($visibility); $page->chageVisibility($database); redirect("../pages.php?pages=1"); } else { if ($_GET['active'] == 0) { $visibility = 1; $page->setVisibility($visibility); $page->chageVisibility($database); redirect("../pages.php?pages=1"); } else { echo "<h1>Go back and try again or contact your Administrator<br>There is something wrong with the visibility value</h1>"; } } } else { echo "<h1>Go back and try again or contact your Administrator</h1>"; }
if (isset($_POST['submitPage'])) { $submitPage = $database->escapeString($_POST['submitPage']); $title = $database->escapeString($_POST['title']); $pageName = $database->escapeString($_POST['pageName']); $urlTag = $database->escapeString($_POST['urlTag']); $metaDesc = $database->escapeString($_POST['metaDesc']); $metaKeywords = $database->escapeString($_POST['metaKeywords']); $layout = $database->escapeString($_POST['layout']); $page->setTitle($title); $page->setPageName($pageName); $page->setUrlTag($urlTag); $page->setMetaDesc($metaDesc); $page->setMetaKeywords($metaKeywords); $page->setPageLayoutId($layout); if ($submitPage == "Save") { $page->setVisibility(0); } else { if ($submitPage == "Save & Publish") { $page->setVisibility(1); } } if (isset($_POST['pageId'])) { $page->setPageId($database->escapeString($_POST['pageId'])); if ($page->update($database)) { redirect("../pages.php?pages=1"); } else { echo "<h2>Something is wrong go back and try again, or contact your administrator</h2>"; } } else { if ($page->create($database)) { redirect("../pages.php?pages=1");