Ejemplo n.º 1
0
function getPageTree($parent)
{
    global $admin, $database, $InternPagesSelectBox, $PagesTitleSelectBox;
    $sql = 'SELECT * FROM `' . TABLE_PREFIX . 'pages` ';
    $sql .= 'WHERE `parent`= ' . (int) $parent . ' ';
    $sql .= PAGE_TRASH != 'inline' ? 'AND `visibility` != \'deleted\' ' : ' ';
    $sql .= 'ORDER BY `position` ASC';
    if ($resPage = $database->query($sql)) {
        while (!false == ($page = $resPage->fetchRow())) {
            if (!$admin->page_is_visible($page)) {
                continue;
            }
            $menu_title = cleanup($page['menu_title']);
            $page_title = cleanup($page['page_title']);
            // Stop users from adding pages with a level of more than the set page level limit
            if ($page['level'] + 1 <= PAGE_LEVEL_LIMIT) {
                $title_prefix = '';
                for ($i = 1; $i <= $page['level']; $i++) {
                    $title_prefix .= ' - ';
                }
                $InternPagesSelectBox .= "new Array( '" . $title_prefix . $menu_title . "', '[wblink" . $page['page_id'] . "]'), ";
                $PagesTitleSelectBox .= "new Array( '" . $page_title . "', '[wblink" . $page['page_id'] . "]'), ";
            }
            getPageTree($page['page_id']);
        }
    }
}
Ejemplo n.º 2
0
function getPageTree($parent)
{
    global $admin, $database, $InternPagesSelectBox, $PagesTitleSelectBox;
    $sql = 'SELECT * FROM `' . TABLE_PREFIX . 'pages` ' . 'WHERE `parent`= ' . (int) $parent . ' AND ' . '`level`<=' . PAGE_LEVEL_LIMIT . ' ' . (PAGE_TRASH != 'inline' ? 'AND `visibility` != \'deleted\' ' : ' ') . 'ORDER BY `position` ASC';
    if ($resPage = $database->query($sql)) {
        while (!(false == ($page = $resPage->fetchRow(MYSQLI_ASSOC)))) {
            if (!$admin->page_is_visible($page)) {
                continue;
            }
            $menu_title = cleanup($page['menu_title']);
            $page_title = cleanup($page['page_title']);
            $title_prefix = str_repeat(' - ', $page['level']);
            $InternPagesSelectBox .= "new Array( '" . $title_prefix . $menu_title . "', '[wblink" . $page['page_id'] . "]'), ";
            $PagesTitleSelectBox .= "new Array( '" . $page_title . "', '[wblink" . $page['page_id'] . "]'), ";
            if ($page['level'] < PAGE_LEVEL_LIMIT) {
                getPageTree($page['page_id']);
            }
        }
    }
}
	/**
	   * Builds an array, with all pages having one certain page as parent-node. Recursive down the tree
	   *
	   * @param $start integer MENU_ID of the page where to start
	   */
	function getPageTree($start) {
		global $db;

		$multipages = createDBCArray("sitepage", "SPID", "MENU_ID=$start AND DELETED=0");
		$menuPages = createDBCArray("sitemap", "MENU_ID", "PARENT_ID = $start AND DELETED=0");
		$result = $multipages;

		if (! is_array($result)) $result = array();
		for ($i = 0; $i < count($menuPages); $i++) {
			$result = array_merge($result, getPageTree($menuPages[$i]));
		}

		if (is_array($result))
			$result = array_unique($result);

		return $result;
	}
Ejemplo n.º 4
0
	function destroyTree() {
		global $destroyexecuted, $form, $db;

		$variations = createDBCArray("variations", "VARIATION_ID", "1");

		if (!$destroyexecuted) {
			$destroyexecuted = true;

			$delstart = value("del", "NUMERIC");
			$parentId = getDBCell("sitemap", "PARENT_ID", "MENU_ID = $delstart");
			$destroyArray = getPageTree($delstart);

			if (value("destroypages") == "0") {
				// geht nicht
				$meldung = "Please select also the check Destroy Tree. Only then the system will delete the tree.";

				$form->addToTopText($meldung);
			} else {
				if (value("destroycluster") == "0") {
					// nur pages löschen
					for ($i = 0; $i < count($destroyArray); $i++) {
						for ($j = 0; $j < count($variations); $j++) {
							expireSitepage($destroyArray[$i], 10, $variations[$j]);
						}

						$sql1 = "DELETE FROM sitepage WHERE SPID = $destroyArray[$i]";
						$menuid = getDBCell("sitepage", "MENU_ID", "SPID = " . $destroyArray[$i]);
						$deletequery = new query($db, $sql1);

						if ($menuid != "0" and $menuid != 0 and $menuid != "") {
							$sql2 = "DELETE FROM sitemap WHERE MENU_ID = $menuid";

							$sql3 = "DELETE FROM sitepage_names WHERE SPID = " . $destroyArray[$i];
							$sql4 = "DELETE FROM sitepage_owner WHERE SPID = " . $destroyArray[$i];

							$deletequery = new query($db, $sql3);
							$deletequery = new query($db, $sql4);
							$deletequery = new query($db, $sql2);
						}

						$deletequery->free();
					}
				} else {
					// pages und cluster
					for ($i = 0; $i < count($destroyArray); $i++) {
						for ($j = 0; $j < count($variations); $j++) {
							expireSitepage($destroyArray[$i], 10, $variations[$j]);
						}

						$clnid = getDBCell("sitepage", "CLNID", "SPID = $destroyArray[$i]");
						// only delete cluster if it is not used as channel article.
						if (!getDBCell("channel_articles", "CHID", "ARTICLE_ID = ".$clnid)) {
							$usage = 0;
							$usage += countRows("sitepage", "CLNID", "CLNID = $clnid AND DELETED=0");
							$usage += countRows("cluster_content", "FKID", "FKID = $clnid");
							$usage += countRows("cluster_template_items", "FDIK", "FKID = $clnid");
	
							if ($usage < 2) {
								$sql = "UPDATE cluster_node SET DELETED = 1 WHERE CLNID = $clnid";
	
								$query = new query($db, $sql);
							}
						}

						$sql1 = "DELETE FROM sitepage WHERE SPID = $destroyArray[$i]";
						$menuid = getDBCell("sitepage", "MENU_ID", "SPID = " . $destroyArray[$i]);
						$deletequery = new query($db, $sql1);

						if ($menuid != "0" and $menuid != 0 and $menuid != "") {
							$sql2 = "DELETE FROM sitemap WHERE MENU_ID = $menuid";

							$sql3 = "DELETE FROM sitepage_names WHERE SPID = " . $destroyArray[$i];
							$sql4 = "DELETE FROM sitepage_owner WHERE SPID = " . $destroyArray[$i];

							$deletequery = new query($db, $sql3);
							$deletequery = new query($db, $sql4);
							$deletequery = new query($db, $sql2);
						}

						$deletequery->free();
					
					}
				}
			}
			sortTableRows("sitemap", "MENU_ID", "POSITION", "PARENT_ID = $parentId");
		}
		
	}