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

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


	//---- Parameters
	// LOC_ID = locality ID
	// THEME = the theme
	// TYPE = type to get (VID or LNK) (optional)
	if ($TYPE == "")
		$TYPE = "VID";

	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);


	$IDTab = "";
	$titleTab = "";
	$linkTab = "";
	$imgetteTab = "";
	$nextVal = "";

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

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

		//---- get all video
		$query = "SELECT DOC_ID, DOC_NAME, DOC_LINK, DOC_FILE FROM documents WHERE DOC_TYPE='".$TYPE."' AND DOC_LOC_ID='".$LOC_ID."' AND DOC_THEM_ID='".$themID."' ORDER BY DOC_NAME";
		$conn->query($query);

		while($conn->next_record())
		{
			$IDTab.= $nextVal.$conn->field_value("DOC_ID");
			$titleTab.= $nextVal.utf8_encode($conn->field_value("DOC_NAME"));
			$linkTab.= $nextVal.utf8_encode($conn->field_value("DOC_LINK"));
			$imgetteTab.= $nextVal.$conn->field_value("DOC_FILE");
			$nextVal = "|";
		}

		//---- display data
		print "IDTab=".$IDTab;
		print "&imgetteTab=".$imgetteTab;
		print "&titleTab=".$titleTab;
		print "&linkTab=".$linkTab;
	}
	else
		print "RESULT=error0";
?>