public function loadpage($obj, $c)
{
// load constructor
$s2 = $obj->url("segment", 2);
$file = $obj->url_last();
// select page types
$type_obj = new page_type();
$page_type = $type_obj->get_page_type($c);
$get_ip = new get_ip();
$ip = $get_ip->ip;
if ($c['website.mode'] == "UnderDeveloper" && !in_array($ip, $c['allowes.ips'])) {
// if under developer
$controller = "controller/under.php";
if (file_exists($controller)) {
$controller = new under($c);
} else {
$controller = new error_page();
}
} else {
if ($file == 'cron') {
//insertemail
// if under developer
$controller = "controller/cron.php";
if (file_exists($controller)) {
$controller = new cron($c);
} else {
$controller = new error_page();
}
} else {
if ($file == 'ajax') {
//insertemail
// if under developer
$controller = "controller/ajax.php";
if (file_exists($controller)) {
$controller = new ajax($c);
} else {
$controller = new error_page();
}
} else {
if ($file == 'sendemail') {
//
// if under developer
$controller = "controller/sendemail.php";
if (file_exists($controller)) {
$controller = new sendemail();
} else {
$controller = new error_page();
}
} else {
if ($file == 'insertemail') {
//
// if under developer
$controller = "controller/insertemail.php";
if (file_exists($controller)) {
$controller = new insertemail($c);
} else {
$controller = new error_page();
}
} else {
if ($obj->url("segment", 1) == 'unsubscribe') {
// if under developer
$controller = "controller/unsubscribe.php";
if (file_exists($controller)) {
$encr = $obj->url("segment", 2);
$controller = new unsubscribe($c, $encr);
} else {
$controller = new error_page();
}
} else {
if ($file == $c['admin.slug']) {
// administrator page
$controller = "controller/admin.php";
if (file_exists($controller)) {
$controller = new admin($obj, $c);
} else {
$controller = new error_page();
}
} else {
if ($file == "session_timeout") {
$controller_sessiontime = 'controller/session_timeout.php';
if (file_exists($controller_sessiontime)) {
$controller = new session_timeout();
}
} else {
if ($file == "ajaxloadoptions") {
$controller_ajaxloadoptions = 'controller/ajaxloadoptions.php';
if (file_exists($controller_ajaxloadoptions)) {
$controller = new ajaxloadoptions();
}
} else {
if ($s2 == "gallery") {
$controller_gallery = 'controller/gallery.php';
if (file_exists($controller_gallery)) {
$controller = new gallery();
}
} else {
if ($file == "invoices") {
$controller_ajaxloadoptions = 'controller/invoices.php';
if (file_exists($controller_ajaxloadoptions)) {
$controller = new invoices($obj, $c);
}
} else {
if ($file == "ajaxmoveimage") {
$controller_ajaxmoveimage = 'controller/ajaxmoveimage.php';
if (file_exists($controller_ajaxmoveimage)) {
$controller = new ajaxmoveimage();
}
} else {
if ($file == "ajaxupload") {
$controller_ajaxupload = 'controller/ajaxupload.php';
if (file_exists($controller_ajaxupload)) {
$controller = new ajaxupload();
}
} else {
if ($file == "image") {
$controller_image = 'controller/image.php';
if (file_exists($controller_image)) {
$controller = new image();
}
} else {
$get_slug_from_url = new get_slug_from_url();
$slug = $get_slug_from_url->slug();
$slug_ = str_replace(array("/", "\\"), array("", ""), strip_tags(urlencode($slug)));
$id = (int) Input::method("GET", "id");
$v = (int) Input::method("GET", "v");
$pn = (int) Input::method("GET", "pn");
$cache_file = "_cache/" . $type . $slug_ . $id . $v . $pn . LANG_ID . ".html";
//select page types
$get_page_type = new get_page_type();
$page_type = $get_page_type->type_page($c);
if (file_exists($cache_file) && $page_type != "eventpage") {
@(include $cache_file);
} else {
ob_start();
if ($file != "admin") {
// load pages
// text pages
$controller_text = "controller/text.php";
// home page
$controller_home = "controller/homepage.php";
// photo gallery page
$controller_photo_gallery = "controller/photogallery.php";
// video gallery page
$contoller_video_gallery = "controller/videogallery.php";
// catalog page
$controller_catalog = "controller/catalog.php";
// custom page
$cust = str_replace("-", "", $file);
$controller_custom = "controller/custom/" . $cust . ".php";
//event page
$controller_event = "controller/events.php";
//eventsinside page
$controller_eventsinside = "controller/eventsinside.php";
//news page
$controller_news = "controller/news.php";
//news inside page
$controller_news_inside = "controller/news_inside.php";
// event inside page
$controller_events_inside = "controller/eventinside.php";
//publication page
$controller_publication = "controller/publication.php";
// team page
$controller_team = "controller/team.php";
// administrator pages
$controller = "controller/" . $file . ".php";
// session timeout
$controller_sessiontime = "controller/session_timeout.php";
//product page
$controller_product = "controller/product.php";
// error page
$controller_errorpage = "controller/error_page.php";
if (empty($page_type) || $page_type == "error_page") {
if (file_exists($controller_home)) {
$controller = new $c["welcome.page.class"]($c);
}
} else {
//echo $page_type;
switch ($page_type) {
case 'homepage':
if (file_exists($controller_home)) {
$controller = new homepage($c);
}
break;
case 'session_timeout':
if (file_exists($controller_sessiontime)) {
$controller = new session_timeout();
}
break;
case 'textpage':
if (file_exists($controller_text)) {
$controller = new text($c);
}
break;
case 'photogallerypage':
if (file_exists($controller_photo_gallery)) {
$controller = new photogallery($c);
}
break;
case 'videogallerypage':
if (file_exists($contoller_video_gallery)) {
$controller = new videogallery($c);
}
break;
case 'catalogpage':
if (file_exists($controller_catalog)) {
$controller = new catalog($c);
}
break;
case 'custompage':
if (file_exists($controller_custom)) {
$controller = new $cust($c);
}
break;
case 'eventpage':
if (file_exists($controller_event)) {
$controller = new events($c);
}
break;
case 'eventsinside':
if (file_exists($controller_eventsinside)) {
$controller = new eventsinside($c);
}
break;
case 'newspage':
if (file_exists($controller_news)) {
$controller = new news($c);
}
break;
case 'newsinside':
if (file_exists($controller_news_inside)) {
$controller = new news_inside($c);
}
break;
case 'publicationpage':
if (file_exists($controller_publication)) {
$controller = new publication($c);
}
break;
case 'teampage':
if (file_exists($controller_team)) {
$controller = new team($c);
}
break;
case 'product':
if (file_exists($controller_product)) {
$controller = new product($c);
}
break;
case 'error_page':
if (file_exists($controller_errorpage)) {
$controller = new error_page();
}
break;
default:
if (file_exists($controller)) {
$controller = new $file($obj, $c);
}
break;
}
}
} else {
$controller = new error_page();
}
$content = ob_get_contents();
ob_clean();
$fh = @fopen($cache_file, 'w') or die("Error opening output file");
@fwrite($fh, $content);
@fclose($fh);
@(include $cache_file);
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
public function left($menu_array)
{
$get_slug_from_url = new get_slug_from_url();
$slug = $get_slug_from_url->slug();
$o = '';
$obj = new url_controll();
$third_segment = $obj->url("segment", 2) . "/" . $obj->url("segment", 3);
if (is_array($menu_array)) {
foreach ($menu_array as $val) {
$active = $val->slug == $third_segment ? 'active' : '';
if ($val->redirectlink != "false" && !empty($val->redirectlink)) {
$gotoUrl = $val->redirectlink;
} else {
$gotoUrl = MAIN_DIR . $val->slug;
}
$o .= '<li class="' . $active . '"><a href="' . $gotoUrl . '">' . $val->title . '</a></li>';
}
}
return $o;
}
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);
}
}
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();
$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 "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 "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 "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_media_item`.`slug` AS smi_slug,
`studio404_gallery`.`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();
$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;
}
if (count($fetch)) {
$fh = @fopen($cache_file, 'w') or die("Error opening output file");
@fwrite($fh, json_encode($fetch, JSON_UNESCAPED_UNICODE));
@fclose($fh);
}
}
public function gnav($menu_array, $type)
{
// echo "<pre>";
// print_r($menu_array);
// echo "</pre>";
$get_slug_from_url = new get_slug_from_url();
$slug = $get_slug_from_url->slug();
if ($type == "header") {
$o = '<div class="gmenu g' . LANG . '"><ul>';
for ($x = 0; $x < count($menu_array->date); $x++) {
$active = $menu_array->slug[$x] == $slug ? 'gactive' : '';
if ($menu_array->sub[$x]) {
$o .= '<li class="ghas">';
// '.MAIN_DIR.$menu_array->slug[$x].'
$o .= '<a href="javascript:;" class="' . $active . '">' . $menu_array->title[$x] . '</a>';
$o .= $this->gsub($menu_array->sub[$x], $slug, "header");
$o .= '</li>';
} else {
$o .= '<li><a href="' . MAIN_DIR . $menu_array->slug[$x] . '?v=' . $menu_array->idx[$x] . '" class="' . $active . '">' . $menu_array->title[$x] . '</a></li>';
}
}
$o .= '</ul>';
}
return $o;
}
public function recreate_cache($c, $type, $cache_file)
{
$conn = $this->conn($c);
switch ($type) {
case "contact_page_data":
$sql = 'SELECT * FROM `studio404_users` WHERE `id`=:id AND `user_type`=:user_type';
$prepare = $conn->prepare($sql);
$prepare->execute(array(":id" => 1, ":user_type" => "administrator"));
$fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
break;
case "homepage_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 "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 "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 "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 "footernavigation":
$sql = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `cid`=1 AND `footermenu`=1 AND `lang`=:lang AND `visibility`!=:visibility AND `status`!=:status ORDER BY `position` ASC';
$prepare = $conn->prepare($sql);
$prepare->execute(array(":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];
}
$f['idx'] = !empty($f['idx']) ? $f['idx'] : 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_media_item`.`slug` AS smi_slug,
`studio404_gallery`.`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();
$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;
case "vectormap_new":
// $sql = 'SELECT * FROM `vectormap_new`';
// $prepare = $conn->prepare($sql);
// $prepare->execute();
// if($prepare->rowCount()>0){
// $fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
// }else{
// $fetch = array();
// }
$sql = 'SELECT `idx` AS id, `title` AS code, `text` AS title, `shorttitle` AS data, `keywords` AS color FROM `studio404_pages` WHERE `cid`=6335 AND `status`!=1 AND `visibility`!=1';
$prepare = $conn->prepare($sql);
$prepare->execute();
if ($prepare->rowCount() > 0) {
$fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
} else {
$fetch = array();
}
break;
case "mapfilter":
$sql = 'SELECT (SELECT `title` FROM `studio404_pages` WHERE `idx`=:cid) AS mainTitle, `idx`,`title` FROM `studio404_pages` WHERE `cid`=:cid AND `visibility`!=:one AND `status`!=:one';
$prepare = $conn->prepare($sql);
$prepare->execute(array(":cid" => 6318, ":one" => 1));
if ($prepare->rowCount() > 0) {
$fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
} else {
$fetch = array();
}
break;
}
if (!empty($fetch) && count($fetch)) {
$fh = @fopen($cache_file, 'w') or die("Error opening output file");
@fwrite($fh, json_encode($fetch, JSON_UNESCAPED_UNICODE));
@fclose($fh);
}
}
