Beispiel #1
0
 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();
     }
 }
Beispiel #2
0
    public function recreate_cache($c, $type, $cache_file)
    {
        $conn = $this->conn($c);
        switch ($type) {
            case "homepage_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                //$slug = "welcome";
                $sql = 'SELECT * FROM `studio404_pages` WHERE `slug`=:slug AND `lang`=:lang AND `visibility`!=:visibility AND `status`!=:status';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "select_form":
                $cid = Input::method("GET", "parent");
                $select_form = new select_form();
                $fetch = $select_form->form($c, $cid, LANG_ID);
                break;
            case "catalog_table_columns":
                $sql = 'SHOW COLUMNS FROM `studio404_module_item`';
                $prepare = $conn->prepare($sql);
                $prepare->execute();
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "catalog_table_list":
                $sql = 'SELECT `attach_column`,`label` FROM `studio404_forms` WHERE `cid`=:cid AND `list`="yes" AND `lang`=:lang ORDER BY `id` ASC';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":cid" => Input::method("GET", "idx"), ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "catalogitems":
                $offset = Input::method("GET", "pn") ? Input::method("GET", "pn") - 1 : 0;
                $sw = Input::method("GET", "sw") && is_numeric(Input::method("GET", "sw")) ? Input::method("GET", "sw") : 10;
                if (!Input::method("GET", "pn") || !is_numeric(Input::method("GET", "pn"))) {
                    $offset = 0;
                }
                $sql = 'SELECT 
			`studio404_module_item`.*
			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 ORDER BY `id` DESC LIMIT ' . $offset . ', ' . $sw;
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "catalogitemsnovisiable":
                $offset = Input::method("GET", "pn") ? Input::method("GET", "pn") - 1 : 0;
                $sw = Input::method("GET", "sw") && is_numeric(Input::method("GET", "sw")) ? Input::method("GET", "sw") : 10;
                if (!Input::method("GET", "pn") || !is_numeric(Input::method("GET", "pn"))) {
                    $offset = 0;
                }
                $sql = 'SELECT 
			`studio404_module_item`.*
			FROM `studio404_module_item` WHERE 
			`module_idx`=25 AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`=:visibility AND 
			`studio404_module_item`.`status`!=:status ORDER BY `id` DESC LIMIT ' . $offset . ', ' . $sw;
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "form":
                $sql = 'SELECT * FROM `studio404_forms` WHERE `cid`=:cid AND `lang`=:lang ORDER BY `id` ASC';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":cid" => Input::method("GET", "parent"), ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "welcomepage_categories":
                $sql = 'SELECT `idx`,`title`,`slug` FROM `studio404_pages` WHERE `cid`=:cid AND `lang`=:lang AND `visibility`!=:visibility AND `status`!=:status ORDER BY `position` ASC';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":cid" => 4, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = array();
                if ($prepare->rowCount() > 0) {
                    $tt = $prepare->fetchAll(PDO::FETCH_ASSOC);
                    foreach ($tt as $value) {
                        $sql2 = 'SELECT `idx`,`cid`,`title`,`slug` FROM `studio404_pages` WHERE `cid`=:cid AND `lang`=:lang AND `visibility`!=:one AND `status`!=:one ORDER BY `position` ASC';
                        $prepare2 = $conn->prepare($sql2);
                        $prepare2->execute(array(":cid" => $value['idx'], ":lang" => LANG_ID, ":one" => 1));
                        $fetch["item"]['idx'][] = $value['idx'];
                        $fetch["item"]['title'][] = $value['title'];
                        $fetch["item"]['slug'][] = $value['slug'];
                        if ($prepare2->rowCount() > 0) {
                            $fetch2 = $prepare2->fetchAll(PDO::FETCH_ASSOC);
                            foreach ($fetch2 as $value2) {
                                $fetch["item"]['sub'][$value['idx']]['idx'][] = $value2['idx'];
                                $fetch["item"]['sub'][$value['idx']]['cid'][] = $value2['cid'];
                                $fetch["item"]['sub'][$value['idx']]['title'][] = $value2['title'];
                                $fetch["item"]['sub'][$value['idx']]['slug'][] = $value2['slug'];
                            }
                        }
                    }
                }
                break;
            case "text_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT * FROM `studio404_pages` WHERE `slug`=:slug AND `lang`=:lang AND `visibility`!=:visibility AND `status`!=:status';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "userlist":
                $sql = 'SELECT `id`,`username`,`namelname`,`email`,`user_type`,`picture` FROM `studio404_users` WHERE `user_type`!="administrator" AND `status`!=1 ORDER BY `id` DESC';
                $prepare = $conn->prepare($sql);
                $prepare->execute();
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "team_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT * FROM `studio404_pages` WHERE `slug`=:slug AND `lang`=:lang AND `visibility`!=:visibility AND `status`!=:status';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "cataloglist":
                $sql = 'SELECT `idx`,`cid`,`title`,`slug`,`position` FROM `studio404_pages` WHERE `cid`=:cid AND `lang`=:lang AND `status`!=1 ORDER BY `position` ASC';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":cid" => 4, ":lang" => LANG_ID));
                if ($prepare->rowCount() > 0) {
                    $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                } else {
                    $fetch = array();
                }
                break;
            case "catalog_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT * FROM `studio404_pages` WHERE `slug`=:slug AND `lang`=:lang AND `visibility`!=:visibility AND `status`!=:status';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "publication_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT * FROM `studio404_pages` WHERE `slug`=:slug AND `lang`=:lang AND `visibility`!=:visibility AND `status`!=:status';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "news_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_module_item`.*, 
			( 
				SELECT `studio404_gallery_file`.`file` FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1 
			) AS pic 
			FROM `studio404_module_item` WHERE 
			`studio404_module_item`.`slug`=:slug AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status ';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'newspage', ":media_type" => 'photo', ":slug" => $slug, ":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "news_list":
                $sql = 'SELECT 
			`studio404_module_item`.*, 
			( 
				SELECT `studio404_gallery_file`.`file` FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1 
			) AS pic 
			FROM 
			`studio404_pages`,`studio404_module_attachment`, `studio404_module`, `studio404_module_item` 
			WHERE 
			`studio404_pages`.`page_type`=:pagetype AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`date` DESC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'newspage', ":media_type" => 'photo', ":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "event_list":
                $sql = 'SELECT 
			`studio404_module_item`.*, 
			( 
				SELECT `studio404_gallery_file`.`file` FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1 
			) AS pic 
			FROM 
			`studio404_pages`,`studio404_module_attachment`, `studio404_module`, `studio404_module_item` 
			WHERE 
			`studio404_pages`.`page_type`=:pagetype AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`date` DESC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'eventpage', ":media_type" => 'photo', ":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "team_list":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_module_item`.`idx` AS smi_idx, 
			`studio404_module_item`.`title` AS namelname 
			FROM 
			`studio404_pages`, `studio404_module_attachment`, `studio404_module`, `studio404_module_item`  
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":media_type" => 'photo', ":media_type_doc" => 'document', ":pagetype" => 'teampage', ":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                // $fetch = $prepare->fetchAll(PDO::FETCH_CLASS,'db_team');
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "catalog_list":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_module_item`.*, 
			(
				SELECT 
				`studio404_gallery_file`.`file` 
				FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`media_type`=:media_type AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1
			) AS pic, 
			(
				SELECT 
				`studio404_gallery_file`.`file` 
				FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type_doc AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1
			) AS doc  
			FROM 
			`studio404_pages`, `studio404_module_attachment`, `studio404_module`, `studio404_module_item`  
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'catalogpage', ":media_type" => 'photo', ":media_type_doc" => 'document', ":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "catalog_info_comments_list":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_module_item`.`idx` AS smi_idx,  
			`studio404_module_item`.`uid` AS smi_uid,  
			`studio404_module_item`.`date` AS smi_date,  
			`studio404_module_item`.`module_idx` AS smi_module_idx,  
			`studio404_module_item`.`title` AS smi_title,  
			`studio404_module_item`.`short_description` AS smi_short_description,  
			`studio404_module_item`.`long_description` AS smi_long_description,  
			`studio404_module_item`.`tags` AS smi_tags,  
			`studio404_module_item`.`slug` AS smi_slug   
			FROM 
			`studio404_pages`, `studio404_module_attachment`, `studio404_module`, `studio404_module_item`  
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'catalogpage', ":media_type" => 'photo', ":media_type_doc" => 'document', ":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_CLASS, "db_catalog");
                break;
            case "publication_list":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_module_item`.*, 
			(
				SELECT 
				`studio404_gallery_file`.`file` 
				FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1
			) AS pic, 
			(
				SELECT 
				`studio404_gallery_file`.`file` 
				FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type_doc AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1
			) AS doc   
			FROM 
			`studio404_pages`, `studio404_module_attachment`, `studio404_module`, `studio404_module_item`  
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'publicationpage', ":media_type" => 'photo', ":media_type_doc" => 'document', ":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "homepage_files":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_gallery_file`.*
			FROM 
			`studio404_pages`,`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND 
			`studio404_gallery_attachment`.`lang`=:lang AND 
			`studio404_gallery_attachment`.`status`!=:status AND 
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
			`studio404_gallery`.`lang`=:lang AND 
			`studio404_gallery`.`status`!=:status AND 
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
			`studio404_gallery_file`.`media_type`=:media_type AND 
			`studio404_gallery_file`.`lang`=:lang AND 
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":media_type" => 'photo', ":slug" => $slug, ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "text_files":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_pages`.`idx` as midx, 
			`studio404_gallery_file`.*
			FROM 
			`studio404_pages`,`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND 
			`studio404_pages`.`page_type`=`studio404_gallery_attachment`.`pagetype` AND 
			`studio404_gallery_attachment`.`lang`=:lang AND 
			`studio404_gallery_attachment`.`status`!=:status AND 
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
			`studio404_gallery`.`lang`=:lang AND 
			`studio404_gallery`.`status`!=:status AND 
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
			`studio404_gallery_file`.`media_type`=:media_type AND 
			`studio404_gallery_file`.`lang`=:lang AND 
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":media_type" => 'photo', ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "last_news_files":
                $sql = 'SELECT 
			`studio404_module_item`.* 
			FROM 
			`studio404_pages`,`studio404_module_attachment`, `studio404_module`, `studio404_module_item` 
			WHERE 
			`studio404_pages`.`page_type`=:pagetype AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`date` DESC LIMIT 1
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'newspage', ":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
                $f = $prepare->fetchAll(PDO::FETCH_ASSOC);
                $slug = $f[0]["slug"];
                $sql = 'SELECT 
			`studio404_gallery_file`.*
			FROM 
			`studio404_module_item`,`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
			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`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND 
			`studio404_gallery_attachment`.`pagetype`="newspage" AND 
			`studio404_gallery_attachment`.`lang`=:lang AND 
			`studio404_gallery_attachment`.`status`!=:status AND 
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
			`studio404_gallery`.`lang`=:lang AND 
			`studio404_gallery`.`status`!=:status AND 
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
			`studio404_gallery_file`.`media_type`=:media_type AND 
			`studio404_gallery_file`.`lang`=:lang AND 
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":media_type" => 'photo', ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "news_files":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_gallery_file`.*
			FROM 
			`studio404_module_item`,`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
			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`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND 
			`studio404_gallery_attachment`.`pagetype`="newspage" AND 
			`studio404_gallery_attachment`.`lang`=:lang AND 
			`studio404_gallery_attachment`.`status`!=:status AND 
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
			`studio404_gallery`.`lang`=:lang AND 
			`studio404_gallery`.`status`!=:status AND 
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
			`studio404_gallery_file`.`media_type`=:media_type AND 
			`studio404_gallery_file`.`lang`=:lang AND 
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":media_type" => 'photo', ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "text_documents":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_pages`.`idx` as midx, 
			`studio404_gallery_file`.*
			FROM 
			`studio404_pages`,`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND 
			`studio404_pages`.`page_type`=`studio404_gallery_attachment`.`pagetype` AND 
			`studio404_gallery_attachment`.`lang`=:lang AND 
			`studio404_gallery_attachment`.`status`!=:status AND 
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
			`studio404_gallery`.`lang`=:lang AND 
			`studio404_gallery`.`status`!=:status AND 
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
			`studio404_gallery_file`.`media_type`=:media_type AND 
			`studio404_gallery_file`.`lang`=:lang AND 
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":media_type" => 'document', ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "news_documents":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_gallery_file`.*
			FROM 
			`studio404_module_item`,`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
			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`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND 
			`studio404_gallery_attachment`.`pagetype`="newspage" AND 
			`studio404_gallery_attachment`.`lang`=:lang AND 
			`studio404_gallery_attachment`.`status`!=:status AND 
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
			`studio404_gallery`.`lang`=:lang AND 
			`studio404_gallery`.`status`!=:status AND 
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
			`studio404_gallery_file`.`media_type`=:media_type AND 
			`studio404_gallery_file`.`lang`=:lang AND 
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":media_type" => 'document', ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "components":
                $sql = 'SELECT 
			`studio404_components`.`name` AS com_name,  
			`studio404_components_inside`.* 
			FROM 
			`studio404_components`,`studio404_components_inside`
			WHERE 
			`studio404_components`.`status`!=:status AND 
			`studio404_components`.`id`=`studio404_components_inside`.`cid` AND  
			`studio404_components_inside`.`lang`=:lang AND  
			`studio404_components_inside`.`status`!=:status 
			ORDER BY `studio404_components_inside`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":status" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "languages":
                $sql = 'SELECT * FROM `studio404_language` WHERE `status`=:status AND `variable`=:false';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":status" => 1, ":false" => 'false'));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "language_data":
                $sql = 'SELECT * FROM `studio404_language` WHERE `status`!=:status AND `variable`!=:false AND `langs`=:lang';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":status" => 1, ":false" => 'false', ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "main_menu":
                $sql = 'SELECT * FROM `studio404_pages` WHERE `status`!=:status AND `menu_type`!=:super AND `lang`=:lang AND `visibility`!=:visibility AND `cid`=:cid ORDER BY `position` ASC';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":status" => 1, ":super" => 'super', ":lang" => LANG_ID, ":visibility" => 1, ":cid" => 1));
                $f = $prepare->fetchAll(PDO::FETCH_ASSOC);
                $fetch = $this->sub_menu($c, $f);
                break;
            case "structure":
                $sql = 'SELECT `idx`,`title`,`shorttitle` FROM `studio404_pages` WHERE `status`!=:status AND `menu_type`!=:super AND `lang`=:lang AND `visibility`!=:visibility AND `cid`=:cid ORDER BY `position` ASC';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":status" => 1, ":super" => 'super', ":lang" => LANG_ID, ":visibility" => 1, ":cid" => 46));
                $fetch = $prepare->fetchAll(PDO::FETCH_CLASS, "db_structure");
                break;
            case "left_menu":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT `idx`,`cid` FROM `studio404_pages` WHERE `slug`=:slug AND `status`!=:status AND `menu_type`!=:super AND `lang`=:lang AND `visibility`!=:visibility ORDER BY `position` ASC ';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":status" => 1, ":super" => 'super', ":lang" => LANG_ID, ":visibility" => 1, ":slug" => $slug));
                $f = $prepare->fetch(PDO::FETCH_ASSOC);
                if ($prepare->rowCount() <= 0) {
                    $sql3 = 'SELECT 
				`studio404_pages`.`cid` AS cid
				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`.`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 AND  
				`studio404_module_attachment`.`connect_idx`=`studio404_pages`.`idx` AND  
				`studio404_pages`.`lang`=:lang AND  
				`studio404_pages`.`visibility`!=:visibility AND  
				`studio404_pages`.`status`!=:status 
				';
                    $prepare3 = $conn->prepare($sql3);
                    $prepare3->execute(array(":slug" => $slug, ":lang" => LANG_ID, ":visibility" => 1, ":status" => 1));
                    $f = $prepare3->fetchAll(PDO::FETCH_ASSOC);
                    $f = $f[0];
                }
                $sql2 = 'SELECT * FROM `studio404_pages` WHERE `cid`=:cid AND `status`!=:status AND `menu_type`!=:super AND `lang`=:lang AND `visibility`!=:visibility ORDER BY `position` ASC';
                $prepare2 = $conn->prepare($sql2);
                $prepare2->execute(array(":status" => 1, ":super" => 'super', ":lang" => LANG_ID, ":visibility" => 1, ":cid" => $f['idx']));
                $fetch = $prepare2->fetchAll(PDO::FETCH_ASSOC);
                if ($prepare2->rowCount() <= 0) {
                    $sql3 = 'SELECT * FROM `studio404_pages` WHERE `cid`=:cid AND `status`!=:status AND `menu_type`!=:super AND `lang`=:lang AND `visibility`!=:visibility ORDER BY `position` ASC';
                    $prepare3 = $conn->prepare($sql3);
                    $prepare3->execute(array(":status" => 1, ":super" => 'super', ":lang" => LANG_ID, ":visibility" => 1, ":cid" => $f['cid']));
                    $fetch = $prepare3->fetchAll(PDO::FETCH_ASSOC);
                }
                break;
            case "multimedia":
                $sql = 'SELECT 
			`studio404_gallery_file`.*, `studio404_gallery_file`.`gallery_idx` as x
			FROM 
			`studio404_pages`,`studio404_media_attachment`,`studio404_media`,`studio404_media_item`,`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
			WHERE 
			`studio404_pages`.`page_type`=:videogallery AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_media_attachment`.`connect_idx` AND 
			`studio404_media_attachment`.`lang`=:lang AND 
			`studio404_media_attachment`.`status`!=:status AND 
			`studio404_media_attachment`.`idx`=`studio404_media`.`idx` AND 
			`studio404_media`.`lang`=:lang AND 
			`studio404_media`.`status`!=:status AND 
			`studio404_media`.`idx`=`studio404_media_item`.`media_idx` AND 
			`studio404_media_item`.`lang`=:lang AND 
			`studio404_media_item`.`visibility`!=:visibility AND 
			`studio404_media_item`.`status`!=:status AND 
			`studio404_media_item`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND 
			`studio404_gallery_attachment`.`pagetype`=:videogallery AND 
			`studio404_gallery_attachment`.`lang`=:lang AND 
			`studio404_gallery_attachment`.`status`!=:status AND 
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
			`studio404_gallery`.`lang`=:lang AND 
			`studio404_gallery`.`status`!=:status AND 
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
			`studio404_gallery_file`.`lang`=:lang AND 
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 2
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":videogallery" => 'videogallerypage', ":lang" => LANG_ID, ":visibility" => 1, ":status" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "news":
                $sql = 'SELECT 
			`studio404_module_item`.*
			FROM 
			`studio404_pages`,`studio404_module_attachment`, `studio404_module`, `studio404_module_item` 
			WHERE 
			`studio404_pages`.`page_type`=:pagetype AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`date` DESC LIMIT 15 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'newspage', ":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "events":
                $sql = 'SELECT 
			`studio404_module_item`.*, 
			( 
				SELECT `studio404_gallery_file`.`file` FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1
			) AS pic 
			FROM 
			`studio404_pages`,`studio404_module_attachment`, `studio404_module`, `studio404_module_item` 
			WHERE 
			`studio404_pages`.`page_type`=:pagetype AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`date` DESC LIMIT 15 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'eventpage', ":media_type" => 'photo', ":lang" => LANG_ID, ":status" => 1, ":visibility" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "events_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_module_item`.* 
			FROM 
			`studio404_pages`, `studio404_module_attachment`, `studio404_module`, `studio404_module_item` 
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:page_type AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status ORDER BY `studio404_module_item`.`date` DESC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'eventpage', ":media_type" => 'photo', ":slug" => $slug, ":lang" => LANG_ID, ":visibility" => 1, ":status" => 1, ":page_type" => 'eventpage'));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "eventsinside_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT `studio404_module_item`.*,
			( 
				SELECT `studio404_gallery_file`.`file` FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_module_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:pagetype AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1
			) AS pic 
			FROM `studio404_module_item` WHERE 
			`studio404_module_item`.`slug`=:slug AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":pagetype" => 'eventpage', ":media_type" => 'photo', ":slug" => $slug, ":lang" => LANG_ID, ":visibility" => 1, ":status" => 1));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "photo_gallery_list":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_gallery_attachment`.`idx` AS smi_idx, 
			`studio404_media_item`.`slug` AS smi_slug, 
			`studio404_media_item`.`title` AS sg_title, 
			(
				SELECT 
				`studio404_gallery_file`.`file` 
				FROM 
				`studio404_gallery_attachment`,`studio404_gallery`,`studio404_gallery_file` 
				WHERE 
				`studio404_gallery_attachment`.`connect_idx`=`studio404_media_item`.`idx` AND 
				`studio404_gallery_attachment`.`pagetype`=:page_type AND 
				`studio404_gallery_attachment`.`lang`=:lang AND 
				`studio404_gallery_attachment`.`status`!=:status AND 
				`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
				`studio404_gallery`.`lang`=:lang AND 
				`studio404_gallery`.`status`!=:status AND 
				`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND 
				`studio404_gallery_file`.`media_type`=:media_type AND 
				`studio404_gallery_file`.`lang`=:lang AND 
				`studio404_gallery_file`.`status`!=:status 
				ORDER BY `studio404_gallery_file`.`position` ASC LIMIT 1
			) AS pic 
			FROM 
			`studio404_pages`, `studio404_media_attachment`, `studio404_media`, `studio404_media_item`, `studio404_gallery_attachment`, `studio404_gallery` 
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_media_attachment`.`connect_idx` AND 
			`studio404_media_attachment`.`page_type`=:page_type AND 
			`studio404_media_attachment`.`lang`=:lang AND 
			`studio404_media_attachment`.`status`!=:status AND 
			`studio404_media_attachment`.`idx`=`studio404_media`.`idx` AND 
			`studio404_media`.`lang`=:lang AND 
			`studio404_media`.`status`!=:status AND 
			`studio404_media`.`idx`=`studio404_media_item`.`media_idx` AND 
			`studio404_media_item`.`lang`=:lang AND 
			`studio404_media_item`.`visibility`!=:visibility AND 
			`studio404_media_item`.`status`!=:status AND 
			`studio404_media_item`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND 
			`studio404_gallery_attachment`.`pagetype`=:page_type AND 
			`studio404_gallery_attachment`.`lang`=:lang AND 
			`studio404_gallery_attachment`.`status`!=:status AND 
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND 
			`studio404_gallery`.`lang`=:lang AND 
			`studio404_gallery`.`status`!=:status ORDER BY `studio404_media_item`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":lang" => LANG_ID, ":visibility" => 1, ":status" => 1, ":page_type" => 'photogallerypage', ":media_type" => 'photo'));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "files_":
                // $get_slug_from_url = new get_slug_from_url();
                // $slug = $get_slug_from_url->slug();
                if (Input::method("GET", "slug")) {
                    $slug = Input::method("GET", "slug");
                } else {
                    $cache = new cache();
                    $photo_gallery_list = $cache->index($c, "photo_gallery_list");
                    $data["photo_gallery_list"] = json_decode($photo_gallery_list);
                    $slug = $data["photo_gallery_list"][0]->smi_slug;
                }
                $sql = 'SELECT 
			`studio404_gallery_file`.* 
			FROM 
			`studio404_media_item`, `studio404_gallery_attachment`, `studio404_gallery`, `studio404_gallery_file` 
			WHERE 
			`studio404_media_item`.`slug`=:slug AND 
			`studio404_media_item`.`lang`=:lang AND 
			`studio404_media_item`.`visibility`!=:visibility AND 
			`studio404_media_item`.`status`!=:status AND 
			`studio404_media_item`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND  
			`studio404_gallery_attachment`.`pagetype`=:pagetype AND  
			`studio404_gallery_attachment`.`lang`=:lang AND  
			`studio404_gallery_attachment`.`status`!=:status AND  
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND   
			`studio404_gallery`.`lang`=:lang AND   
			`studio404_gallery`.`status`!=:status AND   
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND   
			`studio404_gallery_file`.`media_type`=:media_type AND   
			`studio404_gallery_file`.`lang`=:lang AND   
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC   
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":lang" => LANG_ID, ":visibility" => 1, ":status" => 1, ":pagetype" => 'photogallerypage', ":media_type" => 'photo'));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "videogallery_general":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $sql = 'SELECT 
			`studio404_gallery_file`.* 
			FROM 
			`studio404_pages`,`studio404_media_attachment`,`studio404_media`,`studio404_media_item`,`studio404_gallery_attachment`, `studio404_gallery`, `studio404_gallery_file` 
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND  
			`studio404_pages`.`visibility`!=:visibility AND  
			`studio404_pages`.`status`!=:status AND  
			`studio404_pages`.`idx`=`studio404_media_attachment`.`connect_idx` AND  
			`studio404_media_attachment`.`lang`=:lang AND  
			`studio404_media_attachment`.`status`!=:status AND  
			`studio404_media_attachment`.`idx`=`studio404_media`.`idx` AND  
			`studio404_media`.`lang`=:lang AND  
			`studio404_media`.`status`!=:status AND   
			`studio404_media`.`idx`=`studio404_media_item`.`media_idx` AND   
			`studio404_media_item`.`lang`=:lang AND 
			`studio404_media_item`.`visibility`!=:visibility AND 
			`studio404_media_item`.`status`!=:status AND 
			`studio404_media_item`.`idx`=`studio404_gallery_attachment`.`connect_idx` AND  
			`studio404_gallery_attachment`.`pagetype`=:pagetype AND  
			`studio404_gallery_attachment`.`lang`=:lang AND  
			`studio404_gallery_attachment`.`status`!=:status AND  
			`studio404_gallery_attachment`.`idx`=`studio404_gallery`.`idx` AND   
			`studio404_gallery`.`lang`=:lang AND   
			`studio404_gallery`.`status`!=:status AND   
			`studio404_gallery`.`idx`=`studio404_gallery_file`.`gallery_idx` AND   
			`studio404_gallery_file`.`media_type`=:media_type AND   
			`studio404_gallery_file`.`lang`=:lang AND   
			`studio404_gallery_file`.`status`!=:status 
			ORDER BY `studio404_gallery_file`.`position` ASC   
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":slug" => $slug, ":lang" => LANG_ID, ":visibility" => 1, ":status" => 1, ":pagetype" => 'videogallerypage', ":media_type" => 'video'));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "breadcrups":
                $get_slug_from_url = new get_slug_from_url();
                $slug = $get_slug_from_url->slug();
                $fetch = $this->breakcrups($c, $slug);
                break;
            case "sector":
                $sectors_subsectors_products = new sectors_subsectors_products();
                $fetch = $sectors_subsectors_products->sectors($c);
                break;
            case "subsector":
                $sectors_subsectors_products = new sectors_subsectors_products();
                $fetch = $sectors_subsectors_products->subsector($c);
                break;
            case "products":
                $sectors_subsectors_products = new sectors_subsectors_products();
                $fetch = $sectors_subsectors_products->products($c);
                break;
            case "countries":
                $sectors_subsectors_products = new sectors_subsectors_products();
                $fetch = $sectors_subsectors_products->countries($c);
                break;
            case "certificates":
                $sectors_subsectors_products = new sectors_subsectors_products();
                $fetch = $sectors_subsectors_products->certificates($c);
                break;
            case "companysize":
                $sectors_subsectors_products = new sectors_subsectors_products();
                $fetch = $sectors_subsectors_products->companysize($c);
                break;
            case "hidden_team_list":
                $sql = 'SELECT 
			`studio404_module_item`.`idx` AS smi_idx, 
			`studio404_module_item`.`title` AS namelname 
			FROM 
			`studio404_pages`, `studio404_module_attachment`, `studio404_module`, `studio404_module_item`  
			WHERE 
			`studio404_pages`.`slug`=:slug AND 
			`studio404_pages`.`lang`=:lang AND 
			`studio404_pages`.`visibility`!=:visibility AND 
			`studio404_pages`.`status`!=:status AND 
			`studio404_pages`.`idx`=`studio404_module_attachment`.`connect_idx` AND 
			`studio404_module_attachment`.`page_type`=:pagetype AND 
			`studio404_module_attachment`.`lang`=:lang AND 
			`studio404_module_attachment`.`status`!=:status AND 
			`studio404_module_attachment`.`idx`=`studio404_module`.`idx` AND 
			`studio404_module`.`lang`=:lang AND 
			`studio404_module`.`status`!=:status AND 
			`studio404_module`.`idx`=`studio404_module_item`.`module_idx` AND 
			`studio404_module_item`.`lang`=:lang AND 
			`studio404_module_item`.`visibility`!=:visibility AND 
			`studio404_module_item`.`status`!=:status 
			ORDER BY `studio404_module_item`.`position` ASC 
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":media_type" => 'photo', ":media_type_doc" => 'document', ":pagetype" => 'catalogpage', ":slug" => 'team', ":status" => 1, ":visibility" => 1, ":lang" => LANG_ID));
                $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                break;
            case "productinside":
                $sql = 'SELECT 
			`studio404_module_item`.*, 
			(SELECT `studio404_users`.`company_type` FROM `studio404_users` WHERE `studio404_users`.`id`=`studio404_module_item`.`insert_admin`) AS com_type, 
			(SELECT `studio404_users`.`namelname` FROM `studio404_users` WHERE `studio404_users`.`id`=`studio404_module_item`.`insert_admin`) AS com_name, 
			(SELECT `studio404_pages`.`title` FROM `studio404_pages` WHERE `studio404_pages`.`idx`=`studio404_module_item`.`hscode`) AS hscode_title 
			FROM 
			 `studio404_module_item`
			 WHERE 
			 `studio404_module_item`.`insert_admin`=' . (int) Input::method("GET", "i") . ' AND 
			 `studio404_module_item`.`id`=' . (int) Input::method("GET", "p") . ' AND 
			 `studio404_module_item`.`status`!=:one
			';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":one" => 1));
                if ($prepare->rowCount() > 0) {
                    $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
                    //$picture = ($fetch["picture"]) ? WEBSITE.'image?f='.WEBSITE.'files/usersproducts/'.$fetch["picture"].'&w=175&h=175' : '';
                }
                break;
        }
        if (count($fetch)) {
            $fh = @fopen($cache_file, 'w') or die("Error opening output file");
            @fwrite($fh, json_encode($fetch, JSON_UNESCAPED_UNICODE));
            @fclose($fh);
        }
    }
