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 '';
     }
 }
Example #2
0
$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>";
}
Example #3
0
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");