<?
##################
	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
	// DESCR = descr
	// THEME = the theme
	// IDTAB = IDs of each element
	// TITLETAB = titles of each element
	// IMGTAB = img filename of each element
	// KEYWORDTAB  = keyword of each element
	// 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 mosaic ID
		$mosID = -1;
		$query = "SELECT mosaics.MOS_ID as eltID
			FROM mosaics, compositionslocalities, compositions
			WHERE mosaics.MOS_THEM_ID = '".$themID."'
			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 mosaics.MOS_ID";
		$conn->query($query);
		if ($conn->next_record())
		{	$mosID = $conn->field_value("eltID");

			//---- update mosaic
//			if (($LANG == "") || ($LANG == $DEFAULT_LANG))
				$query = "UPDATE mosaics SET MOS_TITLE=\"".addslashes($TITLE)."\", MOS_DESCRIPTION=\"".addslashes($DESCR)."\" WHERE MOS_ID='".$mosID."'";
				$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 mosaics_languages WHERE MOSLANG_LANG_ID='".$langID."' AND MOSLANG_MOS_ID='".$mosID."'";
				$conn->query($query);

				$query = "INSERT INTO mosaics_languages (MOSLANG_MOS_ID, MOSLANG_LANG_ID, MOSLANG_TITLE, MOSLANG_DESCRIPTION)";
				$query.= " VALUES ('".$mosID."', '".$langID."', \"".addslashes($TITLE)."\", \"".addslashes($DESCR)."\")";
			}
			$conn->query($query);

			//---- delete old items from mosaic
			$query = "DELETE FROM mosaicsdocuments WHERE MD_MOS_ID='".$mosID."'";
			$conn->query($query);

			//---- insert new elements
			for($i=0;$i<sizeOf($idTab);$i++)
			{
				$query = "INSERT INTO mosaicsdocuments (MD_MOS_ID, MD_DOC_ID, MD_ORDER)";
				$query.= " VALUES ('".$mosID."', '".$idTab[$i]."', '".($i+1)."')";
				$conn->query($query);
			}
		}
		else
		{	//---- create mosaic

			//---- get category
			$catID = -1;
			$query = "SELECT CAT_ID FROM categories WHERE CAT_TITLE='Mosaic'";
			$conn->query($query);
			if ($conn->next_record())
				$catID = $conn->field_value("CAT_ID");

			//---- insert mosaic
			$query = "INSERT INTO mosaics (MOS_CAT_ID, MOS_THEM_ID, MOS_TITLE, MOS_DESCRIPTION)";
			$query.= " VALUES ('".$catID."', '".$themID."', \"".addslashes($TITLE)."\", \"".addslashes($DESCR)."\")";
			$conn->query($query);

			$query = "SELECT LAST_INSERT_ID() AS MYID";
			$conn->query($query);
			if ($conn->next_record())
				$mosID = $conn->field_value("MYID");

			//---- insert new elements
			for($i=0;$i<sizeOf($idTab);$i++)
			{
				$query = "INSERT INTO mosaicsdocuments (MD_MOS_ID, MD_DOC_ID, MD_ORDER)";
				$query.= " VALUES ('".$mosID."', '".$idTab[$i]."', '".($i+1)."')";
				$conn->query($query);
			}

			//---- get compositions ID
			$composID = -1;
			$query = "SELECT COMPOS_ID FROM compositions WHERE COMPOS_TITLE='Mosaic'";
			$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."', '".$mosID."', '".$composID."', '".$regionID."', '".$orderNum."')";
			$conn->query($query);
		}

		//---- display data
		print "RESULT=done";
	}
	else
		print "RESUL=error0";
?>