'message-error', 0=>'Databázi se napodařilo otevřít');
else:
$cSQL = "SET NAMES 'utf8'";
mysql_query($cSQL);
if(trim(mysql_error()) !== ''):
$_SESSION["return_error_vypis"][] = array('class'=>'message-error', 0=>'Chyba při nastavování kódové stránky');
ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
endif;
if(!@mysql_select_db($par_nazev_databaze)):
$_SESSION["return_error_vypis"][] = array('class'=>'message-error', 0=>'Chyba při výběru tabulky z databáze');
else:
$cSQL = "SET GLOBAL sql_mode = ''";
mysql_query($cSQL);
$_SESSION["dbf-open"] = true;
endif;
endif;
else:
$_SESSION["return_error_vypis"][] = array('class'=>'message-error', 0=>'Údaje pro otevření databáze nejsou vyplněny');
endif;
$aFirmaInfo = VratInfoOfirme($par_vychozi_prostredi);
$_REQUEST["page"] = (IsSet($_REQUEST["page"]) && $_REQUEST["page"] !== '') ? $_REQUEST["page"] : 'uvodni-strana';
include "./include/nacti_kurzy.php";
//echo "Page: ".$_REQUEST["page"]."
";
//echo "CID: ".$_REQUEST["cid"]."
";
//echo var_dump($_SESSION);
//echo var_dump($_REQUEST);
switch ($_REQUEST["page"]):
//-------------------------------------------------------------------------------------
// Rezervace
//-------------------------------------------------------------------------------------
case "rezervace":
$cZalozkaStranky = $aFirmaInfo["firma"].' | Rezervace';
include "./include/header.php";
include './include/rezervace.php';
include "./include/footer.php";
break;
case "rezervace_osoby":
$cZalozkaStranky = $aFirmaInfo["firma"].' | Rezervace';
if(IsSet($_REQUEST["zid"]) && (int)$_REQUEST["zid"] > 0):
include "./include/header.php";
include './include/rezervace_osoby.php';
include "./include/footer.php";
else:
header('location: ./uvodni-strana.html');
endif;
break;
case "rezervace_kontrola":
include './include/rezervace_kontrola.php';
break;
case "rezervace_potvrzeni":
$cZalozkaStranky = $aFirmaInfo["firma"].' | Rezervace je kompletní';
include "./include/header.php";
include './include/rezervace_potvrzeni.php';
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// Hotel
//-------------------------------------------------------------------------------------
case "hotel-detail":
$cZalozkaStranky = $aFirmaInfo["firma"].' | Informace o hotelu';
if(IsSet($_REQUEST["hotel"]) && trim($_REQUEST["hotel"]) !== ''):
include "./include/header.php";
include './include/hotel_detail.php';
include "./include/footer.php";
else:
header('location: ./uvodni-strana.html');
endif;
break;
//-------------------------------------------------------------------------------------
// Zobrazeni zajezdu
//-------------------------------------------------------------------------------------
case "zobraz-zajezdy":
$cZalozkaStranky = $aFirmaInfo["firma"].' | Vyhledané zájezdy';
include "./include/header.php";
$_REQUEST["hotel"] = (IsSet($_REQUEST["hotel"]) && trim($_REQUEST["hotel"]) !== '') ? trim($_REQUEST["hotel"]) : '';
if($_REQUEST["hotel"]):
include './include/zobraz_zajezdy_hotel_detail.php';
else:
include './include/zobraz_zajezdy_hotely_prehled.php';
endif;
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// Clanky
//-------------------------------------------------------------------------------------
case "clanek":
$cZalozkaStranky = $aFirmaInfo["firma"].' | Článek';
include "./include/header.php";
include "./include/clanek.php";
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// Uvodni strana
//-------------------------------------------------------------------------------------
case "uvodni-strana":
case "default":
$cZalozkaStranky = $aFirmaInfo["firma"].' | Úvodní strana';
$lNatahniCookie = true;
include "./include/header.php";
include "./include/uvodni_strana.php";
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// O nas
//-------------------------------------------------------------------------------------
case "o-nas":
@MySQL_Query("lock tables _web2_clanky read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT
_web2_clanky.nazev as nadpis
FROM _web2_clanky
WHERE _web2_clanky.aktivni = 'A'
AND _web2_clanky.umisteni = 'O-NAS'
AND _web2_clanky.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() == 1):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'O nás';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/o_nas.php";
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// Sluzby
//-------------------------------------------------------------------------------------
case "sluzby":
@MySQL_Query("lock tables _web2_clanky read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT
_web2_clanky.nazev as nadpis
FROM _web2_clanky
WHERE _web2_clanky.aktivni = 'A'
AND _web2_clanky.umisteni = 'S'
AND _web2_clanky.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() == 1):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'Služby';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/sluzby.php";
include "./include/footer.php";
break;
case "sluzby-detail":
@MySQL_Query("lock tables _web2_clanky read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT
_web2_clanky.nazev as nadpis
FROM _web2_clanky
WHERE _web2_clanky.nazev_seo = '".mysql_real_escape_string($_REQUEST["sluzba"])."'
AND _web2_clanky.aktivni = 'A'
AND _web2_clanky.umisteni = 'SLUZBY'
AND _web2_clanky.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() == 1):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'Podrobné informace';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/sluzby_detail.php";
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// Informace
//-------------------------------------------------------------------------------------
case "informace":
@MySQL_Query("lock tables _web2_clanky read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT
_web2_clanky.nazev as nadpis
FROM _web2_clanky
WHERE _web2_clanky.aktivni = 'A'
AND _web2_clanky.umisteni = 'I'
AND _web2_clanky.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() == 1):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'Informace';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/informace.php";
include "./include/footer.php";
break;
case "informace-detail":
@MySQL_Query("lock tables _web2_clanky read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT
_web2_clanky.nazev as nadpis
FROM _web2_clanky
WHERE _web2_clanky.nazev_seo = '".mysql_real_escape_string($_REQUEST["informace"])."'
AND _web2_clanky.aktivni = 'A'
AND _web2_clanky.umisteni = 'INFORMACE'
AND _web2_clanky.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() == 1):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'Podrobné informace';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/informace_detail.php";
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// Dovolena
//-------------------------------------------------------------------------------------
case "dovolena":
@MySQL_Query("lock tables _web2_clanky read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT
_web2_clanky.nazev as nadpis
FROM _web2_clanky
WHERE _web2_clanky.aktivni = 'A'
AND _web2_clanky.umisteni = 'DOVOLENA'
AND _web2_clanky.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() == 1):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'Dovolená';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/dovolena.php";
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// Kontakt
//-------------------------------------------------------------------------------------
case "kontakt":
@MySQL_Query("lock tables _web2_clanky read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT
_web2_clanky.nazev as nadpis
FROM _web2_clanky
WHERE _web2_clanky.aktivni = 'A'
AND _web2_clanky.umisteni = 'KONTAKT'
AND _web2_clanky.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() == 1):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'Kontakt';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/kontakt.php";
include "./include/footer.php";
break;
case "kontakt-vzkaz":
include "include/kontakt_vzkaz.php";
Location('Header: ./kontakt.html');
//-------------------------------------------------------------------------------------
// Destinace
//-------------------------------------------------------------------------------------
case "partneri":
$cZalozkaStranky = $aFirmaInfo["firma"].' | Partneři';
include "./include/header.php";
include "./include/partneri.php";
include "./include/footer.php";
break;
//-------------------------------------------------------------------------------------
// Destinace
//-------------------------------------------------------------------------------------
case "destinace":
@MySQL_Query("lock tables _web2_clanky read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT
_web2_clanky.nazev as nadpis
FROM _web2_clanky
WHERE _web2_clanky.aktivni = 'A'
AND _web2_clanky.umisteni = 'S'
AND _web2_clanky.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() == 1):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'Destinace';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/destinace.php";
include "./include/footer.php";
break;
case "destinace-detail":
@MySQL_Query("lock tables ciselnik_destinaci read, ciselnik_zemi read");
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', 'LOCK');
$cSQL = "SELECT concat(ciselnik_zemi.zeme, ' - ', ciselnik_destinaci.destinace) as nadpis
FROM ciselnik_destinaci
LEFT OUTER JOIN ciselnik_zemi
ON ciselnik_destinaci.zeme_id = ciselnik_zemi.id
WHERE ciselnik_destinaci.destinace_seo = '".mysql_real_escape_string($_REQUEST["destinace"])."'
AND ciselnik_destinaci.aktivni = 'A'
AND ciselnik_destinaci.smazano = 'N'
AND ciselnik_destinaci.".$par_vychozi_prostredi." = 'A'
LIMIT 1";
@$Vysledek = MySQL_Query($cSQL);
if(trim(mysql_error()) !== '') ZapisChybuMySQL(mysql_error(), __FILE__.' (#'.__LINE__.')', $cSQL);
if(MySQL_Affected_Rows() > 0):
$Zaznam = MySQL_Fetch_Array($Vysledek);
else:
$Zaznam["nadpis"] = 'Podrobné informace';
endif;
@mysql_free_result($Vysledek);
@MySQL_Query("unlock tables");
$cZalozkaStranky = $aFirmaInfo["firma"].' | '.$Zaznam["nadpis"];
include "./include/header.php";
include "./include/destinace_detail.php";
include "./include/footer.php";
break;
endswitch;
@mysql_close($conn);
?>