<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOC_ID = id of the location
	// THEME = the theme
	// LANG (optional)
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);
	$conn2 = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- get current user info
	$query = "SELECT brochures.BRO_ID as eltID, thematics.THEM_ID as themID
				FROM thematics, brochures, compositionslocalities, compositions
				WHERE brochures.BRO_THEM_ID = thematics.THEM_ID
				AND thematics.THEM_NAME = '".$THEME."'
				AND compositionslocalities.COMPOSLOC_OBJ_ID = brochures.BRO_ID
				AND compositionslocalities.COMPOSLOC_LOC_ID = '".$LOC_ID."'
				AND compositions.COMPOS_ID = compositionslocalities.COMPOSLOC_COMPOS_ID
				AND compositions.COMPOS_TYPE = 'BRO' ORDER BY thematics.THEM_ID, brochures.BRO_ID";
	$conn->query($query);
	if ($conn->next_record())
		$broID = $conn->field_value("eltID");


	if (empty($LANG))
		$query = "SELECT BRO_TITLE as BTITLE FROM brochures WHERE BRO_ID='".$broID."'";
	else
	{	$query = "SELECT BROLANG_TITLE as BTITLE FROM brochures_languages, languages
					WHERE BROLANG_BRO_ID='".$broID."'
					  AND LANG_CODE='".$LANG."'
					  AND BROLANG_LANG_ID=LANG_ID";
	}
	$conn->query($query);
	if ($conn->next_record())
		$BROTITLE = utf8_encode($conn->field_value("BTITLE"));


	//---- get services list from brochuresservices
	if (empty($LANG))
		$query = "SELECT SERV_ID, SERV_NAME as SNAME FROM services, brochuresservices WHERE SERV_ID=BS_SERV_ID AND BS_BRO_ID='".$broID."' ORDER BY BS_ORDERNB";
	else
	{	$query = "SELECT SERV_ID, SERVLANG_NAME as SNAME 
					FROM services, brochuresservices, services_languages, languages
					WHERE SERV_ID=BS_SERV_ID 
					  
					  AND LANG_CODE='".$LANG."'
					  AND SERVLANG_LANG_ID=LANG_ID
					  
					  AND SERVLANG_SERV_ID=SERV_ID
					  AND BS_BRO_ID='".$broID."' 
					  ORDER BY BS_ORDERNB";
	}
	$conn->query($query);

	$idTab = "";
	$titleTab = "";
	$nextVal = "";
	while($conn->next_record())
	{
		$idTab.= $nextVal.$conn->field_value("SERV_ID");
		$titleTab.= $nextVal.utf8_encode($conn->field_value("SNAME"));
		$nextVal = "|";
	}


	//---- display data
	print "title=".$BROTITLE;
	print "&idTab=".$idTab;
	print "&titleTab=".$titleTab;
?>