<?
##################
	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);

	if ($LANG == "")
		$LANG = $DEFAULT_LANG;

	//---- get langID
	$langID = 1;
	$query = "SELECT LANG_ID FROM languages WHERE LANG_CODE='".$LANG."'";
	$conn->query($query);
	if ($conn->next_record())
		$langID = $conn->field_value("LANG_ID");


	//---- get current user info
	$query = "SELECT mosaics.MOS_ID as eltID, thematics.THEM_ID as themID
				FROM thematics, mosaics, compositionslocalities, compositions
				WHERE mosaics.MOS_THEM_ID = thematics.THEM_ID
				AND thematics.THEM_NAME = '".$THEME."'
				AND compositionslocalities.COMPOSLOC_OBJ_ID = mosaics.MOS_ID
				AND compositionslocalities.COMPOSLOC_LOC_ID = '".$LOC_ID."'
				AND compositions.COMPOS_ID = compositionslocalities.COMPOSLOC_COMPOS_ID
				AND compositions.COMPOS_TYPE = 'MT' ORDER BY thematics.THEM_ID, mosaics.MOS_ID";
	$conn->query($query);
	if ($conn->next_record())
		$mosID = $conn->field_value("eltID");

/*
	if ($LANG == $DEFAULT_LANG)
	{
		//---- default language
		$query = "SELECT MOS_TITLE, MOS_DESCRIPTION FROM mosaics WHERE MOS_ID='".$mosID."'";
		$conn->query($query);

		if ($conn->next_record())
		{
			$MOSTITLE = utf8_encode($conn->field_value("MOS_TITLE"));
			$MOSDESCR = utf8_encode($conn->field_value("MOS_DESCRIPTION"));
		}
	}
	else
	{	//---- other language
		$query = "SELECT MOSLANG_TITLE, MOSLANG_DESCRIPTION FROM mosaics, mosaics_languages, languages WHERE MOSLANG_MOS_ID=MOS_ID AND MOSLANG_LANG_ID=LANG_ID AND LANG_CODE='".$LANG."' AND MOS_ID='".$mosID."'";
		$conn->query($query);

		if ($conn->next_record())
		{
			$MOSTITLE = utf8_encode($conn->field_value("MOSLANG_TITLE"));
			$MOSDESCR = utf8_encode($conn->field_value("MOSLANG_DESCRIPTION"));
		}
	}
*/

	$query = "SELECT MOSLANG_TITLE, MOSLANG_DESCRIPTION FROM mosaics LEFT JOIN mosaics_languages ON (MOSLANG_MOS_ID=MOS_ID AND MOSLANG_LANG_ID='".$langID."') WHERE MOS_ID='".$mosID."'";
	$conn->query($query);

	if ($conn->next_record())
	{
		$MOSTITLE = utf8_encode($conn->field_value("MOSLANG_TITLE"));
		$MOSDESCR = utf8_encode($conn->field_value("MOSLANG_DESCRIPTION"));
	}


	//---- get all elements of the guide
	$query = "SELECT MD_DOC_ID FROM mosaicsdocuments WHERE MD_MOS_ID='".$mosID."' ORDER BY MD_ORDER";
	$conn->query($query);

	$firstElement = true;
	$idTab = "";
	$filenameTab = "";
	$titleTab = "";
	$keywordTab = "";
	$nextVal = "";
	while($conn->next_record())
	{
		$query2 = "SELECT * FROM documents WHERE DOC_ID='".$conn->field_value("MD_DOC_ID")."'";
		$conn2->query($query2);
		if ($conn2->next_record())
		{
			if ($firstElement)
				$firstElement = false;
			else
				$nextVal = "|";

			$idTab.= $nextVal.$conn2->field_value("DOC_ID");
			$filenameTab.= $nextVal.utf8_encode($conn2->field_value("DOC_FILE"));
			$titleTab.= $nextVal.utf8_encode($conn2->field_value("DOC_NAME"));
			$keywordTab.= $nextVal.utf8_encode($conn2->field_value("DOC_KEYWORD"));
		}
	}


	//---- display data
	print "idTab=".$idTab;
	print "&filenameTab=".$filenameTab;
	print "&titleTab=".$titleTab;
	print "&keywordTab=".$keywordTab;
	print "&title=".$MOSTITLE;
	print "&descr=".$MOSDESCR;
?>