'.$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;
?>