Beispiel #3
0
    public function requests($c)
    {
        // .catalog-add-form-data .form-input
        // #add-catalogue-item
        $conn = $this->conn($c);
        if (Input::method("POST", "checknotification") == "true" && $_SESSION["batumi_id"]) {
            $cachfile = "_cache/notifications_" . $_SESSION["batumi_id"] . ".json";
            if (file_exists($cachfile)) {
                echo file_get_contents($cachfile);
            } else {
                $session_id = $_SESSION['batumi_id'];
                $select = 'SELECT 
				`studio404_notifications`.*, 
				(SELECT `studio404_users`.`namelname` FROM `studio404_users` WHERE `studio404_users`.`id`=`studio404_notifications`.`actionuserid`) AS usersnamelname,  
				(SELECT `studio404_users`.`picture` FROM `studio404_users` WHERE `studio404_users`.`id`=`studio404_notifications`.`actionuserid`) AS userspicture 
				FROM 
				`studio404_notifications` 
				WHERE 
				NOT FIND_IN_SET(' . $session_id . ',`studio404_notifications`.`seen`) AND 
				`studio404_notifications`.`actionuserid`!=:actionuserid AND 
				(`studio404_notifications`.`touserids`="nope" || FIND_IN_SET(' . $session_id . ',`studio404_notifications`.`touserids`)) 
				ORDER BY `studio404_notifications`.`id` ASC 
				';
                $prepare = $conn->prepare($select);
                $prepare->execute(array(":actionuserid" => $session_id));
                if ($prepare->rowCount() > 0) {
                    $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
                    $fh = @fopen($cachfile, 'w') or die("Error opening output file");
                    @fwrite($fh, json_encode($fetch, JSON_UNESCAPED_UNICODE));
                    @fclose($fh);
                    echo file_get_contents($cachfile);
                } else {
                    echo "Error";
                }
            }
            exit;
        }
        if (Input::method("POST", "loadcatalogform") == "true" && Input::method("POST", "v")) {
            $sql = 'SELECT * FROM `studio404_forms` WHERE `cid`=:cid AND `lang`=:lang ORDER BY `id` ASC';
            $prepare = $conn->prepare($sql);
            $prepare->execute(array(":cid" => Input::method("POST", "v"), ":lang" => 1));
            $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
            echo "<div style='text-align:left' class='catalog-add-form-data'>";
            $select_form = new select_form();
            $file_count = 0;
            foreach ($fetch as $form) {
                if ($form["type"] == "text") {
                    if ($form["important"] == "yes") {
                        $dataimportant = "data-important='true'";
                    } else {
                        $dataimportant = "data-important='false'";
                    }
                    ?>
	            <div class="form-group">
	               <label><?php 
                    echo $form["label"];
                    ?>
: <?php 
                    echo $form["important"] == "yes" ? '<font color="red">*</font>' : '';
                    ?>
</label> <!-- Fisrname & lastname -->
	               <input class="form-control form-input" type="text" placeholder="<?php 
                    echo $form["placeholder"];
                    ?>
" data-name="<?php 
                    echo $form["name"];
                    ?>
" data-attach="<?php 
                    echo $form["attach_column"];
                    ?>
" data-type="text" data-important="<?php 
                    echo $form["important"];
                    ?>
" value="" />
	               </div>
            <?php 
                } else {
                    if ($form["type"] == "select") {
                        $fetchx = $select_form->select_options($c, $form["id"], Input::method("POST", "v"), 1);
                        ?>
            <div class="form-group">
	            <label><?php 
                        echo $form["label"];
                        ?>
: <?php 
                        echo $form["important"] == "yes" ? '<font color="red">*</font>' : '';
                        ?>
</label> <!-- Fisrname & lastname -->
	            <select class="form-control form-input" data-name="<?php 
                        echo $form["name"];
                        ?>
" data-attach="<?php 
                        echo $form["attach_column"];
                        ?>
" data-important="<?php 
                        echo $form["important"];
                        ?>
" data-type="select">
				<?php 
                        foreach ($fetchx as $value) {
                            echo '<option value="' . htmlentities($value["text"]) . '">' . $value["text"] . '</option>';
                        }
                        ?>
			</select>
	        </div>
            <?php 
                    } else {
                        if ($form["type"] == "checkbox") {
                            ?>
            <div class="form-group">
	        <label><?php 
                            echo $form["label"];
                            ?>
: <?php 
                            echo $form["important"] == "yes" ? '<font color="red">*</font>' : '';
                            ?>
</label> <!-- Fisrname & lastname -->
	        <?php 
                            $fetchx = $select_form->select_options($c, $form["id"], Input::method("POST", "v"), 1);
                            foreach ($fetchx as $value) {
                                echo '<div class="checkbox">';
                                echo '<label><input type="checkbox" class="form-input" data-name="' . $form["name"] . '" data-attach="' . $form["attach_column"] . '" data-important="' . $form["important"] . '" data-type="checkbox" value="' . htmlentities($value["text"]) . '" />' . $value["text"] . '</label>';
                                echo '</div>';
                            }
                            ?>
	        </div>
            <?php 
                        } else {
                            if ($form["type"] == "filex") {
                                // not signed cant upload
                                $multiple = "";
                                // not signed cant upload multy
                                $fileformat = $form["attach_format"];
                                $fileformat = explode(",", $form["attach_format"]);
                                $accept = "";
                                foreach ($fileformat as $value) {
                                    $accept .= "." . $value . ",";
                                }
                                ?>
            	<label><?php 
                                echo $form["label"];
                                ?>
: <?php 
                                echo $multiple == "multiple" ? '<a href="javascript:void(0)" class="makemedouble" data-doubleid="form-name-' . $file_count . '" data-filename="file[' . $file_count . '][]" data-fileaccept="' . $accept . '"><i class="glyphicon glyphicon-plus-sign"></i></a>' : '';
                                echo $form["important"] == "yes" ? '<font color="red">*</font>' : '';
                                ?>
 ( <?php 
                                echo $form["attach_format"];
                                ?>
 )</label> <!-- Fisrname & lastname -->
        		<input type="hidden" name="file" value="true" />
        		<input type="hidden" name="filenumber[<?php 
                                echo $file_count;
                                ?>
]" value="<?php 
                                echo $file_count;
                                ?>
" />
        		<input type="hidden" name="form-name-<?php 
                                echo $file_count;
                                ?>
" value="<?php 
                                echo $form["name"];
                                ?>
" />
        		<input type="hidden" name="form-attach-<?php 
                                echo $file_count;
                                ?>
" value="<?php 
                                echo $form["attach_column"];
                                ?>
" />
        		<input type="hidden" name="form-important-<?php 
                                echo $file_count;
                                ?>
" value="<?php 
                                echo $form["important"];
                                ?>
" />
        		<input type="hidden" name="form-multiple-<?php 
                                echo $file_count;
                                ?>
" value="<?php 
                                echo $multiple;
                                ?>
" />
        		<input type="hidden" name="form-format-<?php 
                                echo $file_count;
                                ?>
" value="<?php 
                                echo $form["attach_format"];
                                ?>
" />
        		<?php 
                                if ($multiple) {
                                    echo '<span id="form-name-' . $file_count . '"><input class="form-control form-input" type="file" name="file[' . $file_count . '][]" value="" accept="' . $accept . '" /></span>';
                                } else {
                                    ?>
        			<input class="form-control form-input" type="file" name="file[<?php 
                                    echo $file_count;
                                    ?>
][]" value="" accept="<?php 
                                    echo $accept;
                                    ?>
" />
        		<?php 
                                }
                                ?>
	            <!-- <div class="form-group">
		        	<label><?php 
                                echo $form["label"];
                                ?>
: <?php 
                                echo $form["important"] == "yes" ? '<font color="red">*</font>' : '';
                                ?>
</label> 
		        	<input class="form-control form-input" type="file" data-name="<?php 
                                echo $form["name"];
                                ?>
" data-attach="<?php 
                                echo $form["attach_column"];
                                ?>
" data-type="file" data-important="<?php 
                                echo $form["important"];
                                ?>
" data-multiple="<?php 
                                echo $multiple;
                                ?>
" data-formatsx="<?php 
                                echo $form["attach_format"];
                                ?>
" value="" <?php 
                                echo $multiple;
                                ?>
/>
		        </div> -->
            <?php 
                            } else {
                                if ($form["type"] == "date") {
                                    ?>
            <div class="form-group">
	        <label><?php 
                                    echo $form["label"];
                                    ?>
: <?php 
                                    echo $form["important"] == "yes" ? '<font color="red">*</font>' : '';
                                    ?>
</label> <!-- Fisrname & lastname -->
	        <input type="text" class="form-control form-input" data-inputmask="'alias': 'dd/mm/yyyy'" data-mask="" data-name="<?php 
                                    echo $form["name"];
                                    ?>
" data-attach="<?php 
                                    echo $form["attach_column"];
                                    ?>
" data-important="<?php 
                                    echo $form["important"];
                                    ?>
" data-type="date" value="dd/mm/YYYY" />
	        </div>
            <?php 
                                } else {
                                    if ($form["type"] == "textarea") {
                                        ?>
            <div class="form-group">
	        <label><?php 
                                        echo $form["label"];
                                        ?>
: <?php 
                                        echo $form["important"] == "yes" ? '<font color="red">*</font>' : '';
                                        ?>
</label> <!-- Fisrname & lastname -->
	        <textarea class="form-control form-input" data-name="<?php 
                                        echo $form["name"];
                                        ?>
" data-attach="<?php 
                                        echo $form["attach_column"];
                                        ?>
" data-type="textarea" data-important="<?php 
                                        echo $form["important"];
                                        ?>
"></textarea>
	        </div>
            <?php 
                                    }
                                }
                            }
                        }
                    }
                }
                $file_count++;
            }
            echo '</div>';
            exit;
        }
        if (Input::method("POST", "deleteGalleryItem") == "true" && is_numeric(Input::method("POST", "i"))) {
            $sql = 'SELECT `file` FROM `studio404_gallery_file` WHERE `idx`=:idx';
            $prepare = $conn->prepare($sql);
            $prepare->execute(array(":idx" => Input::method("POST", "i")));
            if ($prepare->rowCount() > 0) {
                $update = 'UPDATE `studio404_gallery_file` SET `status`=:status WHERE `idx`=:idx';
                $prepareup = $conn->prepare($update);
                $prepareup->execute(array(":idx" => Input::method("POST", "i"), ":status" => 1));
                $fecth = $prepare->fetch(PDO::FETCH_ASSOC);
                $getFile = DIR . $fecth['file'];
                if (file_exists($getFile)) {
                    @unlink($getFile);
                }
                $insert_notification = new insert_notification();
                $insert_notification->insert($c, $_SESSION["batumi_id"], "ფოტოს წაშლა ::" . Input::method("POST", "i"), "Delete Photo ::" . Input::method("POST", "i"));
                echo "Done";
            }
        }
        if (Input::method("POST", "sendmessage") == "true" && Input::method("POST", "u") && Input::method("POST", "s") && Input::method("POST", "m") && Input::method("POST", "a")) {
            $u = json_decode(Input::method("POST", "u"), true);
            $count = count($u);
            if ($count > 0) {
                $attach = Input::method("POST", "a") == "true" ? 1 : 0;
                $draft = Input::method("POST", "d") == "yes" ? 1 : 0;
                $tousers = implode(",", $u);
                $sql = 'INSERT INTO `studio404_messages` SET `date`=:date, `ip`=:ip, `fromuser`=:fromuser, `tousers`=:tousers, `subject`=:subject, `text`=:textx, `attchment`=:attchment, `draft`=:draft';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":date" => time(), ":ip" => get_ip::ip(), ":fromuser" => $_SESSION["batumi_id"], ":tousers" => $tousers, ":subject" => Input::method("POST", "s"), ":textx" => Input::method("POST", "m"), ":draft" => $draft, ":attchment" => $attach));
                $lastInsertId = $conn->lastInsertId();
                $files = glob(DIR . '_cache/*');
                // get all file names
                foreach ($files as $file) {
                    // iterate files
                    if (is_file($file)) {
                        @unlink($file);
                    }
                    // delete file
                }
                $url = WEBSITE . 'ge/mailbox/readmail?id=' . $lastInsertId . '&back=mailbox/inbox::';
                $url .= WEBSITE . 'en/mailbox/readmail?id=' . $lastInsertId . '&back=mailbox/inbox';
                $insert_notification = new insert_notification();
                $insert_notification->insert($c, $_SESSION["batumi_id"], Input::method("POST", "s"), Input::method("POST", "s"), $url, "message", $tousers);
                echo $conn->lastInsertId();
            } else {
                echo "Error";
            }
        }
        if (Input::method("POST", "messageseen") == "true") {
            $session_id = $_SESSION["batumi_id"];
            $sql = 'UPDATE `studio404_notifications` SET `seen` = CONCAT(`seen`, "' . $session_id . ',") WHERE `type`="message" AND FIND_IN_SET("' . $session_id . '", `touserids`) AND NOT FIND_IN_SET("' . $session_id . '", `seen`)';
            $prepare = $conn->prepare($sql);
            $prepare->execute();
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            echo "Done";
        }
        //
        if (Input::method("POST", "notification_count") == "true") {
            $session_id = $_SESSION["batumi_id"];
            $sql = 'UPDATE `studio404_notifications` SET `seen` = CONCAT(`seen`, "' . $session_id . ',") WHERE `type`="notification" AND NOT FIND_IN_SET("' . $session_id . '", `seen`)';
            $prepare = $conn->prepare($sql);
            $prepare->execute();
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            echo "Done";
        }
        if (Input::method("POST", "removeUnpublished") == "true" && Input::method("POST", "i")) {
            $sql = 'UPDATE `studio404_module_item` SET `status`=1 WHERE `idx`=:idx';
            $prepare = $conn->prepare($sql);
            $idx = (int) Input::method("POST", "i");
            $prepare->execute(array(":idx" => $idx));
            $sql2 = 'UPDATE `studio404_gallery_attachment` SET `status`=1 WHERE `connect_idx`=:idx';
            $prepare2 = $conn->prepare($sql2);
            $prepare2->execute(array(":idx" => $idx));
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            $insert_notification = new insert_notification();
            $insert_notification->insert($c, $_SESSION["batumi_id"], "წაშალა მონაცემი ს.კ: N" . $idx, "Deleted Item ID: N" . $idx);
            echo "Done";
        }
        if (Input::method("POST", "givepermision") == "true") {
            $idx = Input::method("POST", "p") && is_numeric(Input::method("POST", "p")) ? Input::method("POST", "p") : 0;
            $sql = 'UPDATE `studio404_module_item` SET `visibility`=2 WHERE `idx`=' . $idx . ' AND `status`!=1';
            $conn->query($sql);
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            echo "Done";
            exit;
        }
        if (Input::method("POST", "removepermision") == "true") {
            $idx = Input::method("POST", "p") && is_numeric(Input::method("POST", "p")) ? Input::method("POST", "p") : 0;
            $sql = 'UPDATE `studio404_module_item` SET `visibility`=1 WHERE `idx`=' . $idx;
            $conn->query($sql);
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            $insert_notification = new insert_notification();
            $insert_notification->insert($c, $_SESSION["batumi_id"], "ნებართვის მოხსნა ::" . $idx, "Remove Permision ::" . $idx);
            echo "Done";
            exit;
        }
        if (Input::method("POST", "addCatalogItem") == "true") {
            if (!isset($_SESSION["batumi_id"])) {
                $_SESSION["batumi_id"] = 0;
            }
            $macat = json_decode(Input::method("POST", "macat"), true);
            $types = json_decode(Input::method("POST", "ta"), true);
            $values = json_decode(Input::method("POST", "va"), true);
            $names = json_decode(Input::method("POST", "na"), true);
            $db_columns = json_decode(Input::method("POST", "ca"), true);
            $checkbox_values = json_decode(Input::method("POST", "ca2"), true);
            $importent = json_decode(Input::method("POST", "ia"), true);
            $sql = 'SELECT 
			MAX(`idx`) AS maxidx, 
			(SELECT MAX(`position`) FROM `studio404_module_item` WHERE `status`!=1 ) AS maxposition
			FROM 
			`studio404_module_item`';
            $prepare = $conn->prepare($sql);
            $prepare->execute();
            if ($prepare->rowCount() > 0) {
                $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
                $maxidx = $fetch["maxidx"] + 1;
                $maxposition = $fetch["maxposition"] + 1;
            } else {
                $maxidx = 1;
                $maxposition = 1;
            }
            //select gallery max idx
            $sqlg = 'SELECT MAX(`idx`) AS maxid FROM `studio404_gallery` WHERE `lang`=:lang';
            $prepareg = $conn->prepare($sqlg);
            $prepareg->execute(array(":lang" => 1));
            $fetchg = $prepareg->fetch(PDO::FETCH_ASSOC);
            $gallery_maxidx = $fetchg['maxid'] ? $fetchg['maxid'] + 1 : 1;
            $columns_and_data = '';
            $xx = 0;
            foreach ($db_columns as $val) {
                if ($types[$xx] == "text" || $types[$xx] == "select" || $types[$xx] == "textarea") {
                    $columns_and_data .= '`' . $val . '`="' . $values[$xx] . '", ';
                } else {
                    if ($types[$xx] == "checkbox") {
                        if ($checkbox_values[$xx] == "yes") {
                            $checkboxdata_value[$val][] = $values[$xx];
                        }
                    } else {
                        if ($types[$xx] == "file") {
                            $columns_and_data .= '`' . $val . '`="' . $values[$xx] . '", ';
                        } else {
                            if ($types[$xx] == "date") {
                                $timestamp = strtotime(str_replace('/', '-', $values[$xx]));
                                $columns_and_data .= '`' . $val . '`="' . $timestamp . '", ';
                            }
                        }
                    }
                }
                $xx++;
            }
            if (is_array($checkboxdata_value)) {
                foreach ($checkboxdata_value as $key => $value) {
                    $columns_and_data .= '`' . $key . '`="' . implode(",", $checkboxdata_value[$key]) . '", ';
                }
            }
            $uid = new uid();
            $u = $uid->generate(9);
            $url = '';
            foreach ($c['languages.num.array'] as $l) {
                $insert = 'INSERT INTO `studio404_module_item` SET ' . $columns_and_data . ' `cataloglist`="' . implode(",", $macat) . '", `insert_ip`="' . get_ip::ip() . '", `insert_admin`="' . $_SESSION["batumi_id"] . '", `position`="' . $maxposition . '", `idx`="' . $maxidx . '", `visibility`=1, `lang`="' . $l . '", `uid`="' . $u . '", `date`="' . time() . '", `expiredate`="' . time() . '", `module_idx`="25" ';
                $query = $conn->query($insert);
                $insertId = $conn->lastInsertId();
                $s = 'SELECT `idx` FROM studio404_module_item WHERE `id`=:id';
                $p = $conn->prepare($s);
                $p->execute(array(":id" => $insertId));
                if ($p->rowCount() > 0) {
                    $f = $p->fetch(PDO::FETCH_ASSOC);
                    $p = Input::method("POST", "p");
                    $url .= WEBSITE . 'ge/monacemis-redaqtireba?parent=' . $p . '&idx=' . $f['idx'] . '&back=http://batumi.404.ge/ge/Cemi-galerea?idx=' . $p . '::';
                }
                // insert gallery
                $sql_media = 'INSERT INTO `studio404_gallery` SET 
				`idx`=:idx, 
				`date`=:datex,
				`title`=:title, 
				`lang`=:lang, 
				`status`=:status 
				';
                $prepare_media = $conn->prepare($sql_media);
                $prepare_media->execute(array(":idx" => $gallery_maxidx, ":datex" => time(), ":title" => "batumi catalog", ":lang" => $l, ":status" => 0));
                // insert gallery attachment
                $sql_media2 = 'INSERT INTO `studio404_gallery_attachment` SET 
				`idx`=:idx, 
				`connect_idx`=:connect_idx, 
				`pagetype`=:pagetype, 
				`lang`=:lang, 
				`status`=:status
				';
                $prepare_media2 = $conn->prepare($sql_media2);
                $prepare_media2->execute(array(":idx" => $gallery_maxidx, ":connect_idx" => $maxidx, ":pagetype" => "catalogpage", ":lang" => $l, ":status" => 0));
            }
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            $selectCatName = 'SELECT `title` FROM `studio404_pages` WHERE `lang`=1 AND `idx` IN (' . implode(",", $macat) . ')';
            $prepareCatName = $conn->prepare($selectCatName);
            $prepareCatName->execute();
            $fetchCatName = $prepareCatName->fetchAll(PDO::FETCH_ASSOC);
            $selectCatName2 = 'SELECT `title` FROM `studio404_pages` WHERE `lang`=2 AND `idx` IN (' . implode(",", $macat) . ')';
            $prepareCatName2 = $conn->prepare($selectCatName2);
            $prepareCatName2->execute();
            $fetchCatName2 = $prepareCatName2->fetchAll(PDO::FETCH_ASSOC);
            $insert_notification = new insert_notification();
            $insert_notification->insert($c, $_SESSION["batumi_id"], "დაამატა მონაცემი", "Added data", $url);
            echo $gallery_maxidx;
            exit;
        }
        /* EDIT start */
        if (Input::method("POST", "editCatalogItem") == "true" && Input::method("POST", "editidx")) {
            if (!isset($_SESSION["batumi_id"])) {
                $_SESSION["batumi_id"] = 0;
            }
            $editidx = Input::method("POST", "editidx");
            $macat = json_decode(Input::method("POST", "macat"), true);
            $types = json_decode(Input::method("POST", "ta"), true);
            $values = json_decode(Input::method("POST", "va"), true);
            $names = json_decode(Input::method("POST", "na"), true);
            $db_columns = json_decode(Input::method("POST", "ca"), true);
            $checkbox_values = json_decode(Input::method("POST", "ca2"), true);
            $importent = json_decode(Input::method("POST", "ia"), true);
            $columns_and_data = '';
            $xx = 0;
            foreach ($db_columns as $val) {
                if ($types[$xx] == "text" || $types[$xx] == "select" || $types[$xx] == "textarea") {
                    $columns_and_data .= '`' . $val . '`="' . $values[$xx] . '", ';
                } else {
                    if ($types[$xx] == "checkbox") {
                        if ($checkbox_values[$xx] == "yes") {
                            $checkboxdata_value[$val][] = $values[$xx];
                        }
                    } else {
                        if ($types[$xx] == "file") {
                            $columns_and_data .= '`' . $val . '`="' . $values[$xx] . '", ';
                        } else {
                            if ($types[$xx] == "date") {
                                $timestamp = strtotime(str_replace('/', '-', $values[$xx]));
                                $columns_and_data .= '`' . $val . '`="' . $timestamp . '", ';
                            }
                        }
                    }
                }
                $xx++;
            }
            if (is_array($checkboxdata_value)) {
                foreach ($checkboxdata_value as $key => $value) {
                    $columns_and_data .= '`' . $key . '`="' . implode(",", $checkboxdata_value[$key]) . '", ';
                }
            }
            $selectEditAdmins = 'SELECT `edit_admin` FROM `studio404_module_item` WHERE `idx`=:idx AND `lang`=:lang';
            $prp = $conn->prepare($selectEditAdmins);
            $prp->execute(array(":lang" => Input::method("POST", "edit_language"), ":idx" => $editidx));
            $ftc = $prp->fetch(PDO::FETCH_ASSOC);
            $edit_admin = $ftc['edit_admin'] . "," . $_SESSION["batumi_id"];
            $update = 'UPDATE `studio404_module_item` SET ' . $columns_and_data . ' `cataloglist`="' . implode(",", $macat) . '", `edit_admin`=:edit_admin WHERE `idx`=:idx AND `lang`=:lang';
            $prepare = $conn->prepare($update);
            $prepare->execute(array(":lang" => Input::method("POST", "edit_language"), ":edit_admin" => $edit_admin, ":idx" => $editidx));
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            $url = '';
            $p = Input::method("POST", "p");
            $url .= WEBSITE . 'ge/monacemis-redaqtireba?parent=' . $p . '&idx=' . $editidx . '&back=http://batumi.404.ge/ge/Cemi-galerea?idx=' . $p . '::';
            $url .= WEBSITE . 'en/monacemis-redaqtireba?parent=' . $p . '&idx=' . $editidx . '&back=http://batumi.404.ge/en/Cemi-galerea?idx=' . $p;
            $insert_notification = new insert_notification();
            $insert_notification->insert($c, $_SESSION["batumi_id"], "დაარედაქტირა მონაცემი ", "Edited Data", $url);
            echo "Done";
            exit;
        }
        /* EDIT end */
        if (Input::method("POST", "adddatabasecolumn") == "true" && Input::method("POST", "a") && Input::method("POST", "ct") && Input::method("POST", "cn")) {
            $arrayType = array("int", "varchar", "text", "longtext");
            if (in_array(Input::method("POST", "ct"), $arrayType)) {
                if (Input::method("POST", "ct") == "varchar") {
                    $type = "VARCHAR(255)";
                } else {
                    if (Input::method("POST", "ct") == "int") {
                        $type = "INT(11)";
                    } else {
                        if (Input::method("POST", "ct") == "text") {
                            $type = "TEXT";
                        } else {
                            if (Input::method("POST", "ct") == "longtext") {
                                $type = "LONGTEXT";
                            }
                        }
                    }
                }
                $sql = 'ALTER TABLE `studio404_module_item` ADD COLUMN `' . Input::method("POST", "cn") . '` ' . $type . ' NOT NULL AFTER `' . str_replace(" ", "", Input::method("POST", "a")) . '` ';
                $prepare = $conn->prepare($sql);
                $prepare->execute();
                $files = glob(DIR . '_cache/*');
                // get all file names
                foreach ($files as $file) {
                    // iterate files
                    if (is_file($file)) {
                        @unlink($file);
                    }
                    // delete file
                }
                $insert_notification = new insert_notification();
                $insert_notification->insert($c, $_SESSION["batumi_id"], "ბაზაში სვეტის დამატება ::" . Input::method("POST", "cn"), "Database Insert New Column ::" . Input::method("POST", "cn"));
                echo "Done";
            } else {
                echo "Error";
            }
            exit;
        }
        if (Input::method("POST", "updatedatabasecolumn") == "true" && Input::method("POST", "ecno") && Input::method("POST", "ecn") && Input::method("POST", "ect") && Input::method("POST", "datatype")) {
            if (Input::method("POST", "ect") == "delete") {
                $sql = 'ALTER TABLE `studio404_module_item` DROP COLUMN `' . Input::method("POST", "ecn") . '`';
                $prepare = $conn->prepare($sql);
                $prepare->execute();
                $insert_notification = new insert_notification();
                $insert_notification->insert($c, $_SESSION["batumi_id"], "ბაზაში სვეტის წაშლა ::" . Input::method("POST", "ecn"), "Database delete Column ::" . Input::method("POST", "ecn"));
                echo "Done";
            } else {
                if (Input::method("POST", "ecno") != Input::method("POST", "ecn")) {
                    $sql = 'ALTER TABLE `studio404_module_item` CHANGE COLUMN `' . Input::method("POST", "ecno") . '` `' . Input::method("POST", "ecn") . '` ' . Input::method("POST", "datatype");
                    $prepare = $conn->prepare($sql);
                    $prepare->execute();
                    $insert_notification = new insert_notification();
                    $insert_notification->insert($c, $_SESSION["batumi_id"], "ბაზაში სვეტის რედაქტირება ::" . Input::method("POST", "ecno"), "Database rename Column ::" . Input::method("POST", "ecno"));
                    echo "Done";
                } else {
                    echo "Done";
                }
            }
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            exit;
        }
        if (Input::method("POST", "createform") == "true" && Input::method("POST", "t") && Input::method("POST", "lang") && Input::method("POST", "l") && Input::method("POST", "n") && Input::method("POST", "d")) {
            $catId = (int) Input::method("POST", "catId");
            $type = json_decode(Input::method("POST", "t"), true);
            $lang = json_decode(Input::method("POST", "lang"), true);
            $label = json_decode(Input::method("POST", "l"), true);
            $name = json_decode(Input::method("POST", "n"), true);
            $value = json_decode(Input::method("POST", "v"), true);
            $database = json_decode(Input::method("POST", "d"), true);
            $important = json_decode(Input::method("POST", "i"), true);
            $list = json_decode(Input::method("POST", "li"), true);
            $filter = json_decode(Input::method("POST", "f"), true);
            $dataOptions = json_decode(Input::method("POST", "dop"), true);
            $dataCheckbox = json_decode(Input::method("POST", "dch"), true);
            $fileformat = json_decode(Input::method("POST", "ff"), true);
            $multiple = json_decode(Input::method("POST", "mp"), true);
            if (Input::method("POST", "update_lang") == "single") {
                $c['languages.num.array'] = array($lang[0]);
            }
            foreach ($c['languages.num.array'] as $lang_numeric_array_value) {
                // delete old catalog form
                $sql = 'DELETE FROM `studio404_forms` WHERE `cid`=:cid AND `lang`=:lang';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":cid" => $catId, ":lang" => $lang_numeric_array_value));
                if ($prepare->rowCount() > 0) {
                    $sql2 = 'DELETE FROM `studio404_forms_lists` WHERE `cid`=:cid AND `lang`=:lang';
                    $prepare2 = $conn->prepare($sql2);
                    $prepare2->execute(array(":cid" => $catId, ":lang" => $lang_numeric_array_value));
                }
                for ($x = 0; $x < count($type); $x++) {
                    if ($type[$x] == "text" || $type[$x] == "date" || $type[$x] == "textarea") {
                        $vdb = $value[$x] ? $value[$x] : "";
                        $insert = 'INSERT INTO `studio404_forms` SET `cid`=:cid, `label`=:label, `type`=:type, `name`=:name, `placeholder`=:placeholder, `attach_column`=:attach_column, `important`=:important, `list`=:list, `filter`=:filter, `lang`=:lang';
                        $prepare_insert = $conn->prepare($insert);
                        $prepare_insert->execute(array(":cid" => $catId, ":label" => $label[$x], ":type" => $type[$x], ":name" => $name[$x], ":placeholder" => $vdb, ":attach_column" => rtrim($database[$x]), ":important" => $important[$x], ":list" => $list[$x], ":filter" => $filter[$x], ":lang" => $lang_numeric_array_value));
                    } else {
                        if ($type[$x] == "file") {
                            $vdb = $value[$x] ? $value[$x] : "";
                            $insert = 'INSERT INTO `studio404_forms` SET `cid`=:cid, `label`=:label, `attach_format`=:attach_format, `attach_multiple`=:attach_multiple, `type`=:type, `name`=:name, `placeholder`=:placeholder, `attach_column`=:attach_column, `important`=:important, `list`=:list, `filter`=:filter, `lang`=:lang';
                            $prepare_insert = $conn->prepare($insert);
                            $attachformat = $fileformat[$x] ? $fileformat[$x] : "jpg";
                            $attachmulti = $multiple[$x] ? $multiple[$x] : "no";
                            $prepare_insert->execute(array(":cid" => $catId, ":label" => $label[$x], ":type" => $type[$x], ":name" => $name[$x], ":placeholder" => $vdb, ":attach_column" => $database[$x], ":important" => $important[$x], ":attach_format" => $attachformat, ":attach_multiple" => $attachmulti, ":list" => $list[$x], ":filter" => $filter[$x], ":lang" => $lang_numeric_array_value));
                        } else {
                            if ($type[$x] == "select" || $type[$x] == "checkbox") {
                                $vdb = $value[$x] ? $value[$x] : "";
                                $insert = 'INSERT INTO `studio404_forms` SET `cid`=:cid, `label`=:label, `type`=:type, `name`=:name, `placeholder`=:placeholder, `attach_column`=:attach_column, `important`=:important, `list`=:list, `filter`=:filter, `lang`=:lang';
                                $prepare_insert = $conn->prepare($insert);
                                $prepare_insert->execute(array(":cid" => $catId, ":label" => $label[$x], ":type" => $type[$x], ":name" => $name[$x], ":placeholder" => $vdb, ":attach_column" => $database[$x], ":important" => $important[$x], ":list" => $list[$x], ":filter" => $filter[$x], ":lang" => $lang_numeric_array_value));
                                $lastId = $conn->lastInsertId();
                                $foreachelement = $type[$x] == "select" ? $dataOptions[$x] : $dataCheckbox[$x];
                                foreach ($foreachelement as $option) {
                                    $optioninsert = 'INSERT INTO `studio404_forms_lists` SET `cid`=:cid, `cf_id`=:cf_id, `text`=:textx, `lang`=:lang';
                                    $prepare_option_insert = $conn->prepare($optioninsert);
                                    $prepare_option_insert->execute(array(":cid" => $catId, ":cf_id" => $lastId, ":textx" => $option, ":lang" => $lang_numeric_array_value));
                                }
                            }
                        }
                    }
                }
            }
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            $insert_notification = new insert_notification();
            $insert_notification->insert($c, $_SESSION["batumi_id"], "ფორმის განახლება ::" . $catId, "Form Updated: " . $catId);
            echo "Done";
            exit;
        }
        if (Input::method("POST", "b_auth") == "true" && Input::method("POST", "e") && Input::method("POST", "p") && Input::method("POST", "c")) {
            if ($_SESSION['protect_x'] != Input::method("POST", "c")) {
                echo "wrongCaptcha";
            } else {
                $sql = 'SELECT `id`,`username`,`namelname`,`picture`,`user_type` FROM `studio404_users` WHERE `username`=:username AND `password`=:password AND `user_type`!=:user_type';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":username" => Input::method("POST", "e"), ":password" => md5(Input::method("POST", "p")), ":user_type" => "administrator"));
                if ($prepare->rowCount() > 0) {
                    $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
                    $_SESSION["batumi_id"] = $fetch['id'];
                    $_SESSION["batumi_username"] = $fetch['username'];
                    $_SESSION["batumi_namelname"] = $fetch['namelname'];
                    $_SESSION["batumi_picture"] = $fetch['picture'];
                    $_SESSION["batumi_user_type"] = $fetch['user_type'];
                    echo "Enter";
                } else {
                    echo "NoUser";
                }
            }
            exit;
        }
        if (Input::method("POST", "removeuserx") == "true" && Input::method("POST", "uid")) {
            $sql = 'UPDATE `studio404_users` SET `status`=1 WHERE `id`=:uid';
            $prepare = $conn->prepare($sql);
            $prepare->execute(array(":uid" => Input::method("POST", "uid")));
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            echo "Done";
            exit;
        }
        if (Input::method("POST", "logout") == "true") {
            session_destroy();
            echo "Out";
            exit;
        }
        if (Input::method("POST", "updateUserProfile") == "true" && Input::method("POST", "n") && Input::method("POST", "m") && Input::method("POST", "e") && Input::method("POST", "a") && Input::method("POST", "lang")) {
            $sql = 'UPDATE `studio404_users` SET `dob`=:dob, `namelname`=:namelname, `mobile`=:mobile, `email`=:email, `address`=:address WHERE `id`=:id';
            $prepare = $conn->prepare($sql);
            $dob = str_replace("/", "-", Input::method("POST", "d"));
            $dob = strtotime($dob);
            $prepare->execute(array(":namelname" => Input::method("POST", "n"), ":dob" => $dob, ":mobile" => Input::method("POST", "m"), ":email" => Input::method("POST", "e"), ":address" => Input::method("POST", "a"), ":id" => $_SESSION["batumi_id"]));
            if (Input::method("POST", "lang") == "en") {
                echo "Profile Updated !";
            } else {
                echo "პროფილი განახლდა !";
            }
            exit;
        }
        if (Input::method("POST", "addcatalogue") == "true" && Input::method("POST", "n")) {
            $maxIdx = 'SELECT MAX(`idx`) as maxidx FROM `studio404_pages`';
            $prepare = $conn->prepare($maxIdx);
            $prepare->execute();
            if ($prepare->rowCount() > 0) {
                $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
                $maxidx = $fetch["maxidx"] + 1;
            } else {
                $maxidx = 1;
            }
            if (Input::method("POST", "p")) {
                $cid = Input::method("POST", "p");
            } else {
                $cid = 4;
            }
            $pos = 'SELECT MAX(`position`) as posmax FROM `studio404_pages` WHERE `cid`=:cid AND `status`!=1';
            $prepare2 = $conn->prepare($pos);
            $prepare2->execute(array(":cid" => $cid));
            if ($prepare2->rowCount() > 0) {
                $fetch2 = $prepare2->fetch(PDO::FETCH_ASSOC);
                $posmax = $fetch2["posmax"] + 1;
            } else {
                $posmax = 1;
            }
            $model = 'SELECT MAX(`idx`) as model_idx FROM `studio404_module_attachment`';
            $modelp = $conn->prepare($model);
            $modelp->execute();
            if ($modelp->rowCount() > 0) {
                $modelf = $modelp->fetch(PDO::FETCH_ASSOC);
                $modelx = $modelf["model_idx"] + 1;
            } else {
                $posmax = 1;
            }
            $slug_generation = new slug_generation();
            $slug = $slug_generation->generate(Input::method("POST", "n"));
            for ($x = 1; $x <= 2; $x++) {
                $sql = 'INSERT INTO `studio404_pages` SET `date`=:datex, `menu_type`=:menu_type, `page_type`=:page_type, `idx`=:idx, `cid`=:cid, `subid`=:cid, `title`=:titlex, `shorttitle`=:titlex, `slug`=:slug, `position`=:position, `visibility`=2, `lang`=:lang, `insert_admin`=:insert_admin';
                $preparein = $conn->prepare($sql);
                $preparein->execute(array(":cid" => $cid, ":datex" => time(), ":page_type" => 'catalogpage', ":menu_type" => 'sub', ":idx" => $maxidx, ":position" => $posmax, ":titlex" => Input::method("POST", "n"), ":slug" => $slug, ":lang" => $x, ":insert_admin" => $_SESSION["batumi_id"]));
                $insertCat = 'INSERT INTO `studio404_module_attachment` SET `idx`=:idx, `connect_idx`=:connect_idx, `page_type`=:page_type, `lang`=:lang';
                $prepatta = $conn->prepare($insertCat);
                $prepatta->execute(array(":idx" => $modelx, ":connect_idx" => $maxidx, ":page_type" => "catalogpage", ":lang" => $x));
                $insertCat2 = 'INSERT INTO `studio404_module` SET `idx`=:idx, `date`=:datex, `title`=:titlex, `lang`=:lang';
                $prepatta2 = $conn->prepare($insertCat2);
                $prepatta2->execute(array(":idx" => $modelx, ":datex" => time(), ":titlex" => Input::method("POST", "n"), ":lang" => $x));
            }
            $files = glob(DIR . '_cache/*');
            // get all file names
            foreach ($files as $file) {
                // iterate files
                if (is_file($file)) {
                    @unlink($file);
                }
                // delete file
            }
            $name = Input::method("POST", "n");
            $insert_notification = new insert_notification();
            $insert_notification->insert($c, $_SESSION["batumi_id"], "დაემატა კატალოგის კატეგორია: {$name}", "Catalogue's Category Added: {$name}");
            echo "Done";
            exit;
        }
        if (Input::method("POST", "editcatalogue") == "true" && Input::method("POST", "n") && Input::method("POST", "i") && Input::method("POST", "lang")) {
            $n = Input::method("POST", "n");
            $i = Input::method("POST", "i");
            $lang = Input::method("POST", "lang");
            $old = Input::method("POST", "old");
            $sql = 'UPDATE `studio404_pages` SET `title`=:titlex WHERE `idx`=:idx AND `lang`=:lang';
            $prepare = $conn->prepare($sql);
            $prepare->execute(array(":idx" => $i, ":lang" => $lang, ":titlex" => $n));
            if ($prepare->rowCount() > 0) {
                $files = glob(DIR . '_cache/*');
                // get all file names
                foreach ($files as $file) {
                    // iterate files
                    if (is_file($file)) {
                        @unlink($file);
                    }
                    // delete file
                }
                $insert_notification = new insert_notification();
                $insert_notification->insert($c, $_SESSION["batumi_id"], "განახლდა კატალოგის დასახელება: {$old} TO {$n}", "Catalogue Updated: {$old} TO {$n}");
                echo "Done";
            }
            exit;
        }
        if (Input::method("POST", "checkmodelitem") && Input::method("POST", "ci") && Input::method("POST", "lang")) {
            // echo "a";
            $sql0 = 'SELECT `id` FROM `studio404_pages` WHERE `cid`=:cid AND `status`!=1';
            $preparex = $conn->prepare($sql0);
            $preparex->execute(array(":cid" => Input::method("POST", "ci")));
            if ($preparex->rowCount() > 0) {
                echo "Exists";
            } else {
                $sql = 'SELECT 
				`studio404_module_item`.`id` 
				FROM 
				`studio404_module_attachment`,`studio404_module_item`
				WHERE 
				`studio404_module_attachment`.`connect_idx`=:connect_idx AND 
				`studio404_module_attachment`.`page_type`=:page_type AND 
				`studio404_module_attachment`.`lang`=:lang AND 
				`studio404_module_attachment`.`status`!=:one AND 
				`studio404_module_attachment`.`idx`=`studio404_module_item`.`module_idx` AND 
				`studio404_module_item`.`lang`=:lang AND 
				`studio404_module_item`.`status`!=:one 
				';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":connect_idx" => Input::method("POST", "ci"), ":page_type" => 'catalogpage', ":lang" => Input::method("POST", "lang"), ":one" => 1));
                if ($prepare->rowCount() > 0) {
                    echo "Exists";
                } else {
                    echo "Free to delete";
                }
            }
            exit;
        }
        if (Input::method("POST", "removeCatalogue") == "true" && Input::method("POST", "cidx")) {
            $selPos = 'SELECT `title`,`cid`,`position` FROM `studio404_pages` WHERE `idx`=:idx';
            $prepare1 = $conn->prepare($selPos);
            $prepare1->execute(array(":idx" => Input::method("POST", "cidx")));
            if ($prepare1->rowCount() > 0) {
                $fetch1 = $prepare1->fetch(PDO::FETCH_ASSOC);
                $title = $fetch1['title'];
                $cid = $fetch1['cid'];
                $posfrom = $fetch1['position'];
                $uppos = 'UPDATE `studio404_pages` SET `position`=`position`-1 WHERE `cid`=:cid AND `position`>:posfrom AND `status`!=1';
                $prepare2 = $conn->prepare($uppos);
                $prepare2->execute(array(":cid" => $cid, ":posfrom" => $posfrom));
                $sql = 'UPDATE `studio404_pages` SET `status`=1 WHERE `idx`=:idx';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":idx" => Input::method("POST", "cidx")));
                $files = glob(DIR . '_cache/*');
                // get all file names
                foreach ($files as $file) {
                    // iterate files
                    if (is_file($file)) {
                        @unlink($file);
                    }
                    // delete file
                }
                $insert_notification = new insert_notification();
                $insert_notification->insert($c, $_SESSION["batumi_id"], "წაშალა კატალოგი: {$title}", "Catalogue Deleted: {$title}");
                echo "Done";
            }
            exit;
        }
        if (Input::method("POST", "changeposition") == "true" && Input::method("POST", "t") && Input::method("POST", "i") && Input::method("POST", "c") && Input::method("POST", "p")) {
            if (Input::method("POST", "t") == "up") {
                $sql = 'UPDATE `studio404_pages` SET `position`=0 WHERE `idx`=:idx';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":idx" => Input::method("POST", "i")));
                if ($prepare->rowCount() > 0) {
                    $minpos = Input::method("POST", "p") - 1;
                    $sql2 = 'UPDATE `studio404_pages` SET `position`=`position`+1 WHERE `position`=:minpos AND `cid`=:cid';
                    $prepare2 = $conn->prepare($sql2);
                    $prepare2->execute(array(":minpos" => $minpos, ":cid" => Input::method("POST", "c")));
                    if ($prepare2->rowCount() > 0) {
                        $sql3 = 'UPDATE `studio404_pages` SET `position`=:minpos WHERE `position`=0 AND `cid`=:cid';
                        $prepare3 = $conn->prepare($sql3);
                        $prepare3->execute(array(":minpos" => $minpos, ":cid" => Input::method("POST", "c")));
                        if ($prepare3->rowCount() > 0) {
                            $files = glob(DIR . '_cache/*');
                            // get all file names
                            foreach ($files as $file) {
                                // iterate files
                                if (is_file($file)) {
                                    @unlink($file);
                                }
                                // delete file
                            }
                            $insert_notification = new insert_notification();
                            $insert_notification->insert($c, $_SESSION["batumi_id"], "კატალოგის პოზიციის შეცვლა", "Change Catalogue Position");
                            echo "Done";
                        }
                    }
                }
            } else {
                $sql = 'UPDATE `studio404_pages` SET `position`=0 WHERE `idx`=:idx';
                $prepare = $conn->prepare($sql);
                $prepare->execute(array(":idx" => Input::method("POST", "i")));
                if ($prepare->rowCount() > 0) {
                    $pluspos = Input::method("POST", "p") + 1;
                    $sql2 = 'UPDATE `studio404_pages` SET `position`=`position`-1 WHERE `position`=:pluspos AND `cid`=:cid';
                    $prepare2 = $conn->prepare($sql2);
                    $prepare2->execute(array(":pluspos" => $pluspos, ":cid" => Input::method("POST", "c")));
                    if ($prepare2->rowCount() > 0) {
                        $sql3 = 'UPDATE `studio404_pages` SET `position`=:pluspos WHERE `position`=0 AND `cid`=:cid';
                        $prepare3 = $conn->prepare($sql3);
                        $prepare3->execute(array(":pluspos" => $pluspos, ":cid" => Input::method("POST", "c")));
                        if ($prepare3->rowCount() > 0) {
                            $files = glob(DIR . '_cache/*');
                            // get all file names
                            foreach ($files as $file) {
                                // iterate files
                                if (is_file($file)) {
                                    @unlink($file);
                                }
                                // delete file
                            }
                            $insert_notification = new insert_notification();
                            $insert_notification->insert($c, $_SESSION["batumi_id"], "კატალოგის პოზიციის შეცვლა", "Change Catalogue Position");
                            echo "Done";
                        }
                    }
                }
            }
        }
        if (Input::method("POST", "adduser") == "true" && Input::method("POST", "u") && Input::method("POST", "us") && Input::method("POST", "n") && Input::method("POST", "m")) {
            $sql = 'INSERT INTO `studio404_users` SET `username`=:username, `password`=:password, `user_type`=:user_type, `namelname`=:namelname, `dob`=:dob, `mobile`=:mobile, `email`=:email, `address`=:address';
            $prepare = $conn->prepare($sql);
            $dob = str_replace("/", "-", Input::method("POST", "d"));
            $dob = strtotime($dob);
            $username = Input::method("POST", "u");
            $password = md5(Input::method("POST", "p"));
            $user_type = Input::method("POST", "us");
            $namelname = Input::method("POST", "n");
            $mobile = Input::method("POST", "m");
            $email = Input::method("POST", "e");
            $address = Input::method("POST", "a");
            $image = Input::method("POST", "i");
            $prepare->execute(array(":username" => $username, ":password" => $password, ":user_type" => $user_type, ":namelname" => $namelname, ":dob" => $dob, ":mobile" => $mobile, ":email" => $email, ":address" => $address));
            $insert_notification = new insert_notification();
            $insert_notification->insert($c, $_SESSION["batumi_id"], "დაამატა მომხმარებელი -> " . $namelname, "Added New User -> " . $namelname);
            if ($prepare->rowCount() > 0) {
                $files = glob(DIR . '_cache/*');
                // get all file names
                foreach ($files as $file) {
                    // iterate files
                    if (is_file($file)) {
                        @unlink($file);
                    }
                    // delete file
                }
            } else {
                echo "Error";
            }
            exit;
        }
        if (Input::method("POST", "edituser") == "true" && Input::method("POST", "n") && Input::method("POST", "m") && Input::method("POST", "userid")) {
            if (Input::method("POST", "p") != "") {
                $password = md5(Input::method("POST", "p"));
                $sql_p = '`password`=:password, ';
            } else {
                $sql_p = '';
            }
            $sql = 'UPDATE `studio404_users` SET ' . $sql_p . '`namelname`=:namelname, `dob`=:dob, `mobile`=:mobile, `email`=:email, `address`=:address WHERE `id`=:userid';
            $prepare = $conn->prepare($sql);
            $dob = str_replace("/", "-", Input::method("POST", "d"));
            $dob = strtotime($dob);
            $userid = Input::method("POST", "userid");
            $namelname = Input::method("POST", "n");
            $mobile = Input::method("POST", "m");
            $email = Input::method("POST", "e");
            $address = Input::method("POST", "a");
            $image = Input::method("POST", "i");
            if (Input::method("POST", "p") != "") {
                $prepare->execute(array(":userid" => $userid, ":password" => $password, ":namelname" => $namelname, ":dob" => $dob, ":mobile" => $mobile, ":email" => $email, ":address" => $address));
            } else {
                $prepare->execute(array(":userid" => $userid, ":namelname" => $namelname, ":dob" => $dob, ":mobile" => $mobile, ":email" => $email, ":address" => $address));
            }
            if ($prepare->rowCount() > 0) {
                $files = glob(DIR . '_cache/*');
                // get all file names
                foreach ($files as $file) {
                    // iterate files
                    if (is_file($file)) {
                        @unlink($file);
                    }
                    // delete file
                }
            } else {
                echo "Error";
            }
            exit;
        }
        if (Input::method("POST", "reloadImage") == "true") {
            $_SESSION['protect_x'] = ustring::random(4);
            echo "Done";
        }
        if (Input::method("POST", "removemessage") == "true" && is_numeric(Input::method("POST", "rmi"))) {
            $id = Input::method("POST", "rmi");
            $delete_admin = $_SESSION["batumi_id"];
            $sql = 'SELECT `status` FROM `studio404_messages` WHERE `id`=:id';
            $prepare = $conn->prepare($sql);
            $prepare->execute(array(":id" => $id));
            if ($prepare->rowCount() > 0) {
                $fetch = $prepare->fetch(PDO::FETCH_ASSOC);
                $old_status = $fetch["status"];
                if ($old_status == 0) {
                    $new_status = $delete_admin;
                } else {
                    $new_status = $old_status . "," . $delete_admin;
                }
                $sql2 = 'UPDATE `studio404_messages` SET `status`=:status WHERE `id`=:id';
                $prepare2 = $conn->prepare($sql2);
                $prepare2->execute(array(":status" => $new_status, ":id" => $id));
                echo "Done";
            }
        }
        /* end batumi */
    }
                    <select class="form-control select2" id="mainpagecategory" multiple="multiple" data-placeholder="Select a State" style="width: 100%;">
                      <?php 
