<?php session_start(); ?>
<?
include("scripts/inc_mysql_connect.php");

$sql = "SELECT * FROM th_hotels ";
$sql .= "WHERE hotel_detail_link = '$id' AND hotel_active = '1'";

$result = send_sql($db, $sql);

if (mysql_num_rows($result) == 0)
{
    HEADER("Location: https://www.mein-tourenhotel.de");
} else {
$row = mysql_fetch_array($result);

$anzahl_views = $row['hotel_watched'] + 1;

$sql = "UPDATE th_hotels SET ";
$sql .= "hotel_watched = '$anzahl_views' ";
$sql .= "WHERE hotel_detail_link = '$id'";
$res = send_sql($db, $sql);

$anzahl_views = $row['hotel_watched_all'] + 1;

$sql = "UPDATE th_hotels SET ";
$sql .= "hotel_watched_all = '$anzahl_views' ";
$sql .= "WHERE hotel_detail_link = '$id'";
$res = send_sql($db, $sql);

if (!$d1) {
    $d1 = date("d");
}
if (!$d2) {
    $d2 = date("d") + 1;
}
if (!$m1) {
    $m1 = date("m");
}
if (!$m2) {
    $m2 = date("m");
}
if (!$y1) {
    $y1 = date("Y");
}
if (!$y2) {
    $y2 = date("Y");
}

$sql_key = "SELECT * FROM th_bundesland ";
$sql_key .= "WHERE bu_id = $row[hotel_bundesland_id]  ";
$result_key = send_sql($db, $sql_key);
$row_key = mysql_fetch_array($result_key);
$bula = $row_key['bu_name'];

$sql_key = "SELECT * FROM th_regionen ";
$sql_key .= "WHERE re_id = $row[hotel_region] ";
$result_key = send_sql($db, $sql_key);
$row_key = mysql_fetch_array($result_key);
$rela = $row_key['re_name'];
$reladerdiedas = $row_key['re_name_der_die_das'];
$relaURL = $row_key['re_link'];

$sql_key = "SELECT * FROM th_regionen ";
$sql_key .= "WHERE re_id = $row[hotel_region2] ";
$result_key = send_sql($db, $sql_key);
$row_key = mysql_fetch_array($result_key);
$rela2 = $row_key['re_name'];
$reladerdiedas2 = $row_key['re_name_der_die_das'];
$relaURL2 = $row_key['re_link'];

$sql_key = "SELECT * FROM th_regionen ";
$sql_key .= "WHERE re_id = $row[hotel_region3] ";
$result_key = send_sql($db, $sql_key);
$row_key = mysql_fetch_array($result_key);
$rela3 = $row_key['re_name'];
$reladerdiedas3 = $row_key['re_name_der_die_das'];
$relaURL3 = $row_key['re_link'];

include("includes/hotel_helpers.php");
include("includes/hotel_data_prepare.php");

include("includes/hotel_head.php");
include("includes/hotel_header.php");
include("includes/hotel_intro.php");
include("includes/hotel_premium_contact.php");
include("includes/hotel_hangaround_booking.php");
include("includes/hotel_booking.php");
include("includes/hotel_gallery.php");
include("includes/hotel_services.php");
include("includes/hotel_text_sections.php");
include("includes/hotel_map.php");
include("includes/hotel_social.php");
include("includes/hotel_related.php");
include("includes/hotel_footer.php");

}
?>