<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOC_ID = id of the location
	// THEME = the theme
	// VVID = VV_ID of the panoramic (optional)
	// ID = ID of pano image
	// TITLE = title
	// IMGETTE = imgette filename
	// KEYWORD = keyword
	// PICTOID = picto model ID tab
	// PICTOCOORDX = picto coord X tab
	// PICTOCOORDY = picto coord Y tab
	// PICTOOBJID = picto linked objID tab
	// PICTOOBJTYPE = picto linked obj type tab
	// PICTOALPHA = picto alpha tab
	// PICTOCOLOR = picto color tab
	// PICTOTEXT = picto text tab
	// LANG = (optional)
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	$pictoIDTab = split("\|", $PICTOID);
	$pictoCoordXTab = split("\|", $PICTOCOORDX);
	$pictoCoordYTab = split("\|", $PICTOCOORDY);
	$pictoObjIDTab = split("\|", $PICTOOBJID);
	$pictoObjTypeTab = split("\|", $PICTOOBJTYPE);
	$pictoAlphaTab = split("\|", $PICTOALPHA);
	$pictoColorTab = split("\|", $PICTOCOLOR);
	$pictoTextTab = split("\|", $PICTOTEXT);


	//---- 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
		if (($ID != "%2D") && ($ID != "-"))
		{
			//---- update document
			$query = "UPDATE documents SET DOC_NAME=\"".addslashes($TITLE)."\", DOC_FILE=\"".$IMGETTE."\", DOC_KEYWORD=\"".addslashes($KEYWORD)."\", DOC_THEM_ID='".$themID."' WHERE DOC_ID='".$ID."'";
			$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($TITLE)."\", \"".$IMGETTE."\", '".$LOC_ID."', '".$themID."', \"".addslashes($KEYWORD)."\", 'PAN', now())";
			$conn->query($query);

			$query = "SELECT LAST_INSERT_ID() AS MYID";
			$conn->query($query);
			if ($conn->next_record())
				$ID = $conn->field_value("MYID");
		}


		//---- get pano ID
		if ($VVID == "")
		{	//---- get main pano for the selected location
			$query = "SELECT virtualvisits.VV_ID as eltID
				FROM virtualvisits, compositionslocalities, compositions
				WHERE virtualvisits.VV_THEM_ID = '".$themID."'
				AND compositionslocalities.COMPOSLOC_OBJ_ID = virtualvisits.VV_ID
				AND compositionslocalities.COMPOSLOC_LOC_ID = '".$LOC_ID."'
				AND compositions.COMPOS_ID = compositionslocalities.COMPOSLOC_COMPOS_ID
				AND compositions.COMPOS_TYPE = 'VV' ORDER BY virtualvisits.VV_ID";
		}
		else
			$query = "SELECT VV_ID as eltID FROM virtualvisits WHERE VV_ID='".$VVID."'";

		$conn->query($query);
		if ($conn->next_record())
		{	$vvID = $conn->field_value("eltID");

			if ($IMGETTE == "")
			{
				//---- delete pano
				$query = "DELETE FROM virtualvisits WHERE VV_ID='".$vvID."'";
				$conn->query($query);

				//---- delete items from pano
				$query = "DELETE FROM virtualvisitsdocuments WHERE VVD_VV_ID='".$vvID."'";
				$conn->query($query);
			}
			else
			{
				//---- update pano
//				if (($LANG == "") || ($LANG == $DEFAULT_LANG))
					$query = "UPDATE virtualvisits SET VV_TITLE=\"".addslashes($TITLE)."\" WHERE VV_ID='".$vvID."'";
					$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 virtualvisits_languages WHERE VVLANG_LANG_ID='".$langID."' AND VVLANG_VV_ID='".$vvID."'";
					$conn->query($query);

					$query = "INSERT INTO virtualvisits_languages (VVLANG_VV_ID, VVLANG_LANG_ID, VVLANG_TITLE)";
					$query.= " VALUES ('".$vvID."', '".$langID."', \"".addslashes($TITLE)."\")";
				}
				$conn->query($query);

				//---- delete old items from pano
				$query = "DELETE FROM virtualvisitsdocuments WHERE VVD_VV_ID='".$vvID."'";
				$conn->query($query);

				//---- insert new elements
				for($i=0;$i<sizeOf($pictoIDTab);$i++)
				{
					if ($pictoIDTab[$i] != "")
					{
						$query = "INSERT INTO virtualvisitsdocuments (VVD_VV_ID, VVD_PICTO_ID, VVD_COORDX, VVD_COORDY, VVD_OBJ_TYPE, VVD_OBJ_ID, VVD_ALPHA, VVD_COLOR, VVD_TEXT)";
						$query.= " VALUES ('".$vvID."', '".$pictoIDTab[$i]."', '".$pictoCoordXTab[$i]."', '".$pictoCoordYTab[$i]."', '".$pictoObjTypeTab[$i]."', '".$pictoObjIDTab[$i]."', '".$pictoAlphaTab[$i]."', '".$pictoColorTab[$i]."', \"".addslashes($pictoTextTab[$i])."\")";
						$conn->query($query);
					}
				}
			}
		}
		else if ($IMGETTE != "")
		{	//---- create pano

			//---- get category
			$catID = -1;
			$query = "SELECT CAT_ID FROM categories WHERE CAT_TITLE='Virtual Visit'";
			$conn->query($query);
			if ($conn->next_record())
				$catID = $conn->field_value("CAT_ID");

			//---- insert pano
			$query = "INSERT INTO virtualvisits (VV_CAT_ID, VV_THEM_ID, VV_TITLE, VV_DOC_ID)";
			$query.= " VALUES ('".$catID."', '".$themID."', \"".addslashes($TITLE)."\", '".$ID."')";
			$conn->query($query);

			$query = "SELECT LAST_INSERT_ID() AS MYID";
			$conn->query($query);
			if ($conn->next_record())
				$vvID = $conn->field_value("MYID");

			//---- insert new elements
			for($i=0;$i<sizeOf($pictoIDTab);$i++)
			{
				if ($pictoIDTab[$i] != "")
				{
					$query = "INSERT INTO virtualvisitsdocuments (VVD_VV_ID, VVD_PICTO_ID, VVD_COORDX, VVD_COORDY, VVD_OBJ_TYPE, VVD_OBJ_ID, VVD_ALPHA, VVD_COLOR, VVD_TEXT)";
					$query.= " VALUES ('".$vvID."', '".$pictoIDTab[$i]."', '".$pictoCoordXTab[$i]."', '".$pictoCoordYTab[$i]."', '".$pictoObjTypeTab[$i]."', '".$pictoObjIDTab[$i]."', '".$pictoAlphaTab[$i]."', '".$pictoColorTab[$i]."', \"".addslashes($pictoTextTab[$i])."\")";
					$conn->query($query);
				}
			}


			//---- get compositions ID
			$composID = -1;
			$query = "SELECT COMPOS_ID FROM compositions WHERE COMPOS_TITLE='Virtual Visit'";
			$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."', '".$vvID."', '".$composID."', '".$regionID."', '".$orderNum."')";
			$conn->query($query);
		}

		//---- display data
		print "RESULT=done";
	}
	else
		print "RESUL=error0";
?>