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