<?php
# License:
# Copyright (c) 2009, Open Source Geospatial Foundation
# This program is dual licensed under the GNU General Public License 
# and Simplified BSD license.  
# http://svn.osgeo.org/mapbender/trunk/mapbender/license/license.txt

require_once dirname(__FILE__) . "/../../core/globalSettings.php";
require_once dirname(__FILE__) . "/../../core/epsg.php";
require_once dirname(__FILE__) . "/class_connector.php";
require_once dirname(__FILE__) . "/class_user.php";
require_once dirname(__FILE__) . "/class_Uuid.php";
require_once dirname(__FILE__) . "/class_administration.php";
require_once dirname(__FILE__) . "/class_georss_factory.php";
require_once dirname(__FILE__) . "/class_mb_exception.php";
require_once dirname(__FILE__) . "/class_iso19139.php";
require_once(dirname(__FILE__) . "/class_propagateMetadata.php");
require_once dirname(__FILE__) . "/../classes/class_universal_wms_factory.php";
class wms {
	var $lastURL;
	var $wms_id;
	var $wms_status;
	var $wms_version;
	var $wms_title;
	var $wms_abstract;
	var $wms_getcapabilities;
	var $wms_getcapabilities_doc;
	var $wms_getmap;
	var $wms_getfeatureinfo;
	var $wms_getlegendurl;
	var $wms_upload_url;
	var $wms_timestamp;
	var $wms_timestamp_create;
	var $wms_srs = array();
	//extended information
	var $wms_termsofuse;
	var $wms_license_source_note;

	var $fees;
	var $accessconstraints;
	var $contactperson;
	var $contactposition;
	var $contactorganization;
	var $address;
	var $city;
	var $stateorprovince;
	var $postcode;
	var $country;
	var $contactvoicetelephone;
	var $contactfacsimiletelephone;
	var $contactelectronicmailaddress;
	//The following attribute is not part of the wms spec, but usefull if someone want to print or give back referenced data via wms - e.g. inspire download services for predefined datasets
	var $wms_max_pixelsize;
	  
	var $wms_keyword = array();
	var $data_type = array(); 
	var $data_format = array();
	var $objLayer = array(); 
	  
	var $wms_supportsld;
	var $wms_userlayer;
	var $wms_userstyle;
	var $wms_remotewfs;

	var $inspire_annual_requests;
		
	var $gui_wms_mapformat;
	var $gui_wms_featureinfoformat;
	var $gui_wms_exceptionformat;
	var $gui_wms_epsg;
	var $gui_wms_sldurl;
	var $gui_wms_dimension_time;
	var $gui_wms_dimension_elevation;
	  
	var $default_epsg = 0;
	var $overwrite = true;
	var $overwriteCategories = false;
	var $twitterNews = false;
	var $setGeoRss = false;
        
        //dataset metadata handling - defaults to true
	var $harvestCoupledDatasetMetadata = true;
	//inheritance of service elements to coupled dataset metadata
	var $wms_bequeath_licence_info = 0; //bequeath relation wms_termsofuse to coupled dataset metadata
	var $wms_bequeath_contact_info = 0; //bequeath database attribute fkey_mb_group_id to dataset metadata
       
	var $geoRss;
	var $geoRssFactory; // = new GeoRssFactory();
	const GEORSS = true;
	// append items to the feed when a new WMS is inserted?
	const GEORSS_APPEND_ON_INSERT = true;
	// append items to the feed when an existing WMS is updated?
	const GEORSS_APPEND_ON_UPDATE = true;
	// append items to the feed only when an existing WMS is updated 
	// and new layers have been added?
	const GEORSS_APPEND_ON_UPDATE_NEWLAYERS = true;
	  
	function __construct() {
	    	if (defined("TWITTER_NEWS") && TWITTER_NEWS == true) {
    	    		$this->twitterNews = true;
    	    		require_once dirname(__FILE__) . "/class_twitter.php";
    		}
    	
    		if(defined("GEO_RSS_FILE") && GEO_RSS_FILE != "") {
        		//GeoRSS feed
    	    		$this->setGeoRss = true;
    		}
	} 

        /**
         *
         * @generate RSS formated date 
         *
         * @param int $timestamp The UNIX_TIMESTAMP
         *
         * @return string
         *
        */
        private static function rssDate($timestamp=null) {
            /*** set the timestamp ***/
            $timestamp = ($timestamp==null) ? time() : $timestamp;

            /*** Mon, 02 Jul 2009 11:36:45 +0000 ***/
            return date(DATE_RSS, $timestamp);
        }

        /**
         *
         * @filter multidimensional array by value - https://www.w3resource.com/php-exercises/php-array-exercise-52.php TODO - push it in class_administration.php
         *
         * @param array $my_array
         * @param string $index array key
         * @param string $value value to filter for
         * 
         * @return $array Filtered array
         *
         */
    	public function array_filter_by_value($my_array, $index, $value) { 
             if(is_array($my_array) && count($my_array)>0) { 
                 foreach(array_keys($my_array) as $key) { 
                     $temp[$key] = $my_array[$key][$index];
                         if ($temp[$key] == $value) { 
                             $new_array[$key] = $my_array[$key]; 
                         } 
                 } 
             } 
             return $new_array; 
        }

        /**
         *
         * @normalize json array of layer_metadata_featuretype_wfs-conf relations to object
         * json array is given as result of database procedure f_get_layer_featuretype_coupling
         * examples (the second boolean parameter defines, if only those couplings should be pulled, that have pre-configured featuretypes!):
         * select f_get_layer_featuretype_coupling(array[20370,20369], FALSE);
         * select f_get_layer_featuretype_coupling(ARRAY(select layer_id from layer), TRUE);
         *
         * @param string $jsonTable
         *
         * 
         * @return string normalized json object: layer->metadata->featuretype->wfs_conf
         *
        */
    	public function normalizeLayerFeaturetypeCoupling($jsonTable) { 
 	    $originalJsonArray = json_decode($jsonTable, TRUE); //!array - not object!
	    //initialize temp arrays
	    $layerIdArray = array();
	    $metadataIdArray = array();
	    $featuretypeIdArray = array();
	    $wfsconfIdArray = array();
	    //$returnObject = new StdClass();
	    $layerCount = 0;
	    $metadataCount = 0;
	    $featuretypeCount = 0;
	    $wfsConfCount = 0;
	    foreach ($originalJsonArray as $layerRecord) {
	    	if (!in_array($layerRecord['layerId'], $layerIdArray)) {
	    	    //get all entries for metadataId
		    $returnObject->layer[$layerCount]->id = $layerRecord['layerId'];
		    $reducedLayerArray = $this->array_filter_by_value($originalJsonArray, 'layerId', $layerRecord['layerId']);
		    foreach ($reducedLayerArray as $metadataRecord) {
			if (!in_array($metadataRecord['metadataId'], $metadataIdArray) && $metadataRecord['$metadataId'] !== 0) {
			    $returnObject->layer[$layerCount]->metadata[$metadataCount]->id = $metadataRecord['metadataId'];
			    $reducedMetadataArray = $this->array_filter_by_value($reducedLayerArray, 'metadataId', $metadataRecord['metadataId']);
			    if ($reducedMetadataArray !== null) {
				foreach ($reducedMetadataArray as $featuretypeRecord) {
				    if ($featuretypeRecord['$featuretypeId'] !== 0) {
					$returnObject->layer[$layerCount]->metadata[$metadataCount]->featuretype[$featuretypeCount]->id = $featuretypeRecord['featuretypeId'];
					$reducedFeaturetypeArray = $this->array_filter_by_value($reducedMetadataArray, 'featuretypeId', $featuretypeRecord['featuretypeId']);
					if ($reducedFeaturetypeArray !== null) {
					    foreach ($reducedFeaturetypeArray as $wfsConfRecord) {
					        if (!in_array($wfsConfIdArray, $wfsConfRecord['wfsConfId']) && $wfsConfRecord['wfsConfId'] !== 0) {
						    $returnObject->layer[$layerCount]->metadata[$metadataCount]->featuretype[$featuretypeCount]->wfsConf[$wfsConfCount]->id = $wfsConfRecord['wfsConfId'];
						}
						$wfsConfIdArray[] = $wfsConfRecord['wfsConfId'];
						$wfsConfCount++;
					    }			
					    $wfsConfCount = 0;
					    $featuretypeIdArray[] = $featuretypeRecord['featuretypeId'];
					    $featuretypeCount++;	
					}
				    }
				}
				$featuretypeCount = 0;
				$wfsConfCount = 0;
				$metadataIdArray[] = $metadataRecord['metadataId'];
			        $metadataCount++;
			    }
			}
		    }
		    $metadataCount = 0;
		    $featuretypeCount = 0;
		    $wfsConfCount = 0;
		    $layerIdArray[] = $layerRecord['layerId'];
		    $layerCount++;
		}
	    }
            return json_encode($returnObject); 
        }

	public static function getWmsMetadataUrl ($wmsId) {
		#return preg_replace(
		#	"/(.*)frames\/login.php/", 
		#	"$1php/mod_layerMetadata.php?id=", 
		#	LOGIN
		#) . $wmsId;
		//MAPBENDER_PATH maybe something like http://www.geoportal.rlp.de/mapbender !
		if (defined("MAPBENDER_PATH") && MAPBENDER_PATH != "") {
		    return str_replace("mapbender","",MAPBENDER_PATH)."wms/".$wmsId;
		} else {
		    return str_replace("portal/anmelden.html","",LOGIN)."wms/".$wmsId;
                }  
		//the following may be activated if the metadata for the resources can be accessed over restful urls - maybe with help of apaches mod_rewrite
		#return "http://www.geoportal.rlp.de/wms/".$wmsId;
	}
	public static function getLayerMetadataUrl ($layerId) {
		#return preg_replace(
		#	"/(.*)frames\/login.php/", 
		#	"$1php/mod_layerMetadata.php?id=", 
		#	LOGIN
		#) . $wmsId;		
		//MAPBENDER_PATH maybe something like http://www.geoportal.rlp.de/mapbender !
		if (defined("MAPBENDER_PATH") && MAPBENDER_PATH != "") {
		    return str_replace("mapbender","",MAPBENDER_PATH)."layer/".$layerId;
		} else {
		    return str_replace("portal/anmelden.html","",LOGIN)."layer/".$layerId;
		}
		//the following may be activated if the metadata for the resources can be accessed over restful urls - maybe with help of apaches mod_rewrite
		#return "http://www.geoportal.rlp.de/layer/".$layerId;
	}
	public static function isOwsProxyUrl ($getmap) {
//		$e = new mb_notice("isOwsProxyUrl? " . $getmap);
		$result = preg_match("/^.*owsproxy.([^i][\w\d]+)\/([\w\d]{32})\/?.*$/", $getmap);
//		$e = new mb_notice("result: " . $result);
		return $result;
	}

	private function replaceSessionIdInOwsProxyUrl ($getMap) {
//		$e = new mb_notice("replaceSessionIdInOwsProxyUrl: ");
		$e = new mb_notice("before: " . $getMap);
		$pattern = '/(^.*owsproxy.)([^i][\w\d]+)(\/)([\w\d]{32})(\/?.*)$/';
		$getMap1= preg_replace($pattern, "$1",$getMap);
		$getMap2=  preg_replace($pattern, "$3$4$5",$getMap);
		$getMap = $getMap1.session_id().$getMap2;
		$e = new mb_notice("after: " . $getMap);
		return $getMap;
	}
	
	public static function getHashFromOwsProxyUrl ($getMap) {
//		$e = new mb_notice("replaceSessionIdInOwsProxyUrl: " . $getMap);
		$result = preg_replace("/^.*owsproxy.([^i][\w\d]+)\/([\w\d]{32})\/?.*$/", "$2", $getMap);
//		$e = new mb_notice("result: " . $result);
		return $result;
	}
	
	private function getWmsIdByOwsProxyHash($md5) {
		$sql = "SELECT wms_id FROM wms WHERE wms_owsproxy = $1";
		$v = array($md5);
		$t = array("s");
		$res = db_prep_query($sql, $v, $t);
		$row = db_fetch_row($res);
		if ($row["wms_id"]) {
			return $row["wms_id"];
		}
		return null;
	}
	
	private function updateOwsProxyUrl ($url) {
		// is OWS proxy URL?
		if (self::isOwsProxyUrl($url)) {

			// No WMS id could be found
			if (!$this->wms_id) {
				$e = new mb_notice("No WMS id could be found!");
				return $url;
			}			
			// Update session id in OWS proxy URL
			$new_proxy_url = $this->replaceSessionIdInOwsProxyUrl($url);

			// If new url is a valid proxy URL, return true
			if (self::isOwsProxyUrl($new_proxy_url)) {
				return $new_proxy_url;
			}
			else {
//				$e = new mb_notice("new URL is not an OWS proxy URL!");
			}
			// new URL is not an OWS proxy URL; 
			// some error must have occured.
			// no update
			return $url;
		}
		// no OWS proxy URL, no update necessary
//		$e = new mb_notice("URL is not an OWS proxy URL!");
		return $url;
	}
	
	function updateAllOwsProxyUrls () {
		$wmsId = $this->wms_id;

		// if WMS id is unknown, try to 
		// find it via OWS proxy entry
		//FIXME -Funktion berichtigen 
		if (!$wmsId) {
			$md5 = wms::getHashFromOwsProxyUrl($url);
			if ($md5) {
				$wmsId = $this->getWmsIdByOwsProxyHash($md5);
				if (!is_null($wmsId)) {
					$this->wms_id = $wmsId;
				}
			}
		}

		$this->wms_getmap = 
			$this->updateOwsProxyUrl($this->wms_getmap);
		$this->wms_getfeatureinfo = 
			$this->updateOwsProxyUrl($this->wms_getfeatureinfo);
		$this->wms_getlegendurl = 
			$this->updateOwsProxyUrl($this->wms_getlegendurl);
		
		for ($i = 0; $i < count($this->objLayer); $i++) {
			for ($j = 0; $j < count($this->objLayer[$i]->layer_style); $j++) {
				$this->objLayer[$i]->layer_style[$j]["legendurl"] = 
					$this->updateOwsProxyUrl($this->objLayer[$i]->layer_style[$j]["legendurl"]);
			}
		}
	}
	
	public static function getConjunctionCharacter ($url) {
		if (mb_strpos($url, "?") !== false) { 
			if (mb_substr($url, mb_strlen($url)-1, 1) == "?") { 
				return "";
			}
			else if (mb_substr($url, mb_strlen($url)-1, 1) == "&"){
				return "";
			}
			else {
				return "&";
			}
		}
		else {
			return "?";
		}
		return "";
	}
	//TODO: Problem layer_name is not always given - use other possibility to gain access - think deeper
	public function getLayerById ($id) {
		$adm = new administration();
		for ($i = 0; $i < count($this->objLayer); $i++) {
			if (strval($this->objLayer[$i]->layer_uid) === strval($id)) {
				if ($adm->getLayerPermission(
							$this->wms_id, 
							$this->objLayer[$i]->layer_name, 
							Mapbender::session()->get("mb_user_id")
				)) {
					return $this->objLayer[$i];
				}
				else {
					throw new AccessDeniedException ($id);
				}
			}
		}
		throw new Exception ("Layer not found.");
	}
	//TODO: Problem layer_name is not always given - use other possibility to gain access - think deeper
	public function &getLayerReferenceById ($id) {//this is done to update one layer with the metadata editor!
		$adm = new administration();
		for ($i = 0; $i < count($this->objLayer); $i++) {
			if (strval($this->objLayer[$i]->layer_uid) === strval($id)) {
				if ($adm->getLayerPermission(
							$this->wms_id, 
							$this->objLayer[$i]->layer_name, 
							Mapbender::session()->get("mb_user_id")
				)) {
					//return the reference to the layer which will be updated
					return $this->objLayer[$i];
				}
				else {
					throw new AccessDeniedException ($id);
				}
			}
		}
		throw new Exception ("Layer not found.");
	}


	public function getLayerByPos ($pos) {
		for ($i = 0; $i < count($this->objLayer); $i++) {
			if (strval($this->objLayer[$i]->layer_pos) === strval($pos)) {
				return $this->objLayer[$i];
			}
		}
		return null;
	}

	function createOlObjFromWMS($base){
	 	if(!$this->wms_title || $this->wms_title == ""){
			echo "alert('Error: no valid capabilities-document !!');";
			die; exit;
		}
		// wms_title and abstract have previously been urlencoded
		// this solution may not yet be the ultimate one
		
		$add_wms_string  = "var wms_".$this->wms_id." = new OpenLayers.Layer.WMS(";
		// WMS-title
		$add_wms_string .= "'" . addslashes($this->wms_title) . "',";
		// Base-URL of service
		$add_wms_string .= "'" . $this->wms_getmap ."',";
		// Additional URL params
		$add_wms_string .= "{layers:'";
		for($i=1;$i<count($this->objLayer);$i++){
			$add_wms_string .= addslashes($this->objLayer[$i]->layer_name);
			if($i!=count($this->objLayer)-1) {
				$add_wms_string .= ",";
			}
		}
		$add_wms_string .= "',";
		// This is hardcoded, exactly as for Mapbender WMS
		$add_wms_string .= "transparent: 'true',";
		$add_wms_string .= "format: '".$this->gui_wms_mapformat."'},";
		// OpenLayers-Layer options
		$add_wms_string .= "{";
		$add_wms_string .= 	"transitionEffect:'resize',";
		$add_wms_string .= 	"ratio:1.2,";
		$add_wms_string .= 	"singleTile:true,";
		// baselayer?				
		if($base) {
			$add_wms_string .= 	"isBaseLayer:true,";
		} else {
			$add_wms_string .= 	"isBaseLayer:false,";
		}
		// visible or not?
		if($this->gui_wms_visible=="1") {
			$add_wms_string .= 	"visibility:true,";
		} else {
			$add_wms_string .= 	"visibility:false,";
		}

		// max extent
		for ($i = 0; $i < count($this->objLayer[0]->layer_epsg); $i++) {
			$rootLayerEpsg = $this->objLayer[0]->layer_epsg[$i];
			if ($rootLayerEpsg["epsg"] === "EPSG:4326") {
				$add_wms_string .= "maxExtent: new OpenLayers.Bounds(" .
					$rootLayerEpsg["minx"] . "," .
					$rootLayerEpsg["miny"] . "," .
					$rootLayerEpsg["maxx"] . "," .
					$rootLayerEpsg["maxy"] .
				"),";
			}
		}

		// initial transparency
		$add_wms_string .= 	"opacity:" . strval(round($this->gui_wms_opacity/100, 2));

		$add_wms_string .= "}";
		$add_wms_string .= ");";
		
		$queryLayers = array();
		for ($i = 0; $i < count($this->objLayer); $i++) {
			$layer = $this->objLayer[$i];
			if ($layer->layer_queryable 
				&& $layer->gui_layer_queryable 
				&& $layer->gui_layer_querylayer
			) {
				$queryLayers[]= $layer->layer_name;
			}
		}
		$queryLayerString = implode(",", $queryLayers);
		$add_wms_string .= "wms_" . $this->wms_id . ".params.QUERY_LAYERS = '$queryLayerString';";

		// TODO why ol_map
		$add_wms_string .= "ol_map.addLayer(wms_".$this->wms_id.");";
		echo $add_wms_string;
	}	
	
	/**
	 * Compares this WMS to another WMS.
	 * 
	 * @return boolean false, if
	 * 					- the capabilities URLs don't match
	 * 					- the layer count is different
	 * 					- the layer names are different
	 * 
	 * @param $anotherWms wms this is just another WMS object
	 */
	public function equals ($anotherWms) {
		// If the getMap URLs are not equal, the WMS are not equal.
		if ($this->wms_getmap != $anotherWms->wms_getmap) {
//			$e = new mb_notice($this . " != " . $anotherWms . " (getMap URL)");
			return false;
		}

		// If the layer count is different, the WMS are not equal.
		if (count($this->objLayer) != count($anotherWms->objLayer)) {
//			$e = new mb_notice($this . " != " . $anotherWms . " (layer count: " . count($this->objLayer) . ":" . count($anotherWms->objLayer). ")");
// removing this check because you can also load single layers of WMS!
// so you might load different layers of the WMS at different times,
// they need to be grouped under the same WMS
//			return false;
		}
		
		// If the layer names are different, the WMS are not equal.
		for ($i = 0; $i < count($this->objLayer); $i++) {
			$name1 = $this->objLayer[$i]->layer_name;
			$name2 = $anotherWms->objLayer[$i]->layer_name;
			if ($name1 != $name2) {
//				$e = new mb_notice($this . " != " . $anotherWms . " (layer names, " . $name1 . " vs. " . $name2 . ")");
// removing this check because you can also load single layers of WMS!
// so you might load different layers of the WMS at different times,
// they need to be grouped under the same WMS
//				return false;
			}
		}
		
//		$e = new mb_notice($this . " == " . $anotherWms);
		return true;
	}  
	
	/**
	 * Removes duplicate WMS from an array of WMS. To find duplicates,
	 * two WMS are compared via equals().
	 * 
	 * @return wms[]
	 * @param $wmsArray wms[]
	 */
	public static function merge ($wmsArray) {
//		$e = new mb_notice("before: " . implode(", ", $wmsArray));
		if (!is_array($wmsArray)) {
			$e = new mb_notice("class_wms.php: merge(): parameter is NOT an array.");
			return array();
		}
		if (count($wmsArray) == 0) {
			$e = new mb_notice("class_wms.php: merge(): parameter is an EMPTY array.");
			return array();
		}

		$newWmsArray = array();

		while (count($wmsArray) > 0) {
			$currentWms = array_pop($wmsArray);

			$isNewWms = true;

			if (get_class($currentWms) != "wms") {
				$e = new mb_notice("class_wms.php: merge(): current WMS is not a WMS object, but a " . get_class($currentWms));
			}
			else {
				$index = null;
				for ($i = 0; $i < count($newWmsArray) && $isNewWms; $i++) {
					if ($currentWms->equals($newWmsArray[$i])) {
						$isNewWms = false;
						$index = $i;
					}
				}
				if ($isNewWms) {
					$e = new mb_notice("adding WMS " . $currentWms);
					$newWmsArray[]= $currentWms;
				}
				else {
					$existingWms = $newWmsArray[$index];

					$len = count($currentWms->objLayer);
					for ($i = 0; $i < $len; $i++) {
						$currentWmsLayer = $currentWms->objLayer[$i];
						$found = false;
						$lenExist = count($existingWms->objLayer);
						for ($j = 0; $j < $lenExist; $j++) {
							$existingWmsLayer = $existingWms->objLayer[$j];
							if ($currentWmsLayer->equals($existingWmsLayer)) {
								$found = true;
								break;
							}
							if ($existingWmsLayer->layer_pos > $currentWmsLayer->layer_pos) {
								break;
							}
						}
						if (!$found) {
							array_splice($existingWms->objLayer, $j, 0, array($currentWmsLayer));
						}
					}
				}
			}
		}
		// reversal of the array, because the elements were popped 
		// from another array before.
		$e = new mb_notice("after: " . implode(", ", array_reverse($newWmsArray)));
		return array_reverse($newWmsArray);
	}

	private function formatExists ($type, $format) {
		for ($i = 0; $i < count($this->data_type); $i++) {
			if ($type == $this->data_type[$i] && $format == $this->data_format[$i]) {
				$e = new mb_warning("WMS format already exists ($type, $format). Violation of WMS spec. Ignoring this WMS format.");
				return true;
			}
		}
		return false;
	}

	public function __toString () {
		return strval($this->wms_title);
	}
	
