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

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


	//---- Parameters
	// none
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);
	$conn2 = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);
	$conn3 = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);


	$REGIDS = "IDTAB=0";
	$REGNAMES = "&NAMETAB=Root";
	$separator = "|";


	function displayNextLevel($connReg, $connTmp, $regID, $level, $idList, $nameList)
	{
		$separator = "";
		$query = "SELECT * FROM regions WHERE REG_PARENT_REG_ID='".$regID."' ORDER BY REG_NAME";
		$connReg->query($query);

		while($connReg->next_record())
		{
			$spacer = "    ";
			for($i=0;$i<$level;$i++)
			{
				$spacer.= "    ";
			}
			$idList.= $separator.$connReg->field_value("REG_ID");
			$nameList.= $separator.$spacer.$connReg->field_value("REG_NAME");
			$separator = "|";

			$resultChilds = displayNextLevel($connReg, $connTmp, $connReg->field_value("REG_ID"), $level+1, "", "");
			if ($resultChilds != "#")
			{
				$resultChildsTab = split("#", $resultChilds);
				$idList.= $separator.$resultChildsTab[0];
				$nameList.= $separator.$resultChildsTab[1];
			}

			//---- get localities
			if ($connReg->field_value("REG_ID") != "")
			{
				$query = "SELECT LOC_ID, LOC_NAME FROM maps, localities WHERE MAP_LOC_ID=LOC_ID AND MAP_LOC_ID<>0 AND MAP_REG_ID='".$connReg->field_value("REG_ID")."' ORDER BY LOC_NAME";
				$connTmp->query($query);

				while($connTmp->next_record())
				{
					$spacer = "    ";
					for($i=0;$i<$level+1;$i++)
					{
						$spacer.= "    ";
					}
					$idList.= $separator.$connTmp->field_value("LOC_ID");
					$nameList.= $separator.$spacer."- ".$connTmp->field_value("LOC_NAME");
				}


				//---- touristic regions
				$query = "SELECT LOC_ID, LOC_NAME FROM touristicregionslocalities, localities WHERE TRL_LOC_ID=LOC_ID AND TRL_LOC_ID<>0 AND TRL_REG_ID='".$connReg->field_value("REG_ID")."' ORDER BY LOC_NAME";
				$connTmp->query($query);

				while($connTmp->next_record())
				{
					$spacer = "    ";
					for($i=0;$i<$level+1;$i++)
					{
						$spacer.= "    ";
					}
					$idList.= $separator.$connTmp->field_value("LOC_ID");
					$nameList.= $separator.$spacer."- ".$connTmp->field_value("LOC_NAME");
				}
			}

		}

		return $idList."#".$nameList;
	}


	//---- get tree
/*	$query = "SELECT * FROM regions WHERE REG_PARENT_REG_ID=0 ORDER BY REG_NAME";
	$conn->query($query);

	while($conn->next_record())
	{
		$REGIDS.= $separator.$conn->field_value("REG_ID");
		$REGNAMES.= $separator."    ".$conn->field_value("REG_NAME");
		$resultChilds = displayNextLevel($conn2, $conn3, $conn->field_value("REG_ID"), 1, "", "");

		$resultChildsTab = split("#", $resultChilds);
		$REGIDS.= $separator.$resultChildsTab[0];
		$REGNAMES.= $separator.$resultChildsTab[1];
	}
*/


	$query = "SELECT LOC_ID, LOC_NAME FROM maps, localities WHERE MAP_LOC_ID=LOC_ID AND MAP_LOC_ID<>0 ORDER BY LOC_NAME";
	$conn->query($query);

	while($conn->next_record())
	{
		$REGIDS.= $separator.$conn->field_value("LOC_ID");
		$REGNAMES.= $separator."- ".$conn->field_value("LOC_NAME");
	}


	//---- print results
	print $REGIDS;
	print $REGNAMES;
?>