<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOCID = ID of the location
	// LANG
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);


	/*if($APPLI=='Tac')
	{*/

		$query = "SELECT distinct SERV_DESC_ID FROM thematics, services WHERE THEM_ID=SERV_THEM_ID
					AND SERV_LOC_ID='".$LOCID."'
					AND THEM_NAME='Activities'";
		$conn->query($query);

		$separator = "";
		while($conn->next_record())
		{
			$leisureServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
			$separator = "|";
		}


		$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
					WHERE THEM_ID=SERV_THEM_ID
					AND SERV_LOC_ID='".$LOCID."'
					AND THEM_NAME='Lodging'";
		$conn->query($query);

		$separator = "";
		while($conn->next_record())
		{
			$lodgingServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
			$separator = "|";
		}


		$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
					WHERE THEM_ID=SERV_THEM_ID
					AND SERV_NBDAYS <> 0
					AND SERV_LOC_ID='".$LOCID."'
					AND THEM_NAME='Transport'";
		$conn->query($query);

		$separator = "";
		while($conn->next_record())
		{
			$transportServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
			$separator = "|";
		}


			//---- get wellness services
		$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
					WHERE THEM_ID=SERV_THEM_ID
					AND SERV_NBDAYS <> 0
					AND SERV_LOC_ID='".$LOCID."'
					AND THEM_NAME='Wellness'";
		$conn->query($query);

		$separator = "";
		while($conn->next_record())
		{
			$wellnessServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
			$separator = "|";
		}


		//---- get locName
		$query = "SELECT * FROM localities WHERE LOC_ID='".$LOCID."'";
		$conn->query($query);
		if ($conn->next_record())
			$LOCNAME = $conn->field_value("LOC_NAME");


	/*}

	else
	{

		$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
					WHERE THEM_ID=SERV_THEM_ID
					AND SERV_LOC_ID='".$LOCID."'
					AND THEM_NAME='Activities'
					AND SERV_ID IN (SELECT SERVD_SERV_ID FROM services_details)
					ORDER BY SERV_DESC_ID";
		$conn->query($query);

		$separator = "";
		while($conn->next_record())
		{
			$leisureServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
			$separator = "|";
		}


		$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
					WHERE THEM_ID=SERV_THEM_ID
					AND SERV_LOC_ID='".$LOCID."'
					AND THEM_NAME='Lodging'
					AND SERV_ID IN (SELECT SERVD_SERV_ID FROM services_details)
					ORDER BY SERV_DESC_ID";
		$conn->query($query);

		$separator = "";
		while($conn->next_record())
		{
			$lodgingServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
			$separator = "|";
		}


		$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
					WHERE THEM_ID=SERV_THEM_ID
					AND SERV_NBDAYS <> 0
					AND SERV_LOC_ID='".$LOCID."'
					AND THEM_NAME='Transport'
					AND SERV_ID IN (SELECT SERVD_SERV_ID FROM services_details)
					ORDER BY SERV_DESC_ID";
		$conn->query($query);

		$separator = "";
		while($conn->next_record())
		{
			$transportServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
			$separator = "|";
		}


			//---- get wellness services
		$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
					WHERE THEM_ID=SERV_THEM_ID
					AND SERV_NBDAYS <> 0
					AND SERV_LOC_ID='".$LOCID."'
					AND THEM_NAME='Wellness'
					AND SERV_ID IN (SELECT SERVD_SERV_ID FROM services_details)
					ORDER BY SERV_DESC_ID";
		$conn->query($query);

		$separator = "";
		while($conn->next_record())
		{
			$wellnessServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
			$separator = "|";
		}


		//---- get locName
		$query = "SELECT * FROM localities WHERE LOC_ID='".$LOCID."'";
		$conn->query($query);
		if ($conn->next_record())
			$LOCNAME = $conn->field_value("LOC_NAME");

	}
	*/


	print "leisureServDescID=".$leisureServDescID;
	print "&lodgingServDescID=".$lodgingServDescID;
	print "&transportServDescID=".$transportServDescID;
	print "&wellnessServDescID=".$wellnessServDescID;
	print "&locName=".utf8_encode($LOCNAME);
?>