<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOC_ID = locality ID
	// THEME = the theme
	// VVID = VV_ID of the panoramic (optional)
	// LANG = the lang (optional)
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);
	$conn2 = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	if ($LANG == "")
		$LANG = $DEFAULT_LANG;

	//---- get langID
	$langID = 1;
	$query = "SELECT LANG_ID FROM languages WHERE LANG_CODE='".$LANG."'";
	$conn->query($query);
	if ($conn->next_record())
		$langID = $conn->field_value("LANG_ID");


	//---- get virtual visit ID
	if ($VVID == "")
	{	//---- get main pano for the selected location
		$query = "SELECT virtualvisits.VV_ID as eltID, thematics.THEM_ID as themID
					FROM thematics, virtualvisits, compositionslocalities, compositions
					WHERE virtualvisits.VV_THEM_ID = thematics.THEM_ID
					AND thematics.THEM_NAME = '".$THEME."'
					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 thematics.THEM_ID, compositionslocalities.COMPOSLOC_ORDER, 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");


	//---- get title
/*	$query = "SELECT * FROM virtualvisits vv, virtualvisits_languages vvl, languages l WHERE l.LANG_ID=vvl.VVLANG_LANG_ID AND vv.VV_ID=vvl.VVLANG_VV_ID AND vv.VV_ID='".$vvID."' AND l.LANG_CODE='".$LANG."'";
	$conn->query($query);

	if ($conn->next_record())
		$VVTITLE = $conn->field_value("VVLANG_TITLE");
	else
	{
		$query = "SELECT VV_TITLE, VV_DOC_ID FROM virtualvisits WHERE VV_ID='".$vvID."'";
		$conn->query($query);

		if ($conn->next_record())
			$VVTITLE = $conn->field_value("VV_TITLE");
	}
*/
/*
	if (($LANG == "") || ($LANG == $DEFAULT_LANG))
	{
		//---- default language
		$query = "SELECT VV_TITLE, VV_DOC_ID  FROM virtualvisits WHERE VV_ID='".$vvID."'";
		$conn->query($query);

		if ($conn->next_record())
			$VVTITLE = $conn->field_value("VV_TITLE");
	}
	else
	{	//---- other language
		$query = "SELECT VVLANG_TITLE, VV_DOC_ID FROM virtualvisits, virtualvisits_languages, languages WHERE VVLANG_VV_ID=VV_ID AND VVLANG_LANG_ID=LANG_ID AND LANG_CODE='".$LANG."' AND VV_ID='".$vvID."'";
		$conn->query($query);

		if ($conn->next_record())
			$VVTITLE = $conn->field_value("VVLANG_TITLE");
	}
*/

	$query = "SELECT VVLANG_TITLE, VV_DOC_ID FROM virtualvisits LEFT JOIN virtualvisits_languages ON (VVLANG_VV_ID=VV_ID AND VVLANG_LANG_ID='".$langID."') WHERE VV_ID='".$vvID."'";
	$conn->query($query);

	if ($conn->next_record())
		$VVTITLE = $conn->field_value("VVLANG_TITLE");


	//---- get main picture name
	$query = "SELECT DOC_ID, DOC_FILE, DOC_KEYWORD FROM documents WHERE DOC_ID='".$conn->field_value("VV_DOC_ID")."'";
	$conn2->query($query);
	if ($conn2->next_record())
	{
		$VVIMAGE = $conn2->field_value("DOC_FILE");
		$VVKEYWORD = $conn2->field_value("DOC_KEYWORD");
		$VVDOCID = $conn2->field_value("DOC_ID");
	}

	//---- get all elements on the panoramic
	$query = "SELECT * FROM virtualvisitsdocuments WHERE VVD_VV_ID='$vvID'";
	$conn->query($query);

	$firstElement = true;
	$nextVal = "";
	while($conn->next_record())
	{
		if ($firstElement)
			$firstElement = false;
		else
			$nextVal = "|";

		$VVPICTOID.= $nextVal.$conn->field_value("VVD_PICTO_ID");
		$VVCOORDX.= $nextVal.$conn->field_value("VVD_COORDX");
		$VVCOORDY.= $nextVal.$conn->field_value("VVD_COORDY");
		$VVWIDTH.= $nextVal.$conn->field_value("VVD_WIDTH");
		$VVEIGHT.= $nextVal.$conn->field_value("VVD_HEIGHT");
		$VVOBJTYPE.= $nextVal.$conn->field_value("VVD_OBJ_TYPE");
		$VVOBJID.= $nextVal.$conn->field_value("VVD_OBJ_ID");
		$VVCOLOR.= $nextVal.utf8_decode($conn->field_value("VVD_COLOR"))."_".utf8_decode($conn->field_value("VVD_ALPHA"));

		if ($conn->field_value("VVD_TEXT") == "undefined")
			$val = "";
		else
			$val = utf8_decode($conn->field_value("VVD_TEXT"));

		$VVOBJTEXT.= $nextVal.$val;
	}

	print "VVID=".$vvID;
	print "&VVTITLE=".$VVTITLE;
	print "&VVIMAGE=".utf8_encode($VVIMAGE);
	print "&VVKEYWORD=".utf8_encode($VVKEYWORD);
	print "&VVDOCID=".$VVDOCID;
	print "&VVPICTOID=".$VVPICTOID;
	print "&VVCOORDX=".$VVCOORDX;
	print "&VVCOORDY=".$VVCOORDY;
	print "&VVWIDTH=".$VVWIDTH;
	print "&VVEIGHT=".$VVEIGHT;
	print "&VVOBJTYPE=".$VVOBJTYPE;
	print "&VVOBJID=".$VVOBJID;
	print "&VVCOLOR=".$VVCOLOR;
	print "&VVOBJTEXT=".utf8_encode($VVOBJTEXT);
?>