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

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


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

	//---- get Data from DB
	$query = "SELECT * FROM maps WHERE MAP_LOC_ID<>0";
	//$query = "SELECT * FROM maps WHERE MAP_LOC_ID<>0 and MAP_LOC_ID<>1 and MAP_LOC_ID<>246 and MAP_LOC_ID<>248";
	$query.= " ORDER BY MAP_ID";
	$conn->query($query);

	$MAPLOCID = "MAPLOCID=";
	$MAPCOORDX = "&MAPCOORDX=";
	$MAPCOORDY = "&MAPCOORDY=";
	$MAPOBJNAME =  "&MAPLOCNAME=";
	$MAPOBJSIZE =  "&MAPSIZE=";

	$firstElement = true;
	$nextVal = "";
	while($conn->next_record())
	{
		if ($firstElement)
			$firstElement = false;
		else
			$nextVal = "|";

		$MAPLOCID.= $nextVal.$conn->field_value("MAP_LOC_ID");
		$MAPCOORDX.= $nextVal.$conn->field_value("MAP_LATITUDE");
		$MAPCOORDY.= $nextVal.$conn->field_value("MAP_LONGITUDE");

		//---- get location names
		$query = "SELECT LOC_NAME FROM localities WHERE LOC_ID='".$conn->field_value("MAP_LOC_ID")."'";
		$conn2->query($query);
		$conn2->next_record();

		if ($conn2->field_value("LOC_NAME"))
			$MAPOBJNAME.= $nextVal.urlencode($conn2->field_value("LOC_NAME"));
		else
			$MAPOBJNAME.= $nextVal."-";
	}

	print $MAPLOCID;
	print $MAPCOORDX;
	print $MAPCOORDY;
	print $MAPOBJNAME;
	print $MAPOBJSIZE;
?>