	function createObjFromXML($url, $auth=false, $datasetId=false){
		if ($auth != false) { //new for HTTP Authentication
			$x = new connector($url, $auth);
		}
		else {
			$x = new connector($url);
		}
		//built hashes for category mapping
		$topicCatHash = array();
		$sql = "SELECT md_topic_category_id, md_topic_category_code_en FROM md_topic_category";
		$res = db_query($sql);
		while ($row = db_fetch_array($res)){
			$topicCatHash[$row['md_topic_category_code_en']] = (integer)$row['md_topic_category_id'];
					
		}
		//inspire
		$inspireCatHash = array();
		$sql = "SELECT inspire_category_id, inspire_category_code_en FROM inspire_category";
		$res = db_query($sql);
		while ($row = db_fetch_array($res)){
			$inspireCatHash[$row['inspire_category_code_en']] = (integer)$row['inspire_category_id'];
			}
		//custom
		//keywords - as text i custom category - special keywords of geoportal instance defined as keys!
		$customCatHash = array();
		$sql = "SELECT custom_category_id, custom_category_key FROM custom_category";
		$res = db_query($sql);
		while ($row = db_fetch_array($res)){
			$customCatHash[$row['custom_category_key']] = (integer)$row['custom_category_id'];	
		}
		$data = $x->file;
		if ($data=='401') {
			$e = new mb_exception("classes/class_wms.php: HTTP Error:".$data." - Authorization required. This seems to be a service which needs HTTP Authentication!");
			//echo "<br>HTTP Error:<b>".$data." - Authorization required. This seems to be a service which needs HTTP Authentication!</b><br>";
			$returnObject['success'] = false;
			$returnObject['message'] = _mb("classes/class_wms.php: HTTP Error:".$data." - Authorization required. This seems to be a service which needs HTTP Authentication!");
			return $returnObject;
		}
		if(!$data){
			$this->wms_status = false;
			return false;
		}
		else {
			$this->wms_status = true;
		}
			
		$values = null;
		$tags = null;
		$admin = new administration();
		$this->wms_getcapabilities_doc = $data;
		$this->wms_upload_url = $url;
		
		$this->wms_id = "";
		$parser = xml_parser_create("");
		xml_parser_set_option($parser,XML_OPTION_CASE_FOLDING,0);
		xml_parser_set_option($parser,XML_OPTION_SKIP_WHITE,1);
		xml_parser_set_option($parser,XML_OPTION_TARGET_ENCODING,CHARSET);
		xml_parse_into_struct($parser,$data,$values,$tags);

		$code = xml_get_error_code($parser);
		if ($code) {
			$line = xml_get_current_line_number($parser); 
			$mb_exception = new mb_exception(xml_error_string($code) .  " in line " . $line);
		}
		
		xml_parser_free($parser);
		
		$section = null;
		$format = null;
		$cnt_format = 0;
		$parent = array();
		$myParent = array();
		$cnt_layer = -1;
		$request = null; 
		$layer_style = array();
		$cnt_styles = -1;
		
		$this->wms_getfeatureinfo = "";
		$this->gui_wms_featureinfoformat = "";
		$this->wms_max_imagesize = 0;
		foreach ($values as $element) {
			if(mb_strtoupper($element['tag']) == "WMT_MS_CAPABILITIES" && $element['type'] == "open"){
				$this->wms_version = $element['attributes']['version'];
			}
			//WMS 1.3.0
			if(mb_strtoupper($element['tag']) == "WMS_CAPABILITIES" && $element['type'] == "open"){
				$this->wms_version = $element['attributes']['version'];
			}
			if(mb_strtoupper($element['tag']) == "TITLE" && $element['level'] == '3'){
				$this->wms_title = $this->stripEndlineAndCarriageReturn($element['value']);
			}
			if(mb_strtoupper($element['tag']) == "ABSTRACT" && $element['level'] == '3'){
				$this->wms_abstract = $this->stripEndlineAndCarriageReturn($element['value']);
			}
			if(mb_strtolower($element['tag']) == "fees"){
				$this->fees = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "accessconstraints"){
				$this->accessconstraints = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "contactperson"){
				$this->contactperson = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "contactposition"){
				$this->contactposition = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "contactorganization"){
				$this->contactorganization = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "address"){
				$this->address = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "city"){
				$this->city = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "stateorprovince"){
				$this->stateorprovince = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "postcode"){
				$this->postcode = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "country"){
				$this->country = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "contactvoicetelephone"){
				$this->contactvoicetelephone = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "contactfacsimiletelephone"){
				$this->contactfacsimiletelephone = $element['value'];
			}
			if(mb_strtolower($element['tag']) == "contactelectronicmailaddress"){
				$this->contactelectronicmailaddress = $element['value'];
			}
	  		if(mb_strtolower($element['tag']) == "keyword" && $section != 'layer'){
				$this->wms_keyword[count($this->wms_keyword)] = $element['value'];
			}
			
			/*map section*/
			if($this->wms_version == "1.0.0"){
		 		if(mb_strtoupper($element['tag']) == "MAP" && $element['type'] == "open"){
					$section = "map";
				}
				if($section == "map" && mb_strtoupper($element['tag']) == "GET"){
					$this->wms_getmap = $element['attributes'][onlineResource];
				}
				if($section == "map" && mb_strtoupper($element['tag']) == "FORMAT" && $element['type'] == "open"){
					$format = "map";
				}
				if(mb_strtoupper($element['tag']) != "FORMAT" && $section == "map" && $format == "map"){
					if (!$this->formatExists("map", trim($element['tag']))) {
						$this->data_type[$cnt_format] = "map";
						$this->data_format[$cnt_format] = trim($element['tag']);
						$cnt_format++;
					}
				}
				if(mb_strtoupper($element['tag']) == "FORMAT" && $element['type'] == "close"){
					$format = "";
				}
				if(mb_strtoupper($element['tag']) == "MAP" && $element['type'] == "close"){
					$section = "";
				}
			}
			else{
				if(mb_strtoupper($element['tag']) == "GETMAP" && $element['type'] == "open"){
					$section = "map";
				}
				if($section == "map" && mb_strtoupper($element['tag']) == "GET" && $element['type'] == "open"){
					$request = "get";
				}
				if($section == "map" && $request == "get" && mb_strtoupper($element['tag']) == "ONLINERESOURCE"){
					$this->wms_getmap = $element['attributes']["xlink:href"];
				}
				if($section == "map" && mb_strtoupper($element['tag']) == "FORMAT"){
					if (!$this->formatExists("map", trim($element['value']))) {
						$this->data_type[$cnt_format] = "map";
						$this->data_format[$cnt_format] = trim($element['value']);
						$cnt_format++;
					}
				}
				if($section == "map" && mb_strtoupper($element['tag']) == "GET" && $element['type'] == "close"){
					$request = "";
				}
				if(mb_strtoupper($element['tag']) == "GETMAP" && $element['type'] == "close"){
					$section = "";
				}
			}
			/*capabilities section*/
			if($this->wms_version == "1.0.0"){
				if(mb_strtoupper($element['tag']) == "CAPABILITIES" && $element['type'] == "open"){
					$section = "capabilities";
				}
				if($section == "capabilities" && mb_strtoupper($element['tag']) == "GET"){
					$this->wms_getcapabilities = $element['attributes'][onlineResource];
				}
				if(mb_strtoupper($element['tag']) == "CAPABILITIES" && $element['type'] == "close"){
					$section = "";
				}
			}
			else{
				if(mb_strtoupper($element['tag']) == "GETCAPABILITIES" && $element['type'] == "open"){
					$section = "capabilities";
				}
				if($section == "capabilities" && mb_strtoupper($element['tag']) == "GET" && $element['type'] == "open"){
					$request = "get";
				}
				if($section == "capabilities" && $request == "get" && mb_strtoupper($element['tag']) == "ONLINERESOURCE"){
					$this->wms_getcapabilities = $element['attributes']["xlink:href"];
				}
				if($section == "capabilities" && mb_strtoupper($element['tag']) == "GET" && $element['type'] == "close"){
					$request = "";
				}
				if(mb_strtoupper($element['tag']) == "GETCAPABILITIES" && $element['type'] == "close"){
					$section = "";
				}
			}
			/*featureInfo section*/
			if($this->wms_version == "1.0.0"){
				if(mb_strtoupper($element['tag']) == "FEATUREINFO" && $element['type'] == "open"){
					$section = "featureinfo";
				}
				if($section == "featureinfo" && mb_strtoupper($element['tag']) == "GET"){
					$this->wms_getfeatureinfo = $element['attributes'][onlineResource];
				}
				if($section == "featureinfo" && mb_strtoupper($element['tag']) == "FORMAT" && $element['type'] == "open"){
					$format = "featureinfo";
				}
				if(mb_strtoupper($element['tag']) != "FORMAT" && $section == "featureinfo" && $format == "featureinfo"){
					if (!$this->formatExists("featureinfo", trim($element['tag']))) {
						$this->data_type[$cnt_format] = "featureinfo";
						$this->data_format[$cnt_format] = trim($element['tag']);
						$cnt_format++;
					}
				}
				if(mb_strtoupper($element['tag']) == "FORMAT" && $element['type'] == "close"){
					$format = "";
				}
				if(mb_strtoupper($element['tag']) == "FEATUREINFO" && $element['type'] == "close"){
					$section = "";
				}
			}
			else{
				if(mb_strtoupper($element['tag']) == "GETFEATUREINFO" && $element['type'] == "open"){
					$section = "featureinfo";
				}
				if($section == "featureinfo" && mb_strtoupper($element['tag']) == "GET" && $element['type'] == "open"){
					$request = "get";
				}
				if($section == "featureinfo" && $request == "get" && mb_strtoupper($element['tag']) == "ONLINERESOURCE"){
					$this->wms_getfeatureinfo = $element['attributes']["xlink:href"];
				}
				if($section == "featureinfo" && mb_strtoupper($element['tag']) == "FORMAT"){
					if (!$this->formatExists("featureinfo", trim($element['value']))) {
						$this->data_type[$cnt_format] = "featureinfo";
						$this->data_format[$cnt_format] = trim($element['value']);
						$cnt_format++;
					}
				}
				if($section == "featureinfo" && mb_strtoupper($element['tag']) == "GET" && $element['type'] == "close"){
					$request = "";
				}
				if(mb_strtoupper($element['tag']) == "GETFEATUREINFO" && $element['type'] == "close"){
					$section = "";
				}
			}
			/*exception section*/
			if($this->wms_version == "1.0.0"){
				if(mb_strtoupper($element['tag']) == "EXCEPTION" && $element['type'] == "open"){
					$section = "exception";
				}
				if($section == "exception" && mb_strtoupper($element['tag']) == "FORMAT" && $element['type'] == "open"){
					$format = "exception";
				}
				if(mb_strtoupper($element['tag']) != "FORMAT" && $section == "exception" && $format == "exception"){
					$this->data_type[$cnt_format] = "exception";
					$this->data_format[$cnt_format] = trim($element['tag']);
					$cnt_format++;
				}
				if($section == "exception" && mb_strtoupper($element['tag']) == "FORMAT" && $element['type'] == "close"){
					$format = "";
				}
				if(mb_strtoupper($element['tag']) == "EXCEPTION" && $element['type'] == "close"){
					$section = "";
				}
			}
			else{
				if(mb_strtoupper($element['tag']) == "EXCEPTION" && $element['type'] == "open"){
					$section = "exception";
				}
				if($section == "exception" && mb_strtoupper($element['tag']) == "FORMAT"){
					$this->data_type[$cnt_format] = "exception";
					$this->data_format[$cnt_format] = trim($element['value']);
					$cnt_format++;
				}
				if(mb_strtoupper($element['tag']) == "EXCEPTION" && $element['type'] == "close"){
					$section = "";
				}
			}
	      /*legend section*/
	      if($this->wms_version == "1.0.0"){
	      
	      }
	      else{
	        if(mb_strtoupper($element['tag']) == "GETLEGENDGRAPHIC" && $element['type'] == "open"){
				$section = "legend";
			}
	        if($section == "legend" && mb_strtoupper($element['tag']) == "GET" && $element['type'] == "open"){
				$request = "get";
			}
			if($section == "legend" && $request == "get" && mb_strtoupper($element['tag']) == "ONLINERESOURCE"){
				$this->wms_getlegendurl = $element['attributes']["xlink:href"];
			}
	        if($section == "legend" && mb_strtoupper($element['tag']) == "GET" && $element['type'] == "close"){
				$request = "";
			}
			if(mb_strtoupper($element['tag']) == "GETLEGENDGRAPHIC" && $element['type'] == "close"){
				$section = "";
			}         
	      }
			/* sld section */	      
			if(mb_strtoupper($element['tag']) == "USERDEFINEDSYMBOLIZATION" && $element['type'] == "complete"){
				$this->wms_supportsld = $element['attributes']["SupportSLD"];
				$this->wms_userlayer = $element['attributes']["UserLayer"];
				$this->wms_userstyle = $element['attributes']["UserStyle"];
				$this->wms_remotewfs = $element['attributes']["RemoteWFS"];
			}
	      	      
			/*layer section*/				
			if(mb_strtoupper($element['tag']) == "LAYER"){
				$section = "layer";
				if ($element['type'] == "open") {
					$cnt_epsg = -1;
					//new for resolving metadataurls and dataurls
					$cnt_metadataurl = -1;
					$cnt_dataurl = -1;
					$cnt_dimension = -1;
					$cnt_layer++;
					$parent[$element['level']+1] = $cnt_layer;
					$myParent[$cnt_layer]= $parent[$element['level']];
					$this->addLayer($cnt_layer,$myParent[$cnt_layer]);
					$this->objLayer[$cnt_layer]->layer_queryable = $element['attributes']['queryable'];
				}
				if ($element['type'] == "close") {
				
				}
			}
			/* attribution */
			if(mb_strtoupper($element['tag']) == "ATTRIBUTION"){
				if ($element['type'] == "open") {
					$section = "attribution";
				}
				if ($element['type'] == "close") {
					$section = "layer";
				}
			}
			/* styles */
			if(mb_strtoupper($element['tag']) == "STYLE"){
				$section = "style";
				if($cnt_layer != $layer_style){
					$layer_style = $cnt_layer;
					$cnt_styles = -1;
				}
				if ($element['type'] == "open") {
					$cnt_styles++;
				}
				if ($element['type'] == "close") {
					$section = "layer";
				}
			}
			if($section == "style"){
				if(mb_strtoupper($element['tag']) == "NAME"){
					$this->objLayer[$cnt_layer]->layer_style[$cnt_styles]["name"] = ($element['value'] ? $element['value'] : 'default');
				}
				if(mb_strtoupper($element['tag']) == "TITLE"){
					$this->objLayer[$cnt_layer]->layer_style[$cnt_styles]["title"] = ($element['value'] ? $element['value'] : '');
				}
	      			if(mb_strtoupper($element['tag']) == "LEGENDURL" && $element['type'] == "open"){
					$legendurl = true;
				}
				if($legendurl && mb_strtoupper($element['tag']) == "FORMAT"){
					$this->objLayer[$cnt_layer]->layer_style[$cnt_styles]["legendurlformat"] = $element['value'];
				}
				if($legendurl && mb_strtoupper($element['tag']) == "ONLINERESOURCE"){
					$this->objLayer[$cnt_layer]->layer_style[$cnt_styles]["legendurl"] = $element['attributes']["xlink:href"];
				}
				if(mb_strtoupper($element['tag']) == "LEGENDURL" && $element['type'] == "close"){
					$legendurl = false;
				}   
			}
			/* end of styles */
			if($section == "layer"){
				if(mb_strtoupper($element['tag']) == "NAME"){
					$this->objLayer[$cnt_layer]->layer_name = $element['value'];
				}
				if(mb_strtoupper($element['tag']) == "IDENTIFIER"){
					if ($datasetId != false) {
					    if ($datasetId == $element['value']) {
						$e = new mb_exception("classes/class_wms.php: found a layer with searched identifier in wms - its name is: ".$this->objLayer[$cnt_layer]->layer_name);
						//only set the identifier if a requested datasetId was found
						$this->objLayer[$cnt_layer]->layer_identifier = $element['value'];
					    }
					}
					//$this->objLayer[$cnt_layer]->layer_identifier = $element['value'];
				}
				if(mb_strtoupper($element['tag']) == "TITLE"){
					$this->objLayer[$cnt_layer]->layer_title = $this->stripEndlineAndCarriageReturn($element['value']);
				}
				if(mb_strtoupper($element['tag']) == "ABSTRACT"){
					$this->objLayer[$cnt_layer]->layer_abstract = $this->stripEndlineAndCarriageReturn($element['value']);
				}
				if(mb_strtoupper($element['tag']) == "KEYWORD"){
					array_push($this->objLayer[$cnt_layer]->layer_keyword, trim($element['value']));
					//add vocabulary attribut to keyword object
					//read attribute
					if (isset($element['attributes']['vocabulary'])) {
						switch ($element['attributes']['vocabulary']) {
							case "ISO 19115:2003":
								array_push($this->objLayer[$cnt_layer]->layer_keyword_vocabulary, "ISO 19115:2003");
								//add id for isoCategory
								if (is_int($topicCatHash[trim($element['value'])])) {
									$this->objLayer[$cnt_layer]->layer_md_topic_category_id[] = (integer)$topicCatHash[trim($element['value'])];
								}
							break;
							case "GEMET - INSPIRE themes":
								array_push($this->objLayer[$cnt_layer]->layer_keyword_vocabulary, "GEMET - INSPIRE themes, version 1.0");
								//check if keyword is a key in mapbenders inspire keywords and add it to mapbenders inspire categories
								if (is_int($inspireCatHash[trim($element['value'])])) {
									$this->objLayer[$cnt_layer]->layer_inspire_category_id[] = (integer)$inspireCatHash[trim($element['value'])];
								}
							break;
							case "http://www.mapbender.org":
								array_push($this->objLayer[$cnt_layer]->layer_keyword_vocabulary, "http://www.mapbender.org");
								//check if keyword is a key in mapbenders inspire keywords and add it to mapbenders inspire categories
								if (is_int($customCatHash[trim($element['value'])])) {
									$this->objLayer[$cnt_layer]->layer_custom_category_id[] = (integer)$customCatHash[trim($element['value'])];
								}
							break;
							default:
								array_push($this->objLayer[$cnt_layer]->layer_keyword_vocabulary, "none");
							break;
						}
					} else {
						array_push($this->objLayer[$cnt_layer]->layer_keyword_vocabulary, "none");
					}
				}
				
	      			if(mb_strtoupper($element['tag']) == "DATAURL" && $element['type'] == "open"){
					$dataurl = true;
					$cnt_dataurl++;
				}
				if($dataurl && mb_strtoupper($element['tag']) == "FORMAT"){
					$this->objLayer[$cnt_layer]->layer_dataurl[$cnt_dataurl]->format = $element['value'];
				}
				if($dataurl && mb_strtoupper($element['tag']) == "ONLINERESOURCE"){
					$this->objLayer[$cnt_layer]->layer_dataurl[$cnt_dataurl]->href = $element['attributes']["xlink:href"]; //TODO exchange the parsing with a real xml parsing cause namespaces will make problems!
				}
			    	if(mb_strtoupper($element['tag']) == "DATAURL" && $element['type'] == "close"){
					$dataurl = false;
			   	}   				
				if(mb_strtoupper($element['tag']) == "METADATAURL" && $element['type'] == "open"){
					$metadataurl = true;
					$cnt_metadataurl++;
					$this->objLayer[$cnt_layer]->layer_metadataurl[$cnt_metadataurl]->type = $element['attributes']["type"];
				}
				if($metadataurl && mb_strtoupper($element['tag']) == "FORMAT"){
					$this->objLayer[$cnt_layer]->layer_metadataurl[$cnt_metadataurl]->format = $element['value'];
				}
				if($metadataurl && mb_strtoupper($element['tag']) == "ONLINERESOURCE"){
					$this->objLayer[$cnt_layer]->layer_metadataurl[$cnt_metadataurl]->href = $element['attributes']["xlink:href"];
				}
			    	if(mb_strtoupper($element['tag']) == "METADATAURL" && $element['type'] == "close"){
					$metadataurl = false;
				}   
				
				if(mb_strtoupper($element['tag']) == "SRS"){
					if(count($this->wms_srs) < 1000){ //workaround: only import up to 1000 srs
					// unique srs only, see http://www.mapbender.org/index.php/Arrays_with_unique_entries
					$this->wms_srs = array_keys(array_flip(array_merge($this->wms_srs, explode(" ", strtoupper($element['value'])))));
					}
				}
				#WMS 1.3.0
				if(mb_strtoupper($element['tag']) == "CRS"){
					if(count($this->wms_srs) < 1000){ //workaround: only import up to 1000 srs
					// unique srs only, see http://www.mapbender.org/index.php/Arrays_with_unique_entries
					$this->wms_srs = array_keys(array_flip(array_merge($this->wms_srs, explode(" ", strtoupper($element['value'])))));	}
				}
				#WMS 1.3.0
				if(mb_strtoupper($element['tag']) == "EX_GEOGRAPHICBOUNDINGBOX" && $element['type'] == "open"){
					$section_bbox = "ex_geographicboundingbox";
				}
				if($section_bbox == "ex_geographicboundingbox" && mb_strtoupper($element['tag']) == "WESTBOUNDLONGITUDE"){
					$cnt_epsg++;
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["epsg"] = "EPSG:4326";
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["minx"] = trim($element['value']);
				}
				if($section_bbox == "ex_geographicboundingbox" && mb_strtoupper($element['tag']) == "SOUTHBOUNDLATITUDE"){
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["miny"] = trim($element['value']);
				}
				if($section_bbox == "ex_geographicboundingbox" && mb_strtoupper($element['tag']) == "EASTBOUNDLONGITUDE"){
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxx"] = trim($element['value']);
				}
				if($section_bbox == "ex_geographicboundingbox" && mb_strtoupper($element['tag']) == "NORTHBOUNDLATITUDE"){
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxy"] = trim($element['value']);
				}
				if(mb_strtoupper($element['tag']) == "GEOGRAPHICBOUNDINGBOX" && $element['type'] == "close"){
					$section_bbox = "";
				}						      
				if(mb_strtoupper($element['tag']) == "LATLONBOUNDINGBOX"){
					$cnt_epsg++;
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["epsg"] = "EPSG:4326";
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["minx"] = $element['attributes']['minx'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["miny"] = $element['attributes']['miny'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxx"] = $element['attributes']['maxx'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxy"] = $element['attributes']['maxy'];
				}
				if(mb_strtoupper($element['tag']) == "BOUNDINGBOX" && $element['attributes']['SRS'] != "EPSG:4326"
										&& $this->wms_version != "1.3.0"){
					$cnt_epsg++;
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["epsg"] = $element['attributes']['SRS'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["minx"] = $element['attributes']['minx'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["miny"] = $element['attributes']['miny'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxx"] = $element['attributes']['maxx'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxy"] = $element['attributes']['maxy'];
					// a default epsg for mapbender
					if($cnt_layer == 0 && $this->default_epsg == 0 && mb_strlen(trim($element['attributes']['SRS']))>= 10){
						$this->default_epsg = $cnt_epsg;
					}
				}
				#WMS 1.3.0
				if(mb_strtoupper($element['tag']) == "BOUNDINGBOX" && $element['attributes']['CRS'] == "EPSG:4326"
										&& $this->wms_version == "1.3.0"){
					$cnt_epsg++;
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["epsg"] = $element['attributes']['CRS'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["minx"] = $element['attributes']['miny'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["miny"] = $element['attributes']['minx'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxx"] = $element['attributes']['maxy'];
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxy"] = $element['attributes']['maxx'];
				}
				#WMS 1.3.0
				if(mb_strtoupper($element['tag']) == "BOUNDINGBOX" && $element['attributes']['CRS'] != "EPSG:4326"
										&& $this->wms_version == "1.3.0"){
					$cnt_epsg++;
					$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["epsg"] = $element['attributes']['CRS'];
					$tmp_epsg = $element['attributes']['CRS'];
					$tmp_epsg = str_replace('CRS:','',str_replace ( 'EPSG:', '', $tmp_epsg ));
					if(check_epsg_wms_13($tmp_epsg)){
						$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["minx"] = $element['attributes']['miny'];
						$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["miny"] = $element['attributes']['minx'];
						$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxx"] = $element['attributes']['maxy'];
						$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxy"] = $element['attributes']['maxx'];
					}else{
						//$e = new mb_exception("class_wms: createObjFromXML: WMS 1.3.0 ELSE");
						$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["minx"] = $element['attributes']['minx'];
						$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["miny"] = $element['attributes']['miny'];
						$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxx"] = $element['attributes']['maxx'];
						$this->objLayer[$cnt_layer]->layer_epsg[$cnt_epsg]["maxy"] = $element['attributes']['maxy'];
					}
					// a default epsg for mapbender
					if($cnt_layer == 0 && $this->default_epsg == 0 && mb_strlen(trim($element['attributes']['SRS']))>= 10){
						$this->default_epsg = $cnt_epsg;
					}
				}
				if(mb_strtoupper($element['tag']) == "SCALEHINT"){
					if($element['attributes']['max']>1000) $max = 0; else $max = $element['attributes']['max']; 	
					if($element['attributes']['min']>1000) $min = 0; else $min = $element['attributes']['min']; 	
					$this->objLayer[$cnt_layer]->layer_minscale = round(($min * 2004.3976484406788493955738891127));
					$this->objLayer[$cnt_layer]->layer_maxscale = round(($max * 2004.3976484406788493955738891127));
					$this->objLayer[$cnt_layer]->layer_minscale = sprintf("%u", $this->objLayer[$cnt_layer]->layer_minscale);
					$this->objLayer[$cnt_layer]->layer_maxscale = sprintf("%u", $this->objLayer[$cnt_layer]->layer_maxscale);
				}
				// Parse dimension for each layer
				if(mb_strtoupper($element['tag']) == "DIMENSION"){
					$cnt_dimension++;
					//extract dimension from capabilities
					$this->objLayer[$cnt_layer]->layer_dimension[$cnt_dimension]->name = $element['attributes']['name'];
					$this->objLayer[$cnt_layer]->layer_dimension[$cnt_dimension]->units = $element['attributes']['units'];
					if (isset($element['attributes']['unitSymbol']) && $element['attributes']['unitSymbol'] !== "") {
						$this->objLayer[$cnt_layer]->layer_dimension[$cnt_dimension]->unitSymbol = $element['attributes']['unitSymbol'];
					}
					switch ($this->wms_version) {
						case "1.1.1":
							//$this->objLayer[$cnt_layer]->layer_dimension[$cnt_dimension]->units = $element['attributes']['units'];
							break;
						case "1.3.0":
							//mandatory
							$this->objLayer[$cnt_layer]->layer_dimension[$cnt_dimension]->extent = $element['value'];
							//optional
							$optionalElements = array("default", "multipleValues", "nearestValue", "current");
							foreach ($optionalElements as $optionalElement) {
								if (isset($element['attributes'][$optionalElement]) && $element['attributes'][$optionalElement] !== "") {
									$this->objLayer[$cnt_layer]->layer_dimension[$cnt_dimension]->{$optionalElement} = $element['attributes'][$optionalElement];
								}
							}
							break; 
					}
				}
				//pull extent attributes for wms 1.1.1 into dimension object
				if ($this->wms_version == '1.1.1') {
					//$e = new mb_exception("version 1.1.1");
					if(mb_strtoupper($element['tag']) == "EXTENT"){
						//check for position of dimension element with same name
						$posDimensionName = 0;
						foreach ($this->objLayer[$cnt_layer]->layer_dimension as $layerDimension) {
							if ($layerDimension->name == $element['attributes']['name']) {
								
								break;
							}
							$posDimensionName++;
						}
						//extract 
						$this->objLayer[$cnt_layer]->layer_dimension[$posDimensionName]->extent = $element['value'];
						$mandatoryElements = array("default", "nearestValue");	
						foreach ($mandatoryElements as $mandatoryElement) {
							if (isset($element['attributes'][$mandatoryElement]) && $element['attributes'][$mandatoryElement] !== "") {
								$this->objLayer[$cnt_layer]->layer_dimension[$posDimensionName]->{$mandatoryElement} = $element['attributes'][$mandatoryElement];
							}
						}
					}
				}
			} 
			else {
				continue;
			}
		}
		//test if there are double layer names! - if so give a reasonable feedback to the users!
		//create array of layer_names:
		foreach ($this->objLayer as $layer) {
			$layerNames[] = $layer->layer_name;
			//$e = new mb_exception("class_wms: createObjFromXML: layer name: " . $layer->layer_name);
		}		
		//double entries
		$doubleLayers = $this->array_not_unique($layerNames);
		//foreach ($doubleLayers as $layer) {
		//	$e = new mb_exception("class_wms: createObjFromXML: double layers: " . $layer);
		//}

		if(count($doubleLayers) > 0) {
			$e = new mb_exception("class_wms: createObjFromXML: WMS has " . count($doubleLayers) . " double layer name entries and could therefor not be loaded.");
			$returnObject['success'] = false;
			$returnObject['message'] = _mb("WMS has following double layer names and could therefor not be loaded!");
			$returnObject['message'] .= " "._mb("Double layer names").": ".implode(',', $doubleLayers);
			return $returnObject;	
		}
		
		if(!$this->wms_title || $this->wms_title == "" || !$this->wms_getmap || $this->wms_getmap == ""){
			$this->wms_status = false;
			//$this->optimizeWMS();
			$e = new mb_exception("class_wms: createObjFromXML: WMS " . $url . " could not be loaded.");
			$returnObject['success'] = false;
			$returnObject['message'] = _mb("WMS could not be loaded!");
			return $returnObject;	
		} else {
			$this->wms_status = true;
			$this->optimizeWMS();
			$e = new mb_notice("class_wms: createObjFromXML: WMS " . $url . " has been loaded successfully.");
			$returnObject['success'] = true;
			$returnObject['message'] = _mb("WMS Capabilities has been parsed successfully!");
			return $returnObject;	
		}
	}

	//http://stackoverflow.com/questions/1259407/php-return-only-duplicated-entries-from-an-array
	function array_not_unique($raw_array) {
    		$dupes = array();
    		natcasesort($raw_array);
    		reset ($raw_array);
   		$old_key    = NULL;
     		$old_value    = NULL;
  		foreach ($raw_array as $key => $value) {
        		if ($value === NULL) { continue; }
        		if (strcmp($old_value, $value) === 0) {
            			$dupes[$old_key]    = $old_value;
            			$dupes[$key]        = $value;
        		}
        		$old_value    = $value;
        		$old_key    = $key;
    		}
		return $dupes;
	}

	function getLayerInfo() {
	    $resultArray = array();
	    for($i=0; $i<count($this->objLayer); $i++){
	        $resultArray[] = array (
                //"id" => $this->objLayer[$i]->layer_id,
                "pos" => $this->objLayer[$i]->layer_pos,
                //"parent"   => $this->objLayer[$i]->layer_parent,
                "name"   => $this->objLayer[$i]->layer_name
                //"title"   => $this->objLayer[$i]->layer_title
            );
	    }
	    return $resultArray;
	}
	/**
	 * private function
	 */
	function optimizeWMS($layerSearchable = null) {
	    /*define defaults for wms-version 1.0.0*/
		$map_default_ok = false;
		$featureinfo_default_ok = false;
		$exception_default_ok = false;
		if($this->wms_version == "1.0.0"){
			$map_default = "PNG";
			$featureinfo_default = "MIME";
			$exception_default = "INIMAGE";
		}elseif($this->wms_version == "1.3.0"){
			$map_default = "image/png";
			$featureinfo_default = "text/html";
			$exception_default = "INIMAGE";
		}
		/*define defaults for wms-version 1.1.0 and 1.1.1*/
		else{
			$map_default = "image/png";
			$featureinfo_default = "text/html";
			$exception_default = "application/vnd.ogc.se_inimage";
		}
		#some default
		$this->gui_wms_visible = 1;
		$this->gui_wms_opacity = 100;
		/*if the rootlayer has no epsg...read them from following layer TODO what if this layer have also no SRS?*/
		$testVar = $this->objLayer[0]->layer_epsg[0]["epsg"];
		if($this->objLayer[0]->layer_epsg[0]["epsg"] == "" || empty($testVar)){
			$this->objLayer[0]->layer_epsg = $this->objLayer[1]->layer_epsg;
			for($i=0;$i<count($this->objLayer[0]->layer_epsg);$i++){
				for($j=1; $j<count($this->objLayer); $j++){
					if($this->objLayer[0]->layer_epsg[$i]["epsg"] == $this->objLayer[$j]->layer_epsg[$i]["epsg"]){
						if($this->objLayer[$j]->layer_epsg[$i]["minx"]<$this->objLayer[0]->layer_epsg[$i]["minx"]){
							$this->objLayer[0]->layer_epsg[$i]["minx"] = $this->objLayer[$j]->layer_epsg[$i]["minx"];
						}
						if($this->objLayer[$j]->layer_epsg[$i]["miny"]<$this->objLayer[0]->layer_epsg[$i]["miny"]){
							$this->objLayer[0]->layer_epsg[$i]["miny"] = $this->objLayer[$j]->layer_epsg[$i]["miny"];
						}
						if($this->objLayer[$j]->layer_epsg[$i]["maxx"]>$this->objLayer[0]->layer_epsg[$i]["maxx"]){
							$this->objLayer[0]->layer_epsg[$i]["maxx"] = $this->objLayer[$j]->layer_epsg[$i]["maxx"];
						}
						if($this->objLayer[$j]->layer_epsg[$i]["maxy"]>$this->objLayer[0]->layer_epsg[$i]["maxy"]){
							$this->objLayer[0]->layer_epsg[$i]["maxy"] = $this->objLayer[$j]->layer_epsg[$i]["maxy"];
						}
					}
				}
			}
		}
		for($i=0;$i<count($this->objLayer);$i++){
			if(count($this->objLayer[$i]->layer_epsg) == 0 && count($this->objLayer[0]->layer_epsg) > 0){
				$this->objLayer[$i]->layer_epsg = $this->objLayer[0]->layer_epsg; 
			}
			if(!is_int($this->objLayer[$i]->layer_parent)){
				$this->objLayer[$i]->layer_abstract = $this->wms_abstract;
				for ($r = 0; $r < count($this->wms_keyword); $r++) {
					array_push($this->objLayer[$i]->layer_keyword, trim($this->wms_keyword[$r]));
				}
			}
			if($this->objLayer[$i]->layer_name == ""){
				//TODO: Check if this handling is ok - maybe we need another handling of layer without names (category layer)!
				$this->objLayer[$i]->layer_name = $this->objLayer[$i]->layer_title;
			}
			if($this->objLayer[$i]->layer_minscale == ""){
				$this->objLayer[$i]->layer_minscale = 0;
			}
			if($this->objLayer[$i]->layer_maxscale == ""){
				$this->objLayer[$i]->layer_maxscale = 0;
			}
			if($this->objLayer[$i]->layer_queryable == ""){
				$this->objLayer[$i]->layer_queryable = 0;
			}
			$this->objLayer[$i]->gui_layer_minscale = $this->objLayer[$i]->layer_minscale;
			$this->objLayer[$i]->gui_layer_maxscale = $this->objLayer[$i]->layer_maxscale;
			if($layerSearchable != "") {
			    $this->objLayer[$i]->layer_searchable = $layerSearchable;
			}
			else {
			    $this->objLayer[$i]->layer_searchable = 1;
			}
		}
		for($i=0;$i<count($this->data_format);$i++){
			if(mb_strtolower($this->data_type[$i]) == 'map' && mb_strtoupper($this->data_format[$i]) == mb_strtoupper($map_default)){
				$this->gui_wms_mapformat = mb_strtolower($map_default);
				$map_default_ok = true;
			}
			if(mb_strtolower($this->data_type[$i]) == 'featureinfo' && mb_strtoupper($this->data_format[$i]) == mb_strtoupper($featureinfo_default)){
				$this->gui_wms_featureinfoformat = mb_strtolower($featureinfo_default);
				$featureinfo_default_ok = true;
			}		
			if(mb_strtolower($this->data_type[$i]) == 'exception' && mb_strtolower($this->data_format[$i]) == mb_strtolower($exception_default)){
				$this->gui_wms_exceptionformat = mb_strtolower($exception_default);
				$exception_default_ok = true;
			}		
		}
		if($map_default_ok == false){
			for($i=0;$i<count($this->data_format);$i++){
				if(mb_strtolower($this->data_type[$i]) == "map" ){$this->gui_wms_mapformat = $this->data_format[$i]; break;}
			}
		}
		if($featureinfo_default_ok == false){
			for($i=0;$i<count($this->data_format);$i++){
				if(mb_strtolower($this->data_type[$i]) == "featureinfo" ){$this->gui_wms_featureinfoformat = $this->data_format[$i]; break;}
			}
		}
		if($exception_default_ok == false){
			for($i=0;$i<count($this->data_format);$i++){
				if(mb_strtolower($this->data_type[$i]) == "exception" ){$this->gui_wms_exceptionformat = $this->data_format[$i]; break;}
			}
		}
		
		if(count($this->objLayer[0]->layer_epsg)>1){
			$this->gui_wms_epsg = $this->objLayer[0]->layer_epsg[$this->default_epsg]['epsg'];
		}
		else{
			$this->gui_wms_epsg = $this->objLayer[0]->layer_epsg[0]['epsg'];
		}
		/*the queryable layers*/
		for($i=0; $i<count($this->objLayer); $i++){
			if($this->objLayer[$i]->layer_queryable == 1){
				$this->objLayer[$i]->gui_layer_queryable = 1;
			}
			else{
				$this->objLayer[$i]->gui_layer_queryable = 0;
			}
		}
		for($i=0; $i<count($this->objLayer); $i++){
				$this->objLayer[$i]->layer_pos=$i;
		}
		
		// check if gui_layer_title isset
		for($i=0; $i<count($this->objLayer); $i++){
			$this->objLayer[$i]->gui_layer_title = $this->objLayer[$i]->gui_layer_title != "" ?
				$this->objLayer[$i]->gui_layer_title :
				$this->objLayer[$i]->layer_title;
		}
		
		/* fill sld variables when empty */
		if($this->wms_supportsld == ""){
				$this->wms_supportsld = 0;
		}
		if($this->wms_userlayer == ""){
				$this->wms_userlayer = 0;
		}
		if($this->wms_userstyle == ""){
				$this->wms_userstyle = 0;
		}
		if($this->wms_remotewfs == ""){
				$this->wms_remotewfs = 0;
		}
		
		/* initialize inspire_annual_requests - only needed for inspire monitoring but maybe usefull for other things*/
		/*if(!isset($this->inspire_annual_requests) || $this->inspire_annual_requests == "" || !is_int($this->inspire_annual_requests)){
				$this->inspire_annual_requests = 0;
		}*/
	  }
	
	function displayWMS(){
		echo "<br>id: " . $this->wms_id . " <br>";
		echo "version: " . $this->wms_version . " <br>";
		echo "title: " . $this->wms_title . " <br>";
		echo "abstract: " . $this->wms_abstract . " <br>";
		echo "maprequest: " . $this->wms_getmap . " <br>";
		echo "capabilitiesrequest: " . $this->wms_getcapabilities . " <br>";
		echo "featureinforequest: " . $this->wms_getfeatureinfo . " <br>";
		echo "gui_wms_mapformat: " . $this->gui_wms_mapformat . " <br>";
		echo "gui_wms_featureinfoformat: " . $this->gui_wms_featureinfoformat . " <br>";
		echo "gui_wms_exceptionformat: " . $this->gui_wms_exceptionformat . " <br>";	
		echo "gui_wms_epsg: " . $this->gui_wms_epsg . " <br>";
		echo "wms_srs: " . implode(", ", $this->wms_srs) . " <br>";
		echo "gui_wms_visible: " . $this->gui_wms_visible . " <br>";
		echo "gui_wms_opacity: " . $this->gui_wms_opacity . " <br>";
		echo "support_sld: " . $this->wms_supportsld . " <br>";
		
		for($i=0; $i<count($this->data_type);$i++){
			echo $this->data_type[$i]. " -> ".$this->data_format[$i]. "<br>";
		}
		for($i=0; $i<count($this->objLayer); $i++){
			echo "<hr>";
			echo "id: <b>".$this->objLayer[$i]->layer_id ."</b> parent: <b>".$this->objLayer[$i]->layer_parent."</b> name: <b>".$this->objLayer[$i]->layer_name;
			echo "</b> title: <b>".$this->objLayer[$i]->layer_title. "</b> queryable: <b>".$this->objLayer[$i]->layer_queryable."</b> minScale: <b>". $this->objLayer[$i]->layer_minscale."</b> maxScale: <b>".$this->objLayer[$i]->layer_maxscale."</b>";
			echo "<br>";
			echo "<br>DataUrl(s):<br>";
			echo "<table border='1'>";
			echo "<tr><td>link</td><td>format</td></tr>";
			for($j=0; $j<count($this->objLayer[$i]->layer_dataurl);$j++){
				echo "<tr><td>".$this->objLayer[$i]->layer_dataurl[$j]->href."</td><td>".$this->objLayer[$i]->layer_dataurl[$j]->format."</td></tr>";
			}
			echo "</table>";
			echo "<br>MetadataUrls:<br>";
			echo "<table border='1'>";
			echo "<tr><td>link</td><td>type</td><td>format</td></tr>";
			for($j=0; $j<count($this->objLayer[$i]->layer_metadataurl);$j++){
				echo "<tr><td>".$this->objLayer[$i]->layer_metadataurl[$j]->href."</td><td>".$this->objLayer[$i]->layer_metadataurl[$j]->type."</td><td>".$this->objLayer[$i]->layer_metadataurl[$j]->format."</td></tr>";
			}
			echo "</table>";
			echo "<br>BBOXes:<br>";
			echo "<table border='1'>";
			for($j=0; $j<count($this->objLayer[$i]->layer_epsg);$j++){
				echo "<tr><td>".$this->objLayer[$i]->layer_epsg[$j]['epsg']."</td><td>".$this->objLayer[$i]->layer_epsg[$j]['minx']."</td>";
				echo "<td>".$this->objLayer[$i]->layer_epsg[$j]['miny']."</td><td>".$this->objLayer[$i]->layer_epsg[$j]['maxx']."</td>";
				echo "<td>".$this->objLayer[$i]->layer_epsg[$j]['maxy']."</td></tr>";
			}
			echo "</table>";
			echo "layerstyle:";
			echo "<table border='1'>";
			echo "<tr><td>name</td><td>title</td><td>legendurl</td><td>legendurlformat</td></tr>";
			for($j=0; $j<count($this->objLayer[$i]->layer_style);$j++){
				echo "<tr><td>".$this->objLayer[$i]->layer_style[$j]['name']."</td><td>".$this->objLayer[$i]->layer_style[$j]['title']."</td><td>".$this->objLayer[$i]->layer_style[$j]['legendurl']."</td><td>".$this->objLayer[$i]->layer_style[$j]['legendurlformat']."</td></tr>";
			}
			echo "</table>";
	        echo "<hr>";
	        echo "<hr>";
		}
	} 
	  function addLayer($id,$parent){	
		$this->objLayer[count($this->objLayer)] = new layer($id,$parent);
	  }
	  /**
	   * private function
	   */
	  function stripEndlineAndCarriageReturn($string) {
	  	return preg_replace("/\n/", "", preg_replace("/\r/", " ", $string));
	  }
		function createJsObjFromWMS($parent=0){
			echo $this->createJsObjFromWMS_($parent);
		}
		

	function newLayer ($currentLayer, $currentExtent) {
		$pos = $currentLayer["extension"]["LAYER_POS"];
		$parent = $currentLayer["extension"]["LAYER_PARENT"];
		$this->addLayer($pos, $parent); 

		// set layer data
		$layerIndex = count($this->objLayer) - 1;
		$newLayer = $this->objLayer[$layerIndex];
		$newLayer->layer_uid = $currentLayer["extension"]["LAYER_ID"];
		$newLayer->layer_name = $currentLayer["name"];
		$newLayer->layer_title = $currentLayer["title"];
		$newLayer->gui_layer_title = $currentLayer["title"];
		//if layer is built from wmc, there will only be a string given for each dataurl/metadataurl
		if (is_string($currentLayer["layer_dataurl"])) {
			$newLayer->layer_dataurl[0]->href = $currentLayer["layer_dataurl"];
		} else {
			$newLayer->layer_dataurl = $currentLayer["layer_dataurl"];
		}
		if (is_string($currentLayer["layer_metadataurl"])) {
			$newLayer->layer_metadataurl[0]->href = $currentLayer["layer_metadataurl"];
		} else {
			$newLayer->layer_metadataurl = $currentLayer["layer_metadataurl"];
		}	
		//$newLayer->gui_layer_dataurl_href = $currentLayer["dataurl"];
		$newLayer->layer_pos = $currentLayer["extension"]["LAYER_POS"];
		$newLayer->layer_queryable = $currentLayer["queryable"];
		$newLayer->layer_minscale = $currentLayer["extension"]["MINSCALE"];
		$newLayer->layer_maxscale = $currentLayer["extension"]["MAXSCALE"];
//		$newLayer->layer_metadataurl[0]->href = $currentLayer["layer_metadataurl"];
//		$newLayer->layer_searchable = $currentLayer["searchable"];
		$newLayer->gui_layer_wms_id = $currentLayer["extension"]["WMS_ID"];
		$newLayer->gui_layer_status = $currentLayer["extension"]["GUI_STATUS"];
		if ($styleIndex >= 0 && $styleIndex < count($currentLayer["style"])) {
			$newLayer->gui_layer_style = $currentLayer["style"][$styleIndex]["name"];
		}
		else {
			$newLayer->gui_layer_style = "";
		}
		$newLayer->gui_layer_selectable = $currentLayer["extension"]["GUI_SELECTABLE"];
		if (isset($currentLayer["extension"]["OVERVIEWHIDDEN"])) {
			$newLayer->gui_layer_visible = ($currentLayer["extension"]["OVERVIEWHIDDEN"] === "1") ? false : true;
		}
		else {
			$newLayer->gui_layer_visible = $currentLayer["visible"];
		}
		if (isset($currentLayer["extension"]["WFSFEATURETYPE"])) {
			$newLayer->gui_layer_wfs_featuretype = strval($currentLayer["extension"]["WFSFEATURETYPE"]);
		}
		else {
			$newLayer->gui_layer_wfs_featuretype = "";
		}
		if (isset($currentLayer["extension"]["LAYER_FEATURETYPE_COUPLING"])) {
			$newLayer->layer_featuretype_coupling = $currentLayer["extension"]["LAYER_FEATURETYPE_COUPLING"];
//$e = new mb_exception("classes/class_wms.php: newLayer: layer_featuretype_coupling: ".$currentLayer["extension"]["LAYER_FEATURETYPE_COUPLING"]);
		}
		$newLayer->gui_layer_queryable = $currentLayer["extension"]["GUI_QUERYABLE"];
		$newLayer->gui_layer_querylayer = $currentLayer["extension"]["QUERYLAYER"];
		$newLayer->gui_layer_minscale = $currentLayer["extension"]["GUI_MINSCALE"];
		$newLayer->gui_layer_maxscale = $currentLayer["extension"]["GUI_MAXSCALE"];
		
		$newLayer->layer_abstract = $currentLayer["abstract"];

		//
		// set layer epsg
		//
		$tmpEpsgArray= array();
		$newLayer->layer_epsg = array();
		if ($currentLayer["extension"]["EPSG"]) {
			$layerEpsgArray = array();
			$layerMinXArray = array();
			$layerMinYArray = array();
			$layerMaxXArray = array();
			$layerMaxYArray = array();
			if (!is_array($currentLayer["extension"]["EPSG"])) {
				$layerEpsgArray[0] = $currentLayer["extension"]["EPSG"];
				$layerMinXArray[0] = $currentLayer["extension"]["MINX"];
				$layerMinYArray[0] = $currentLayer["extension"]["MINY"];
				$layerMaxXArray[0] = $currentLayer["extension"]["MAXX"];
				$layerMaxYArray[0] = $currentLayer["extension"]["MAXY"];
			}
			else {
				$layerEpsgArray = $currentLayer["extension"]["EPSG"];
				$layerMinXArray = $currentLayer["extension"]["MINX"];
				$layerMinYArray = $currentLayer["extension"]["MINY"];
				$layerMaxXArray = $currentLayer["extension"]["MAXX"];
				$layerMaxYArray = $currentLayer["extension"]["MAXY"];
			}

			for ($i=0; $i < count($layerEpsgArray); $i++) {
				$currentLayerEpsg = array();
				$currentLayerEpsg["epsg"] = $layerEpsgArray[$i];
				$tmpEpsgArray[]= $layerEpsgArray[$i];
				if ($layerMinXArray[$i] == 0
					&& $layerMinYArray[$i] == 0
					&& $layerMaxXArray[$i] == 0
					&& $layerMaxYArray[$i] == 0
					) {
					$currentLayerEpsg["minx"] = null;
					$currentLayerEpsg["miny"] = null; 
					$currentLayerEpsg["maxx"] = null;
					$currentLayerEpsg["maxy"] = null;
				}
				else {
					$currentLayerEpsg["minx"] = floatval($layerMinXArray[$i]);
					$currentLayerEpsg["miny"] = floatval($layerMinYArray[$i]); 
					$currentLayerEpsg["maxx"] = floatval($layerMaxXArray[$i]);
					$currentLayerEpsg["maxy"] = floatval($layerMaxYArray[$i]);
				}
				array_push($newLayer->layer_epsg, $currentLayerEpsg);
			}
		}
		for ($i = 0; $i < count($currentLayer["epsg"]); $i++) {
			if (!in_array($currentLayer["epsg"][$i], $tmpEpsgArray)) {
				$newLayer->layer_epsg[]= array(
					"epsg" => $currentLayer["epsg"][$i],
					"minx" => null,
					"miny" => null,
					"maxx" => null,
					"maxy" => null
				);
			}
		}

		//
		// set layer style
		//
		for ($i = 0; $i < count($currentLayer["style"]); $i++) {
			$newLayer->layer_style[$i] = array();
			$newLayer->layer_style[$i]["name"] = $currentLayer["style"][$i]["name"];
			$newLayer->layer_style[$i]["title"] = $currentLayer["style"][$i]["title"];
			$newLayer->layer_style[$i]["legendurl"] = $currentLayer["style"][$i]["legendurl"];
			$newLayer->layer_style[$i]["legendurl_format"] = $currentLayer["style"][$i]["legendurl_type"];
		}
		//2016-08-31 add dimension - user value come from wmc standard and client mapobject
		$dimensionAttributes = array('name', 'units', 'unitSymbol', 'default', 'multipleValues', 'nearestValue', 'current', 'extent','userValue');
		for ($i = 0; $i < count($currentLayer['dimension']); $i++) {
			//$newLayer->layer_dimension[$i] = array();
			foreach ($dimensionAttributes as $attributeName) {
				$newLayer->layer_dimension[$i]->{$attributeName} = $currentLayer['dimension'][$i][$attributeName];
			}
		}
	}
	
	  function createJsObjFromWMS_($parent=0){
		$str = "";
	  	if(!$this->wms_title || $this->wms_title == ""){
			$str .= "alert('Error: no valid capabilities-document !!');";
			die; exit;
		}
		if($parent){
			$str .=  "parent.";
		}
		// wms_title and abstract have previously been urlencoded
		// this solution may not yet be the ultimate one
			
		$add_wms_string = "add_wms(" .
				"'" . $this->wms_id ."'," .
				"'" . $this->wms_version ."'," .
				"'" . addslashes($this->wms_title) . "'," .
				"'" . addslashes($this->wms_abstract) ."'," .
				"'" . $this->wms_getmap ."'," .
				"'" . $this->wms_getfeatureinfo ."'," .
				"'" . $this->wms_getlegendurl ."'," .
				"'" . $this->wms_filter ."'," .
				"'" . $this->gui_wms_mapformat . "'," .
				"'" . $this->gui_wms_featureinfoformat . "'," .
				"'" . $this->gui_wms_exceptionformat . "'," .
				"'" . $this->gui_wms_epsg ."'," .
				"'" . $this->gui_wms_visible ."'," .
				"'" . $this->gui_wms_opacity ."'," .
				"'" . $this->gui_wms_sldurl ."'," .
				"'" . $this->gui_wms_dimension_time ."'," .
				"'" . $this->gui_wms_dimension_elevation ."" .
				"');";
		$str .=  $add_wms_string;
		//add possible data formats
		for($i=0;$i<count($this->data_format);$i++){
			if($parent){
				$str .=  "parent.";
			}		
			$str .= "wms_add_data_type_format('". $this->data_type[$i] ."','". $this->data_format[$i] ."');";		
		}
		//do the things for each layer
		for($i=0; $i<count($this->objLayer); $i++){
//debug
//$e = new mb_exception("layer: ".$this->objLayer[$i]->layer_title." - layer_featuretype_coupling: ". $this->objLayer[$i]->layer_featuretype_coupling);
			if($parent){
				$str .= "parent.";
			}
			$str .=  "wms_add_layer('". 
			$this->objLayer[$i]->layer_parent ."','". 
			$this->objLayer[$i]->layer_uid ."','". 
			addslashes($this->objLayer[$i]->layer_name) . "','". 
			addslashes($this->objLayer[$i]->layer_title) ."','". 
			$this->objLayer[$i]->layer_dataurl[0]->href ."','". 
			$this->objLayer[$i]->layer_pos ."','". 
			$this->objLayer[$i]->layer_queryable ."','". 
			$this->objLayer[$i]->layer_minscale . "','". 
			$this->objLayer[$i]->layer_maxscale ."','". 
			$this->objLayer[$i]->layer_metadataurl[0]->href ."','". 
			// will be added later, not needed now TODO check if more than one metadataUrl is usefull here
			// $this->objLayer[$i]->layer_searchable ."','". 
			$this->objLayer[$i]->gui_layer_wms_id ."','". 
			$this->objLayer[$i]->gui_layer_status ."','".
			$this->objLayer[$i]->gui_layer_style ."','".  
			$this->objLayer[$i]->gui_layer_selectable ."','". 
			$this->objLayer[$i]->gui_layer_visible ."','". 
			$this->objLayer[$i]->gui_layer_queryable ."','". 
			$this->objLayer[$i]->gui_layer_querylayer ."','". 
			$this->objLayer[$i]->gui_layer_minscale ."','". 
			$this->objLayer[$i]->gui_layer_maxscale ."','".
			$this->objLayer[$i]->gui_layer_wfs_featuretype ."','".
			$this->objLayer[$i]->gui_layer_title ."','".
			$this->objLayer[$i]->layer_dataurl[0]->href ."','".
			$this->objLayer[$i]->layer_featuretype_coupling ."');";
				
			for($j=0; $j<count($this->objLayer[$i]->layer_epsg);$j++){
				$currentEpsg = $this->objLayer[$i]->layer_epsg[$j];
				if($i==0){
					if($parent){
						$str .= "parent.";
					}
					$str .= "wms_addSRS('". 
						$currentEpsg["epsg"] ."',". 
						(is_null($currentEpsg["minx"]) ? "null" : $currentEpsg["minx"]) .",". 
						(is_null($currentEpsg["miny"]) ? "null" : $currentEpsg["miny"]) .",". 
						(is_null($currentEpsg["maxx"]) ? "null" : $currentEpsg["maxx"]) .",". 
						(is_null($currentEpsg["maxy"]) ? "null" : $currentEpsg["maxy"]) .");";
				}
				if (!is_null($currentEpsg["epsg"])) {
					if($parent){
						$str .=  "parent.";
					}
					$str .= "layer_addEpsg('". 
					$currentEpsg["epsg"] ."',". 
						(is_null($currentEpsg["minx"]) ? "null" : $currentEpsg["minx"]) .",". 
						(is_null($currentEpsg["miny"]) ? "null" : $currentEpsg["miny"]) .",". 
						(is_null($currentEpsg["maxx"]) ? "null" : $currentEpsg["maxx"]) .",". 
						(is_null($currentEpsg["maxy"]) ? "null" : $currentEpsg["maxy"]) .");";
				}
			}
			for($j=0; $i==0 && $j<count($this->wms_srs);$j++){
				$found = false;
				for ($k = 0; $k < count($this->objLayer[$i]->layer_epsg); $k++){
					if ($this->objLayer[$i]->layer_epsg[$k]["epsg"] === $this->wms_srs[$j]) {
						$found = true;
						break;
					}
				}
				if ($found) {
					continue;
				}
				
				if($parent){
					$str .= "parent.";
				}
				$str .= "wms_addSRS('". 
				$this->wms_srs[$j] ."', null, null, null, null);\n";
			}
			for($j=0; $j<count($this->objLayer[$i]->layer_style);$j++){
				if($parent){
					$str .= "parent.";
				}
				$str .= "wms_addLayerStyle('".$this->objLayer[$i]->layer_style[$j]["name"].
					"', '".addslashes($this->objLayer[$i]->layer_style[$j]["title"]).
					"', ".$j.
					",".$i.
					",'".$this->objLayer[$i]->layer_style[$j]["legendurl"].
					"', '".$this->objLayer[$i]->layer_style[$j]["legendurlformat"]."');";
			}
			//2016 - new for dimension (time and elevation)
			//$e = new mb_exception("class_wms.php: test for dimension in layer object: count of dimension: ".count($this->objLayer[$i]->layer_dimension));
			for($j=0; $j<count($this->objLayer[$i]->layer_dimension);$j++){
				if($parent){
					$str .= "parent.";
				}
				//'name', 'units', 'unitSymbol', 'default', 'multipleValues', 'nearestValue', 'current', 'extent'
				$dimensionString = "wms_addLayerDimension('".$this->objLayer[$i]->layer_dimension[$j]->name."', '".$this->objLayer[$i]->layer_dimension[$j]->units."', '".$this->objLayer[$i]->layer_dimension[$j]->unitSymbol."',  '".$this->objLayer[$i]->layer_dimension[$j]->default."',  '".$this->objLayer[$i]->layer_dimension[$j]->multipleValues."',  '".$this->objLayer[$i]->layer_dimension[$j]->nearestValue."',  '".$this->objLayer[$i]->layer_dimension[$j]->current."', '".$this->objLayer[$i]->layer_dimension[$j]->extent."','".$this->objLayer[$i]->layer_dimension[$j]->userValue."');";
				//$e = new mb_exception("class_wms.php: dimensionstring= ".$dimensionString);
				$str .= $dimensionString;
			}
		}
		return $str;
	  }
	  
	  function createJsLayerObjFromWMS($parent=0, $layer_name){
	  	if(!$this->wms_title || $this->wms_title == ""){
			echo " alert('Error: no valid capabilities-document !!');";
			die; exit;
		}
			if($parent){
				echo "parent.";
			}
			// wms_title and abstract have previously been urlencoded
			// this solution may not yet be the ultimate one
			print("add_wms('". 
			$this->wms_id ."','".
			$this->wms_version ."','".
			preg_replace("/'/", "", $this->wms_title) ."','".
			preg_replace("/'/", "", $this->wms_abstract) ."','". 
			$this->wms_getmap ."','" .
			$this->wms_getfeatureinfo ."','".
			$this->wms_getlegendurl ."','".
			$this->wms_filter ."','".
			$this->gui_wms_mapformat ."','". 
			$this->gui_wms_featureinfoformat ."','". 
			$this->gui_wms_exceptionformat . "','". 
			$this->gui_wms_epsg ."','". 
			$this->gui_wms_visible ."','".
			$this->gui_wms_opacity ."','".
			$this->gui_wms_sldurl ."','".
			$this->gui_wms_dimension_time ."','".
			$this->gui_wms_dimension_elevation ."');");
			
		for($i=0;$i<count($this->data_format);$i++){
			if($parent){
				echo "parent.";
			}		
			echo "wms_add_data_type_format('". $this->data_type[$i] ."','". $this->data_format[$i] ."');";		
		}
		for($i=0; $i<count($this->objLayer); $i++){
			if($this->objLayer[$i]->layer_name == $layer_name|| $this->objLayer[$i]->layer_pos == 0){
			
				if($parent){
					echo "parent.";
				}
			 print ("wms_add_layer('". 
				$this->objLayer[$i]->layer_parent ."','". 
				$this->objLayer[$i]->layer_uid ."','". 
				$this->objLayer[$i]->layer_name . "','". 
				addslashes($this->objLayer[$i]->layer_title) ."','". 
				$this->objLayer[$i]->layer_dataurl[0]->href ."','". 
				$this->objLayer[$i]->layer_pos ."','". 
				$this->objLayer[$i]->layer_queryable ."','". 
				$this->objLayer[$i]->layer_minscale . "','". 
				$this->objLayer[$i]->layer_maxscale ."','". 
				$this->objLayer[$i]->layer_metadataurl[0]->href ."','". 
// will be added later, not needed now TODO check if more than one metadataUrl is usefull here
//				$this->objLayer[$i]->layer_searchable ."','". 
				$this->objLayer[$i]->gui_layer_wms_id ."','". 
				$this->objLayer[$i]->gui_layer_status ."','".
				$this->objLayer[$i]->gui_layer_style ."','". 
				$this->objLayer[$i]->gui_layer_selectable ."','". 
				$this->objLayer[$i]->gui_layer_visible ."','". 
				$this->objLayer[$i]->gui_layer_queryable ."','". 
				$this->objLayer[$i]->gui_layer_querylayer ."','". 
				$this->objLayer[$i]->gui_layer_minscale ."','". 
				$this->objLayer[$i]->gui_layer_maxscale ."','".
				$this->objLayer[$i]->gui_layer_wfs_featuretype ."','".
				$this->objLayer[$i]->gui_layer_title ."','".
				$this->objLayer[$i]->layer_dataurl[0]->href ."','".
				$this->objLayer[$i]->layer_featuretype_coupling ."');");

			for($j=0; $j<count($this->objLayer[$i]->layer_epsg);$j++){
				if($i==0){
					if($parent){
					echo "parent.";
					}
					print("wms_addSRS('". 
						$this->objLayer[$i]->layer_epsg[$j]["epsg"] ."','". 
						$this->objLayer[$i]->layer_epsg[$j]["minx"] ."','". 
						$this->objLayer[$i]->layer_epsg[$j]["miny"] ."','". 
						$this->objLayer[$i]->layer_epsg[$j]["maxx"] ."','". 
						$this->objLayer[$i]->layer_epsg[$j]["maxy"] ."');");
				}
				if($parent){
				echo "parent.";
				}
				print("layer_addEpsg('". 
					$this->objLayer[$i]->layer_epsg[$j]["epsg"] ."','". 
					$this->objLayer[$i]->layer_epsg[$j]["minx"] ."','". 
					$this->objLayer[$i]->layer_epsg[$j]["miny"] ."','". 
					$this->objLayer[$i]->layer_epsg[$j]["maxx"] ."','". 
					$this->objLayer[$i]->layer_epsg[$j]["maxy"] ."');");
			}
			for($j=0; $j<count($this->objLayer[$i]->layer_style);$j++){
				if($parent){
				 echo "parent.";
				}
				print("wms_addLayerStyle('".$this->objLayer[$i]->layer_style[$j]["name"]."', '".addslashes($this->objLayer[$i]->layer_style[$j]["title"])."', ".$j.",".$i.",'".$this->objLayer[$i]->layer_style[$j]["legendurl"]."', '".$this->objLayer[$i]->layer_style[$j]["legendurlformat"]."');");
			}
			//2016 - new for dimension (time and elevation)
			for($j=0; $j<count($this->objLayer[$i]->layer_dimension);$j++){
				if($parent){
				 echo "parent.";
				}
				//'name', 'units', 'unitSymbol', 'default', 'multipleValues', 'nearestValue', 'current', 'extent'
				print("wms_addLayerDimension('".$this->objLayer[$i]->layer_dimension[$j]->name."', '".$this->objLayer[$i]->layer_dimension[$j]->units."', '".$this->objLayer[$i]->layer_dimension[$j]->unitSymbol."',  '".$this->objLayer[$i]->layer_dimension[$j]->default."',  '".$this->objLayer[$i]->layer_dimension[$j]->multipleValues."',  '".$this->objLayer[$i]->layer_dimension[$j]->nearestValue."',  '".$this->objLayer[$i]->layer_dimension[$j]->current."', '".$this->objLayer[$i]->layer_dimension[$j]->extent."','".$this->objLayer[$i]->layer_dimension[$j]->userValue."');");
			}
		   }	
		}
	  }
	  
	  
	/**
	* writeObjInDB
	*
	* this function exports the information from the xml to the mapbender database, defaults owner to root if invoked from cli
	*/
	function writeObjInDB($gui_id, $auth=false, $cli=false, $ownerId=1){
		global $con;
		if ($auth !== false) { //new for HTTP Authentication
			$username = $auth['username'];
			$password = $auth['password'];
			$authType = $auth['auth_type'];
		}
		else {
			$username = '';
			$password = '';
			$authType = '';		
		}
		$admin = new administration();
		$uuid = new Uuid();
		$this->checkObj();
		if($this->setGeoRss == true){
		    $this->geoRssFactory = new GeoRssFactory();
		    $this->geoRss = $this->geoRssFactory->loadOrCreate(GEO_RSS_FILE);
		}
		
		db_begin();
	
		if ($cli == true) {
			$userId = $ownerId;
		} else {
			$userId = Mapbender::session()->get('mb_user_id');
		}

		# TABLE wms
		$sql = "INSERT INTO wms (wms_version, wms_title, wms_abstract, wms_getcapabilities, wms_getmap, ";
		$sql.= "wms_getfeatureinfo, wms_getlegendurl, wms_getcapabilities_doc, wms_upload_url, fees, ";
		$sql .= "accessconstraints, contactperson, contactposition, contactorganization, address, city, ";
		$sql .= "stateorprovince, postcode, country, contactvoicetelephone, contactfacsimiletelephone, contactelectronicmailaddress, ";
		$sql .= "wms_owner,wms_timestamp,wms_timestamp_create,wms_username,wms_password,wms_auth_type,";
		$sql .= "wms_supportsld, wms_userlayer, wms_userstyle, wms_remotewfs, uuid, inspire_annual_requests, wms_license_source_note) ";
		$sql .= "VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31,$32,$33,$34,$35)";
		$v = array(
			$this->wms_version,
			$this->wms_title,
			$this->wms_abstract,
			$this->wms_getcapabilities,
			$this->wms_getmap,
			$this->wms_getfeatureinfo,
			$this->wms_getlegendurl,
			$admin->char_encode($this->wms_getcapabilities_doc), //convert xml to utf-8, if it was given in iso! 
			$this->wms_upload_url,
			$this->fees,
			$this->accessconstraints,
			$this->contactperson,
			$this->contactposition,
			$this->contactorganization,
			$this->address,
			$this->city,
			$this->stateorprovince,
			$this->postcode,
			$this->country,
			$this->contactvoicetelephone,
			$this->contactfacsimiletelephone,
			$this->contactelectronicmailaddress,
			$userId,
			strtotime("now"),
			strtotime("now"),
			$username,
			$password,
			$authType,
			$this->wms_supportsld,
			$this->wms_userlayer,
			$this->wms_userstyle,
			$this->wms_remotewfs,
			$uuid,
			$this->inspire_annual_requests,
			$this->wms_license_source_note
		);
		$t = array(
			's','s','s','s','s','s','s','s','s','s','s','s','s','s','s','s',
			's','s','s','s','s','s','i','i','i','s','s','s','s','s','s','s','s','i','s'
		);
		$res = db_prep_query($sql,$v,$t);
		if(!$res){
			db_rollback();
			return null;
		}
		
		$myWMS = db_insert_id($con,'wms', 'wms_id');

		if ($authType != '') { //some authentication is needed! 
			$admin = new administration();
			echo "WMS ID: ".$myWMS;
			$admin->setWMSOWSstring($myWMS, 1);
		}

		# TABLE layer and gui_layer
		
		for($i=0; $i<count($this->objLayer); $i++){
			$this->insertLayer($i,$myWMS,$gui_id);
			$this->insertGuiLayer($i,$myWMS,$gui_id);
		}	
			
		
		#TABLE wms_srs
		$this->insertSRS($myWMS);	
		
		# TABLE wms_format	
		$this->insertFormat($myWMS);	
			
		# TABLE gui_wms
		
		$sql ="SELECT MAX(gui_wms_position) AS pos FROM gui_wms WHERE fkey_gui_id = $1";
		$v = array($gui_id);
		$t = array('s');
		$res = db_prep_query($sql,$v,$t);
		if (db_result($res, 0,"pos") > -1) {
			$position = db_result($res, 0,"pos") + 1;
		} 
		else { 
			$position = 0; 
		}
		
		$sql ="INSERT INTO gui_wms (fkey_gui_id, fkey_wms_id, gui_wms_position, gui_wms_mapformat, ";
		$sql .= "gui_wms_featureinfoformat, gui_wms_exceptionformat, gui_wms_epsg)";
		$sql .= "VALUES($1,$2,$3,$4,$5,$6,$7)";
		$v = array(
			$gui_id,
			$myWMS,
			$position,
			$this->gui_wms_mapformat,
			$this->gui_wms_featureinfoformat,
			$this->gui_wms_exceptionformat,
			$this->gui_wms_epsg
		);
		$t = array('s','i','i','s','s','s','s');
		$res = db_prep_query($sql,$v,$t);
		if(!$res){
			db_rollback();	
			return null;
		}
		db_commit();
		
		//
		// update GeoRSS feed
		//
		//$geoRssFactory = new GeoRssFactory();
		//$geoRss = $geoRssFactory->loadOrCreate(GEO_RSS_FILE);
		$e = new mb_notice("class_wms.php: writeObjInDB: test if geoRss maybe null!");
		if ($this->setGeoRss == true && !is_null($this->geoRss)) {
			$e = new mb_notice("class_wms.php: writeObjInDB: geoRss was not NULL!");
			$geoRssItem = new GeoRssItem();
			$geoRssItem->setTitle("NEW WMS: " . $this->wms_title." (".$myWMS.")");
			$geoRssItem->setDescription($this->wms_abstract);
			$geoRssItem->setUrl(self::getWmsMetadataUrl($myWMS));
			$geoRssItem->setPubDate(self::rssDate());

			for ($j = 0; $j < count($this->objLayer[0]->layer_epsg); $j++) {
				$currentEpsg = $this->objLayer[0]->layer_epsg[$j];
				if ($currentEpsg["epsg"] === "EPSG:4326") {
					$currentBbox = new Mapbender_bbox(
						$currentEpsg["minx"],
						$currentEpsg["miny"],
						$currentEpsg["maxx"],
						$currentEpsg["maxy"],
						$currentEpsg["epsg"]
					);
					$geoRssItem->setBbox($currentBbox);
					break;
				}
			}
			$this->geoRss->appendTop($geoRssItem);
			$this->geoRss->saveAsFile();
		}
		if ($this->twitterNews == true) {
		    //new WMS
			$twitter_wms = new twitter();
			$twUuid = new Uuid();
			//combine text for tweet
			$tweetText = "NEW WMS: " . $this->wms_title." (".$myWMS.") ".self::getWmsMetadataUrl($myWMS)." ".$twUuid;
			//reduce to 140 chars
			$tweetText = substr($tweetText, 0, 136);
			//push to twitter
			$result = $twitter_wms->postTweet($tweetText);
			if ($result != '200') {
				$e = new mb_exception("class_wms.php: Twitter API give back error code: ".$result);
			}
		}
		//Propagate information for each new layer to csw if configured***************************
		//select all layer which are searchable
		$sql = "SELECT layer_id, uuid FROM layer WHERE fkey_wms_id = $1 and layer_searchable = 1";
		$v = array($myWMS);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		$insertedLayerArray = array();
		while($row = db_fetch_array($res)){
			$insertedLayerArray[] = $row['layer_id'];
		}
		$propagation = new propagateMetadata();
		$result = $propagation->doPropagation("layer", $insertedLayerArray, "push", false);
		//****************************************************************************************    
	    	//Changes JW
	    	$this->wms_id = $myWMS;
	}

	function insertLayer($i,$myWMS){
		global $con;
		$uuid = new Uuid();
		$sql = <<<SQL

INSERT INTO layer 
(fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, 
layer_queryable, layer_minscale, layer_maxscale, layer_dataurl,
layer_metadataurl, layer_searchable, layer_abstract, uuid, inspire_download) 
VALUES
($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14)

SQL;
		if($this->objLayer[$i]->layer_id != null){
			$tmpPos =  $this->objLayer[$i]->layer_id;
		}
		else {
			$tmpPos .= 0;
		}
		if($this->objLayer[$i]->layer_parent == '' && $this->objLayer[$i]->layer_parent != '0'){
			$this->objLayer[$i]->layer_parent = '';
		}
		$v = array($myWMS,$tmpPos,$this->objLayer[$i]->layer_parent,$this->objLayer[$i]->layer_name,
				$this->objLayer[$i]->layer_title,
				$this->objLayer[$i]->layer_queryable,$this->objLayer[$i]->layer_minscale,
				$this->objLayer[$i]->layer_maxscale,$this->objLayer[$i]->layer_dataurl[0]->href,
				$this->objLayer[$i]->layer_metadataurl[0]->href, $this->objLayer[$i]->layer_searchable,
				$this->objLayer[$i]->layer_abstract,
				$uuid,
				$this->objLayer[$i]->inspire_download);
		$t = array('i','i','s','s','s','i','i','i','s','s','i','s','s','i');
		$res = db_prep_query($sql,$v,$t);
		if(!$res){
			db_rollback();	
		}
		else {
			// save the id of each layer: set param2 true		
			$this->objLayer[$i]->db_id = db_insert_id($con, 'layer','layer_id');
			$this->insertLayerEPSG($i);
			
			//
			$this->insertLayerDimension($i);

			// TABLE layer_style for each layer
			$this->insertLayerStyle($i);
			
			// insert Keywords
			$this->insertLayerKeyword($i);

			//insert categories - new for wms 1.3.0 as from october 2013
			$this->insertLayerCategories($i);

			// insert dataurls
			$this->insertLayerDataUrls($i); //TODO: in the spec 1.3.0 the schema defines a 1:n relation, but in the table there is only one link possible - maybe we need only this one link

			// insert metadataurls
			$this->insertLayerMetadataUrls($i);

			//update messages for twitter and georss
			$currentLayer = $this->objLayer[$i];
			
			if ($this->setGeoRss == true && !is_null($this->geoRss)) {
			    $geoRssItemNewLayer = new GeoRssItem();
				$geoRssItemNewLayer->setTitle("NEW LAYER: " . $currentLayer->layer_title." (".$currentLayer->db_id.")");
				$geoRssItemNewLayer->setDescription($currentLayer->layer_abstract);
				$geoRssItemNewLayer->setUrl(self::getLayerMetadataUrl($currentLayer->db_id));
				$geoRssItemNewLayer->setPubDate(self::rssDate());
				for ($j = 0; $j < count($currentLayer->layer_epsg); $j++) {
					$currentEpsg = $currentLayer->layer_epsg[$j];
					if ($currentEpsg["epsg"] === "EPSG:4326") {
						$currentBbox = new Mapbender_bbox(
							$currentEpsg["minx"],
							$currentEpsg["miny"],
							$currentEpsg["maxx"],
							$currentEpsg["maxy"],
							$currentEpsg["epsg"]
						);
						$geoRssItemNewLayer->setBbox($currentBbox);
						break;
					}
				}
				$this->geoRss->appendTop($geoRssItemNewLayer);
			}
			if ($this->twitterNews == true) {
				//new LAYER
				$twitter_layer = new twitter();
				//combine text for tweet
				$twUuid = new Uuid();
				$tweetText = "NEW LAYER: " . $currentLayer->layer_title." (".$currentLayer->db_id.") ".self::getLayerMetadataUrl($currentLayer->db_id)." ".$twUuid;
				//reduce to 140 chars
				$tweetText = substr($tweetText, 0, 136);
				//push to twitter
				$result = $twitter_layer->postTweet($tweetText);
				if ($result != '200') {
					$e = new mb_exception("class_wms.php: Twitter API give back error code: ".$result);
				}
			}
			
		}
	}
	function updateLayer($i,$myWMS,$updateMetadataOnly=false){
		$e = new mb_notice("class_wms.php: updateLayer");
		$sql = "SELECT layer_id, layer_searchable, inspire_download FROM layer WHERE fkey_wms_id = $1 AND layer_name = $2";
		$v = array($myWMS,$this->objLayer[$i]->layer_name);
		$t = array('i','s');
		$res = db_prep_query($sql,$v,$t);
		if($row = db_fetch_array($res)){
			$l_id = $row['layer_id'];	
		}
		else{
			db_rollback();
			$e = new mb_exception("Not found: ".$this->objLayer[$i]->layer_name);
			return;	
		}	
		//don't update title, abstract when not explicitly demanded thru $this->overwrite == true

		$sql = "UPDATE layer SET ";
		$sql .= "layer_pos = $1, ";
		$sql .= "layer_parent = $2, ";
		
		$sql .= "layer_queryable = $3, ";
		$sql .= "layer_minscale = $4, ";
		$sql .= "layer_maxscale = $5, ";
		$sql .= "layer_dataurl = $6, ";
		$sql .= "layer_metadataurl = $7, ";
		$sql .= "layer_searchable = $8, ";
		
		$sql .= "inspire_download = $10 ";
		$sql .= "WHERE layer_id = $9";

		if (!$updateMetadataOnly) {
			//read inspire_download and layer_searchable from database if update from capabilities
			$this->objLayer[$i]->inspire_download = $row["inspire_download"];
			$this->objLayer[$i]->layer_searchable = $row["layer_searchable"];
		}
		//if inspire_download, and layer_searchable is neither stored in database nor given thru object, set it too a default value 0
		if (!isset($this->objLayer[$i]->inspire_download) || ($this->objLayer[$i]->inspire_download =='')) {
			$this->objLayer[$i]->inspire_download = intval('0');
		}
		if (!isset($this->objLayer[$i]->layer_searchable) || ($this->objLayer[$i]->layer_searchable =='')) {
			$this->objLayer[$i]->layer_searchable = intval('0');
		}
		
		if($this->objLayer[$i]->layer_id != null){
			$tmpPos =  $this->objLayer[$i]->layer_id;
		}
		else {
			$tmpPos .= 0;
		}
		if($this->objLayer[$i]->layer_parent == '' && $this->objLayer[$i]->layer_parent != '0'){
			$this->objLayer[$i]->layer_parent = '';
		}
		$v = array($tmpPos,$this->objLayer[$i]->layer_parent,
				
				$this->objLayer[$i]->layer_queryable,$this->objLayer[$i]->layer_minscale,
				$this->objLayer[$i]->layer_maxscale,$this->objLayer[$i]->layer_dataurl[0]->href,
				$this->objLayer[$i]->layer_metadataurl[0]->href, $this->objLayer[$i]->layer_searchable,
				$l_id, 
				$this->objLayer[$i]->inspire_download
			);
		$t = array('i','s','i','i','i','s','s','i', 'i', 'i');
		$e = new mb_notice("class_wms.php: update layer sql:".$sql);
		$e = new mb_notice("class_wms.php: layerid: ".$l_id." layersearchable: ".$this->objLayer[$i]->layer_searchable);
		$e = new mb_notice("class_wms.php: layerid: ".$l_id." inspiredownload: ".$this->objLayer[$i]->inspire_download);
		$res = db_prep_query($sql,$v,$t);
		if($this->overwrite == true){
			$e = new mb_notice("class_wms.php - overwrite has been activated");
			$sql = "UPDATE layer SET ";
			$sql .= "layer_title = $1, ";
			$sql .= "layer_abstract = $2 ";
			$sql .= "WHERE layer_id = $3";
			
			$v = array($this->objLayer[$i]->layer_title,$this->objLayer[$i]->layer_abstract, $l_id);
			$t = array('s','s','i');
			$res = db_prep_query($sql,$v,$t);
		}
		if(!$res){
			db_rollback();	
		} else {
			if ($this->overwriteCategories == true) {
				$e = new mb_notice("class_wms.php - overwrite categories has been activated");
			}
			//save the id of each layer: set param2 true
			$this->objLayer[$i]->db_id = $l_id;
			//this things can only be updated, if the service is updated thru new capabilities documents
			if (!$updateMetadataOnly) {
				$this->insertLayerEPSG($i);
				$this->insertLayerDimension($i);
				$this->insertLayerDataUrls($i);
				$this->insertLayerMetadataUrls($i);
				$this->insertLayerStyle($i);
			}
			if($this->overwrite == true){
				$this->insertLayerKeyword($i);
				//$this->insertLayerCategories($i); //Don't overwrite layer categories by default any longer - it will make problems - maybe the wms 1.3.0 possibilities are a better way
			}
			if($this->overwriteCategories == true){
				//$e = new mb_exception("class_wsm.php - insertLayerCategories!");
				$this->insertLayerCategories($i);
			}
		}
	}
	function insertGuiLayer($i,$myWMS,$gui_id){
		//table gui_layer
		$sql = "INSERT INTO gui_layer (fkey_gui_id, fkey_layer_id, gui_layer_wms_id, ";
		$sql .= "gui_layer_status, gui_layer_selectable, gui_layer_visible, gui_layer_queryable, ";
		$sql .= "gui_layer_querylayer,gui_layer_minscale,gui_layer_maxscale, gui_layer_priority, gui_layer_style, gui_layer_title) ";
		$sql .= "VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13)";
		if(count($this->objLayer[$i]->layer_style)>0){
			$layer_style_name = $this->objLayer[$i]->layer_style[0]["name"];
		}
		else{
			$layer_style_name = NULL;
		}
		$v = array($gui_id,$this->objLayer[$i]->db_id,$myWMS,1,1,1,$this->objLayer[$i]->layer_queryable,
			$this->objLayer[$i]->layer_queryable,$this->objLayer[$i]->layer_minscale,$this->objLayer[$i]->layer_maxscale,$i,$layer_style_name,$this->objLayer[$i]->gui_layer_title);
		$t = array('s','i','i','i','i','i','i','i','i','i','i','s', 's');
		$res = db_prep_query($sql,$v,$t);
		#$e = new mb_notice("name des insert styles und fkey_layer_id: ".$layer_style_name." --- ".$this->objLayer[$i]->db_id);
		if(!$res){
			db_rollback();	
		}	
	}
	function appendGuiLayer($i,$myWMS,$gui_id){
		# table gui_layer
		
		$sql = "INSERT INTO gui_layer (fkey_gui_id, fkey_layer_id, gui_layer_wms_id, ";
		$sql .= "gui_layer_status, gui_layer_selectable, gui_layer_visible, gui_layer_queryable, ";
		$sql .= "gui_layer_querylayer,gui_layer_minscale,gui_layer_maxscale, gui_layer_priority, gui_layer_style, gui_layer_title) ";
		$sql .= "VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13)";
		if(count($this->objLayer[$i]->layer_style)>0){
			$layer_style_name = $this->objLayer[$i]->layer_style[0]["name"];
		}
		else{
			$layer_style_name = NULL;
		}
		$v = array($gui_id,$this->objLayer[$i]->db_id,$myWMS,0,0,0,$this->objLayer[$i]->layer_queryable,
			$this->objLayer[$i]->layer_queryable,$this->objLayer[$i]->layer_minscale,$this->objLayer[$i]->layer_maxscale,$i,$layer_style_name, $this->objLayer[$i]->gui_layer_title);
		$t = array('s','i','i','i','i','i','i','i','i','i','i','s', 's');
		$res = db_prep_query($sql,$v,$t);
		if(!$res){
			db_rollback();	
		}	
	}
	function insertSRS($myWMS){
		for($i=0; $i<count($this->wms_srs);$i++){
			$sql ="INSERT INTO wms_srs (fkey_wms_id, wms_srs) values($1,$2)";		
			$v = array($myWMS,mb_strtoupper($this->wms_srs[$i]));
			$t = array('i','s');		
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
		}	
	}
	function insertTermsOfUse ($myWMS) {
		if (!is_numeric($this->wms_termsofuse)) {
			return;
		}
		$sql ="INSERT INTO wms_termsofuse (fkey_wms_id, fkey_termsofuse_id) ";
		$sql .= " VALUES($1,$2)";
		$v = array($myWMS,$this->wms_termsofuse);
		$t = array('i','i');
		$res = db_prep_query($sql,$v,$t);
		if(!$res){
			db_rollback();	
		}
		
	}
	function insertFormat($myWMS){
		for($i=0; $i<count($this->data_type);$i++){
			$sql ="INSERT INTO wms_format (fkey_wms_id, data_type, data_format) ";
			$sql .= " VALUES($1,$2,$3)";
			$v = array($myWMS,$this->data_type[$i],$this->data_format[$i]);
			$t = array('i','s','s');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
		}	
	}
	function isSupportedSRS($epsg,$layerId) {
		//request the original capabilities from service
        	$sql = "SELECT layer.layer_name AS layer_name, wms.wms_getcapabilities_doc AS cap from layer,wms WHERE layer.layer_id=".$layerId." AND layer.fkey_wms_id=wms.wms_id";
        	$res = db_query($sql);
        	$row = db_fetch_array($res);
		//parse capabilities to php object - check if it is still loaded to db
		if ($row['cap'] == '') {
			$wmsCapXml=simplexml_load_string($this->wms_getcapabilities_doc);	
		} else {
			$wmsCapXml=simplexml_load_string($row['cap']);
		}
		if(!isset($wmsCapXml)) {
			$n = new mb_exception("Problem while parsing capabilities document with simplexml");
			echo "Problem while parsing capabilities document with simplexml<br>";
			return false;
       		}
		//layer name from DB
		$layerName=$row['layer_name'];
		//defining the xpath for getting all Layer-tags
		$xpathLayerName="//Layer[./Name =\"".$layerName."\"]";
		
                $layerObject=$wmsCapXml->xpath($xpathLayerName);

        	//for none named layer (only title is set)	
        	if (empty($layerObject)){
        		$xpathLayerName="//Layer[./Title =\"".$layerName."\"]";
            		$layerObject=$wmsCapXml->xpath($xpathLayerName);
        	}

		if(!isset($layerObject[0])) {
			$n = new mb_notice("Layer has no name and title, BBOX will not be generated for ".$epsg);
			return false;	
		}
		
		//search for the SRS tag of specified layer		
		$srsElementArray=$layerObject[0]->xpath("SRS");
		foreach($srsElementArray as $srsElement) {
			//create an array of the given srsElements -> include also srs written as a space separated list  
			$srsArray = explode(" ",$srsElement);
			foreach($srsArray as $srs) {
				if(strtoupper($srs) == strtoupper($epsg)) {
					$n = new mb_notice("Requested SRS: ".$epsg." is supported by layer: ".$layerName." with layerId: ".$layerId);
					return true;
				}
			}
		}
		
		$n = new mb_notice("Requested SRS: ".$epsg." is not supported by layer: ".$layerName." with layerId: ".$layerId);
		return false;
	}
	//get all supported srs as an intersection of the supported srs of the root layer and the SRS_ARRAY defined in mapbender.conf  
	function getSupportedSRS($layerId, $confSrsArray) {
		//request the original capabilities from service
        	$sql = "SELECT layer.layer_name AS layer_name, wms.wms_getcapabilities_doc AS cap, wms.wms_id as wms_id FROM layer, wms ".
        		"WHERE layer.fkey_wms_id IN (SELECT layer.fkey_wms_id FROM layer WHERE layer.layer_id = " . $layerId . ") ".
        		"AND layer.layer_parent = '' AND layer.fkey_wms_id=wms.wms_id";
        	$res = db_query($sql);
        	$row = db_fetch_array($res);
        
		//parse capabilities to php object - check if it is still loaded to db
		if ($row['cap'] == '') {
			$wmsCapXml=simplexml_load_string($this->wms_getcapabilities_doc);	
		}
		else {
			$wmsCapXml=simplexml_load_string($row['cap']);
		}
		
		if(!isset($wmsCapXml)) {
			$n = new mb_exception("Problem while parsing capabilities document with simplexml");
			echo "Problem while parsing capabilities document with simplexml<br>";
			return false;
       		}
       		$wmsId = $row['wms_id'];	
		//$n = new mb_exception("wms_id: ".$wmsId);
		//return false;
		//$this->xpath('parent::*')- problematic, cause some services have duplicated layer names!
		//there must be an other solution, which goes over the layer_title element :-(
		//get all layer titles which are parents of the current and push them into a list
		$e = new mb_notice("Searching parents for layer: ".$layerId);
		//$e = new mb_exception("SRS from conf: ".print_r($confSrsArray));
		$layerHasParent = true;
		$countParent = 0;
		$layerParentArray = array();
		$sql = "SELECT layer_title, layer_parent, layer_name FROM layer ".
        			"WHERE layer.layer_id = $layerId";
        	$res = db_query($sql);
        	$row = db_fetch_array($res);
		//initialize with layer itself
		$layerParentArray[0]['id'] = $layerId;
		$layerParentArray[0]['name'] = $row['layer_name'];
		$layerParentArray[0]['title'] = $row['layer_title'];

		$layerParent = $row['layer_parent'];
		//$e = new mb_exception("Type of parent: ". gettype($row['layer_parent']));

		if ($layerParent != '') {
			$e = new mb_notice("parent found at pos: ".$layerParent);
			$countParent = 1;
			while ($layerHasParent) {
				$sql = "SELECT layer_title, layer_id, layer_parent, layer_name FROM layer ".
        				"WHERE fkey_wms_id = $wmsId AND layer.layer_pos = $layerParent";
        			$res = db_query($sql);
        			$row = db_fetch_array($res);

				$layerParentArray[$countParent]['id'] = $row['layer_id'];
				$layerParentArray[$countParent]['name'] = $row['layer_name'];
				$layerParentArray[$countParent]['title'] = $row['layer_title'];

				$layerParent = $row['layer_parent'];

				$countParent++;
				if ($layerParent == '') {
					$layerHasParent = false;
				}
				
			}
		} else {
			$e = new mb_notice("class_wms.php: no further parents available!");
		}

		$supportedSrsArray = array();

		for($j=0; $j<count($layerParentArray);$j++){
			$layerName=$layerParentArray[$j]['name'];
			//defining the xpath for getting all Layer-tags
			$xpathLayerName="//Layer[./Name =\"".$layerName."\"]";
		
			$layerObject=$wmsCapXml->xpath($xpathLayerName);
		
			//for none named layer (only title is set)
               	 	if (empty($layerObject)){
                   	    	$xpathLayerName="//Layer[./Title =\"".$layerName."\"]";
                  		$layerObject=$wmsCapXml->xpath($xpathLayerName);
               		}

			if(!isset($layerObject[0])) {
				$n = new mb_notice("Layer has no name and title, BBOX will not be generated for ".$epsg);
				return false;
			}
		
			
			//search for the SRS tag of specified layer		
			$srsElementArray=$layerObject[0]->xpath("SRS");
			
			foreach($srsElementArray as $srsElement) {
				//create an array of the given srsElements -> include also srs written as a space separated list  
				$srsArray = explode(" ",$srsElement);
				foreach($srsArray as $srs) {
					if(in_array(strtoupper($srs),$confSrsArray)) {
						array_push($supportedSrsArray, strtoupper($srs));
						
//						//$n = new mb_notice("Requested SRS: ".$srs." is supported by layer: ".$layerName." with layer_id: ".${$layerParentArray}[$j]['layer_id']);
                                                //for compatibility reasons (PHP 5 -> 7) changed to
                                                $n = new mb_notice("Requested SRS: ".$srs." is supported by layer: ".$layerName." with layer_id: ".${$layerParentArray[$j]['layer_id']});
					}	
				}
			}
		
		}
		for($k=0; $k < count($supportedSrs);$k++) {
			$e = new mb_notice("SRS ".$supportedSrs[$k]." supported for the layer: ".$layerId);
		}
		if(count($supportedSrsArray) == 0) {
			$n = new mb_notice("class_wms.php: None of the defined srs are supported by the layer");
		}
		return $supportedSrsArray;
	}
	function insertLayerDimension($i) {
		//first get array of all parent layers with their dimensions
		//delete old dimension entries
		$sql = "DELETE FROM layer_dimension WHERE fkey_layer_id = $1";
		$v = array($this->objLayer[$i]->db_id);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		for($j=0; $j<count($this->objLayer[$i]->layer_dimension);$j++){
			$sql = "INSERT INTO layer_dimension (fkey_layer_id, name, units, unitSymbol,\"default\", multipleValues, nearestValue, current, extent, inherited) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, false);";
			$v = array($this->objLayer[$i]->db_id,
			$this->objLayer[$i]->layer_dimension[$j]->name, $this->objLayer[$i]->layer_dimension[$j]->units, $this->objLayer[$i]->layer_dimension[$j]->unitSymbol, $this->objLayer[$i]->layer_dimension[$j]->default, $this->objLayer[$i]->layer_dimension[$j]->multipleValues, $this->objLayer[$i]->layer_dimension[$j]->nearestValue, $this->objLayer[$i]->layer_dimension[$j]->current, $this->objLayer[$i]->layer_dimension[$j]->extent);
			$t = array('i','s','s','s','s','s','s','s','s');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
		}
		//do the things for the parent layers
		//get parent layer
		//$e = new mb_exception("wms_id: ".$this->wms_id);
		if (is_int($this->wms_id)) {
			$admin = new administration();
			$layerIdArray = $admin->getParentLayers($this->wms_id, $this->objLayer[$i]->db_id);
			if ($layerIdArray !== false AND count($layerIdArray) > 0 AND is_array($layerIdArray)) {
				//insert dimensions from parent layers
				$sql = "INSERT INTO layer_dimension (fkey_layer_id, name, units, unitSymbol,\"default\", multipleValues, nearestValue, current, extent, inherited) SELECT ".$this->objLayer[$i]->db_id." AS fkey_layer_id, name, units, unitSymbol,\"default\", multipleValues, nearestValue, current, extent, true as inherited FROM layer_dimension WHERE fkey_layer_id IN (".implode(",",$layerIdArray).") AND inherited IS FALSE";
				$res = db_query($sql);
			}
		}
	}
	function insertLayerEPSG($i) {
		//$currentSrsArray = array();
		$sql = "DELETE FROM layer_epsg WHERE fkey_layer_id = $1";
		$v = array($this->objLayer[$i]->db_id);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		//1. fill in srs from layers with given bboxes from capabilities
		for($j=0; $j<count($this->objLayer[$i]->layer_epsg);$j++){
			$sql = "INSERT INTO layer_epsg (fkey_layer_id, epsg, minx, miny, maxx, maxy) ";
			$sql .= "VALUES($1,$2,$3,$4,$5,$6)";
			$v = array($this->objLayer[$i]->db_id,$this->objLayer[$i]->layer_epsg[$j]['epsg'],
				$this->objLayer[$i]->layer_epsg[$j]['minx'],$this->objLayer[$i]->layer_epsg[$j]['miny'],
				$this->objLayer[$i]->layer_epsg[$j]['maxx'],$this->objLayer[$i]->layer_epsg[$j]['maxy']
				); 
			$e = new mb_notice("class_wms.php: insertLayerEPSG: INSERT SQL:".$sql. " for Layer ".$this->objLayer[$i]->db_id);
			$t = array('i','s','d','d','d','d');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
			//push this srs into the currentSrsArray!
			//array_push($currentSrsArray,$this->objLayer[$i]->layer_epsg[$j]['epsg']);
		}
		
//		GET SRS_ARRAY of mapbender.conf
		if(SRS_ARRAY != "") {
			$confSrsArray = explode(",",SRS_ARRAY);
			foreach($confSrsArray as &$srs) {
				$srs = trim($srs);
			}
		}
		for ($index = 0; $index < sizeof($confSrsArray); $index++) {
			$confSrsArray[$index] = "EPSG:" . $confSrsArray[$index];
		}
		//read the epsg entries which have been filled in before 
		$sql_epsg = "SELECT * FROM layer_epsg WHERE fkey_layer_id = $1";
		$v_epsg = array($this->objLayer[$i]->db_id);
		$t_epsg = array('i');
		$res_epsg = db_prep_query($sql_epsg,$v_epsg,$t_epsg);
		$epsg = array();
		$minx = array();
		$miny = array();
		$maxx = array();
		$maxy = array();
		$cnt = 0;
		//write this results into an array  
		while($row_epsg = db_fetch_array($res_epsg)){
			array_push($epsg,strtoupper($row_epsg['epsg']));
			array_push($minx,$row_epsg['minx']);
			array_push($miny,$row_epsg['miny']);
			array_push($maxx,$row_epsg['maxx']);
			array_push($maxy,$row_epsg['maxy']);
			if (strtoupper($row_epsg['epsg']) == "EPSG:4326") {
				$wgs84Minx = $row_epsg['minx'];
				$wgs84Miny = $row_epsg['miny'];
				$wgs84Maxx = $row_epsg['maxx'];
				$wgs84Maxy = $row_epsg['maxy'];
			}
			$cnt++;
		}

		//get all srs which are supported by the parent layer and in array SRS_ARRAY from mapbender.conf
		//TODO: not only for the root layer but read also all srs from all parent layers!!!
		$supportedSrs = $this->getSupportedSRS($this->objLayer[$i]->db_id, $confSrsArray);
		$supportedSrs = array_unique($supportedSrs);
    		foreach ($supportedSrs as $srs) {
        		$supportedSrsNew[] = $srs;
    		}
		$supportedSrs = $supportedSrsNew;
		
		for($k=0; $k < count($supportedSrs);$k++) {
			$e = new mb_notice("SRS ".$supportedSrs[$k]." for the layer: ".$this->objLayer[$i]->db_id);
			//compute this only, if the srs was not already in the current layer - see array epsg!
			if(!in_array($supportedSrs[$k],$epsg) && $supportedSrs[$k] != '') {
				$n = new mb_notice("Calculation for: ".$supportedSrs[$k]);
				$pointMin = new Mapbender_point($wgs84Minx, $wgs84Miny, "EPSG:4326");
				$pointMax = new Mapbender_point($wgs84Maxx, $wgs84Maxy, "EPSG:4326");
				$pointMin->transform($supportedSrs[$k]);	
				$pointMax->transform($supportedSrs[$k]);
				if($pointMin->epsg != '' && $pointMin->x != '' && $pointMin->y != '' 
					&& $pointMax->x != '' && $pointMax->y != '') {
					$sql_bbox = "INSERT INTO layer_epsg (fkey_layer_id, epsg, minx, miny, maxx, maxy) ";
					$sql_bbox .= "VALUES($1,$2,$3,$4,$5,$6)";
					$v_bbox = array($this->objLayer[$i]->db_id,$pointMin->epsg,$pointMin->x,
									$pointMin->y,$pointMax->x,$pointMax->y); 
					$t_bbox = array('i','s','d','d','d','d');
					$res_bbox = db_prep_query($sql_bbox,$v_bbox,$t_bbox);
					$n = new mb_notice("Calculation for: ".$supportedSrs[$k]." finished successful.");
				}
				else {
					$e = new mb_exception("Could not transform ".strtoupper($epsg[0])." to ".$supportedSrs[$k].".");
				}
			}
		}
	}
	function insertLayerStyle($i){
		$sql = "DELETE FROM layer_style WHERE fkey_layer_id = $1";
		$v = array($this->objLayer[$i]->db_id);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		for($j=0; $j<count($this->objLayer[$i]->layer_style);$j++){
			$sql = "INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) ";
			$sql .= "VALUES($1,$2,$3,$4,$5)";
			$v = array($this->objLayer[$i]->db_id,$this->objLayer[$i]->layer_style[$j]["name"],
					$this->objLayer[$i]->layer_style[$j]["title"],$this->objLayer[$i]->layer_style[$j]["legendurl"],
					$this->objLayer[$i]->layer_style[$j]["legendurlformat"]				
				);
			$t = array('i','s','s','s','s');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
		}
	}
	
	function insertLayerCategories($i){
		
		global $con;
		$types = array("md_topic", "inspire", "custom");
		foreach ($types as $cat) {
			$sql = "DELETE FROM layer_{$cat}_category WHERE fkey_layer_id = $1 AND fkey_metadata_id ISNULL";
			$v = array($this->objLayer[$i]->db_id);
			$t = array('i');
			$res = db_prep_query($sql,$v,$t);
			$attr = "layer_{$cat}_category_id";
			$k = $this->objLayer[$i]->$attr;
			//$e = new mb_exception("class_wms: delete category: ".$attr." from db for layer ".$this->objLayer[$i]->db_id);				
			for ($j = 0; $j < count($k); $j++) {
				$sql = "INSERT INTO layer_{$cat}_category (fkey_layer_id, fkey_{$cat}_category_id) VALUES ($1, $2)";
				$v = array($this->objLayer[$i]->db_id, $k[$j]);
				$t = array('i', 'i');
				if (isset($k[$j])) {
					$res = db_prep_query($sql,$v,$t);
					if(!$res){
						db_rollback();	
						return;
					}
				} else {
					$e = new mb_notice("class_wms: cat: ".$attr." was not set!");				
				}
			}
		}
	}	
	
	function insertLayerKeyword($i){
		global $con;
		$sql = "DELETE FROM layer_keyword WHERE fkey_layer_id = $1";
		$v = array($this->objLayer[$i]->db_id);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		
//		var_dump($this);
		$k = $this->objLayer[$i]->layer_keyword;
//		var_dump($k);
		for($j=0; $j<count($k); $j++){
			$keyword_id = "";
			
			while ($keyword_id == "") {
				$sql = "SELECT keyword_id FROM keyword WHERE UPPER(keyword) = UPPER($1)";
				$v = array($k[$j]);
				$t = array('s');
				$res = db_prep_query($sql,$v,$t);
				$row = db_fetch_array($res);
			//print_r($row);
				if ($row) {
					$keyword_id = $row["keyword_id"];	
				}
				else {
					$sql_insertKeyword = "INSERT INTO keyword (keyword)";
					$sql_insertKeyword .= "VALUES ($1)";
					$v1 = array($k[$j]);
					$t1 = array('s');
					$res_insertKeyword = db_prep_query($sql_insertKeyword,$v1,$t1);
					if(!$res_insertKeyword){
						db_rollback();	
					}
				}
			}

			// check if layer/keyword combination already exists
			$sql_layerKeywordExists = "SELECT * FROM layer_keyword WHERE fkey_layer_id = $1 AND fkey_keyword_id = $2";
			$v = array($this->objLayer[$i]->db_id, $keyword_id);
			$t = array('i', 'i');
			$res_layerKeywordExists = db_prep_query($sql_layerKeywordExists, $v, $t);
			$row = db_fetch_array($res_layerKeywordExists);
			//print_r($row);
			if (!$row) {
				$sql1 = "INSERT INTO layer_keyword (fkey_keyword_id,fkey_layer_id)";
				$sql1 .= "VALUES ($1,$2)";
				$v1 = array($keyword_id,$this->objLayer[$i]->db_id);
				$t1 = array('i','i');
				$res1 = db_prep_query($sql1,$v1,$t1);
				if(!$res1){
					db_rollback();	
				}
			}
		}
	}

	function insertLayerDataUrls($i){
		$e = new mb_notice("class_wms.php: insertLayerDataUrls:".$i);
		//first delete the old ones - but only those who have been harvested thru caps before!
		global $con;
		$sql = "DELETE FROM datalink WHERE datalink_id IN (SELECT datalink_id FROM datalink INNER JOIN";
		$sql .= " (SELECT * from ows_relation_data WHERE fkey_layer_id = $1) as relation ON ";
		$sql .= " datalink.datalink_id = relation.fkey_datalink_id AND datalink.datalink_origin = 'capabilities')";
		$v = array($this->objLayer[$i]->db_id);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		$e = new mb_notice("class_wms.php:  count dataurl: ".count($this->objLayer[$i]->layer_dataurl));
		//for each dataurl entry do something
		for($j=0; $j<count($this->objLayer[$i]->layer_dataurl);$j++){
			//push single elements into database
			//generate random number
			$randomId = new Uuid();
			$sql = "INSERT INTO datalink (datalink_url, datalink_timestamp, datalink_timestamp_create, datalink_origin, datalink_format, datalink_randomid) ";
			$sql .= "VALUES($1, now(), now(), 'capabilities', $2, $3)";
			$v = array(	$this->objLayer[$i]->layer_dataurl[$j]->href,
					$this->objLayer[$i]->layer_dataurl[$j]->format,
					$randomId	
			);
			$e = new mb_notice("dataurl to insert: ".$this->objLayer[$i]->layer_dataurl[$j]->href);
			$e = new mb_notice("dataformat to insert: ".$this->objLayer[$i]->layer_dataurl[$j]->format);
	
			$t = array('s','s','s');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
			//get datalink_id of record which have been inserted before
			$sql = <<<SQL

SELECT datalink_id FROM datalink WHERE datalink_randomid = $1

SQL;
			$v = array($randomId);
			$t = array('s');
			try {
				$res = db_prep_query($sql,$v,$t);
			}
			catch (Exception $e){
				$e = new mb_exception(_mb("Cannot get datalink record with following uuid from database: ".$uuid));
			}
			if ($res) {
				$row = db_fetch_assoc($res);
				$dataLinkId = $row['datalink_id'];
			}
			$sql = "INSERT INTO ows_relation_data (fkey_layer_id, fkey_datalink_id) values ($1, $2);";
			$v = array($this->objLayer[$i]->db_id, $dataLinkId);
			$t = array('i','i');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
		}
	}

	function insertLayerMetadataUrls($i){
		global $con;
		//origin 2 - set by mapbender metadata editor - new record
		//origin 3 - set by mapbender metadata editor - new linkage
		//harvest the record if some readable format is given - should this be adoptable?
		//parse the content if iso19139 is given
		//TODO: generate temporal uuid for inserting and getting the serial afterwards
		//delete old relations for this resource - only those which are from 'capabilities'
		$mbMetadata_1 = new Iso19139();
		$mbMetadata_1->deleteMetadataRelation("layer", $this->objLayer[$i]->db_id,"capabilities");
		//delete object?
		for($j=0; $j<count($this->objLayer[$i]->layer_metadataurl);$j++){
			$mbMetadata = new Iso19139();
			$randomid = new Uuid();
			$mdOwner = Mapbender::session()->get("mb_user_id");
			//The next loop is needed for automatic wms update - no session exists!
			if ($mdOwner == false) {
				$mdOwner = $this->owner;
			}
			$mbMetadata->randomId = $randomid;
			$mbMetadata->href = $this->objLayer[$i]->layer_metadataurl[$j]->href;
			$mbMetadata->format = $this->objLayer[$i]->layer_metadataurl[$j]->format;
			$mbMetadata->type = $this->objLayer[$i]->layer_metadataurl[$j]->type;
			$mbMetadata->origin = "capabilities";
			$mbMetadata->owner = $mdOwner;
			if ($this->wms_bequeath_licence_info == 1 || $this->wms_bequeath_licence_info == '1') {
				$bequeathLicence = true;
			} else {
				$bequeathLicence = false;
			}
			if ($this->wms_bequeath_contact_info == 1 || $this->wms_bequeath_contact_info == '1') {
				$bequeathContact = true;
			} else {
				$bequeathContact = false;
			}
                        if ($this->harvestCoupledDatasetMetadata == true) {
				try {
					$result = $mbMetadata->insertToDB("layer",$this->objLayer[$i]->db_id, $bequeathContact, $bequeathLicence);
					if ($result['value'] == false){
						throw new Exception("Problem while storing metadata url from wms to db");
					} else {
						$ex = new mb_notice("Storing of metadata url from wms to db was successful");
						$ex = new mb_notice($result['message']);
					}
				}
				catch(Exception $e) {
    					$exception = new mb_exception($e->getMessage());
				}
			}
		}
	}

	function updateObjInDB($myWMS,$updateMetadataOnly=false,$changedLayers=null){ //TODO give return true or false to allow feedback to user!!!
        	if (func_num_args() == 4) { //new for HTTP Authentication 
			$auth = func_get_arg(3); 
			$username = $auth['username']; 
			$password = $auth['password']; 
			$authType = $auth['auth_type']; 
		} else { 
			$username = ''; 
			$password = ''; 
			$authType = ''; 
		} 
        	$this->wms_id = $myWMS;
		//get some things out from database if not already given thru metadata editor: wms_network_access, wms_max_imagesize, inspire_download (on layer level)
		//they don't come from the capabilities!
		if (!$updateMetadataOnly) {
			//read network_access from database
			$sql = "SELECT wms_network_access, fkey_mb_group_id, wms_max_imagesize, inspire_annual_requests, wms_license_source_note, wms_bequeath_licence_info, wms_bequeath_contact_info from wms WHERE wms_id = $1 ";
			$v = array($myWMS);
			$t = array('i');
			$res = db_prep_query($sql,$v,$t);
			$row = db_fetch_assoc($res);
			$this->wms_network_access = $row["wms_network_access"];
			$this->wms_max_imagesize = $row["wms_max_imagesize"];
			$this->inspire_annual_requests = $row["inspire_annual_requests"];
			$this->wms_license_source_note = $row["wms_license_source_note"];
			$this->wms_bequeath_licence_info = $row["wms_bequeath_licence_info"];
			$this->wms_bequeath_contact_info = $row["wms_bequeath_contact_info"];
			$this->fkey_mb_group_id = $row["fkey_mb_group_id"];
		}
		$e = new mb_exception('bequeath_licence: '.$this->wms_bequeath_licence_info);
		//if network access is either stored in database nor given thru object, set it too a default value 0
		if (!isset($this->wms_network_access) || ($this->wms_network_access == '')) {
			$this->wms_network_access = intval('0');
		}
		if ($this->setGeoRss == true) {
		    $this->geoRssFactory = new GeoRssFactory();
		    $this->geoRss = $this->geoRssFactory->loadOrCreate(GEO_RSS_FILE);
		}
		
		$admin = new administration();
		db_begin();
		
		$sql = "UPDATE wms SET ";
		$sql .= "wms_version = $1 ,";
		$sql .= "wms_getcapabilities  = $2 ,";
		$sql .= "wms_getmap  = $3 ,";
		$sql .= "wms_getfeatureinfo  = $4 ,";
		$sql .= "wms_getlegendurl  = $5 ,";
		$sql .= "wms_getcapabilities_doc = $6 ,";
		$sql .= "wms_upload_url = $7,  ";
		#$sql .= "wms_owner = $8, ";
		$sql .= "wms_timestamp = $8, ";
		$sql .= "wms_supportsld = $9, ";
		$sql .= "wms_userlayer = $10, ";
		$sql .= "wms_userstyle = $11, ";
		$sql .= "wms_remotewfs = $12, ";
		$sql .= "wms_network_access = $13, ";
		$sql .= "wms_max_imagesize = $16, ";
		$sql .= "fkey_mb_group_id = $14, ";
        	$sql .= "wms_auth_type = $17, "; 
 		$sql .= "wms_username = $18, "; 
 		$sql .= "wms_password = $19, ";
		$sql .= "inspire_annual_requests = $20, ";
		$sql .= "wms_license_source_note = $21, ";
		$sql .= "wms_bequeath_licence_info= $22, ";
		$sql .= "wms_bequeath_contact_info = $23 ";
		//$sql .= "uuid = $15 ";
		$sql .= " WHERE wms_id = $15";
	
		$v = array($this->wms_version,$this->wms_getcapabilities,
			$this->wms_getmap,$this->wms_getfeatureinfo,$this->wms_getlegendurl,
			$admin->char_encode($this->wms_getcapabilities_doc),$this->wms_upload_url,strtotime("now"),
			$this->wms_supportsld,$this->wms_userlayer,$this->wms_userstyle,$this->wms_remotewfs,$this->wms_network_access, $this->fkey_mb_group_id ,$myWMS, $this->wms_max_imagesize, $authType, $username, $password, $this->inspire_annual_requests,$this->wms_license_source_note, $this->wms_bequeath_licence_info, $this->wms_bequeath_contact_info);
		$t = array('s','s','s','s','s','s','s','i','s','s','s','s','i','i','i','i','s','s','s','i','s','i','i');
			
		$res = db_prep_query($sql,$v,$t);
		if(!$res){
			db_rollback();
		}
		//update following metadata only if intended - mapbender.conf
		if($this->overwrite == true){
			$sql = "UPDATE wms SET ";
			$sql .= "wms_title  = $1 ,";
			$sql .= "wms_abstract  = $2 ,";
			$sql .= "fees = $3, ";
			$sql .= "accessconstraints = $4, ";
			$sql .= "contactperson = $5, ";
			$sql .= "contactposition = $6, ";
			$sql .= "contactorganization = $7, ";
			$sql .= "address = $8, ";
			$sql .= "city = $9, ";
			$sql .= "stateorprovince = $10, ";
			$sql .= "postcode = $11, ";
			$sql .= "country = $12, ";
			$sql .= "contactvoicetelephone = $13, ";
			$sql .= "contactfacsimiletelephone = $14, ";
			$sql .= "contactelectronicmailaddress = $15, ";
			$sql .= "wms_network_access = $16, ";
			$sql .= "wms_max_imagesize = $19, ";
			$sql .= "wms_license_source_note = $20, ";
			//$sql .= "inspire_annual_requests = $20, ";
			$sql .= "wms_bequeath_licence_info = $21, ";
			$sql .= "wms_bequeath_contact_info = $22, ";
			$sql .= "fkey_mb_group_id = $17 ";
			#$sql .= "uuid = $18 ";
			$sql .= " WHERE wms_id = $18";
			$v = array($this->wms_title,$this->wms_abstract,$this->fees,$this->accessconstraints,
				$this->contactperson,$this->contactposition,$this->contactorganization,$this->address,
				$this->city,$this->stateorprovince,$this->postcode,$this->country,$this->contactvoicetelephone,
				$this->contactfacsimiletelephone,$this->contactelectronicmailaddress,$this->wms_network_access, $this->fkey_mb_group_id , $myWMS, $this->wms_max_imagesize, $this->wms_license_source_note, $this->wms_bequeath_licence_info, $this->wms_bequeath_contact_info);
			$t = array('s','s','s','s','s','s','s','s','s','s','s','s','s','s','s','i','i','i','i','s','i','i');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
		}
		if ($updateMetadataOnly) {
			# delete and refill wms_termsofuse
			$sql = "DELETE FROM wms_termsofuse WHERE fkey_wms_id = $1 ";
			$v = array($myWMS);
			$t = array('i');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
			$this->insertTermsOfUse($myWMS);
		}
		//the following things should not be updated by using the metadata editor! Therefor 
		//if ($updateMetadataOnly) {
		//	die();
		//}
		if (!$updateMetadataOnly) {
			# delete and refill srs and formats
			$sql = "DELETE FROM wms_srs WHERE fkey_wms_id = $1 ";
			$v = array($myWMS);
			$t = array('i');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
			$this->insertSRS($myWMS);
			$e = new mb_notice("update formats, srs and gui confs!");
			$sql = "DELETE FROM wms_format WHERE fkey_wms_id = $1 ";
			$v = array($myWMS);
			$t = array('i');
			$res = db_prep_query($sql,$v,$t);
			if(!$res){
				db_rollback();	
			}
			$this->insertFormat($myWMS);
		
			# update gui_wms
			$this->update_gui_wms($myWMS);
		}
		
		//NEW 2012-11: Check for changed layer names with options $changedLayersObj
        	for($i=0; $i<count($changedLayers); $i++){
            		if(trim($changedLayers[$i]["oldLayerName"]) != trim($changedLayers[$i]["newLayerName"])) {
                		$sql = "UPDATE layer SET layer_name = $1 WHERE fkey_wms_id = $2 AND layer_name = $3";
    				$v = array(trim($changedLayers[$i]["newLayerName"]), $myWMS, trim($changedLayers[$i]["oldLayerName"]));
    				$t = array('s','i','s');
    				$res = db_prep_query($sql,$v,$t);
    				new mb_notice("update oldLayerName to newLayerName :". $changedLayers[$i]["oldLayerName"]."----->".$changedLayers[$i]["newLayerName"]);
    				if(!$res){
    					db_rollback();	
    				}    
            		}
		 	#new mb_notice("oldLayerName ==================". $changedLayers[$i]["oldLayerName"]);
		    	#new mb_notice("newLayerName ==================". $changedLayers[$i]["newLayerName"]);
        	}
		
        	######## NEW 2013-07: split off the check routine to insert and update layers to one section for root layer and one for all child layers 
        	######## reason: If root layer and child layer have same name, it crashes here!!!
        	################################ start section for root-layer
        
		# update TABLE layer	
		$oldLayerNameArray = array();
		$sql = "SELECT layer_id, layer_name, layer_title, layer_abstract, inspire_download FROM layer WHERE fkey_wms_id = $1 AND layer_pos = 0 AND NOT layer_name = $2"; 
		$v = array($myWMS,$this->objLayer[0]->layer_name);
		$t = array("i","s");
		
		$res = db_prep_query($sql,$v,$t);
		while ($row = db_fetch_array($res)) {
			$oldLayerNameArray[]= array(
				"id" => $row["layer_id"],
				"name" => $row["layer_name"],
				"title" => $row["layer_title"],
				"abstract" => $row["layer_abstract"]
				//"inspire_download" => $row["inspire_download"]
			);
			
		}
		
		# delete all layer which are outdated
		//first delete their metadataUrl entries*****
		$e = new mb_notice("class_wms.php: delete all metadataUrl relations of old layer");
		$sql = "DELETE FROM ows_relation_metadata WHERE fkey_layer_id IN " ;
		$sql .= "(SELECT layer_id FROM layer WHERE fkey_wms_id = $1 AND layer_pos = 0 AND NOT layer_name = $2)";
		$sql .= " AND ows_relation_metadata.relation_type = 'capabilities'";
		$v = array($myWMS, $this->objLayer[0]->layer_name);
		$t = array("i", "s");
		$res = db_prep_query($sql,$v,$t);
		
		//*******************************************
		//TODO: is this done for the keywords too? Maybe not, cause they are stored only once! Only the relations have to be deleted!
		//and then the layer entries
		$v = array($myWMS);
		$t = array('i');
		$c = 2;
		$sql = "DELETE FROM layer WHERE fkey_wms_id = $1 AND layer_pos = 0 AND NOT layer_name = $2";
		$v = array($myWMS, $this->objLayer[0]->layer_name);
		$t = array('i','s');
		$res = db_prep_query($sql,$v,$t);
		if(!$res){
			db_rollback();	
		}
		
		################################ end section for root-layer
		
		################################ start section for all child layers
		
		# update TABLE layer
		$oldLayerNameArray = array();
		$v = array($myWMS);
		$t = array('i');
		$c = 2;
		$sql = "SELECT layer_id, layer_name, layer_title, layer_abstract, inspire_download, uuid FROM layer WHERE fkey_wms_id = $1 AND layer_pos > 0 AND NOT layer_name IN(";
		for($i=1; $i<count($this->objLayer); $i++){
			if($i>1){$sql .= ',';}
			$sql .= "$".$c;
			array_push($v,$this->objLayer[$i]->layer_name);
			array_push($t,'s');
			$c++;
		}
		$sql .= ")";
		$res = db_prep_query($sql,$v,$t);
		while ($row = db_fetch_array($res)) {
			$oldLayerNameArray[]= array(
					"id" => $row["layer_id"],
					"name" => $row["layer_name"],
					"title" => $row["layer_title"],
					"abstract" => $row["layer_abstract"],
					"uuid" => $row["uuid"],
					"layer_searchable" => $row["layer_searchable"]
					//"inspire_download" => $row["inspire_download"]
			);
				
		}
		
		# delete all layer which are outdated
		//first delete their metadataUrl entries*****
		$e = new mb_notice("class_wms.php: delete all metadataUrl relations of old layer");
		$v = array($myWMS);
				$t = array('i');
				$c = 2;
		$sql = "DELETE FROM ows_relation_metadata WHERE fkey_layer_id IN " ;
		$sql .= "(SELECT layer_id FROM layer WHERE fkey_wms_id = $1 AND layer_pos > 0 AND NOT layer_name IN (";
		for($i=1; $i<count($this->objLayer); $i++){
				if($i>1){$sql .= ',';}
				$sql .= "$".$c;
				array_push($v,$this->objLayer[$i]->layer_name);
				array_push($t,'s');
				$c++;
				}
				$sql .= ") )";
				$sql .= " AND ows_relation_metadata.relation_type = 'capabilities'";
		$res = db_prep_query($sql,$v,$t);
		
		
		//*******************************************
		//TODO: is this done for the keywords too? Maybe not, cause they are stored only once! Only the relations have to be deleted!
		//and then the layer entries
		$v = array($myWMS);
		$t = array('i');
		$c = 2;
		$sql = "DELETE FROM layer WHERE fkey_wms_id = $1 AND layer_pos > 0 AND NOT layer_name IN(";
		for($i=1; $i<count($this->objLayer); $i++){
			if($i>1){$sql .= ',';}
			$sql .= "$".$c;
			array_push($v,$this->objLayer[$i]->layer_name);
			array_push($t,'s');
			$c++;
		}
		$sql .= ")";
	
		$res = db_prep_query($sql,$v,$t);
		if(!$res){
			db_rollback();
		}
		
		################ end section for all child layers
			
		# update or insert?
		$sql = "SELECT layer_id, layer_name, uuid, layer_searchable FROM layer WHERE fkey_wms_id = $1";
		$v = array($myWMS);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		$exLayer = array();
		while($row = db_fetch_array($res)){
			array_push($exLayer,$row["layer_name"]);
		}
		$sql = "SELECT fkey_gui_id FROM gui_wms WHERE fkey_wms_id = $1";
		$v = array($myWMS);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		$exGui = array();
		while($row = db_fetch_array($res)){
			array_push($exGui,$row["fkey_gui_id"]);
		}
		$newLayerArray = array();
		for($i=0; $i<count($this->objLayer); $i++){
			if(in_array($this->objLayer[$i]->layer_name,$exLayer)){
				#echo "<br>update: ".$this->objLayer[$i]->layer_name;
				$e = new mb_notice("update layer of wms: ".$myWMS);
				$this->updateLayer($i,$myWMS,$updateMetadataOnly);
				for($j=0; $j<count($exGui); $j++){
					$this->updateGuiLayer($i,$myWMS,$exGui[$j]);
				}
			}
			else{
				#echo "<br>append: ".$this->objLayer[$i]->layer_name;
				$e = new mb_notice("insert layer");
				$this->insertLayer($i,$myWMS);
				$newLayerArray[]= $i;
				for($j=0; $j<count($exGui); $j++){
					$this->appendGuiLayer($i,$myWMS,$exGui[$j]);
				}
			}
		}
		//select new layer after update and insert
		$sql = "SELECT layer_id, layer_name, uuid, layer_searchable FROM layer WHERE fkey_wms_id = $1";
		$v = array($myWMS);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		$updatedInsertedLayerArray = array();
		while($row = db_fetch_array($res)){
			$updatedInsertedLayerArray[] = array(
					"id" => $row['layer_id'],
					"uuid" => $row['uuid'],
					"layer_searchable" => $row['layer_searchable']
			);
			//$e = new mb_exception("insert update layer: ".$row['uuid']." - searchable: ". $row['layer_searchable']);
		}
		db_commit();

		//
		// update GeoRSS feed
		//
		//$geoRssFactory = new GeoRssFactory();
		//$geoRss = $geoRssFactory->loadOrCreate(GEO_RSS_FILE);
		
		if ($this->setGeoRss == true && !is_null($this->geoRss)) {
			$geoRssItem = new GeoRssItem();
			$geoRssItem->setTitle("UPDATED WMS: " . $this->wms_title." (".$myWMS.")");
			$geoRssItem->setDescription($this->wms_abstract);
			$geoRssItem->setUrl(self::getWmsMetadataUrl($myWMS));
			$geoRssItem->setPubDate(self::rssDate());
			for ($j = 0; $j < count($this->objLayer[0]->layer_epsg); $j++) {
				$currentEpsg = $this->objLayer[0]->layer_epsg[$j];
				if ($currentEpsg["epsg"] === "EPSG:4326") {
					$currentBbox = new Mapbender_bbox(
						$currentEpsg["minx"],
						$currentEpsg["miny"],
						$currentEpsg["maxx"],
						$currentEpsg["maxy"],
						$currentEpsg["epsg"]
					);
					$geoRssItem->setBbox($currentBbox);
					break;
				}
			}
			$this->geoRss->appendTop($geoRssItem);

			foreach ($oldLayerNameArray as $oldLayer) {
				$geoRssItemOldLayer = new GeoRssItem();
				$geoRssItemOldLayer->setTitle("DELETED LAYER: " . $oldLayer['title']." (".$oldLayer['id'].")");
				$geoRssItemOldLayer->setUrl(self::getLayerMetadataUrl($oldLayer['id']));
				$geoRssItemOldLayer->setDescription($oldLayer["abstract"]);
				$geoRssItemOldLayer->setPubDate(self::rssDate());
//				$geoRssItem->setUrl();
				$this->geoRss->appendTop($geoRssItemOldLayer);
			}
			$this->geoRss->saveAsFile();
		}
		//twitter out changes
		if ($this->twitterNews == true) {
			//updated WMS
			$twitter_wms = new twitter();
			$twUuid = new Uuid();
			//combine text for tweet
			$tweetText = "UPDATED WMS: " . $this->wms_title." (".$myWMS.") ".self::getWmsMetadataUrl($myWMS)." ".$twUuid;
			//reduce to 140 chars
			$tweetText = substr($tweetText, 0, 136);
			//push to twitter
			$result = $twitter_wms->postTweet($tweetText);
			if ($result != '200') {
				$e = new mb_exception("class_wms.php: Twitter API give back error code: ".$result);
			}
			//for each layer which was deleted
			
			foreach ($oldLayerNameArray as $oldLayer) {
				$twitter_layer = new twitter();
				$twUuid = new Uuid();
				$tweetText = "DELETED LAYER: " . $oldLayer['title']." (".$oldLayer['id'].") ".self::getLayerMetadataUrl($currentLayer->layer_id)." ".$twUuid;
				//reduce to 140 chars
				$tweetText = substr($tweetText, 0, 136);
				$result = $twitter_layer->postTweet($tweetText);
				if ($result != '200') {
					$e = new mb_exception("class_wms.php: Twitter API give back error code: ".$result);
				}
			}
		}
		//sync to metadatacatalogue (service metadata for each layer by uuid) if configured - use uuid*******
		//delete old orphaned layer
		$layerUuidsToDelete = array();
		$layerIdsToPush = array();
		foreach ($oldLayerNameArray as $oldLayer) {
			if ($oldLayer['layer_searchable'] == "1") {
				$layerUuidsToDelete[] = $oldLayer['uuid'];
			}
		}
		//update existing layer
		foreach ($updatedInsertedLayerArray as $updatedInsertedLayer) {
			if ($updatedInsertedLayer['layer_searchable'] !== "1") {
				$layerUuidsToDelete[] = $updatedInsertedLayer['uuid'];
			} else {
				$layerIdsToPush[] = $updatedInsertedLayer['id'];
			}
		}
		//do delete and push
		$propagation = new propagateMetadata();
		$result = $propagation->doPropagation("layer", false, "delete", $layerUuidsToDelete);
		$result = $propagation->doPropagation("layer", $layerIdsToPush, "push", false);
		//****************************************************************************************************
		if ($authType != '') { //some authentication is needed! 
 			$admin = new administration(); 
 			echo "WMS ID: ".$myWMS; 
 			$admin->setWMSOWSstring($myWMS, 1); 
 		} 
		return true;	
	}

	function updateGuiLayer($i,$myWMS,$gui_id){
		$sql = "SELECT layer_id FROM layer WHERE fkey_wms_id = $1 AND layer_name = $2";
		$v = array($myWMS,$this->objLayer[$i]->layer_name);
		$t = array('i','s');
		$res = db_prep_query($sql,$v,$t);
		if($row = db_fetch_array($res)){
			$l_id = $row['layer_id'];	
		}
		else{
			db_rollback();
			$e = new mb_exception("Not found: ".$this->objLayer[$i]->layer_name. " in gui: ".$gui_id);
			return;	
		}
		
		$sql = "SELECT * FROM gui_layer WHERE fkey_layer_id = $1 and fkey_gui_id = $2";
		$v = array($l_id,$gui_id);
		$t = array('i','s');
		$res = db_prep_query($sql,$v,$t);		
		while($row = db_fetch_array($res)){

				$sql1 = "UPDATE gui_layer SET gui_layer_title = $1 ";
				$sql1 .= "WHERE fkey_layer_id = $2 and fkey_gui_id = $3";
				$v = array($this->objLayer[$i]->layer_title, $l_id,$gui_id);
				$t = array('s', 'i','s');
				$res1 = db_prep_query($sql1,$v,$t);
				if(!$res1){
					db_rollback();
				}

			if($this->objLayer[$i]->layer_queryable == 0){
				$sql1 = "UPDATE gui_layer set gui_layer_queryable = 0, gui_layer_querylayer = 0 ";
				$sql1 .= "WHERE fkey_layer_id = $1 and fkey_gui_id = $2";
				$v = array($l_id,$gui_id);
				$t = array('i','s');
				$res1 = db_prep_query($sql1,$v,$t);
				if(!$res1){
					
				db_rollback();
				}
			}
			if($this->objLayer[$i]->layer_queryable == 1){
				$sql1 = "UPDATE gui_layer set gui_layer_queryable = 1 ";
				$sql1 .= "WHERE fkey_layer_id = $1 and fkey_gui_id = $2";
				$v = array($l_id,$gui_id);
				$t = array('i','s');
				$res1 = db_prep_query($sql1,$v,$t);
				if(!$res1){
					
					db_rollback();
				}
			}
			if($row["gui_layer_minscale"] < $this->objLayer[$i]->layer_minscale){
				$sql1 = "UPDATE gui_layer set gui_layer_minscale = $1 ";
				$sql1 .= "WHERE fkey_layer_id = $2 and fkey_gui_id = $3";
				$v = array($this->objLayer[$i]->layer_minscale,$l_id,$gui_id);
				$t = array('i','i','s');
				$res1 = db_prep_query($sql1,$v,$t);
				if(!$res1){db_rollback();
				}
			}
			if(($row["gui_layer_maxscale"] > $this->objLayer[$i]->layer_maxscale) && ((integer)$this->objLayer[$i]->layer_maxscale <> 0)){
				$sql1 = "UPDATE gui_layer set gui_layer_maxscale = $1 ";
				$sql1 .= "WHERE fkey_layer_id = $2 and fkey_gui_id = $3";
				$v = array($this->objLayer[$i]->layer_maxscale,$l_id,$gui_id);
				$t = array('i','i','s');
				$res1 = db_prep_query($sql1,$v,$t);
				if(!$res1){db_rollback();
				}
			}		
		}
	}
	function update_gui_wms($myWMS){
		$mySubmit = null;
		$sql = "SELECT * FROM gui_wms where fkey_wms_id = $1";
		$v = array($myWMS);
		$t = array('i');
		$res = db_prep_query($sql,$v,$t);
		$cnt = 0;
		while($row = db_fetch_array($res)){	
			unset($mySubmit);
			$myGUI[$cnt] = $row["fkey_gui_id"];

			$sql = "UPDATE gui_wms SET ";
			$v = array();
			$t = array();
			$paramCount = 0;		

			for($i=0; $i<count($this->data_type); $i++){
				# gui_wms_mapformat
				if(mb_strtolower($this->data_type[$i]) == "map" && mb_strtolower($this->data_format[$i]) == mb_strtolower($row["gui_wms_mapformat"])){
					$myMapFormat = true;
				}
				# gui_wms_featureinfoformat
				if(mb_strtolower($this->data_type[$i]) == "featureinfo" && mb_strtolower($this->data_format[$i]) == mb_strtolower($row["gui_wms_featureinfoformat"])){
					$myFeatureInfoFormat = true;
				}
				# gui_wms_exceptionformat
				if(mb_strtolower($this->data_type[$i]) == "exception" && mb_strtolower($this->data_format[$i]) == mb_strtolower($row["gui_wms_exceptionformat"])){
					$myExceptionFormat = true;
				}
			}
			if(!$myMapFormat){
				$paramCount++;
				$sql .= "gui_wms_mapformat = $" . $paramCount . " ";
				$mySubmit = true;
				array_push($v, $this->gui_wms_mapformat);
				array_push($t, "s");
			}
			if(!$myFeatureInfoFormat){
				if($mySubmit){ $sql .= ",";}
				$paramCount++;
				$sql .= "gui_wms_featureinfoformat = $" . $paramCount . " ";
				array_push($v, $this->gui_wms_featureinfoformat);
				array_push($t, "s");
				$mySubmit = true;
			}
			if(!$myExceptionFormat){
				if($mySubmit){ $sql .= ",";}
				$paramCount++;
				$sql .= "gui_wms_exceptionformat = $" . $paramCount ." ";
				array_push($v, $this->gui_wms_exceptionformat);
				array_push($t, "s");
				$mySubmit = true;
			}
				
			# gui_wms_epsg
			for($j=0; $j<count($this->objLayer[0]->layer_epsg);$j++){
				if($this->objLayer[0]->layer_epsg[$j]['epsg'] == mb_strtoupper($row["gui_wms_epsg"])){
					$myGUI_EPSG = true;
				}
			}
			if(!$myGUI_EPSG){
				if($mySubmit){ $sql .= ",";}
				$paramCount++;
				$sql .= "gui_wms_epsg = $" . $paramCount . " ";
				array_push($v, $this->gui_wms_epsg);
				array_push($t, "s");
				$mySubmit = true;
			}
			$paramCount++;
			$sql .= " WHERE fkey_gui_id = $" . $paramCount . " ";
			array_push($v, $row["fkey_gui_id"]);
			array_push($t, "s");

			$paramCount++;
			$sql .= "AND fkey_wms_id = $" . $paramCount;
			array_push($v, $myWMS);
			array_push($t, "i");
			if($mySubmit){
				$res = db_prep_query($sql,$v,$t);
				if(!$res){
					db_rollback();	
					echo "<pre>".$sql."</pre><br> <br><p>";
				 	echo db_error(); 
				 	echo "<br /> UPDATE ERROR -> KILL PROCESS AND ROLLBACK....................no update<br><br>";
					$e = new mb_exception("class_wms.php: transaction: Transaction aborted, rollback.");
				}
			}
			$cnt++;
		}	
	}
	function getVersion() {
		return $this->wms_version;
	}
	
	function getCapabilities() {
		return $this->wms_getcapabilities;
	}
	
	function getCapabilitiesDoc() {
		return $this->wms_getcapabilities_doc;
	}

	/**
	* creatObjfromDB
	*
	*/ 
	  function createObjFromDB($gui_id,$wms_id){
		$sql = "Select * from gui_wms where fkey_wms_id = $1 AND fkey_gui_id = $2";
		$v = array($wms_id,$gui_id);
		$t = array('i','s');
		$res = db_prep_query($sql,$v,$t);
		//$e = new mb_exception("class_wms.php - invoke createObjFromDB - for gui ".$gui_id);
		$count=0;
		#$res_count=db_num_rows($res);
		while($row = db_fetch_array($res)){
			$this->gui_wms_mapformat=$row["gui_wms_mapformat"];
			$this->gui_wms_featureinfoformat=$row["gui_wms_featureinfoformat"];
			$this->gui_wms_exceptionformat=$row["gui_wms_exceptionformat"];
			$this->gui_wms_epsg=$row["gui_wms_epsg"];
			$this->gui_wms_visible = $row["gui_wms_visible"];
			$this->gui_wms_opacity = $row["gui_wms_opacity"];
			$this->gui_wms_sldurl = $row["gui_wms_sldurl"];
			$this->gui_wms_dimension_time = false;
	  		$this->gui_wms_dimension_elevation = false;
			$sql = "Select * from wms where wms_id = $1 ";
			$v = array($wms_id);
			$t = array('i');
			$res_wms = db_prep_query($sql,$v,$t);
			$count_wms=0;
			while($row2 = db_fetch_array($res_wms)){
				$this->wms_id = $row2["wms_id"];
				$this->wms_version = $row2["wms_version"];
				$this->wms_title = administration::convertIncomingString($this->stripEndlineAndCarriageReturn($row2["wms_title"]));
				$this->wms_abstract = administration::convertIncomingString($this->stripEndlineAndCarriageReturn($row2["wms_abstract"]));
				$wmsowsproxy = $row2["wms_owsproxy"];
				#$wmsowsproxy = "test";
				if($wmsowsproxy != ""){
					$owsproxyurl = OWSPROXY."/".session_id()."/".$wmsowsproxy."?";
					$this->wms_getmap = $owsproxyurl;
					$this->wms_getcapabilities =  $owsproxyurl;
					$this->wms_getfeatureinfo = $owsproxyurl;
					$this->wms_getlegendurl = $owsproxyurl;
				} else {
					$this->wms_getmap =  $row2["wms_getmap"];
					$this->wms_getcapabilities =  $row2["wms_getcapabilities"];
					$this->wms_getfeatureinfo = $row2["wms_getfeatureinfo"];
					$this->wms_getlegendurl = $row2["wms_getlegendurl"];
				}			
				// TO DO: Capabilities document needs to 
				// be encoded to the original encoding
				// if different from the database encoding
				$this->wms_getcapabilities_doc = $row2["wms_getcapabilities_doc"];
				$this->wms_filter = $row2["wms_filter"];
				$this->wms_supportsld = $row2["wms_supportsld"];
				$this->wms_userlayer = $row2["wms_userlayer"];
				$this->wms_userstyle = $row2["wms_userstyle"];
				$this->wms_remotewfs = $row2["wms_remotewfs"];
				$this->wms_timestamp_create = $row2["wms_timestamp_create"];
				$this->fees = $row2["fees"];
				$this->accessconstraints = $row2["accessconstraints"];
				$this->contactperson = $row2["contactperson"];
				$this->contactposition = $row2["contactposition"];
				$this->contactvoicetelephone = $row2["contactvoicetelephone"];
				$this->contactfacsimiletelephone = $row2["contactfacsimiletelephone"];
				$this->contactorganization = $row2["contactorganization"];
				$this->address = $row2["address"];
				$this->city = $row2["city"];
				$this->stateorprovince = $row2["stateorprovince"];
				$this->postcode = $row2["postcode"];
				$this->country = $row2["country"];
				$this->contactelectronicmailaddress = $row2["contactelectronicmailaddress"];
				$this->wms_max_imagesize = $row2["wms_max_imagesize"];
				$this->inspire_annual_requests = $row2["inspire_annual_requests"];
				$this->wms_license_source_note = $row2["wms_license_source_note"];
				$this->wms_bequeath_licence_info = $row2["wms_bequeath_licence_information"];
				$this->wms_bequeath_contact_info = $row2["wms_bequeath_contact_information"];
				$count_wms++;
			}
	
			### srs
			$srs_sql = "SELECT * FROM wms_srs WHERE fkey_wms_id = $1 ";
			$srs_v = array($wms_id);
			$srs_t = array('i'); 
			$srs_res = db_prep_query($srs_sql, $srs_v, $srs_t);
			$this->wms_srs = array();
			while($srs_row = db_fetch_array($srs_res)) {		
				$this->wms_srs[]= $srs_row["wms_srs"];
			}

			### formats
			$sql = "SELECT * FROM wms_format WHERE fkey_wms_id = $1 ";
			$v = array($wms_id);
			$t = array('i'); 
			$res_wms = db_prep_query($sql,$v,$t);
			$count_format=0;		
			while($row3 = db_fetch_array($res_wms)){		
				$this->data_type[$count_format] = $row3["data_type"];
				$this->data_format[$count_format] = $row3["data_format"];
				$count_format++;
			}
			$count++;
		}
		
		#layer
		$sql = "Select * from gui_layer JOIN layer ON gui_layer.fkey_layer_id = layer.layer_id where gui_layer_wms_id = $1 AND fkey_gui_id = $2 ";
		$sql .= " AND gui_layer_status = 1 ORDER BY gui_layer_priority, CAST(layer_pos AS numeric);";
		$v = array($wms_id,$gui_id);
		$t = array('i','s');
		$res = db_prep_query($sql,$v,$t);
		$count=0;
		
		while($row = db_fetch_array($res)){
			$layer_id = $row["fkey_layer_id"];
			if (defined("SHOW_COUPLED_FEATURETYPES_IN_TREE") && SHOW_COUPLED_FEATURETYPES_IN_TREE == true) {
				$sql = "SELECT *, f_get_download_options_for_layer(layer_id) as downloadoptions, f_get_layer_featuretype_coupling(array[ layer_id ], TRUE) as featuretypecoupling FROM layer WHERE layer_id = $1";
//$e = new mb_exception("show coupling!");
			} else {
				$sql = "SELECT *, f_get_download_options_for_layer(layer_id) as downloadoptions FROM layer WHERE layer_id = $1";
			}
			$v = array($layer_id);
			$t = array('i');
			$res_layer = db_prep_query($sql,$v,$t);
			$count_layer=0;
			while($row2 = db_fetch_array($res_layer)){
				$this->addLayer($row2["layer_pos"],$row2["layer_parent"]);
				$layer_cnt=count($this->objLayer)-1;
				$this->objLayer[$layer_cnt]->layer_uid = $layer_id;
				$this->objLayer[$layer_cnt]->layer_name = administration::convertIncomingString($row2["layer_name"]);
				$this->objLayer[$layer_cnt]->layer_title = administration::convertIncomingString($row2["layer_title"]);			
				//load all dataUrl elements from datalink!
				$sql = "SELECT datalink_id, datalink_url, datalink_format FROM datalink INNER JOIN (SELECT * from ows_relation_data WHERE fkey_layer_id = $1) as relation ON  datalink.datalink_id = relation.fkey_datalink_id AND datalink.datalink_origin = 'capabilities'";
				$v = array($layer_id);
				$t = array('i');
				$res_dataUrl = db_prep_query($sql,$v,$t);
				$count_dataUrl = 0;
				while($row3 = db_fetch_array($res_dataUrl)){
					$this->objLayer[$layer_cnt]->layer_dataurl[$count_dataUrl]->href = $row3["datalink_url"];
					//$this->objLayer[$layer_cnt]->layer_dataurl[$count_dataUrl]->type = $row3["linktype"];
					$this->objLayer[$layer_cnt]->layer_dataurl[$count_dataUrl]->format = $row3["datalink_format"];
					$count_dataUrl++;
				}
				//exchange layer_dataurl[0]->href with downloadoptions for inspire if defined in mapbender.conf
				if (defined("SHOW_INSPIRE_DOWNLOAD_IN_TREE") && SHOW_INSPIRE_DOWNLOAD_IN_TREE == true && $row2["downloadoptions"] != "") {
					//delete {} from downloadoptions and add url
					if (defined("MAPBENDER_PATH") && MAPBENDER_PATH != "") {
						$downloadOptionsUrl = MAPBENDER_PATH."/php/mod_getDownloadOptions.php?outputFormat=html&id=".str_replace('{','',str_replace('}','',str_replace('}{',',',$row2["downloadoptions"])));
					} else {
						$downloadOptionsUrl = "../php/mod_getDownloadOptions.php?outputFormat=html&id=".str_replace('{','',str_replace('}','',str_replace('}{',',',$row2["downloadoptions"])));
					}
					$this->objLayer[$layer_cnt]->layer_dataurl[0]->href = $downloadOptionsUrl;
				}
				//load all metadataUrl elements from mb_metadata
				$sql = "SELECT metadata_id, link, linktype, md_format FROM mb_metadata INNER JOIN (SELECT * from ows_relation_metadata WHERE fkey_layer_id = $1) as relation ON  mb_metadata.metadata_id = relation.fkey_metadata_id AND mb_metadata.origin = 'capabilities'";
				$v = array($layer_id);
				$t = array('i');
				$res_metadataUrl = db_prep_query($sql,$v,$t);
				$count_metadataUrl = 0;
				while($row3 = db_fetch_array($res_metadataUrl)){
					$this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->href = $row3["link"];
					$this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->type = $row3["linktype"];
					$this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->format = $row3["md_format"];
					
					$count_metadataUrl++;
				}
				//new in 2019 - possibility to show symbol for accessing datatable - one url for each entry in json string $row2['featuretypecoupling']
				//link to be invoked
				if (defined("SHOW_COUPLED_FEATURETYPES_IN_TREE") && SHOW_COUPLED_FEATURETYPES_IN_TREE == true && $row2["featuretypecoupling"] !== "[]") {
					//filter wfs_conf for accessiblity for current user
					$currentUser = new User(Mapbender::session()->get("mb_user_id"));
					$accessibleWfsConfIds = $currentUser->getWfsConfByPermission();
					$wfsCouplingArrayOld = json_decode($row2["featuretypecoupling"]);
					$wfsCouplingArrayNew = array();
					foreach ($wfsCouplingArrayOld as $rowWfsConfArray) {
						if (in_array($rowWfsConfArray->wfsConfId, $accessibleWfsConfIds)) {
							$wfsCouplingArrayNew[] = $rowWfsConfArray;
						}
					}
					$row2["featuretypecoupling"] = json_encode($wfsCouplingArrayNew);
					//parse json and built following tree
					/*TODO - alter json object to following struct: {"layerId": 1234,
					    "datasetMetadata": 
					      ["metadataId": 12334,
					       "fileIdentifier": "ded3dsd3e...",
					       "featurtypes": 
					         ["featurtypeId": 123456,
						  "wfsConfs":
                                                    ["wfsConfId": 1234,
						     "wfsConfType": 0
 						    ]
						 ]
					      ]
                                           }
					*/
											
					//built url for webservice
					/*if (defined("MAPBENDER_PATH") && MAPBENDER_PATH != "") {
						$featuretypeMetadataUrl = MAPBENDER_PATH."/php/mod_showLayerToFeaturetypeCoupling.php?outputFormat=html&struct=";
					} else {
						$featuretypeMetadataUrl = "../php/mod_showLayerToFeaturetypeCoupling.php?outputFormat=html&struct=";
					}*/
					$this->objLayer[$layer_cnt]->layer_featuretype_coupling = $this->normalizeLayerFeaturetypeCoupling($row2["featuretypecoupling"]);
//$e = new mb_exception("coupling json - from GUI: ".$this->normalizeLayerFeaturetypeCoupling($row2["featuretypecoupling"]));					
				} else {
					$this->objLayer[$layer_cnt]->layer_featuretype_coupling = null;
				}
				//add to layer object
				//$this->objLayer[$layer_cnt]->layer_featuretype_coupling = $jsonObject;
				//old one:
				//$this->objLayer[$layer_cnt]->layer_metadataurl[0]->href = $row2["layer_metadataurl"];
				$this->objLayer[$layer_cnt]->layer_searchable =$row2["layer_searchable"];
				$this->objLayer[$layer_cnt]->inspire_download =$row2["inspire_download"];
				$this->objLayer[$layer_cnt]->layer_pos =$row2["layer_pos"];						
				//$this->objLayer[$layer_cnt]->layer_queryable =$row2["layer_pos"];
				$this->objLayer[$layer_cnt]->layer_queryable =$row2["layer_queryable"];
				$this->objLayer[$layer_cnt]->layer_minscale =$row2["layer_minscale"];
				$this->objLayer[$layer_cnt]->layer_maxscale = $row2["layer_maxscale"];
				$count_layer++;
			}
			$this->objLayer[$layer_cnt]->layer_uid = $layer_id;
			$this->objLayer[$layer_cnt]->gui_layer_wms_id = $row["gui_layer_wms_id"];
			$this->objLayer[$layer_cnt]->gui_layer_selectable = $row["gui_layer_selectable"];
			$this->objLayer[$layer_cnt]->gui_layer_title = $row["gui_layer_title"] != "" ? $row["gui_layer_title"] : $this->objLayer[$layer_cnt]->layer_title;
			$this->objLayer[$layer_cnt]->gui_layer_visible = $row["gui_layer_visible"];
			$this->objLayer[$layer_cnt]->gui_layer_queryable = $row["gui_layer_queryable"];
			$this->objLayer[$layer_cnt]->gui_layer_querylayer = $row["gui_layer_querylayer"];
			$this->objLayer[$layer_cnt]->gui_layer_minscale = $row["gui_layer_minscale"];
			$this->objLayer[$layer_cnt]->gui_layer_maxscale = $row["gui_layer_maxscale"];
			$this->objLayer[$layer_cnt]->gui_layer_style = $row["gui_layer_style"];
			$this->objLayer[$layer_cnt]->gui_layer_wfs_featuretype = $row["gui_layer_wfs_featuretype"];

			$sql = "Select * from layer_epsg where fkey_layer_id = $1 ORDER BY fkey_layer_id";
			$v = array($layer_id);
			$t = array('i');
			$res_layer_epsg = db_prep_query($sql,$v,$t);
			
			$count_layer_epsg=0;
			while($row2 = db_fetch_array($res_layer_epsg)){
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["epsg"]=strtoupper($row2["epsg"]);
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["minx"]=$row2["minx"];
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["miny"]=$row2["miny"];
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["maxx"]=$row2["maxx"];
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["maxy"]=$row2["maxy"];
				$count_layer_epsg++;
			}
			
			// handle styles
			$sql = "SELECT * FROM layer_style WHERE fkey_layer_id = $1 ";
			$v = array($layer_id);
			$t = array('i');
			$res_style = db_prep_query($sql,$v,$t);
			$count_layer_style = 0;
			while($row2 = db_fetch_array($res_style)){
				$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["name"] = $row2["name"] ? $row2["name"] : "default";
				$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["title"]=$row2["title"];
				if($wmsowsproxy != ""){
					if($row2["legendurl"]!=''){
						$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurl"]=$owsproxyurl.
						"REQUEST=getlegendgraphic&VERSION=".$this->wms_version."&LAYER=".$this->objLayer[$layer_cnt]->layer_name."&FORMAT=".$row2["legendurlformat"].
						"&STYLE=".$row2["name"];
					}
				}
				else{
					if($row2["legendurl"]!=''){
						$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurl"]=$row2["legendurl"];
					}
				}
				$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurlformat"]=$row2["legendurlformat"];
				$count_layer_style++;
			}
			//handle layer dimensions (first only time and elevation!)
			$sql = "SELECT * FROM layer_dimension WHERE fkey_layer_id = $1 AND ( name = 'time' OR name = 'elevation')";
			$v = array($layer_id);
			$t = array('i');
			$res_dimension = db_prep_query($sql,$v,$t);
			$count_layer_dimension = 0;
			//test
			$attributeNames = array('name', 'units', 'unitSymbol', 'default', 'multipleValues', 'nearestValue', 'current', 'extent');
			while($row_dim = db_fetch_array($res_dimension)) {
				foreach($attributeNames as $attribute) {
					$this->objLayer[$layer_cnt]->layer_dimension[$count_layer_dimension]->{$attribute} = $row_dim[strtolower($attribute)];
				}
				$count_layer_dimension++;
			}
			$count++;
		}
	   }
	/** end createObjfromDB **/
	
	  /**
	* creatObjfromDBNoGui
	*
	*/ 
	//TODO Update while editing metadata of wms will update the metadata - delete entries and read new ones - then they will be visible and cannot be set to inactive!
	  function createObjFromDBNoGui($wms_id, $withProxyUrls = true){
	   	$sql = "Select * from wms where wms_id = $1 ";
		$v = array($wms_id);
		$t = array('i');
		$res_wms = db_prep_query($sql,$v,$t);
		$count_wms=0;
		while($row2 = db_fetch_array($res_wms)){
			$this->wms_id = $row2["wms_id"];
			$this->wms_version = $row2["wms_version"];
			$this->wms_title = administration::convertIncomingString($this->stripEndlineAndCarriageReturn($row2["wms_title"]));
			$this->wms_abstract = administration::convertIncomingString($this->stripEndlineAndCarriageReturn($row2["wms_abstract"]));
			$wmsowsproxy = $row2["wms_owsproxy"];
			#$wmsowsproxy = "test";
			//exchange the method urls with owsproxy urls if needed - default is to do it, but sometimes this is not usefull!
			if($wmsowsproxy != "" && $withProxyUrls){
				$owsproxyurl = OWSPROXY."/".session_id()."/".$wmsowsproxy."?";
				$this->wms_getmap = $owsproxyurl;
				$this->wms_getcapabilities =  $owsproxyurl;
				$this->wms_getfeatureinfo = $owsproxyurl;
				$this->wms_getlegendurl = $owsproxyurl;
			}
			else{
				$this->wms_getmap =  $row2["wms_getmap"];
				$this->wms_getcapabilities =  $row2["wms_getcapabilities"];
				$this->wms_getfeatureinfo = $row2["wms_getfeatureinfo"];
				$this->wms_getlegendurl = $row2["wms_getlegendurl"];
			}			
			// TO DO: Capabilities document needs to 
			// be encoded to the original encoding
			// if different from the database encoding
			$this->wms_getcapabilities_doc = $row2["wms_getcapabilities_doc"];
			$this->wms_upload_url = $row2["wms_upload_url"];
			$this->wms_filter = $row2["wms_filter"];
			$this->wms_supportsld = $row2["wms_supportsld"];
			$this->wms_userlayer = $row2["wms_userlayer"];
			$this->wms_userstyle = $row2["wms_userstyle"];
			$this->wms_remotewfs = $row2["wms_remotewfs"];
			$this->wms_timestamp = $row2["wms_timestamp"];
			$this->wms_timestamp_create = $row2["wms_timestamp_create"];
			$this->fees = $row2["fees"];
			$this->accessconstraints = $row2["accessconstraints"];
			$this->contactperson = $row2["contactperson"];
			$this->contactposition = $row2["contactposition"];
			$this->contactvoicetelephone = $row2["contactvoicetelephone"];
			$this->contactfacsimiletelephone = $row2["contactfacsimiletelephone"];
			$this->contactorganization = $row2["contactorganization"];
			$this->address = $row2["address"];
			$this->city = $row2["city"];
			$this->stateorprovince = $row2["stateorprovince"];
			$this->postcode = $row2["postcode"];
			$this->country = $row2["country"];
			$this->contactelectronicmailaddress = $row2["contactelectronicmailaddress"];
			$this->wms_network_access = $row2["wms_network_access"];
			$this->fkey_mb_group_id = $row2["fkey_mb_group_id"];
			$this->uuid = $row2["uuid"];
			$this->wms_max_imagesize = $row2["wms_max_imagesize"];
			$this->inspire_annual_requests = $row2["inspire_annual_requests"];
			$this->wms_license_source_note = $row2["wms_license_source_note"];
			$this->wms_bequeath_licence_info = $row2["wms_bequeath_licence_info"];
			$this->wms_bequeath_contact_info = $row2["wms_bequeath_contact_info"];
			//some default values
			$this->gui_wms_visible = 1;
			$this->gui_wms_opacity = 100;
			$this->gui_wms_dimension_time = false;
			$this->gui_wms_dimension_elevation = false;
			//the following things are not given without a special gui!!!!!
			$this->gui_wms_epsg=$row["gui_wms_epsg"];
			$this->gui_wms_sldurl = $row["gui_wms_sldurl"];
			//default
			$this->gui_wms_dimension_time = false;
			$this->gui_wms_dimension_elevation = false;

			if($this->wms_version == "1.0.0"){
			    $this->gui_wms_mapformat = "PNG";
			    $this->gui_wms_featureinfoformat = "MIME";
			    $this->gui_wms_exceptionformat = "INIMAGE";
			}elseif($this->wms_version == "1.3.0"){
			    $this->gui_wms_mapformat = "image/png";
			    $this->gui_wms_featureinfoformat = "text/html";
			    $this->gui_wms_exceptionformat = "INIMAGE";
			/*define defaults for wms-version 1.1.0 and 1.1.1*/
			}else{
			    $this->gui_wms_mapformat = "image/png";
			    $this->gui_wms_featureinfoformat = "text/html";
			    $this->gui_wms_exceptionformat = "application/vnd.ogc.se_inimage";
			}
			
			$count_wms++;
		}
	
		### formats
		$sql = "SELECT * FROM wms_format WHERE fkey_wms_id = $1 ";
		$v = array($wms_id);
		$t = array('i'); 
		$res_wms = db_prep_query($sql,$v,$t);
		$count_format=0;		
		while($row3 = db_fetch_array($res_wms)){		
			$this->data_type[$count_format] = $row3["data_type"];
			$this->data_format[$count_format] = $row3["data_format"];
			$count_format++;
		}

		if (defined("SHOW_COUPLED_FEATURETYPES_IN_TREE") && SHOW_COUPLED_FEATURETYPES_IN_TREE == true) {
			$sql = "SELECT *, f_get_download_options_for_layer(layer_id) as downloadoptions, f_get_layer_featuretype_coupling(array[ layer_id ], TRUE) as featuretypecoupling FROM layer WHERE fkey_wms_id = $1 ORDER BY layer_pos";
//$e = new mb_exception("show coupling!");
		} else {
			$sql = "SELECT *, f_get_download_options_for_layer(layer_id) as downloadoptions FROM layer WHERE fkey_wms_id = $1 ORDER BY layer_pos";
		}	
		//$sql = "SELECT *, f_get_download_options_for_layer(layer_id) as downloadoptions from layer where fkey_wms_id = $1 ORDER BY layer_pos";
		$v = array($wms_id);
		$t = array('i');
		$res_layer = db_prep_query($sql,$v,$t);
		$count_layer=0;
		while($row2 = db_fetch_array($res_layer)){
			$this->addLayer($row2["layer_pos"],$row2["layer_parent"]);
			$layer_cnt=count($this->objLayer)-1;
			$this->objLayer[$layer_cnt]->layer_uid = $row2["layer_id"];
			$this->objLayer[$layer_cnt]->layer_name = administration::convertIncomingString($row2["layer_name"]);
			$this->objLayer[$layer_cnt]->layer_title = administration::convertIncomingString($row2["layer_title"]);
			$this->objLayer[$layer_cnt]->layer_abstract = administration::convertIncomingString($row2["layer_abstract"]);	
			$this->objLayer[$layer_cnt]->gui_layer_title = $this->objLayer[$layer_cnt]->layer_title;			
			//load all dataUrl elements from datalink!
			$sql = "SELECT datalink_id, datalink_url, datalink_format FROM datalink INNER JOIN (SELECT * from ows_relation_data WHERE fkey_layer_id = $1) as relation ON  datalink.datalink_id = relation.fkey_datalink_id AND datalink.datalink_origin = 'capabilities'";
			$e = new mb_notice("class_wms: layer_id: ".$layer_id);
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_dataUrl = db_prep_query($sql,$v,$t);
			$count_dataUrl = 0;
			while($row3 = db_fetch_array($res_dataUrl)){
				$this->objLayer[$layer_cnt]->layer_dataurl[$count_dataUrl]->href = $row3["datalink_url"];
				//$this->objLayer[$layer_cnt]->layer_dataurl[$count_dataUrl]->type = $row3["linktype"];
				$this->objLayer[$layer_cnt]->layer_dataurl[$count_dataUrl]->format = $row3["datalink_format"];
				$count_dataUrl++;
			}
			//exchange layer_dataurl[0]->href with downloadoptions for inspire if defined in mapbender.conf
			if (defined("SHOW_INSPIRE_DOWNLOAD_IN_TREE") && SHOW_INSPIRE_DOWNLOAD_IN_TREE == true && $row2["downloadoptions"] != "") {
				//delete {} from downloadoptions and add url
				if (defined("MAPBENDER_PATH") && MAPBENDER_PATH != "") {
					$downloadOptionsUrl = MAPBENDER_PATH."/php/mod_getDownloadOptions.php?outputFormat=html&id=".str_replace('{','',str_replace('}','',str_replace('}{',',',$row2["downloadoptions"])));
				} else {
					$downloadOptionsUrl = "../php/mod_getDownloadOptions.php?outputFormat=html&id=".str_replace('{','',str_replace('}','',str_replace('}{',',',$row2["downloadoptions"])));
				}
				$this->objLayer[$layer_cnt]->layer_dataurl[0]->href = $downloadOptionsUrl;					
			}
			
			$e = new mb_notice("class_wms.php: # of found dataurls in db: ".$count_dataUrl);
			//load all metadataUrl elements from mb_metadata
			$sql = "SELECT metadata_id, link, linktype, md_format FROM mb_metadata INNER JOIN (SELECT * from ows_relation_metadata WHERE fkey_layer_id = $1) as relation ON  mb_metadata.metadata_id = relation.fkey_metadata_id AND mb_metadata.origin = 'capabilities'";
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_metadataUrl = db_prep_query($sql,$v,$t);
			$count_metadataUrl = 0;
			while($row4 = db_fetch_array($res_metadataUrl)){
				$this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->href = $row4["link"];
				$this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->type = $row4["linktype"];
				$this->objLayer[$layer_cnt]->layer_metadataurl[$count_metadataUrl]->format = $row4["md_format"];
				$count_metadataUrl++;
			}
			//new in 2019 - possibility to show symbol for accessing datatable - one url for each entry in json string $row2['featuretypecoupling']
			//link to be invoked
//$e = new mb_exception("row2 featuretypecoupling:".$row2["featuretypecoupling"]);
			if (defined("SHOW_COUPLED_FEATURETYPES_IN_TREE") && SHOW_COUPLED_FEATURETYPES_IN_TREE == true && $row2["featuretypecoupling"] != "[]") {
				//filter wfs_conf for accessiblity for current user
				$currentUser = new User(Mapbender::session()->get("mb_user_id"));
				$accessibleWfsConfIds = $currentUser->getWfsConfByPermission();
				$wfsCouplingArrayOld = json_decode($row2["featuretypecoupling"]);
				$wfsCouplingArrayNew = array();
				foreach ($wfsCouplingArrayOld as $rowWfsConfArray) {
					if (in_array($rowWfsConfArray->wfsConfId, $accessibleWfsConfIds)) {
						$wfsCouplingArrayNew[] = $rowWfsConfArray;
					}
				}
				$row2["featuretypecoupling"] = json_encode($wfsCouplingArrayNew);
				//parse json and built following tree
				/*TODO - alter json object to following struct: {"layerId": 1234,
					   "datasetMetadata": 
					     ["metadataId": 12334,
					      "fileIdentifier": "ded3dsd3e...",
					      "featurtypes": 
					        ["featurtypeId": 123456,
					  "wfsConfs":
                                                   ["wfsConfId": 1234,
						    "wfsConfType": 0
 						   ]
					 ]
					     ]
                                          }
				*/						
				//built url for webservice
				/*if (defined("MAPBENDER_PATH") && MAPBENDER_PATH != "") {
					$featuretypeMetadataUrl = MAPBENDER_PATH."/php/mod_showLayerToFeaturetypeCoupling.php?outputFormat=html&struct=";
				} else {
					$featuretypeMetadataUrl = "../php/mod_showLayerToFeaturetypeCoupling.php?outputFormat=html&struct=";
				}*/
				$this->objLayer[$layer_cnt]->layer_featuretype_coupling = $this->normalizeLayerFeaturetypeCoupling($row2["featuretypecoupling"]);
//$e = new mb_exception("coupling json: - no GUI ".$this->normalizeLayerFeaturetypeCoupling($row2["featuretypecoupling"]));					
			} else {
				$this->objLayer[$layer_cnt]->layer_featuretype_coupling = null;
			}
			$this->objLayer[$layer_cnt]->layer_searchable =$row2["layer_searchable"];
			$this->objLayer[$layer_cnt]->inspire_download =$row2["inspire_download"];
			$this->objLayer[$layer_cnt]->layer_pos =$row2["layer_pos"];						
			$this->objLayer[$layer_cnt]->layer_queryable =$row2["layer_queryable"];
			$this->objLayer[$layer_cnt]->layer_minscale =$row2["layer_minscale"];
			$this->objLayer[$layer_cnt]->layer_maxscale = $row2["layer_maxscale"];
			$this->objLayer[$layer_cnt]->uuid = $row2["uuid"];
			
			if($this->objLayer[$layer_cnt]->layer_minscale == ""){
				$this->objLayer[$layer_cnt]->layer_minscale = 0;
			}
			if($this->objLayer[$layer_cnt]->layer_maxscale == ""){
				$this->objLayer[$layer_cnt]->layer_maxscale = 0;
			}
			$this->objLayer[$layer_cnt]->gui_layer_minscale = $this->objLayer[$layer_cnt]->layer_minscale;
			$this->objLayer[$layer_cnt]->gui_layer_maxscale = $this->objLayer[$layer_cnt]->layer_maxscale;
			$this->objLayer[$layer_cnt]->gui_layer_queryable = $this->objLayer[$layer_cnt]->layer_queryable;
			$this->objLayer[$layer_cnt]->gui_layer_wms_id = $this->wms_id;
			
			$sql = "Select * from layer_epsg where fkey_layer_id = $1 ORDER BY fkey_layer_id";
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_layer_epsg = db_prep_query($sql,$v,$t);
			
			$count_layer_epsg=0;
			while($row2 = db_fetch_array($res_layer_epsg)){
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["epsg"]=strtoupper($row2["epsg"]);
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["minx"]=$row2["minx"];
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["miny"]=$row2["miny"];
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["maxx"]=$row2["maxx"];
				$this->objLayer[$layer_cnt]->layer_epsg[$count_layer_epsg]["maxy"]=$row2["maxy"];
				$count_layer_epsg++;
			}
			//handle layer dimensions (first only time and elevation!)
			$sql = "SELECT * FROM layer_dimension WHERE fkey_layer_id = $1 AND ( name = 'time' OR name = 'elevation')";
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_dimension = db_prep_query($sql,$v,$t);
			$count_layer_dimension = 0;			
			//$e = new mb_exception("classes/class_wms.php - select dimension from database (createObjFromDBNoGui)!");
			while($row_dim = db_fetch_array($res_dimension)) {
				$attributeNames = array('name', 'units', 'unitSymbol', 'default', 'multipleValues', 'nearestValue', 'current', 'extent');
				foreach($attributeNames as $attribute) {
					$this->objLayer[$layer_cnt]->layer_dimension[$count_layer_dimension]->{$attribute} = $row_dim[strtolower($attribute)];
				}
				//Initialize empty string for userValue from db cause this is only handled by wmc standard
				$this->objLayer[$layer_cnt]->layer_dimension[$count_layer_dimension]->userValue = "";
				$count_layer_dimension++;
			}

			// read out keywords
			$sql = "SELECT keyword FROM keyword, layer_keyword 
WHERE keyword_id = fkey_keyword_id AND fkey_layer_id = $1";
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_layer_keywords = db_prep_query($sql,$v,$t);
			
			$count_layer_keywords=0;
			while($row2 = db_fetch_array($res_layer_keywords)){
				$this->objLayer[$layer_cnt]->layer_keyword[$count_layer_keywords]=$row2["keyword"];
				$count_layer_keywords++;
			}
			### read out layer_md_topic_category_id
			$sql = "SELECT fkey_md_topic_category_id FROM layer_md_topic_category WHERE fkey_layer_id =  $1 AND fkey_metadata_id ISNULL";
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_layer_md_topic_category = db_prep_query($sql,$v,$t);
			
			$count_layer_md_topic_category=0;
			while($row2 = db_fetch_array($res_layer_md_topic_category)){
				$this->objLayer[$layer_cnt]->layer_md_topic_category_id[$count_layer_md_topic_category]=$row2["fkey_md_topic_category_id"];
				$count_layer_md_topic_category++;
			}
			### read out layer_inspire_category_id
			$sql = "SELECT fkey_inspire_category_id FROM layer_inspire_category WHERE fkey_layer_id =  $1 AND fkey_metadata_id ISNULL";
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_layer_inspire_category = db_prep_query($sql,$v,$t);
			
			$count_layer_inspire_category=0;
			while($row2 = db_fetch_array($res_layer_inspire_category)){
				$this->objLayer[$layer_cnt]->layer_inspire_category_id[$count_layer_inspire_category]=$row2["fkey_inspire_category_id"];
				$count_layer_inspire_category++;
			}
			### read out layer_custom_category_id
			$sql = "SELECT fkey_custom_category_id FROM layer_custom_category WHERE fkey_layer_id =  $1 AND fkey_metadata_id ISNULL";
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_layer_custom_category = db_prep_query($sql,$v,$t);
			
			$count_layer_custom_category=0;
			while($row2 = db_fetch_array($res_layer_custom_category)){
				$this->objLayer[$layer_cnt]->layer_custom_category_id[$count_layer_custom_category]=$row2["fkey_custom_category_id"];
				$count_layer_custom_category++;
			}
			### handle styles
			$sql = "SELECT * FROM layer_style WHERE fkey_layer_id = $1 ";
			$v = array($this->objLayer[$layer_cnt]->layer_uid);
			$t = array('i');
			$res_style = db_prep_query($sql,$v,$t);
			$count_layer_style = 0;
			while($row2 = db_fetch_array($res_style)){
				$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["name"]=$row2["name"];
				$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["title"]=$row2["title"];
				if($wmsowsproxy != ""){
					if($row2["legendurl"]!=''){
						$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurl"]=$owsproxyurl.
						"REQUEST=getlegendgraphic&VERSION=".$this->wms_version."&LAYER=".$this->objLayer[$layer_cnt]->layer_name."&FORMAT=".$row2["legendurlformat"].
						"&STYLE=".$row2["name"];
					}
				}
				else{
					if($row2["legendurl"]!=''){
						$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurl"]=$row2["legendurl"];
						#$e = new mb_notice("legendurl = ".$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurl"]);
					}
				}
				$this->objLayer[$layer_cnt]->layer_style[$count_layer_style]["legendurlformat"]=$row2["legendurlformat"];
				$count_layer_style++;
			}
						
			$count_layer++;
		}
	
   }
	/** end createObjfromDBNoGui **/
	
	  /**
	* function checkObjExistsInDB()
	*
	* this function checks wether the onlineresource already exists in the database.
	*/ 
	function checkObjExistsInDB(){
	
		$sql = "Select * from wms where wms_getcapabilities = $1";
		$v = array($this->wms_getcapabilities);
		$t = array('s');
		$res = db_prep_query($sql,$v,$t);
		$res_count= db_num_rows($res);	  
		$wms_id=0;
		if($res_count>0){
			$count=0;
			while($row = db_fetch_array($res)){
				$wms_id=$row["wms_id"];
				$count++;
			}
		}
		return $wms_id;
	}
	
	function displayDBInformation(){
		echo $this->wms_getcapabilities;
		$sql="Select * from wms where wms_getcapabilities = $1";
		$v = array($this->wms_getcapabilities);
		$t = array('s');
		$res = db_prep_query($sql,$v,$t);
		$count=0;
		while($row = db_fetch_array($res)){
		echo "count: ".$count."<br>";
			$wms_id=$row["wms_id"];
			echo "version: " .$wms_id." <br>";
			echo "title: " .$row["wms_version"]. " <br>";
			echo "abstract: " . $row["wms_title"] . " <br>";
			echo "maprequest: " .$row["wms_abstract"] . " <br>";
			echo "capabilitiesrequest: " . $row["wms_getcapabilities"] . " <br>";
			echo "featureinforequest: " . $row["wms_getmap"]. " <br>";
			echo "gui_wms_mapformat: " . $row["wms_getfeatureinfo"] . " <br>---------<br>";
			$count++;
		}
	   echo "----<br> wms_id: ".$wms_id."<br>";
	   
	   $sql = "Select * from gui_wms where fkey_wms_id = $1";
	   $v = array($wms_id);
	   $t = array('i');
	   echo "sql: ".$sql." <br>---------<br>";
	   $res = db_prep_query($sql,$v,$t);
	   $res_count= db_num_rows($res); 
	   echo "result count: ".$res_count." <br>---------<br>";
	   
	   $count=0;
	   while($row = db_fetch_array($res)){
	    	echo "gui_wms_featureinfoformat: " . $row["gui_wms_featureinfoformat"]." <br>";
	    	echo "gui_wms_exceptionformat: " .  $row["gui_wms_exceptionformat"]. " <br>";
	    	echo "gui_wms_epsg: " .  $row["gui_wms_epsg"]. " <br>";
	      $count++;
	   }
		
	   #db_close($connect);
	}

	function checkObj(){
		if($this->wms_getcapabilities == '' || $this->wms_getmap == '' ){
			echo "<br>Missing parameters: <br>";
			$this->displayWMS();
			print_r($this);
			echo "<br> Data not committed<br>";
			die();
		}
	}
	
	public static function getWmsIdByLayerId ($id) {
		$sql = "SELECT DISTINCT fkey_wms_id FROM layer WHERE layer_id = $1";
		$res = db_prep_query($sql, array($id), array("i"));
		$row = db_fetch_assoc($res);
		if ($row) {
			return $row["fkey_wms_id"];
		}
		return null;
	}
	
	/**
	 * Selects all WMS of the current user from the database.
	 * Then it creates the corresponding WMS object and returns
	 * these objects as an array.
	 * 
	 * @return wms[]
	 * @param $appId String
	 */
	public static function selectMyWmsByApplication ($appId) {
		// check if user is permitted to access the application
		$currentUser = new User(Mapbender::session()->get("mb_user_id"));
		$appArray = $currentUser->getApplicationsByPermission(false);
		if (!in_array($appId, $appArray)) {
			$e = new mb_warning("class_wms.php: selectMyWmsByApplication(): User '" . $currentUser . "' is not allowed to acces application '" . $appId . "'.");
			return array();
		}
		
		// get WMS of this application
		$sql = "SELECT fkey_wms_id FROM gui_wms WHERE " . 
				"fkey_gui_id = $1 ORDER BY gui_wms_position";
		$v = array($appId);
		$t = array('s');
		$res = db_prep_query($sql,$v,$t);
		
		// instantiate PHP objects and store in array
		$wmsArray = array();
		while ($row = db_fetch_array($res)) {
			$currentWms = new wms();
			$currentWms->createObjFromDB($appId, $row["fkey_wms_id"]);
			array_push($wmsArray, $currentWms);
		}
		return $wmsArray;
	}
}
class layer extends wms {	
	var $layer_id;
	var $layer_parent;
	var $layer_name;
	var $layer_title;
	var $layer_abstract;
	var $layer_pos;
	var $layer_queryable;
	var $layer_minscale;
	var $layer_maxscale;
	var $layer_dataurl = array();
    	//var $layer_dataurl_href;
    	var $layer_metadataurl = array();
	var $layer_searchable;
	var $inspire_download;
    	var $layer_keyword = array();
	var $layer_keyword_vocabulary = array();
	var $layer_epsg = array();
	var $layer_style = array();
	var $layer_dimension = array();
	var $layer_md_topic_category_id = array();
	var $layer_inspire_category_id = array();
	var $layer_custom_category_id = array();
        //var $layer_featuretype_coupling;
	
	var $gui_layer_wms_id;
	var $gui_layer_status = 1;
	var $gui_layer_selectable = 1;
	var $gui_layer_visible = 0;
	var $gui_layer_queryable = 0;
	var $gui_layer_querylayer = 0;
	var $gui_layer_style = NULL;	
	//var $gui_layer_dataurl_href;

	function layer($id,$parent){
		$this->layer_id = $id;
		$this->layer_parent = $parent;	
		//var_dump($this);	
	}

	public function equals ($layer) {
		if (is_numeric($this->layer_uid) && $this->layer_uid === $layer->layer_uid) {
			return true;
		}
		return false;
	}

	public function __toString () {
		//$e = new mb_notice("TITLE: " . $this->layer_title);
		return $this->layer_title;
	}
	
	public function getChildren () {
		$children = array();
		$wmsId = wms::getWmsIdByLayerId($this->layer_uid);
		$wmsFactory = new UniversalWmsFactory();
		$wms = $wmsFactory->createFromDb($wmsId);
		if (!is_null($wms)) {
			try {
				$currentLayer = $wms->getLayerById($this->layer_uid);
			}
			catch (Exception $e) {
				return $children;
			}
			for ($i = 0; $i < count($wms->objLayer); $i++) {
				$l = $wms->objLayer[$i];
				if ($l->layer_parent === $currentLayer->layer_pos) {
					// add this layer and add its children recursively
					$children = array_merge($children, array($l), $l->getChildren());
				}
			}
		}
		return $children;
	}
	
	public function getParents () {
		$parents = array();
		$wmsId = wms::getWmsIdByLayerId($this->layer_uid);
		$wmsFactory = new UniversalWmsFactory();
		$wms = $wmsFactory->createFromDb($wmsId);
		if (!is_null($wms)) {
			try {
				$currentLayer = $wms->getLayerById($this->layer_uid);
			}
			catch (Exception $e) {
				return $parents;
			}
			while (!is_null($currentLayer)) {
				$pos = $currentLayer->layer_parent;
				$currentLayer = $wms->getLayerByPos($pos);
				if (!is_null($currentLayer)) {
					$parents[]= $currentLayer;
				}
			}
		}
		return $parents;
	}
}

class AccessDeniedException extends Exception {
	public function errorMessage() {
		//error message
		$errorMsg = 'Error on line ' . $this->getLine() . ' in ' .
			$this->getFile() .
			': You are not allowed to access layer with ID: ' .
			$this->getMessage();
		return $errorMsg;
	}
}
?>