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