protect($_GET['id']); $therme = $db->single_query_o("SELECT b.bundesland, b.link AS bundesland_link, b.mapimg AS mapimg, t.* FROM thermen t JOIN bundesland b ON b.bundesland_id=t.bundesland_id WHERE t.status=1 AND t.thermen_id=".$id); if(!$therme) { exit; } $rechteWerbung_ThermenId = $id; $bilder_kl = $db->multi_query_o("SELECT * FROM thermen_bild WHERE status=1 AND bild_gruppe='snormal' AND thermen_id=$id ORDER BY sorder LIMIT 2"); $bilder = $db->multi_query_o("SELECT * FROM thermen_bild WHERE status=1 AND bild_gruppe='lnormal' AND thermen_id=$id ORDER BY sorder"); $img_path = '/img/thermen/'.$id.'/'; $link_langtext = '/therme-'.$id.'/'.$therme->link.'_detail.htm'; if($_GET['suche']) $link_langtext.='?suche=true'; if($_GET['detail']){ $seite = "detail"; $text = $therme->text; } else if($_GET['ausstattungs_id']) { $seite = "ausstattung"; $ausstattungS = $db->single_query_o("SELECT t2a.text, a.ausstattung, a.icon, a.ausstattung_id FROM thermen2ausstattung t2a JOIN ausstattung a ON a.ausstattung_id= t2a.ausstattung_id WHERE t2a.status=1 AND t2a.thermen_id=$id AND a.ausstattung_id=".$db->protect($_GET['ausstattungs_id'])); } else { $seite = "start"; $text = $therme->teaser_text.' weiter »'; $ausstattung = $db->multi_query_o("SELECT t2a.teaser, a.ausstattung, a.icon, a.ausstattung_id FROM thermen2ausstattung t2a JOIN ausstattung a ON a.ausstattung_id= t2a.ausstattung_id WHERE t2a.status=1 AND t2a.thermen_id=$id ORDER BY a.sorder"); $openHours_s = $db->multi_query_o("SELECT tag, uhrzeit, typ FROM oeffnungszeiten WHERE thermen_id=$id AND typ='s' ORDER BY id"); $openHours_t = $db->multi_query_o("SELECT tag, uhrzeit, typ FROM oeffnungszeiten WHERE thermen_id=$id AND typ='t' ORDER BY id"); $eintritt_e = $db->single_query_o("SELECT * FROM eintritt WHERE thermen_id=$id AND typ='e' ORDER BY typ"); $eintritt_s = $db->single_query_o("SELECT * FROM eintritt WHERE thermen_id=$id AND typ='s' ORDER BY typ"); $eintritt_k = $db->multi_query_o("SELECT * FROM eintritt WHERE thermen_id=$id AND typ='k' ORDER BY id"); } $content = $db->getContent("select * from design_content where status=1 and design_content_cd IN ('AdSense_4','Button_Thermen_Detail_1')"); //--- Site Setup //Rechte-Seite-Werbung: $rechteWerbung_CD = 'THD'; $page->tpl_content= "thermen/therme_top.tpl.php"; //Breadcrumb $page->breadcrumb = array( array("HOME", "/"), array("ALLE B√ĄDER", "/alle-thermen/"), array($therme->bundesland, "/thermen-".$therme->bundesland_id."/".$therme->bundesland_link.".htm"), array(mystrtoupper($therme->name)) ); //Sonstiges $page->meta_titel = $therme->meta_titel; $page->meta_description = $therme->meta_desc; $page->meta_keywords = $therme->meta_keys; $page->minimap = $therme->mapimg; //--- Include the Layout include_once DOCUMENT_ROOT.'/tpl/layout/layout.tpl.php'; ?>