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;
}
}
