<?php
require_once 'includes/global.inc.php';
require_once 'includes/db.inc.php';
require_once 'includes/gmaps.inc.php';

$id = intval($_GET['id']);
$action = SansQuotes($_GET['action']);

switch ($action) {
	case 'change_image_galerie' :
		$num_image = intval($_GET['num_image']);
		$_SESSION['image_galerie_courante'] = $num_image;
		header('Content-Type: image/jpeg');
		readfile(CHEMIN_DOCUMENTS.'/chu-'.$id.'-n'.$num_image.'-f1.jpg');
		exit();
		break;
	case 'recupere_image_galerie' :
		$num_image = intval($_SESSION['image_galerie_courante']);
		header('Content-Type: image/jpeg');
		readfile(CHEMIN_DOCUMENTS.'/chu-'.$id.'-n'.$num_image.'-f0.jpg');
		exit();
		break;
}

$requete_chateau = 'SELECT CHU_ID ID, CHU_Numero numero, CHU_Nom nom, CHU_Latitude latitude, CHU_Longitude longitude, CHU_Commodites commodites, CHU_NbChambres nb_chambres, CHU_PrixMinChambre prix_min_chambre, CHU_PrixMaxChambre prix_max_chambre, CHU_NbSuites nb_suites, CHU_PrixMinSuite prix_min_suite, CHU_PrixMaxSuite prix_max_suite, CHU_NbAppartements nb_appartements, CHU_PrixMinAppartement prix_min_appartement, CHU_PrixMaxAppartement prix_max_appartement, CHU_Epoques epoques, CHU_Receptions receptions, CHU_CapaCocktail capa_cocktail, CHU_CapaRepas capa_repas, CHU_Pictos pictos, CHU_Adresse adresse, CHU_CodePostal code_postal, CHU_Ville ville, CHU_Telephone telephone, CHU_SiteInternet site_internet, CHU_MoisOuverture mois_ouverture, CHU_DatesOuvertureFR dates_ouverture_fr, CHU_DatesOuvertureEN dates_ouverture_en, CHU_DatesOuvertureDE dates_ouverture_de, CHU_DescriptionFR description_fr, CHU_DescriptionEN description_en, CHU_DescriptionDE description_de, CHU_NomInternet nom_internet, CHU_RepereLatitude repere_latitude, CHU_RepereLongitude repere_longitude, CHU_TypeHebergement type_hebergement, CHU_TypeOuverture type_ouverture, CHU_Region region, CHU_Departement departement, CHU_Statut statut FROM GCX_Chateau WHERE CHU_ID = '.$id;
$ligne_chateau = mysql_query($requete_chateau, $DBCnx);
$champs_chateau = mysql_fetch_object($ligne_chateau);
$requete_chateaux_visites = 'SELECT CHU_ID ID, CHU_Nom nom FROM GCX_Chateau WHERE CHU_RepereLatitude = \''.mysql_real_escape_string($champs_chateau->repere_latitude, $DBCnx).'\' AND CHU_RepereLongitude = \''.mysql_real_escape_string($champs_chateau->repere_longitude, $DBCnx).'\' AND IFNULL(CHU_RepereLatitude, \'\') <> \'\' AND IFNULL(CHU_RepereLongitude, \'\') <> \'\' AND CHU_TypeOuverture IN ('.TYPE_OUVERTURE_VISITE.', '.TYPE_OUVERTURE_VISITE_NUIT.')';
$lignes_chateaux_visites = mysql_query($requete_chateaux_visites, $DBCnx);
$requete_chateaux_hotels = 'SELECT CHU_ID ID, CHU_Nom nom FROM GCX_Chateau WHERE CHU_RepereLatitude = \''.mysql_real_escape_string($champs_chateau->repere_latitude, $DBCnx).'\' AND CHU_RepereLongitude = \''.mysql_real_escape_string($champs_chateau->repere_longitude, $DBCnx).'\' AND IFNULL(CHU_RepereLatitude, \'\') <> \'\' AND IFNULL(CHU_RepereLongitude, \'\') <> \'\' AND CHU_TypeHebergement = '.TYPE_HEBERGEMENT_HOTEL;
$lignes_chateaux_hotels = mysql_query($requete_chateaux_hotels, $DBCnx);
$requete_chateaux_chambres = 'SELECT CHU_ID ID, CHU_Nom nom FROM GCX_Chateau WHERE CHU_RepereLatitude = \''.mysql_real_escape_string($champs_chateau->repere_latitude, $DBCnx).'\' AND CHU_RepereLongitude = \''.mysql_real_escape_string($champs_chateau->repere_longitude, $DBCnx).'\' AND IFNULL(CHU_RepereLatitude, \'\') <> \'\' AND IFNULL(CHU_RepereLongitude, \'\') <> \'\' AND CHU_TypeHebergement = '.TYPE_HEBERGEMENT_CHAMBRES;
$lignes_chateaux_chambres = mysql_query($requete_chateaux_chambres, $DBCnx);
$id_chateau_prec = RequeteSimple('SELECT CHU_ID FROM GCX_Chateau WHERE CHU_Numero < '.intval($champs_chateau->numero).' ORDER BY CHU_Numero DESC LIMIT 1', $DBCnx);
$id_chateau_suiv = RequeteSimple('SELECT CHU_ID FROM GCX_Chateau WHERE CHU_Numero > '.intval($champs_chateau->numero).' ORDER BY CHU_Numero ASC LIMIT 1', $DBCnx);
$param_url_galerie = 'galerie_flash.xml.php?id_chateau='.$champs_chateau->ID.urlencode('&').'base_url_image='.urlencode(urlencode('?').'action=change_image_galerie'.urlencode('&').'id='.$champs_chateau->ID.urlencode('&').'num_image=');

require 'pages/guide-des-chateaux-de-france-fiche.'.$Langue.'.html.inc.php';
?>