if (isset($community_details["octype_id"]) && $community_details["octype_id"]) { $query = "SELECT * FROM `org_community_types` WHERE `octype_id` = " . $db->qstr($community_details["octype_id"]); $COMMUNITY_TYPE = $db->GetRow($query); if ($COMMUNITY_TYPE) { $COMMUNITY_TYPE_OPTIONS = json_decode($COMMUNITY_TYPE["community_type_options"], true); $query = "SELECT b.`cpage_id` FROM `community_type_pages` AS a\n JOIN `community_pages` AS b\n ON a.`page_url` = b.`page_url`\n AND a.`page_type` = b.`page_type`\n WHERE a.`type_id` = " . $db->qstr($COMMUNITY_TYPE["octype_id"]) . "\n AND a.`lock_page` = 1\n AND a.`type_scope` = 'organisation'\n AND b.`community_id` = " . $db->qstr($COMMUNITY_ID); $locked_pages = $db->GetAll($query); if ($locked_pages) { foreach ($locked_pages as $locked_page) { $COMMUNITY_LOCKED_PAGE_IDS[] = $locked_page["cpage_id"]; } } } if (isset($COMMUNITY_TYPE_OPTIONS["sequential_navigation"]) && $COMMUNITY_TYPE_OPTIONS["sequential_navigation"] == "1" && $COMMUNITY_MODULE != "pages") { $is_sequential_nav = true; $result = get_next_community_page($COMMUNITY_ID, $PAGE_ID, $PARENT_ID, $PAGE_ORDER); $query = "\tSELECT a.*, b.`page_url` AS `nav_url`\n\t\t\t\t\t\t\t\t\tFROM `community_page_navigation` AS a\n\t\t\t\t\t\t\t\t\tLEFT JOIN `community_pages` AS b\n\t\t\t\t\t\t\t\t\tON a.`nav_page_id` = b.`cpage_id`\n\t\t\t\t\t\t\t\t\tWHERE a.`community_id` = " . $db->qstr($COMMUNITY_ID) . "\n\t\t\t\t\t\t\t\t\tAND a.`cpage_id` = " . $db->qstr($PAGE_ID) . "\n\t\t\t\t\t\t\t\t\tAND `nav_type` = 'next'"; $nav_result = $db->GetRow($query); if ($nav_result) { $show_right_nav = $nav_result["show_nav"]; } else { $show_right_nav = 1; } if (($result || isset($nav_result["nav_url"]) && $nav_result["nav_url"]) && $show_right_nav) { if ($nav_result["nav_url"]) { $url = $nav_result["nav_url"]; } else { $url = $result["page_url"]; } $next_page_url = ENTRADA_URL . "/community" . $community_details["community_url"] . ":" . $url; } else {
$ERRORSTR[] = "There was a problem creating this new page in your community. Please contact the application administrator and inform them of this error."; } } if ($ERROR) { $STEP = 1; } break; case 1: default: if (!isset($PROCESSED["parent_id"])) { $PROCESSED["parent_id"] = 0; $query = "SELECT MAX(`page_order`) FROM `community_pages` WHERE `parent_id` = 0 AND `community_id` = " . $db->qstr($COMMUNITY_ID); $PROCESSED["page_order"] = $db->GetOne($query); $PROCESSED["page_order"] = (int) $PROCESSED["page_order"] + 1; } $default_next_page = get_next_community_page($COMMUNITY_ID, $PAGE_ID, $PROCESSED["parent_id"], $PROCESSED["page_order"]); $default_previous_page = get_prev_community_page($COMMUNITY_ID, $PAGE_ID, $PROCESSED["parent_id"], $PROCESSED["page_order"]); $PROCESSED = $result; if (isset($PAGE_TYPE) && $PAGE_TYPE != "") { $PROCESSED["page_type"] = $PAGE_TYPE; } break; } //Display Page switch ($STEP) { case 2: if ($NOTICE) { echo display_notice(); } if ($SUCCESS) { echo display_success();
$query = "SELECT *\n\t\t\t\t\t\t\t\t\t\t\t\tFROM `community_page_navigation`\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE `cpage_id` = " . $db->qstr($PAGE_ID) . "\n\t\t\t\t\t\t\t\t\t\t\t\tAND `community_id` = " . $db->qstr($COMMUNITY_ID); $results = $db->GetAll($query); if ($results) { foreach ($results as $result) { $PROCESSED["page_navigation"]["show_" . $result["nav_type"] . "_nav"] = $result["show_nav"]; if ($result["nav_type"] == "next") { $nav_next_page_id = $result["nav_page_id"]; } elseif ($result["nav_type"] == "previous") { $nav_previous_page_id = $result["nav_page_id"]; } } } if (isset($PAGE_TYPE) && $PAGE_TYPE != "") { $PROCESSED["page_type"] = $PAGE_TYPE; } $default_next_page = get_next_community_page($COMMUNITY_ID, $PAGE_ID, $page_details["parent_id"], $page_details["page_order"]); $default_previous_page = get_prev_community_page($COMMUNITY_ID, $PAGE_ID, $page_details["parent_id"], $page_details["page_order"]); break; } //Display Page switch ($STEP) { case 2: if ($NOTICE) { echo display_notice(); } if ($SUCCESS) { echo display_success(); } if ($ERROR) { echo display_error(); }
if (!isset($_POST["page_order"]) || !($page_order = (int) $_POST["page_order"])) { $query = "SELECT (MAX(`page_order`) + 1) FROM `community_pages`\n\t\t\t\t\tWHERE `community_id` = " . $db->qstr($COMMUNITY_ID) . "\n\t\t\t\t\tAND `parent_id` = " . $db->qstr($parent_id); $page_order = $db->GetOne($query); } switch ($nav_type) { case "prev_id": case "previous_id": $default_previous_page = get_prev_community_page($COMMUNITY_ID, $cpage_id, $parent_id, $page_order); echo $default_previous_page["cpage_id"]; exit; break; case "prev": case "previous": $default_previous_page = get_prev_community_page($COMMUNITY_ID, $cpage_id, $parent_id, $page_order); echo communities_pages_inradio(0, 0, array("selected" => $default_previous_page["cpage_id"], "id" => "previous_page_list", "nav_type" => "previous", "parent_swap" => array("parent_id" => $parent_id, "page_id" => $cpage_id))); exit; break; case "next_id": default: $default_next_page = get_next_community_page($COMMUNITY_ID, $cpage_id, $parent_id, $page_order); echo $default_next_page["cpage_id"]; exit; break; case "next": default: $default_next_page = get_next_community_page($COMMUNITY_ID, $cpage_id, $parent_id, $page_order); echo communities_pages_inradio(0, 0, array("selected" => $default_next_page["cpage_id"], "id" => "next_page_list", "nav_type" => "next", "parent_swap" => array("parent_id" => $parent_id, "page_id" => $cpage_id))); exit; break; } }