Пример #1
0
    public function get_page_type($c)
    {
        $conn = $this->conn($c);
        $out = '';
        $url_controll = new url_controll();
        $slugs = $url_controll->slugs();
        //select mane pages
        $sql = 'SELECT `page_type` FROM `studio404_pages` WHERE `slug`=:slug AND `lang`=:lang AND `status`!=:status';
        $prepare = $conn->prepare($sql);
        $prepare->execute(array(":slug" => $slugs, ":lang" => LANG_ID, ":status" => 1));
        $nums = $prepare->rowCount();
        if ($nums) {
            $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
            $out = $fetch["page_type"];
        } else {
            //select news
            $sql_module = 'SELECT 
			`studio404_module_attachment`.`page_type` AS module_pagetype
			FROM 
			`studio404_module_item`, `studio404_module`, `studio404_module_attachment`, `studio404_pages` 
			WHERE 
			`studio404_module_item`.`slug`=:slug AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`status`!=:status AND 
			`studio404_module_item`.`module_idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_attachment`.`idx` AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`connect_idx`=`studio404_pages`.`idx` AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`status`!=:status
			';
            $prepare_module = $conn->prepare($sql_module);
            $prepare_module->execute(array(":slug" => $slugs, ":lang" => LANG_ID, ":status" => 1));
            $nums_module = $prepare_module->rowCount();
            if ($nums_module) {
                $fetch_module = $prepare_module->fetch(PDO::FETCH_ASSOC);
                $out = $fetch_module["module_pagetype"];
            }
        }
        return $out;
    }
Пример #2
0
    public function type_page($c)
    {
        $conn = $this->conn($c);
        //get slug
        $url_controll = new url_controll();
        $slug = $url_controll->slugs();
        try {
            $sql = 'SELECT `page_type` FROM `studio404_pages` WHERE `slug`=:slug AND `status`!=:status';
            $prepare = $conn->prepare($sql);
            $prepare->execute(array(":slug" => $slug, ":status" => 1));
            $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
            $out = $fetch['page_type'];
        } catch (Exception $e) {
            $out = "";
        }
        if (empty($out)) {
            $explode = explode("/", $slug);
            if (is_array($explode)) {
                switch ($explode[0]) {
                    case $c["product.view.pre.slug"]:
                        $out = "product";
                        break;
                    case $c["gallery.view.pre.slug"]:
                        $out = "galleryfolder";
                        break;
                    default:
                        try {
                            $sql = 'SELECT 
						`studio404_module_attachment`.`page_type` AS pgtype 
						FROM 
						`studio404_module_item`, `studio404_module`, `studio404_module_attachment` 
						WHERE 
						studio404_module_item.`slug`=:slug AND 
						`studio404_module_item`.`lang`=:lang AND 
						`studio404_module_item`.`visibility`!=:visibility AND 
						`studio404_module_item`.`status`!=:status AND 
						`studio404_module_item`.`module_idx`=`studio404_module`.`idx` AND 
						`studio404_module`.`lang`=:lang AND 
						`studio404_module`.`status`!=:status AND 
						`studio404_module`.`idx`=`studio404_module_attachment`.`idx` AND 
						`studio404_module_attachment`.`lang`=:lang AND 
						`studio404_module_attachment`.`status`!=:status 
						';
                            $prepare = $conn->prepare($sql);
                            $prepare->execute(array(":slug" => $slug, ":lang" => LANG_ID, ":visibility" => 1, ":status" => 1));
                            if ($slug != "" && $prepare->rowCount() <= 0) {
                                redirect::url(WEBSITE . LANG . "/page404");
                            } else {
                                $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
                                $pgtype = $fetch['pgtype'];
                                if ($pgtype == "newspage") {
                                    $out = "newsinside";
                                } else {
                                    if ($pgtype == "eventpage") {
                                        $out = "eventsinside";
                                    }
                                }
                            }
                        } catch (Exception $e) {
                            redirect::url(WEBSITE . LANG . "/page404");
                        }
                        break;
                }
            } else {
                redirect::url(WEBSITE . LANG . "/page404");
            }
        }
        return $out;
    }