svn commit: r312 - trunk/mapbender/http/php/mod_monitorCapabilities.php

[uli at osgeo.org]

Author: uli
Date: 2006-05-16 12:12:26+0000
New Revision: 312

Modified:
   trunk/mapbender/http/php/mod_monitorCapabilities.php

Log:
db_prep_query included

Modified: trunk/mapbender/http/php/mod_monitorCapabilities.php
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/php/mod_monitorCapabilities.php?view=diff&rev=312&p1=trunk/mapbender/http/php/mod_monitorCapabilities.php&p2=trunk/mapbender/http/php/mod_monitorCapabilities.php&r1=311&r2=312
==============================================================================
--- trunk/mapbender/http/php/mod_monitorCapabilities.php	(original)
+++ trunk/mapbender/http/php/mod_monitorCapabilities.php	2006-05-16 12:12:26+0000
@@ -86,8 +86,11 @@
 	$wmsId = $wms_id_own[$k];
 	echo "<tr><td><b>Processing WMS</b> (ID = " . $wmsId . ")<br>";
 	// get the wms version, capabilities, capabilities_doc
-	$sql = "SELECT wms_title, wms_version, wms_getcapabilities, wms_getcapabilities_doc FROM wms WHERE wms_id = '" . $wmsId . "'";
-	$res = db_query($sql);
+	$sql = "SELECT wms_title, wms_version, wms_getcapabilities, wms_getcapabilities_doc ";
+	$sql .= "FROM wms WHERE wms_id = $1";
+	$v = array($wmsId);
+	$t = array('i');
+	$res = db_prep_query($sql,$v,$t);
 	$someArray = db_fetch_row($res);
 	$wms_title = $someArray[0];
 	$version = $someArray[1];