<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOC_ID = id of the location
	// TITLE = title of the guide
	// THEME = the theme
	// IDTAB = IDs of each element
	// TITLETAB = titles of each element
	// IMGTAB = img filename of each element
	// KEYWORDTAB  = keyword of each element
	// SLIDETIME  = slide time
	// LANG = (optional)
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- update or create images
	$idTab = split("\|", $IDTAB);
	$titleTab = split("\|", $TITLETAB);
	$imgTab = split("\|", $IMGTAB);
	$keywordTab = split("\|", $KEYWORDTAB);


	//---- get theme
	$query = "SELECT * FROM thematics WHERE THEM_NAME='".$THEME."'";
	$conn->query($query);

	if ($conn->next_record())
	{	$themID = $conn->field_value("THEM_ID");

		//---- insert or update documents
		for($i=0;$i<sizeOf($idTab);$i++)
		{
			if ($idTab[$i] != "%2D")
			{
				//---- update document
				$query = "UPDATE documents SET DOC_NAME=\"".addslashes($titleTab[$i])."\", DOC_FILE=\"".$imgTab[$i]."\", DOC_KEYWORD=\"".addslashes($keywordTab[$i])."\", DOC_THEM_ID='".$themID."' WHERE DOC_ID='".$idTab[$i]."'";
				$conn->query($query);
			}
			else
			{	//---- insert new document
				$query = "INSERT INTO documents (DOC_NAME, DOC_FILE, DOC_LOC_ID, DOC_THEM_ID, DOC_KEYWORD, DOC_TYPE, DOC_CREATION_DATE)";
				$query.= " VALUES (\"".addslashes($titleTab[$i])."\", \"".$imgTab[$i]."\", '".$LOC_ID."', '".$themID."', \"".addslashes($keywordTab[$i])."\", 'IMG', now())";
				$conn->query($query);

				$query = "SELECT LAST_INSERT_ID() AS MYID";
				$conn->query($query);
				if ($conn->next_record())
					$idTab[$i] = $conn->field_value("MYID");
			}
		}

		//---- get diaporama ID
		$diapoID = -1;
		$query = "SELECT diaporamas.DIA_ID as eltID
					FROM diaporamas, compositionslocalities, compositions
					WHERE diaporamas.DIA_THEM_ID = '".$themID."'
					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 diaporamas.DIA_ID";
		$conn->query($query);
		if ($conn->next_record())
		{	$diapoID = $conn->field_value("eltID");

			//---- update diaporama
//			if (($LANG == "") || ($LANG == $DEFAULT_LANG))
				$query = "UPDATE diaporamas SET DIA_TITLE=\"".addslashes($TITLE)."\" WHERE DIA_ID='".$diapoID."'";
				$conn->query($query);
//			else
			{	//---- get langID
				$query = "SELECT LANG_ID FROM languages WHERE LANG_CODE='".$LANG."'";
				$conn->query($query);
				$conn->next_record();
				$langID = $conn->field_value("LANG_ID");

				$query = "DELETE FROM diaporamas_languages WHERE DIALANG_LANG_ID='".$langID."' AND DIALANG_DIA_ID='".$diapoID."'";
				$conn->query($query);

				$query = "INSERT INTO diaporamas_languages (DIALANG_DIA_ID, DIALANG_LANG_ID, DIALANG_TITLE)";
				$query.= " VALUES ('".$diapoID."', '".$langID."', \"".addslashes($TITLE)."\")";
			}
			$conn->query($query);

			//---- delete old items from diaporama
			$query = "DELETE FROM diaporamasdocuments WHERE DD_DIA_ID='".$diapoID."'";
			$conn->query($query);

			//---- insert new elements
			for($i=0;$i<sizeOf($idTab);$i++)
			{
				$query = "INSERT INTO diaporamasdocuments (DD_DIA_ID, DD_DOC_ID, DD_DESCRIPTION, DD_TIME, DD_ORDER)";
				$query.= " VALUES ('".$diapoID."', '".$idTab[$i]."', \"".addslashes($titleTab[$i])."\", '".$SLIDETIME."', '".($i+1)."')";
				$conn->query($query);
			}
		}
		else
		{	//---- create diaporama

			//---- get category
			$catID = -1;
			$query = "SELECT CAT_ID FROM categories WHERE CAT_TITLE='Diaporama'";
			$conn->query($query);
			if ($conn->next_record())
				$catID = $conn->field_value("CAT_ID");

			//---- insert diaporama
			$query = "INSERT INTO diaporamas (DIA_CAT_ID, DIA_THEM_ID, DIA_TITLE)";
			$query.= " VALUES ('".$catID."', '".$themID."', \"".addslashes($TITLE)."\")";
			$conn->query($query);

			$query = "SELECT LAST_INSERT_ID() AS MYID";
			$conn->query($query);
			if ($conn->next_record())
				$diapoID = $conn->field_value("MYID");

			//---- insert new elements
			for($i=0;$i<sizeOf($idTab);$i++)
			{
				$query = "INSERT INTO diaporamasdocuments (DD_DIA_ID, DD_DOC_ID, DD_DESCRIPTION, DD_TIME, DD_ORDER)";
				$query.= " VALUES ('".$diapoID."', '".$idTab[$i]."', \"".addslashes($titleTab[$i])."\", '".$SLIDETIME."', '".($i+1)."')";
				$conn->query($query);
			}

			//---- get compositions ID
			$composID = -1;
			$query = "SELECT COMPOS_ID FROM compositions WHERE COMPOS_TITLE='Diaporama'";
			$conn->query($query);
			if ($conn->next_record())
				$composID = $conn->field_value("COMPOS_ID");

			//---- get regions ID
			$regionID = -1;
			$query = "SELECT LOC_CAT_ID FROM localities WHERE LOC_ID='".$LOC_ID."'";
			$conn->query($query);
			if ($conn->next_record())
				$regionID = $conn->field_value("LOC_CAT_ID");

			//---- get orderNumber
			$orderNum = 1;
			$query = "SELECT COMPOSLOC_ORDER FROM compositionslocalities WHERE COMPOSLOC_LOC_ID='".$LOC_ID."' AND COMPOSLOC_CAT_ID='".$regionID."' ORDER BY COMPOSLOC_ORDER";
			$conn->query($query);
			if ($conn->next_record())
				$orderNum = $conn->field_value("COMPOSLOC_ORDER") + 1;

			//---- insert composition in compositionslocalities
			$query = "INSERT INTO compositionslocalities (COMPOSLOC_LOC_ID, COMPOSLOC_OBJ_ID, COMPOSLOC_COMPOS_ID, COMPOSLOC_CAT_ID, COMPOSLOC_ORDER)";
			$query.= " VALUES ('".$LOC_ID."', '".$diapoID."', '".$composID."', '".$regionID."', '".$orderNum."')";
			$conn->query($query);
		}

		//---- display data
		print "RESULT=done";
	}
	else
		print "RESUL=error0";
?>