<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOC_ID = id of the location
	// THEME = the theme
	// IDTAB = IDs of each element
	// TITLETAB = titles of each element
	// IMGETTETAB = imgette filename of each element
	// LINKTAB  = link of each element
	// TYPE = type to get (VID or LNK) (optional)
	if ($TYPE == "")
		$TYPE = "VID";

	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- update or create images
	$idTab = split("\|", $IDTAB);
	$titleTab = split("\|", $TITLETAB);
	$imgTab = split("\|", $IMGETTETAB);
	$linkTab = split("\|", $LINKTAB);


	//---- get theme
	$query = "SELECT * FROM thematics WHERE THEM_NAME='".$THEME."'";
	$conn->query($query);

	if ($conn->next_record())
	{	$themID = $conn->field_value("THEM_ID");

		//---- delete removed element
		$idsToKeep = "";
		$nextVal = "";
		for($i=0;$i<sizeOf($idTab);$i++)
		{
			if ($idTab[$i] != "%2D")
			{
				$idsToKeep.= $nextVal.$idTab[$i];
				$nextVal = ",";
			}
		}
		if ($idsToKeep != "")
			$query = "DELETE FROM documents WHERE DOC_LOC_ID='".$LOC_ID."' AND DOC_TYPE='".$TYPE."' AND DOC_THEM_ID='".$themID."' AND DOC_ID not in (".$idsToKeep.")";
		else
			$query = "DELETE FROM documents WHERE DOC_LOC_ID='".$LOC_ID."' AND DOC_TYPE='".$TYPE."' AND DOC_THEM_ID='".$themID."'";
		$conn->query($query);

		//---- 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_LINK=\"".addslashes($linkTab[$i])."\", DOC_THEM_ID='".$themID."' WHERE DOC_ID='".$idTab[$i]."'";
				$conn->query($query);
			}
			else if ($titleTab[$i] != "")
			{	//---- insert new document
				$query = "INSERT INTO documents (DOC_NAME, DOC_FILE, DOC_LOC_ID, DOC_THEM_ID, DOC_LINK, DOC_TYPE, DOC_CREATION_DATE)";
				$query.= " VALUES (\"".addslashes($titleTab[$i])."\", \"".$imgTab[$i]."\", '".$LOC_ID."', '".$themID."', \"".addslashes($linkTab[$i])."\", '".$TYPE."', now())";
				$conn->query($query);
			}
		}

		//---- display data
		print "RESULT=done";
	}
	else
		print "RESUL=error0";
?>