'.$testMatch.' is not valid.
'; echo 'Parameter id is not valid (integer oder cs integer list).
'; die(); } $layerId = $testMatch; $testMatch = NULL; } //dbselect for generate KML $sqlKML = "select wms.wms_getmap, wms.wms_version, wms.wms_owsproxy, layer.layer_name,layer.layer_title, layer_epsg.minx,layer_epsg.miny,layer_epsg.maxx,layer_epsg.maxy from wms, layer, layer_epsg, wms_format where layer.layer_id=$1 and layer.fkey_wms_id=wms.wms_id and layer.layer_id=layer_epsg.fkey_layer_id and layer_epsg.epsg='EPSG:4326' and wms.wms_id=wms_format.fkey_wms_id and wms_format.data_format like '%image/png%' LIMIT 1"; $vKML = array($layerId); $tKML = array('i'); $resKML = db_prep_query($sqlKML, $vKML, $tKML); $rowKML = db_fetch_array($resKML); if (!isset($rowKML['layer_name'])) { echo "Layer with requested id doesn't exists in registry or layer has no name, so it can't be invoked by Google Earth!"; die(); } $admin = new administration(); $getmapurl = $admin->checkURL($rowKML['wms_getmap']); $getmapurl = str_replace("&","&", $getmapurl); //exchange normal url with owsproxyurl $sessionId = session_id(); if ($rowKML['wms_owsproxy'] <> '' && $rowKML['wms_owsproxy'] <> NULL) { if (defined("OWSPROXY") && OWSPROXY != ""){ $getmapurl = OWSPROXY."/".$sessionId."/".$rowKML["wms_owsproxy"]."?"; } else { $getmapurl = "http://www.google.com?"; } } $kml="".chr(13).chr(10); $kml.="".chr(13).chr(10); $kml.="".chr(13).chr(10); $kml.="".$rowKML['layer_title']."".chr(13).chr(10); $kml.="".chr(13).chr(10); $kml.="".$getmapurl."VERSION=".$rowKML['wms_version']."&REQUEST=GetMap&SRS=EPSG:4326&WIDTH=2048&HEIGHT=2048&LAYERS=".$rowKML['layer_name']."&STYLES=&TRANSPARENT=TRUE&BGCOLOR=0xffffff&FORMAT=image/png&".chr(13).chr(10); $kml.="onExpire".chr(13).chr(10); $kml.="onStop".chr(13).chr(10); $kml.="1".chr(13).chr(10); $kml.="0.87".chr(13).chr(10); $kml.="".chr(13).chr(10); $kml.="".chr(13).chr(10); $kml.="".$rowKML['maxy']."".chr(13).chr(10); $kml.="".$rowKML['miny']."".chr(13).chr(10); $kml.="".$rowKML['maxx']."".chr(13).chr(10); $kml.="".$rowKML['minx']."".chr(13).chr(10); $kml.="".chr(13).chr(10); $kml.="".chr(13).chr(10); $kml.="".chr(13).chr(10); header("Content-Type: application/vnd.google-earth.kml+xml"); header("Content-Disposition: attachment; filename=\"Mapbender_layer_".$layerId.".kml\""); echo $kml; ?>