<?php
define('BUFFER', 10);
$included = strtolower(realpath(__FILE__)) != strtolower(realpath($_SERVER['SCRIPT_FILENAME']));
include dirname(__FILE__) . "/functions.php";
function point_check($point, $displace)
{
$config = (include dirname(__FILE__) . "/../config/config.php");
// Inside allowed area?
if (!validate_meldung_im_erlaubten_bereich($config, $point)) {
return '1002#1002#' . $config['labels']['errors']['ausserhalb_des_bereichs'];
}
return false;
}
if (!$included) {
$ptc = point_check("POINT(" . $_REQUEST["point"] . ")", false);
if ($ptc) {
die($ptc);
}
}
require_once '../../../conf/mapbender.conf';
define('BUFFER', 10);
$included = strtolower(realpath(__FILE__)) != strtolower(realpath($_SERVER['SCRIPT_FILENAME']));
function point_check(&$wkt, $displace)
{
$connection_string = sprintf("host=%s dbname=%s user=%s password=%s", KS_DBSERVER, KS_DB, KS_OWNER, KS_PW);
$connection = pg_connect($connection_string);
// Inside allowed area?
if (!inside_allowed_area_check($wkt)) {
return '1002#1002#Die neue Meldung befindet sich außerhalb Rostocks.';
}
pg_close($connection);
return false;
}
function inside_allowed_area_check($wkt)
{
pg_prepare("", "SELECT ST_Within(ST_GeometryFromText(\$1, 25833), klarschiff.klarschiff_stadtgrenze_hro.the_geom) FROM klarschiff.klarschiff_stadtgrenze_hro");
$result = pg_execute("", array($wkt));
if ($row = pg_fetch_assoc($result)) {
return $row['st_within'] === 't';
}
return false;
}
if (!$included) {
$wkt = $_REQUEST['point'];
$ptc = point_check($wkt, false);
if ($ptc) {
die($ptc);
}
}