[Mapbender-commits] r8361 - branches/2.7/http/php

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2012-05-16 07:43:30 -0700 (Wed, 16 May 2012)
New Revision: 8361

Modified:
   branches/2.7/http/php/mod_changeEPSG_server.php
Log:
use new function st_

Modified: branches/2.7/http/php/mod_changeEPSG_server.php
===================================================================
--- branches/2.7/http/php/mod_changeEPSG_server.php	2012-05-16 13:33:57 UTC (rev 8360)
+++ branches/2.7/http/php/mod_changeEPSG_server.php	2012-05-16 14:43:30 UTC (rev 8361)
@@ -53,19 +53,19 @@
 			
 			
 				$con = db_connect($DBSERVER,$OWNER,$PW);
-				$sqlMinx = "SELECT X(transform(GeometryFromText('POINT(".$extArray[0]." ".$extArray[1].")',".$oldEPSG."),".$newEPSG.")) as minx";
+				$sqlMinx = "SELECT ST_X(ST_transform(ST_GeometryFromText('POINT(".$extArray[0]." ".$extArray[1].")',".$oldEPSG."),".$newEPSG.")) as minx";
 				$resMinx = db_query($sqlMinx);
 				$minx = floatval(db_result($resMinx,0,"minx"));
 				
-				$sqlMiny = "SELECT Y(transform(GeometryFromText('POINT(".$extArray[0]." ".$extArray[1].")',".$oldEPSG."),".$newEPSG.")) as miny";
+				$sqlMiny = "SELECT ST_Y(ST_transform(ST_GeometryFromText('POINT(".$extArray[0]." ".$extArray[1].")',".$oldEPSG."),".$newEPSG.")) as miny";
 				$resMiny = db_query($sqlMiny);
 				$miny = floatval(db_result($resMiny,0,"miny"));
 				
-				$sqlMaxx = "SELECT X(transform(GeometryFromText('POINT(".$extArray[2]." ".$extArray[3].")',".$oldEPSG."),".$newEPSG.")) as maxx";
+				$sqlMaxx = "SELECT ST_X(ST_transform(ST_GeometryFromText('POINT(".$extArray[2]." ".$extArray[3].")',".$oldEPSG."),".$newEPSG.")) as maxx";
 				$resMaxx = db_query($sqlMaxx);
 				$maxx = floatval(db_result($resMaxx,0,"maxx"));
 				
-				$sqlMaxy = "SELECT Y(transform(GeometryFromText('POINT(".$extArray[2]." ".$extArray[3].")',".$oldEPSG."),".$newEPSG.")) as maxy";
+				$sqlMaxy = "SELECT ST_Y(ST_transform(ST_GeometryFromText('POINT(".$extArray[2]." ".$extArray[3].")',".$oldEPSG."),".$newEPSG.")) as maxy";
 				$resMaxy = db_query($sqlMaxy);
 				$maxy = floatval(db_result($resMaxy,0,"maxy"));