Exemple #1
0
 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;
 }
Exemple #2
0
 public function delete()
 {
     if ($this->id != null) {
         $database = Mysql::getConnection();
         $database->Query("DELETE FROM " . TABLE_PREFIX . "m_actualities WHERE id='{$this->id}';");
     }
 }
Exemple #3
0
 public function testGetConnectionInactive()
 {
     $config = ['host' => 'localhost', 'active' => false];
     $object = new Mysql($this->string, $this->dateTime, $config);
     $logger = $this->getMockForAbstractClass('Magento\\Framework\\DB\\LoggerInterface');
     $this->assertNull($object->getConnection($logger));
 }
Exemple #4
0
 public function Register($userNickname, $userPasswd, $userEmail)
 {
     $database = Mysql::getConnection();
     $userNickname = $database->handler->real_escape_string($userNickname);
     $userEmail = $database->handler->real_escape_string($userEmail);
     $userPasswd = $this->PasswdHash($userPasswd);
     $database->Query("INSERT INTO " . TABLE_PREFIX . "users VALUES ('', '{$userNickname}', '{$userEmail}', '', '{$userPasswd}');");
 }
Exemple #5
0
 /**
  * @return bool
  */
 public function delete()
 {
     if ($this->id != "") {
         $database = Mysql::getConnection();
         $database->Query("DELETE FROM " . TABLE_PREFIX . "m_gallery WHERE id='{$this->id}';");
         return true;
     }
     return false;
 }
Exemple #6
0
 public static function Install($template)
 {
     require_once ABS_PATH . '/temp/' . $template . '/install.php';
     $database = Mysql::getConnection();
     $database->Query("INSERT INTO " . TABLE_PREFIX . "templates VALUES ('', '" . $installData['templateName'] . "', '" . $installData['templateAuthor'] . "', '" . $installData['templateVersion'] . "', '0','" . $installData['templateDescription'] . "');");
     $debug = new Debug();
     $debug->debugType = 0;
     $debug->debugMessage = Lang::$langData['installTemplate'] . " (" . $template . ")";
     $debug->StartDebug();
 }
Exemple #7
0
 private function TemplateLoader()
 {
     $tempFiles = scandir(ABS_PATH . '/temp/');
     for ($i = 2; $i < count($tempFiles); $i++) {
         $database = Mysql::getConnection();
         $query = $database->Query("SELECT * FROM " . TABLE_PREFIX . "templates WHERE templateName='{$tempFiles[$i]}';");
         if (!$query->num_rows) {
             Template::Install($tempFiles[$i]);
         }
     }
 }
Exemple #8
0
 /**
  * @return bool
  */
 public function delete()
 {
     if ($this->id != "") {
         $database = Mysql::getConnection();
         $database->Query("DELETE FROM " . TABLE_PREFIX . "m_gallery_pictures WHERE id='{$this->id}';");
         if (file_exists(ABS_PATH . "/upload/modules/gallery/" . $this->file)) {
             unlink(ABS_PATH . "/upload/modules/gallery/" . $this->file);
         }
         return true;
     }
     return false;
 }
Exemple #9
0
 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;
 }
Exemple #10
0
<?php

/*
 *	@author: Tomáš Mičulka
 *	@version: 2.0
 *	@last_update: 15.4.2014 
 */
defined('IN_INNE') or die("Acces denied!");
$database = Mysql::getConnection();
$getToken = $_GET["token"];
$user = User::getInstance();
if ($user->userToken == $getToken && $user->userPerm == 5) {
    $moduleId = $database->handler->real_escape_string($_POST["id"]);
    $module = new Module();
    $module->GetInfo($moduleId);
    if ($module->moduleStatus == 1) {
        $module->DisableModule();
    } else {
        $module->EnableModule();
    }
}
Exemple #11
0
 public function DeleteRouteGet($paramGet)
 {
     $database = Mysql::getConnection();
     //$data = $database->Query("SELECT * FROM ".TABLE_PREFIX."m_routes WHERE routeParamGet='$paramGet';");
     $database->Query("DELETE FROM " . TABLE_PREFIX . "m_routes WHERE routeParamGet='{$paramGet}';");
 }
Exemple #12
0
 public function SaveModule()
 {
     $database = Mysql::getConnection();
     $database->Query("INSERT INTO " . TABLE_PREFIX . "modules VALUES (''," . " '{$this->moduleName}'," . " '{$this->moduleVersion}'," . " '{$this->moduleAuthor}'," . " '{$this->moduleDescription}'," . " '{$this->moduleType}'," . " '{$this->modulePriority}'," . " '{$this->moduleAutoStart}'," . " '{$this->moduleStatus}'," . " '{$this->moduleStyles}'," . " '{$this->moduleIcon}'," . " '{$this->moduleAdmin}'," . " '{$this->moduleAdminMenu}');");
 }
Exemple #13
0
 public function LogEntry()
 {
     $database = Mysql::getConnection();
     $details = json_decode(file_get_contents("http://ipinfo.io/"));
     $clientIp = $details->ip;
     $clientCity = $details->city;
     $clientCountry = $details->country;
     $date = time();
     $data = $database->Query("SELECT * FROM " . TABLE_PREFIX . "uniqueclients WHERE clientIp='{$clientIp}' AND clientCity='{$clientCity}' AND clientCountry='{$clientCountry}';");
     if ($data->num_rows == 0) {
         $database->Query("INSERT INTO " . TABLE_PREFIX . "uniqueclients VALUES ('', '{$clientIp}', '{$clientCity}', '{$clientCountry}');");
     }
     $database->Query("INSERT INTO " . TABLE_PREFIX . "visits VALUES ('', '{$date}', '{$clientIp}', '{$clientCity}', '{$clientCountry}');");
 }