public function GenerateDataArray() { $database = Mysql::getConnection(); if ($this->onlyVisible) { $data = $database->Query("SELECT * FROM " . TABLE_PREFIX . "pages WHERE pageShow='1' AND pageParent='0' ORDER BY pagePosition ASC;"); } else { $data = $database->Query("SELECT * FROM " . TABLE_PREFIX . "pages WHERE pageParent='0' ORDER BY pagePosition ASC;"); } while ($row = $data->fetch_array()) { $pageId = $row["pageId"]; $parentPage = new Page(); $parentPage->GetInfo($pageId); if ($database->Query("SELECT * FROM " . TABLE_PREFIX . "modules WHERE moduleName='simpleRoutes' AND moduleStatus='1';")->num_rows) { $routeQuery = $database->Query("SELECT routeVal FROM " . TABLE_PREFIX . "m_routes WHERE routeParamGET='p={$parentPage->pageId}';"); while ($rData = $routeQuery->fetch_array()) { $pageRoute = $rData["routeVal"]; } } if (isset($pageRoute)) { $this->menu[$this->mainCounter][$this->subCounter]["pageAddress"] = WEBSITE_ADDRESS . substr($pageRoute, 1); } else { $this->menu[$this->mainCounter][$this->subCounter]["pageAddress"] = "index.php?p=" . $parentPage->pageId; } unset($pageRoute); $this->menu[$this->mainCounter][$this->subCounter]["pageId"] = $parentPage->pageId; $this->menu[$this->mainCounter][$this->subCounter]["pageTitle"] = $parentPage->pageTitle; $subPageData = $database->Query("SELECT * FROM " . TABLE_PREFIX . "pages WHERE pageParent='{$parentPage->pageId}' ORDER BY pagePosition ASC;"); while ($subRow = $subPageData->fetch_array()) { $subPageId = $subRow["pageId"]; $subPage = new Page(); $subPage->GetInfo($subPageId); $this->subCounter++; if ($database->Query("SELECT * FROM " . TABLE_PREFIX . "modules WHERE moduleName='simpleRoutes' AND moduleStatus='1';")->num_rows) { $routeQuery = $database->Query("SELECT routeVal FROM " . TABLE_PREFIX . "m_routes WHERE routeParamGET='p={$subPage->pageId}';"); while ($rData = $routeQuery->fetch_array()) { $pageRoute = $rData["routeVal"]; } } if (isset($pageRoute)) { $this->menu[$this->mainCounter][$this->subCounter]["pageAddress"] = WEBSITE_ADDRESS . substr($pageRoute, 1); } else { $this->menu[$this->mainCounter][$this->subCounter]["pageAddress"] = "index.php?p=" . $subPage->pageId; } unset($pageRoute); $this->menu[$this->mainCounter][$this->subCounter]["pageId"] = $subPage->pageId; $this->menu[$this->mainCounter][$this->subCounter]["pageTitle"] = $subPage->pageTitle; } $this->subCounter = 0; $this->mainCounter++; } return $this->menu; }
$pageId = $database->handler->real_escape_string($_GET["id"]); $pageType = "text_master"; $pageTitle = $database->handler->real_escape_string($_POST["newPageTitle"]); $query = $database->Query("SELECT * FROM " . TABLE_PREFIX . "pages WHERE pageParent='{$pageId}' ORDER BY pagePosition DESC;"); $data = mysqli_fetch_array($query); $pagePosition = $data["pagePosition"]; $pageMenu = new Page(); $pageMenu->pageParent = $pageId; $pageMenu->pageType = $pageType; $pageMenu->pageShow = "1"; $pageMenu->pageTemp = "text_master"; $pageMenu->pageTitle = $pageTitle; $pageMenu->pagePosition = intval($pagePosition) + 1; $pageMenu->NewPage(); $pageParent = new Page(); $pageParent->GetInfo($pageId); $query = $database->Query("SELECT * FROM " . TABLE_PREFIX . "pages ORDER BY pageId DESC;"); $data = mysqli_fetch_array($query); $parentPageId = $data["pageId"]; $pageContent = $database->handler->real_escape_string($_POST["newPageContent"]); $pageTextMaster = new MPage(); $pageTextMaster->NewPage($parentPageId, $pageContent); if ($database->Query("SELECT * FROM " . TABLE_PREFIX . "modules WHERE moduleName='simpleRoutes' AND moduleStatus='1';")->num_rows) { require_once ABS_PATH . '/modules/simpleRoutes/src/class/class-route.php'; $route = new Route(); if ($pageMenu->pageParent == 0) { $route->SaveNewRoute("/" . webUriTitle($pageTitle), "p=" . $parentPageId, ""); } else { $route->SaveNewRoute("/" . webUriTitle($pageParent->pageTitle) . "/" . webUriTitle($pageTitle), "p=" . $parentPageId, ""); } }
<?php /* * @author: Tomáš Mičulka * @version: 2.0 * @last_update: 7.1.2014 */ define('IN_INNE', true); require_once './../../../../../class/class-adm.php'; $adm = new Admin(); $getToken = $_GET["token"]; $user = User::getInstance(); if ($user->userToken == $getToken && $user->userPerm == 5) { $delPage = new Page(); $delPage->GetInfo($_GET["pageId"]); require_once ABS_PATH . '/modules/' . $delPage->pageType . '/config.php'; if (isset($moduleAdmFiles) && isset($fileNames['admDel'])) { $moduleActionFile = ABS_PATH . '/modules/' . $delPage->pageType . $moduleAdmFiles . $fileNames['admDel']; if (file_exists($moduleActionFile)) { require_once $moduleActionFile; } } $delPage->DelPage(); }
public function GetPagesDataArray($hidden = false) { $pagesData = array(); $mainCounter = 0; $subCounter = 0; $database = Mysql::getConnection(); if ($hidden == false) { $data = $database->Query("SELECT * FROM " . TABLE_PREFIX . "pages WHERE pageParent='0' AND pageShow='1' ORDER BY pagePosition ASC;"); } else { if ($hidden == true) { $data = $database->Query("SELECT * FROM " . TABLE_PREFIX . "pages WHERE pageParent='0' ORDER BY pagePosition ASC;"); } } while ($row = $data->fetch_array()) { $pageId = $row["pageId"]; $parentPage = new Page(); $parentPage->GetInfo($pageId); $pagesData[$mainCounter][$subCounter]["pageId"] = $parentPage->pageId; $pagesData[$mainCounter][$subCounter]["pageTitle"] = $parentPage->pageTitle; $pagesData[$mainCounter][$subCounter]["pageType"] = $parentPage->pageType; $subPageData = $database->Query("SELECT * FROM " . TABLE_PREFIX . "pages WHERE pageParent='{$parentPage->pageId}' AND pageShow='1' ORDER BY pagePosition ASC;"); while ($subRow = $subPageData->fetch_array()) { $subPageId = $subRow["pageId"]; $subPage = new Page(); $subPage->GetInfo($subPageId); $subCounter++; $pagesData[$mainCounter][$subCounter]["pageId"] = $subPage->pageId; $pagesData[$mainCounter][$subCounter]["pageTitle"] = $subPage->pageTitle; $pagesData[$mainCounter][$subCounter]["pageType"] = $parentPage->pageType; } $subCounter = 0; $mainCounter++; } return $pagesData; }
$page_update->pageTitle = $galleryName; $page_update->UpdatePage(); $gallery_update = new MGallery(); $gallery_update->getInfo($pageId); $gallery_update->name = $galleryName; $gallery_update->description = $galleryDescription; $gallery_update->save(); } if ($_FILES["fileToUpload"]["tmp_name"] != "") { $newGallery = new MGallery(); $newGallery->getInfo($pageId); $newImage = new MGPicture($newGallery); $newImage->save($_FILES["fileToUpload"]); Admin::Refresh("", "0"); } if (isset($_POST["send"])) { $imageId = $database->handler->real_escape_string($_POST["imageId"]); $imageName = $database->handler->real_escape_string($_POST["image_name"]); $imageDescription = $database->handler->real_escape_string($_POST["image_description"]); $image = new MGPicture(); $image->getInfo($imageId); $image->name = $imageName; $image->description = $imageDescription; $image->save(); } $page = new Page(); $page->GetInfo($pageId); $gallery = new MGallery(); $gallery->getInfo($pageId); $template->template->assign("gallery_data", array("name" => $gallery->name, "description" => $gallery->description, "pictures" => $gallery->pictures)); require_once dirname(__FILE__) . '/tinymce/tiny_mce.php';