PHP redirect::url方法代码示例

 public function template($c, $page)
 {
     $conn = $this->conn($c);
     $cache = new cache();
     $text_general = $cache->index($c, "text_general");
     $data["text_general"] = json_decode($text_general, true);
     $welcomepage_categories = $cache->index($c, "welcomepage_categories");
     $data["welcomepage_categories"] = json_decode($welcomepage_categories, true);
     /* language variables */
     $language_data = $cache->index($c, "language_data");
     $language_data = json_decode($language_data);
     $model_template_makevars = new model_template_makevars();
     $data["language_data"] = $model_template_makevars->vars($language_data);
     $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id';
     $prepare = $conn->prepare($sql);
     $prepare->execute(array(":id" => $_SESSION["batumi_id"]));
     if ($prepare->rowCount() > 0) {
         $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
         $data["userdata"] = $fetch;
     } else {
         redirect::url(WEBSITE);
     }
     /* catalog list */
     $userlist = $cache->index($c, "userlist");
     $data['userlist'] = json_decode($userlist, true);
     $include = WEB_DIR . "/momxmareblismarTva.php";
     if (file_exists($include)) {
         @(include $include);
     } else {
         $controller = new error_page();
     }
 }

 function __construct($c)
 {
     if (isset($_SESSION["tradewithgeorgia_username"]) || !isset($_GET["rl"]) || !isset($_GET['ui']) || !is_numeric($_GET['ui'])) {
         redirect::url(WEBSITE);
     }
     $this->template($c);
 }

 public function template($c, $page)
 {
     $conn = $this->conn($c);
     $idx = Input::method("GET", "id");
     if (!isset($_SESSION["greek_id"])) {
         redirect::url(WEBSITE . LANG . "/userspage?docid=" . $idx);
     }
     $sql = 'SELECT `document` FROM `studio404_components_inside` WHERE `idx`=:idx AND `lang`=:lang';
     $prepare = $conn->prepare($sql);
     $prepare->execute(array(":idx" => $idx, ":lang" => LANG_ID));
     if ($prepare->rowCount() > 0) {
         $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
         $file = $fetch["document"];
         if (file_exists($file)) {
             $content = file_get_contents($file);
             $name = time() . ".pdf";
             header('Content-Type: application/pdf');
             header('Content-Length: ' . strlen($content));
             header('Content-disposition: inline; filename="' . $name . '"');
             header('Cache-Control: public, must-revalidate, max-age=0');
             header('Pragma: public');
             header('Expires: Sat, 26 Jul 1997 05:00:00 GMT');
             header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
             // output content
             echo $content;
         } else {
             redirect::url(WEBSITE . LANG . "/page404");
         }
     } else {
         redirect::url(WEBSITE . LANG . "/page404");
     }
 }

 function __construct($c)
 {
     if (!Input::method("GET", "id") || !is_numeric(Input::method("GET", "id"))) {
         redirect::url(WEBSITE);
     }
     $this->newsfetch($c);
 }

 public function template($c, $page)
 {
     $conn = $this->conn($c);
     $cache = new cache();
     $text_general = $cache->index($c, "text_general");
     $data["text_general"] = json_decode($text_general, true);
     $welcomepage_categories = $cache->index($c, "welcomepage_categories");
     $data["welcomepage_categories"] = json_decode($welcomepage_categories, true);
     /* language variables */
     $language_data = $cache->index($c, "language_data");
     $language_data = json_decode($language_data);
     $model_template_makevars = new model_template_makevars();
     $data["language_data"] = $model_template_makevars->vars($language_data);
     /* Upload Users profile picture */
     if (isset($_FILES["profileimage"]["name"])) {
         $model_template_upload_user_logo = new model_template_upload_user_logo();
         $upload = $model_template_upload_user_logo->upload($c);
     }
     $sql = 'SELECT `username`,`user_type`,`namelname`,`dob`,`email`,`mobile`,`address`,`picture` FROM `studio404_users` WHERE `id`=:id';
     $prepare = $conn->prepare($sql);
     $prepare->execute(array(":id" => $_SESSION["batumi_id"]));
     if ($prepare->rowCount() > 0) {
         $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
         $data["userdata"] = $fetch;
     } else {
         redirect::url(WEBSITE);
     }
     $include = WEB_DIR . "/profilisredaqtireba.php";
     if (file_exists($include)) {
         @(include $include);
     } else {
         $controller = new error_page();
     }
 }

 public function template($c, $page)
 {
     $conn = $this->conn($c);
     $cache = new cache();
     $text_general = $cache->index($c, "text_general");
     $data["text_general"] = json_decode($text_general, true);
     /* categories list */
     $welcomepage_categories = $cache->index($c, "welcomepage_categories");
     $data["welcomepage_categories"] = json_decode($welcomepage_categories, true);
     /* all columns catalog table */
     $catalog_table_columns = $cache->index($c, "catalog_table_columns");
     $data["catalog_table_columns"] = json_decode($catalog_table_columns, true);
     /* all columns catalog table */
     // $select_form = $cache->index($c,"select_form");
     // $data["select_form"] = json_decode($select_form,true);
     $cid = Input::method("GET", "parent");
     $select_form = new select_form();
     $data["select_form"] = $select_form->form($c, $cid, LANG_ID);
     /* language variables */
     $language_data = $cache->index($c, "language_data");
     $language_data = json_decode($language_data);
     $model_template_makevars = new model_template_makevars();
     $data["language_data"] = $model_template_makevars->vars($language_data);
     $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id';
     $prepare = $conn->prepare($sql);
     $prepare->execute(array(":id" => $_SESSION["batumi_id"]));
     if ($prepare->rowCount() > 0) {
         $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
         $data["userdata"] = $fetch;
     } else {
         redirect::url(WEBSITE);
     }
     if (Input::method("GET", "parent") != "") {
         $parent = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `idx`=:idx AND `cid`=4 AND `status`!=1 AND `lang`=:lang';
         $prepareParent = $conn->prepare($parent);
         $prepareParent->execute(array(":idx" => Input::method("GET", "parent"), ":lang" => LANG_ID));
         if ($prepareParent->rowCount() > 0) {
             $parent_fetch = $prepareParent->fetch(PDO::FETCH_ASSOC);
             $data["parent_idx"] = $parent_fetch["idx"];
             $data["parent_title"] = $parent_fetch["title"];
         } else {
             redirect::url(WEBSITE . LANG . "/katalogis-marTva");
         }
     } else {
         redirect::url(WEBSITE . LANG . "/katalogis-marTva");
     }
     $include = WEB_DIR . "/formismarTva.php";
     if (file_exists($include)) {
         @(include $include);
     } else {
         $controller = new error_page();
     }
 }

    public function template($c, $page)
    {
        $conn = $this->conn($c);
        // connection
        $cache = new cache();
        $welcomepage_categories = $cache->index($c, "welcomepage_categories");
        $data["welcomepage_categories"] = json_decode($welcomepage_categories, true);
        /* language variables */
        $language_data = $cache->index($c, "language_data");
        $language_data = json_decode($language_data);
        $model_template_makevars = new model_template_makevars();
        $data["language_data"] = $model_template_makevars->vars($language_data);
        $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id';
        $prepare = $conn->prepare($sql);
        $prepare->execute(array(":id" => $_SESSION["batumi_id"]));
        if ($prepare->rowCount() > 0) {
            $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
            $data["userdata"] = $fetch;
        } else {
            redirect::url(WEBSITE);
        }
        $sql2 = 'SELECT 
		`studio404_messages`.*, 
		`studio404_users`.`namelname` AS fromusername 
		FROM 
		`studio404_messages`, `studio404_users`
		WHERE 
		`studio404_messages`.`fromuser`="' . $_SESSION["batumi_id"] . '" AND 
		`studio404_messages`.`draft`=1 AND 
		NOT FIND_IN_SET("' . $_SESSION["batumi_id"] . '",`studio404_messages`.`status`) AND 
		`studio404_messages`.`tousers`=`studio404_users`.`id` 
		ORDER BY `studio404_messages`.`date` DESC LIMIT 20';
        $prepare2 = $conn->prepare($sql2);
        $prepare2->execute();
        if ($prepare2->rowCount() > 0) {
            $fetch2 = $prepare2->fetchAll(PDO::FETCH_ASSOC);
            $data["messages"] = $fetch2;
        } else {
            $data["messages"] = array();
        }
        $catalog_general = $cache->index($c, "catalog_general");
        $data["catalog_general"] = json_decode($catalog_general, true);
        $catalogitemsnovisiable = $cache->index($c, "catalogitemsnovisiable");
        $data["catalogitems"] = json_decode($catalogitemsnovisiable, true);
        $include = WEB_DIR . "/draft.php";
        if (file_exists($include)) {
            @(include $include);
        } else {
            $controller = new error_page();
        }
    }

 public function template($c, $page)
 {
     $conn = $this->conn($c);
     $cache = new cache();
     $text_general = $cache->index($c, "text_general");
     $data["text_general"] = json_decode($text_general, true);
     $welcomepage_categories = $cache->index($c, "welcomepage_categories");
     $data["welcomepage_categories"] = json_decode($welcomepage_categories, true);
     /* language variables */
     $language_data = $cache->index($c, "language_data");
     $language_data = json_decode($language_data);
     $model_template_makevars = new model_template_makevars();
     $data["language_data"] = $model_template_makevars->vars($language_data);
     /* Upload Users profile picture */
     if (isset($_FILES["profileimage"]["name"])) {
         $model_template_upload_user_logo = new model_template_upload_user_logo();
         $upload = $model_template_upload_user_logo->upload($c);
     }
     $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id';
     $prepare = $conn->prepare($sql);
     $prepare->execute(array(":id" => $_SESSION["batumi_id"]));
     if ($prepare->rowCount() > 0) {
         $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
         $data["userdata"] = $fetch;
     } else {
         redirect::url(WEBSITE);
     }
     if (Input::method("GET", "parent") != "") {
         $parent = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `idx`=:idx AND `cid`=4 AND `status`!=1 AND `lang`=:lang';
         $prepareParent = $conn->prepare($parent);
         $prepareParent->execute(array(":idx" => Input::method("GET", "parent"), ":lang" => LANG_ID));
         if ($prepareParent->rowCount() > 0) {
             $parent_fetch = $prepareParent->fetch(PDO::FETCH_ASSOC);
             $data["parent_idx"] = $parent_fetch["idx"];
             $data["parent_title"] = $parent_fetch["title"];
         } else {
             redirect::url(WEBSITE . LANG . "/katalogis-marTva/damateba");
         }
     }
     $include = WEB_DIR . "/damateba.php";
     if (file_exists($include)) {
         @(include $include);
     } else {
         $controller = new error_page();
     }
 }

    public function template($c, $page)
    {
        $conn = $this->conn($c);
        // connection
        $cache = new cache();
        $welcomepage_categories = $cache->index($c, "welcomepage_categories");
        $data["welcomepage_categories"] = json_decode($welcomepage_categories, true);
        /* language variables */
        $language_data = $cache->index($c, "language_data");
        $language_data = json_decode($language_data);
        $model_template_makevars = new model_template_makevars();
        $data["language_data"] = $model_template_makevars->vars($language_data);
        $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id';
        $prepare = $conn->prepare($sql);
        $prepare->execute(array(":id" => $_SESSION["batumi_id"]));
        if ($prepare->rowCount() > 0) {
            $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
            $data["userdata"] = $fetch;
        } else {
            redirect::url(WEBSITE);
        }
        $data["cataloglist_names"] = new cataloglist_names();
        $data["getusername"] = new getusername();
        $labellists = new labellists();
        $data["labellists"] = $labellists->loadlabels($c);
        $sql2 = 'SELECT 
		`studio404_module_item`.* 
		FROM `studio404_module_item` WHERE 
		`module_idx`=25 AND 
		`studio404_module_item`.`idx`=:idx AND 
		`studio404_module_item`.`lang`=:lang AND 
		`studio404_module_item`.`status`!=:status';
        $prepare2 = $conn->prepare($sql2);
        $prepare2->execute(array(":idx" => Input::method("GET", "view"), ":lang" => LANG_ID, ":status" => 1));
        if ($prepare2->rowCount() > 0) {
            $data["fetch"] = $prepare2->fetch(PDO::FETCH_ASSOC);
        } else {
            redirect::url(WEBSITE . LANG . "/welcomesystem");
        }
        $include = WEB_DIR . "/monacemisnaxva.php";
        if (file_exists($include)) {
            @(include $include);
        } else {
            $controller = new error_page();
        }
    }

    public function template($c)
    {
        $conn = $this->conn($c);
        // connection
        if (empty(Input::method("GET", "idx"))) {
            redirect::url(WEBSITE . LANG . "/welcomesystem");
        }
        $cache = new cache();
        $welcomepage_categories = $cache->index($c, "welcomepage_categories");
        $data["welcomepage_categories"] = json_decode($welcomepage_categories, true);
        /* language variables */
        $language_data = $cache->index($c, "language_data");
        $language_data = json_decode($language_data);
        $model_template_makevars = new model_template_makevars();
        $data["language_data"] = $model_template_makevars->vars($language_data);
        $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id';
        $prepare = $conn->prepare($sql);
        $prepare->execute(array(":id" => $_SESSION["batumi_id"]));
        if ($prepare->rowCount() > 0) {
            $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
            $data["userdata"] = $fetch;
        } else {
            redirect::url(WEBSITE);
        }
        $catalog_general = $cache->index($c, "catalog_general");
        $data["catalog_general"] = json_decode($catalog_general, true);
        $catalog_table_list = $cache->index($c, "catalog_table_list");
        $data["catalog_table_list"] = json_decode($catalog_table_list, true);
        $catalogitems = $cache->index($c, "catalogitems");
        $data["catalogitems"] = json_decode($catalogitems, true);
        $sql2 = 'SELECT 
		COUNT(`studio404_module_item`.`idx`) AS allitems
		FROM `studio404_module_item` WHERE 
		FIND_IN_SET(' . Input::method("GET", "idx") . ', `studio404_module_item`.`cataloglist`) AND 
		`studio404_module_item`.`lang`=:lang AND 
		`studio404_module_item`.`visibility`!=:visibility AND 
		`studio404_module_item`.`status`!=:status';
        $prepare2 = $conn->prepare($sql2);
        $prepare2->execute(array(":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
        $data["fetch"] = $prepare2->fetch(PDO::FETCH_ASSOC);
        @(include $c["website.directory"] . "/catalog.php");
    }

 public function change($c)
 {
     $conn = $this->conn($c);
     $sql = 'SELECT `id` FROM `studio404_users` WHERE `recover`=:recover AND `id`=:id';
     $prepare = $conn->prepare($sql);
     $prepare->execute(array(":recover" => Input::method("GET", "rl"), ":id" => (int) Input::method("GET", "ui")));
     if ($prepare->rowCount() > 0) {
         if (Input::method("POST", "npassword") && Input::method("POST", "npassword") === Input::method("POST", "cpassword")) {
             $update = 'UPDATE `studio404_users` SET `password`=:password, `recover`=:newrecover WHERE `recover`=:recover AND `id`=:id';
             $prepare2 = $conn->prepare($update);
             $prepare2->execute(array(":password" => md5(Input::method("POST", "npassword")), ":recover" => Input::method("GET", "rl"), ":id" => Input::method("GET", "ui"), ":newrecover" => ''));
             return "Password recovered !";
         } else {
             return "Error";
         }
     } else {
         redirect::url(WEBSITE);
         return false;
     }
 }

    public function template($c, $page)
    {
        $conn = $this->conn($c);
        // connection
        $cache = new cache();
        $welcomepage_categories = $cache->index($c, "welcomepage_categories");
        $data["welcomepage_categories"] = json_decode($welcomepage_categories, true);
        /* language variables */
        $language_data = $cache->index($c, "language_data");
        $language_data = json_decode($language_data);
        $model_template_makevars = new model_template_makevars();
        $data["language_data"] = $model_template_makevars->vars($language_data);
        $sql = 'SELECT `namelname`,`picture` FROM `studio404_users` WHERE `id`=:id';
        $prepare = $conn->prepare($sql);
        $prepare->execute(array(":id" => $_SESSION["batumi_id"]));
        if ($prepare->rowCount() > 0) {
            $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
            $data["userdata"] = $fetch;
        } else {
            redirect::url(WEBSITE);
        }
        $catalog_general = $cache->index($c, "catalog_general");
        $data["catalog_general"] = json_decode($catalog_general, true);
        $catalogitemsnovisiable = $cache->index($c, "catalogitemsnovisiable");
        $data["catalogitems"] = json_decode($catalogitemsnovisiable, true);
        $sql2 = 'SELECT 
		COUNT(`studio404_module_item`.`idx`) AS allitems
		FROM `studio404_module_item` WHERE 
		`studio404_module_item`.`lang`=:lang AND 
		`studio404_module_item`.`visibility`=:visibility AND 
		`studio404_module_item`.`status`!=:status';
        $prepare2 = $conn->prepare($sql2);
        $prepare2->execute(array(":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
        $data["fetch"] = $prepare2->fetch(PDO::FETCH_ASSOC);
        $include = WEB_DIR . "/nebarTvismicema.php";
        if (file_exists($include)) {
            @(include $include);
        } else {
            $controller = new error_page();
        }
    }

 public function select_sub($c)
 {
     $out = array();
     $conn = $this->conn($c);
     if (isset($_GET['footermenu'], $_GET['id']) && is_numeric($_GET['id'])) {
         if ($_GET['footermenu'] == "off") {
             $sqlUpdateFooter = 'UPDATE `studio404_pages` SET `footermenu`=0 WHERE `idx`=:idx';
         } else {
             if ($_GET['footermenu'] == "on") {
                 $sqlUpdateFooter = 'UPDATE `studio404_pages` SET `footermenu`=1 WHERE `idx`=:idx';
             }
         }
         $prepareUpdate = $conn->prepare($sqlUpdateFooter);
         $prepareUpdate->execute(array(":idx" => $_GET['id']));
         $files = glob(DIR . "_cache/*");
         array_map('unlink', $files);
         redirect::url(WEBSITE . LANG . "/" . $c['admin.slug'] . "?action=" . $_GET['action'] . "&super=" . $_GET['super']);
     }
     $sqlCount = 'SELECT COUNT(`id`) AS cc FROM `studio404_pages` WHERE `menu_type`!=:menu_type AND `cid`=:cid AND `status`!=:status AND `lang`=:lang';
     $prepare = $conn->prepare($sqlCount);
     $prepare->execute(array(":cid" => $_GET['super'], ":menu_type" => "super", ":status" => 1, ":lang" => LANG_ID));
     $fetchCount = $prepare->fetch(PDO::FETCH_ASSOC);
     if ($fetchCount["cc"] < 250) {
         $sql = 'SELECT * FROM `studio404_pages` WHERE `menu_type`!=:menu_type AND `cid`=:cid AND `status`!=:status AND `lang`=:lang ORDER BY `position` ASC';
         $exe_array = array(":cid" => $_GET['super'], ":menu_type" => "super", ":status" => 1, ":lang" => LANG_ID);
         $out['table'] = $this->table_sub($c, $sql, $exe_array);
         $out['pager'] = '';
     } else {
         $o = '<div class="TooManyDataElement">';
         $o .= '<div class="row"><span class="cell">Too Many Data To Load ..</span></div>';
         $o .= '</div>';
         $out['table'] = $o;
         $out['pager'] = '';
     }
     $out['count'] = $fetchCount["cc"];
     return $out;
 }

    public function get_users($c)
    {
        if (isset($_GET['visibilitychnage'], $_GET['load'], $_GET["allow"], $_GET['username'])) {
            $conn = $this->conn($c);
            if ($_GET['username'] != "") {
                $replaceUserAt = str_replace("xXx", "@", $_GET['username']);
                $sql = 'UPDATE `studio404_users` SET `allow`=:allow WHERE `username`=:username';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":allow" => (int) $_GET["allow"], ":username" => $replaceUserAt));
                $pn = isset($_GET['pn']) ? $_GET['pn'] : 1;
                redirect::url(WEBSITE . LANG . "/tadmin?action=fusersstat&load=users&pn=" . $pn);
            }
        }
        $out = array();
        $search2 = "";
        if (isset($_GET['search']) && !empty($_GET['search'])) {
            $search = '%' . $_GET['search'] . '%';
            $search2 = $_GET['search'];
            $search_in = ' AND (`studio404_users`.`id`=:search2 OR `studio404_users`.`username` LIKE :search ) ';
        } else {
            $search = 'a';
            $search_in = ' AND `studio404_users`.`id`!=:search AND `studio404_users`.`id`!=:search2';
        }
        /*
        if($rows['company_type']=="manufacturer"){
        			$tocomplete["tocomplete"] = $rows['tocomplete']." ";
        			$typename = "Product";
        		}else if($rows['company_type']=="serviceprovider"){
        */
        $sql = 'SELECT 
			`studio404_users`.*
			FROM 
			`studio404_users`
			WHERE 
			(`studio404_users`.`company_type`=:manufacturer OR `studio404_users`.`company_type`=:serviceprovider) AND 
			`studio404_users`.`user_type`=:website AND 
			`studio404_users`.`status`!=:status ' . $search_in . '
			ORDER BY 
			`studio404_users`.`id` DESC
			';
        $exe_array = array(":manufacturer" => "manufacturer", ":serviceprovider" => "serviceprovider", ":website" => "website", ":status" => 1, ":search" => $search, ":search2" => (int) $search2);
        $path = '?action=fusersstat&load=users&pn=';
        $itemsPerPage = 15;
        $pager = new pager();
        $pager = $pager->action($c, $sql, $exe_array, $path, $itemsPerPage);
        $out['table'] = $this->table($c, $pager[0], $exe_array);
        $out['pager'] = $pager[1];
        return $out;
    }

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