<?
##################
	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);


	$REGIDS = "0";
	$REGNAMES = "#Root";
	$separator = "|";


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

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

			$conn3 = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);
			$resultChilds = displayNextLevel($conn3, $connReg->field_value("REG_ID"), $level+1, "", "", $HOST, $DATABASE, $LOGIN, $PASSWORD);
			if ($resultChilds != "#")
			{
				$resultChildsTab = split("#", $resultChilds);
				$idList.= $separator.$resultChildsTab[0];
				$nameList.= $separator.$resultChildsTab[1];
			}
		}

		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, $conn->field_value("REG_ID"), 1, "", "", $HOST, $DATABASE, $LOGIN, $PASSWORD);

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


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