<?
##################
	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 diaporamas.DIA_ID as eltID, thematics.THEM_ID as themID
				FROM thematics, diaporamas, compositionslocalities, compositions
				WHERE diaporamas.DIA_THEM_ID = thematics.THEM_ID
				AND thematics.THEM_NAME = '".$THEME."'
				AND compositionslocalities.COMPOSLOC_OBJ_ID = diaporamas.DIA_ID 
				AND compositionslocalities.COMPOSLOC_LOC_ID = '".$LOC_ID."'
				AND compositions.COMPOS_ID = compositionslocalities.COMPOSLOC_COMPOS_ID
				AND compositions.COMPOS_TYPE = 'DIA' ORDER BY thematics.THEM_ID, diaporamas.DIA_ID";
	$conn->query($query);
	if ($conn->next_record())
		$diaID = $conn->field_value("eltID");


/*	if (($LANG == "") || ($LANG == $DEFAULT_LANG))
	{
		//---- default language
		$query = "SELECT DIA_TITLE FROM diaporamas WHERE DIA_ID='".$diaID."'";
		$conn->query($query);

		if ($conn->next_record())
			$DIATITLE = utf8_encode($conn->field_value("DIA_TITLE"));
	}
	else
	{	//---- other language
		$query = "SELECT DIALANG_TITLE FROM diaporamas, diaporamas_languages, languages WHERE DIALANG_DIA_ID=DIA_ID AND DIALANG_LANG_ID=LANG_ID AND LANG_CODE='".$LANG."' AND DIA_ID='".$diaID."'";
		$conn->query($query);

		if ($conn->next_record())
			$DIATITLE = utf8_encode($conn->field_value("DIALANG_TITLE"));
	}
*/

	$query = "SELECT DIALANG_TITLE FROM diaporamas LEFT JOIN diaporamas_languages ON (DIALANG_DIA_ID=DIA_ID AND DIALANG_LANG_ID='".$langID."') WHERE DIA_ID='".$diaID."'";
	$conn->query($query);

	if ($conn->next_record())
		$DIATITLE = utf8_encode($conn->field_value("DIALANG_TITLE"));


	//---- get all elements of the diaporama
	$query = "SELECT DD_DOC_ID, DD_TIME FROM diaporamasdocuments WHERE DD_DIA_ID='".$diaID."' ORDER BY DD_ORDER";
	$conn->query($query);

	$firstElement = true;
	$idTab = "";
	$filenameTab = "";
	$titleTab = "";
	$keywordTab = "";
	$nextVal = "";
	$slideTime = "";
	while($conn->next_record())
	{
		$query2 = "SELECT * FROM documents WHERE DOC_ID='".$conn->field_value("DD_DOC_ID")."'";
		$conn2->query($query2);
		if ($conn2->next_record())
		{
			if ($firstElement)
			{
				$firstElement = false;
				$slideTime = $conn->field_value("DD_TIME");
			}
			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=".$DIATITLE;
	print "&slideTime=".$slideTime;
?>