<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOC_ID = id of the location
	// THEME = the theme
	// IMGETTE = imgette filename
	// IMGID = id of the image (optional)
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- get theme
	$query = "SELECT * FROM thematics WHERE THEM_NAME='".$THEME."'";
	$conn->query($query);

	if ($conn->next_record())
	{	$themID = $conn->field_value("THEM_ID");

		//---- insert new documents
		if ($IMGID == "")
		{
			$query = "INSERT INTO documents (DOC_NAME, DOC_FILE, DOC_LOC_ID, DOC_THEM_ID, DOC_KEYWORD, DOC_TYPE, DOC_CREATION_DATE)";
			$query.= " VALUES ('', \"".$IMGETTE."\", '".$LOC_ID."', '".$themID."', '', 'PAN', now())";
			$conn->query($query);

			$query = "SELECT LAST_INSERT_ID() AS MYID";
			$conn->query($query);
			if ($conn->next_record())
				$ID = $conn->field_value("MYID");
		}
		else
			$ID = $IMGID;

		//---- 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."', '', '".$ID."')";
		$conn->query($query);

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

		//---- display data
		print "RESULT=done&VVID=".$vvID;
	}
	else
		print "RESUL=error0";
?>