[Mapbender-commits] r8748 - trunk/mapbender/http/classes

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2013-12-08 12:45:48 -0800 (Sun, 08 Dec 2013)
New Revision: 8748

Modified:
   trunk/mapbender/http/classes/class_wmc.php
Log:
little bit faster select

Modified: trunk/mapbender/http/classes/class_wmc.php
===================================================================
--- trunk/mapbender/http/classes/class_wmc.php	2013-12-08 20:36:27 UTC (rev 8747)
+++ trunk/mapbender/http/classes/class_wmc.php	2013-12-08 20:45:48 UTC (rev 8748)
@@ -538,7 +538,7 @@
 		$v = array();
 		$t = array();
 		$layerIds = array();
-		$sql = "SELECT layer_id, layer_name, fkey_wms_id, wms_timestamp, wms_getmap, wms_getlegendurl, wms_owsproxy FROM layer, wms WHERE layer_id in ( ";
+		$sql = "SELECT layer_id, layer_name, fkey_wms_id, wms_timestamp, wms_getmap, wms_getlegendurl, wms_owsproxy FROM layer, wms WHERE layer.fkey_wms_id = wms.wms_id and layer_id in (";
 		$i = 0;
 		foreach($layerIdList as $layerIdObject) {
 			//use only integer layer ids
@@ -551,7 +551,7 @@
 			$i++;
 		}
 		$i = 0;
-		$sql .= ") and layer.fkey_wms_id = wms.wms_id";
+		$sql .= ")";
 		$res = db_prep_query($sql,$v,$t);
 		$e = new mb_notice("class_wmc: sql to pull current wms and layer information from database: ".$sql);
 		//for each found layer