$x = 0;
foreach ($data["welcomepage_categories"]["item"]["idx"] as $value) {
    if ($data["welcomepage_categories"]["item"]["idx"][$x] == Input::method("GET", "parent")) {
        echo '<option value="' . $data["welcomepage_categories"]["item"]['idx'][$x] . '" selected="selected">' . $data["welcomepage_categories"]["item"]['title'][$x] . '</option>';
    } else {
        echo '<option value="' . $data["welcomepage_categories"]["item"]['idx'][$x] . '">' . $data["welcomepage_categories"]["item"]['title'][$x] . '</option>';
    }
    $x++;
}
?>
                    </select>
                  </div>
						<?php 
$select_form = new select_form();
$file_count = 0;
foreach ($data["form"] as $form) {
    if ($form["type"] == "text") {
        if ($form["important"] == "yes") {
            $dataimportant = "data-important='true'";
        } else {
            $dataimportant = "data-important='false'";
        }
        ?>
	                          <div class="form-group">
	                            <label><?php 
        echo $form["label"];
        ?>
: <?php 
        echo $form["important"] == "yes" ? '<font color="red">*</font>' : '';
Beispiel #5
0
        if ($create) {
            // If create button was clicked, show the form
            echo $OUTPUT->header();
            echo $OUTPUT->heading(get_string('creategroup', 'mod_groupselect'));
            $mform->display();
            echo $OUTPUT->footer();
            die;
        }
    }
}
// Student group self-selection
if ($select and $canselect and isset($groups[$select]) and $isopen) {
    $grpname = format_string($groups[$select]->name, true, array('context' => $context));
    $usercount = isset($counts[$select]) ? $counts[$select]->usercount : 0;
    $data = array('id' => $id, 'select' => $select, 'group_password' => $password);
    $mform = new select_form(null, array($data, $groupselect, $grpname));
    if ($mform->is_cancelled()) {
        redirect($PAGE->url);
    }
    if (!$isopen) {
        $problems[] = get_string('cannotselectclosed', 'mod_groupselect');
    } else {
        if ($groupselect->maxmembers and $groupselect->maxmembers <= $usercount) {
            $problems[] = get_string('cannotselectmaxed', 'mod_groupselect', $grpname);
        } else {
            if ($return = $mform->get_data()) {
                groups_add_member($select, $USER->id);
                //add_to_log ( $course->id, 'groupselect', 'select', 'view.php?id=' . $cm->id, $groupselect->id, $cm->id );
                redirect($PAGE->url);
            } else {
                echo $OUTPUT->header();
Beispiel #6
0
echo $data["language_data"]["val92"];
?>
</h3>
              <div class="box-tools pull-right">
                <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="<?php 
echo Input::method("GET", "filter") ? 'fa fa-minus' : 'fa fa-plus';
?>
"></i></button>
              </div>
            </div>
            <!-- /.box-header -->
            <!-- form start -->
            <form role="form">
              <div class="box-body">
                <?php 
$select_form = new select_form();
$file_count = 0;
foreach ($data["catalog_form"] as $form) {
    $at = explode(" ", $form["attach_column"]);
    if ($form["type"] == "text") {
        ?>
                      <div class="form-group">
                        <label><?php 
        echo $form["label"];
        ?>
: </label> <!-- Fisrname & lastname -->
                        <input class="form-control form-input-seach" type="text" placeholder="<?php 
        echo $form["placeholder"];
        ?>
" data-name="<?php 
        echo $form["name"];