isError ()) die ( $db->error () ); $url = $_SERVER ['REQUEST_URI']; if ($url {0} == '/') $url = substr ( $url, 1 ); if (($pos = strpos ( $url, '?' )) !== false) { $url = substr ( $url, 0, $pos ); } $url = substr ( $url, 0, - 5 ); global $default_lang; $sql = "SELECT * FROM `cms_languages` WHERE `l_first`=1 LIMIT 1"; $res = @mysql_query ( $sql ) or die ( mysql_error () ); $row = mysql_fetch_array ( $res ); $default_lang = $row ['l_symbol']; if (! empty ( $_GET ['l'] )) { $l = $_GET ['l']; $sql = "SELECT `l_enabled`, `l_symbol` FROM `cms_languages` WHERE `l_symbol` = '" . $db->escape ( $l ) . "'"; $row = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (! empty ( $row )) { if ($row ['l_enabled'] == '1') { $lang_aux = $row ['l_symbol']; $_SESSION ['lang'] = $lang_aux; } } } else { if (empty ( $_SESSION ['lang'] )) { $_SESSION ['lang'] = $default_lang; } } unset ( $_GET ['l'] ); /** * ******************** * Catalog SEO code END * ******************** */ if (empty ( $url )) { header ( 'Location: ' . $lang . '/index.php' ); die (); } if (LANGUAGEMODULE == 'YES') { $pos = strpos ( $url, '/' ); if ($pos === false) { $lang = null; } else { $lang = substr ( $url, 0, $pos ); $sql = "SELECT `l_symbol` FROM `cms_languages` WHERE `l_symbol` = '" . $db->escape ( $lang ) . "' AND `l_enabled` = '1'"; $row = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (empty ( $row )) { $lang = null; } else { $lang = $row ['l_symbol']; $url = substr ( $url, $pos + 1 ); } } if (empty ( $lang ) && ! empty ( $_SESSION ['lang'] )) { $lang = $_SESSION ['lang']; } $_SESSION ['lang'] = $lang_aux = $lang; if (! isset ( $_SESSION ['lang'] )) { $_SESSION ['lang'] = $default_lang; } } /** * ******************** * Catalog SEO code * ******************** */ $catalogSeo = 'catalog'; if (CATALOGMODULE == "YES") { $selQuery = "SELECT * FROM `catalog_settings` WHERE `lang` = '". $_SESSION ['lang'] ."' LIMIT 1"; $selResult = mysql_query ( $selQuery ) or die ( mysql_error () ); if (mysql_num_rows ( $selResult ) >= 1) { $catSettings = mysql_fetch_assoc ( $selResult ); $catalogSeo = $catSettings ['seo_alias']; } } $modules = array ( 'hotelbooking', 'nieuws', 'webshop', 'album', 'nws', 'clients', 'blog', $catalogSeo, 'event', 'photo_album' ); $pos = strpos ( $url, '/' ); if ($pos === false) { if ($url == $catalogSeo) { $pag = $catalogSeo; } else if ($url == 'hotelbooking') { $pag = 'hotelbooking'; } else { $pag = 'pages'; } } else { $pag = substr ( $url, 0, $pos ); if (in_array ( $pag, $modules )) { $url = substr ( $url, $pos + 1 ); } else { $pag = 'pages'; } } $_SESSION ['nonModulePage'] = "0"; switch ($pag) { case 'pages' : $urla = explode ( '/', $url ); $url1 = $urla [0]; $pos = strpos ( $url1, '-' ); if ($pos) { $url2 = explode ( '-', $url1 ); } // issue no 237 photo album if(PHOTOALBUMMODULE == 'YES') { $photo_sql = "SELECT `url_alias_photo_album` FROM `photo_album_setting`"; $photo_result = $db->query ( $photo_sql ); $photo_url = mysql_fetch_array ( $photo_result ); $photoalbum = strtolower ( $photo_url ['url_alias_photo_album'] ); } switch (strtolower ( $url1 )) { case 'zoekresultaten' : $pag = 'search'; break; case 'webshop' : $pag = 'shop'; $_SESSION ['nonModulePage'] = "0"; break; case 'event' : $pag = 'event'; $_SESSION ['nonModulePage'] = "0"; break; // ISSUE NO. 261 case $CALC_ALIAS : $pag = $CALC_ALIAS; break; case $CALC_RESULT_ALIAS . '-' . $CALC_ALIAS : $pag = $CALC_RESULT_ALIAS . '-' . $CALC_ALIAS; break; case $CALC_USERFORM_ALIAS . '-' . $CALC_ALIAS : $pag = $CALC_USERFORM_ALIAS . '-' . $CALC_ALIAS; break; case $photoalbum : // issue no 237 photo album $_SESSION ['nonModulePage'] = "0"; $pag = 'photoalbum'; if (isset ( $urla [1] ) and ! empty ( $urla [1] )) { $album = str_replace ( '-', ' ', $urla [1] ); $album = str_replace ( "_", "\'", $album ); // query to select the album id from database. $album_sql = "SELECT `pa_id` as id FROM photo_album WHERE LOWER(`album_title`) = '" . $album . "'"; $album_result = $db->query ( $album_sql ); $album_array = mysql_fetch_array ( $album_result ); $_GET ['show_album'] = $album_array ['id']; } break; default : $_SESSION ['nonModulePage'] = "1"; if (strpos ( $url, 'modules' ) !== false) $_SESSION ['nonModulePage'] = "0"; $sql = "SELECT `p_id`, `p_p_id`, `p_redirect` FROM `cms_pages` WHERE `p_url` = '" . $db->escape ( $url ) . "' AND `p_lang` = '$_SESSION[lang]'"; $page = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (empty ( $page )) { header ( 'Location:' . $lang . '/index.php' ); die (); } $currentpage_redirect = $page ['p_redirect']; if ($currentpage_redirect != '') { header ( 'Location: ' . $currentpage_redirect, TRUE, 301 ); die (); } $_GET ['id'] = $page ['p_id']; $k = ''; while ( ! empty ( $page ['p_p_id'] ) ) { $_GET ['sid' . $k] = $page ['p_p_id']; $sql = "SELECT `p_id`, `p_p_id` FROM `cms_pages` WHERE `p_id` = $page[p_p_id]"; $page = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (empty ( $k )) $k = 2; else ++ $k; } } break; case 'nws' : $_SESSION ['nonModulePage'] = "1"; if (substr_count ( $url, '/' ) > 1) { $url = str_replace ( '/', '', strrchr ( $url, '/' ) ); $sql = "SELECT `n_id` FROM `cms_news` WHERE `n_url` = '" . $db->escape ( $url ) . "' AND `n_lang` = '$_SESSION[lang]'"; $news = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (empty ( $news )) { header ( 'Location:' . $lang . '/index.php' ); die (); } $_GET ['id'] = $news ['n_id']; } else { $pag = 'newslist'; } break; case 'blog' : $_SESSION ['nonModulePage'] = "1"; if (substr_count ( $url, '/' ) > 1) { $sql = "SELECT `s_blog_seo_url` FROM `cms_settings` WHERE `s_lang` = '" . $lang . "'"; $row = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); $blog_settings = $row; $url = str_replace ( '/', '', strrchr ( $url, '/' ) ); $sql = "SELECT `id` FROM `blog_posts` WHERE `url` = '" . $db->escape ( $url ) . "' AND `lang` = '$_SESSION[lang]'"; $blogitem = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (empty ( $blogitem )) { $sql = "SELECT * FROM `blog_categories` WHERE `url` = '" . $db->escape ( $url ) . "' AND `lang` = '$_SESSION[lang]'"; $blogitem = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (empty ( $blogitem )) { header ( 'Location:' . 'http://' . $_SERVER ['HTTP_HOST'] . '/' . $lang . '/blog/posts.html' ); die (); } } $_GET ['id'] = $blogitem ['id']; $_GET ['url'] = $blogitem ['url']; } elseif ($url != 'posts') { // $pag='blog'; $sql = "SELECT * FROM `blog_categories` WHERE `url` = '" . $db->escape ( $url ) . "' AND `lang` = '$_SESSION[lang]'"; $blogitem = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (empty ( $blogitem )) { header ( 'Location:' . 'http://' . $_SERVER ['HTTP_HOST'] . '/' . $lang . '/blog/posts.html' ); die (); } } else { $url = 'posts'; } break; case 'hotelbooking' : $_SESSION ['nonModulePage'] = "0"; $pag = 'hotelbooking'; $_GET ['url'] = 'hotelbooking'; break; case 'clients' : break; case $catalogSeo : $_SESSION ['nonModulePage'] = "0"; if ($url != $catalogSeo) { $sql = "SELECT `id` FROM `catalog_item` WHERE `url_alias` = '" . $db->escape ( $url ) . "' AND `lang` = '$_SESSION[lang]'"; $catalogitem = $db->select ( $sql ); if ($db->isError ()) die ( $db->error () ); if (empty ( $catalogitem )) { $sql = "SELECT * FROM `catalog_categories` WHERE `url` = '" . $db->escape ( $url ) . "' AND `lang` = '$_SESSION[lang]'"; $catalogitem = $db->select ( $sql ); $_GET ['url'] = $catalogitem ['url']; $_GET ['cat'] = $catalogitem ['id']; if ($db->isError ()) die ( $db->error () ); if (empty ( $catalogitem )) { header ( 'Location:' . 'http://' . $_SERVER ['HTTP_HOST'] . '/' . $lang . '/' . $catalogSeo . '/catalog.html' ); die (); } } else { $_GET ['id'] = $catalogitem ['id']; $_GET ['url'] = $catalogitem ['url']; } } else { $url = $catalogSeo; } break; case 'webshop' : $_SESSION ['nonModulePage'] = "0"; $pag = 'shop'; case 'event' : $_SESSION ['nonModulePage'] = "0"; $pag = 'event'; $event = str_replace ( ".html", '', $url ); if ($event != "event") { $event_sql = "SELECT `e_id` as id FROM events WHERE LOWER(`e_alias`) = '" . $event . "'"; $event_result = $db->query ( $event_sql ); $event_array = mysql_fetch_array ( $event_result ); $_GET ['eventID'] = $event_array ['id']; } break; default : $pag = "photoalbum"; $_SESSION ['nonModulePage'] = "0"; } $_GET ['l'] = $_SESSION ['lang']; $_GET ['pag'] = $pag; $_REQUEST = array_merge ( $_GET, $_POST ); $tmp = array (); foreach ( $_REQUEST as $key => $val ) { if (! is_array ( $key ) && ! is_array ( $val )) { $tmp [] = urlencode ( $key ) . '=' . urlencode ( $val ); } } $_SERVER ["QUERY_STRING"] = implode ( '&', $tmp ); $_SERVER ["PHP_SELF"] = 'main.php'; $PHP_SELF = $_SERVER ["PHP_SELF"]; $QUERY_STRING = $_SERVER ["QUERY_STRING"]; include $_SERVER ['PHP_SELF']; ?>