svn commit: r779 - trunk/mapbender/http/php/mod_loadCapabilitiesList.php

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-10-02 09:12:33+0000
New Revision: 779

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

Log:
error: wrong function was used and $ was missing
db_query was used instead of db_prep_query

Modified: trunk/mapbender/http/php/mod_loadCapabilitiesList.php
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/php/mod_loadCapabilitiesList.php?view=diff&rev=779&p1=trunk/mapbender/http/php/mod_loadCapabilitiesList.php&p2=trunk/mapbender/http/php/mod_loadCapabilitiesList.php&r1=778&r2=779
==============================================================================
--- trunk/mapbender/http/php/mod_loadCapabilitiesList.php	(original)
+++ trunk/mapbender/http/php/mod_loadCapabilitiesList.php	2006-10-02 09:12:33+0000
@@ -141,7 +141,7 @@
 	$sql = "SELECT * FROM gui_wms WHERE fkey_gui_id = $1 AND fkey_wms_id = $2";
 	$v = array($guiID,$wmsID);
 	$t = array('s','i');
-	$res = db_query($sql,$v,$t);
+	$res = db_prep_query($sql,$v,$t);
 	$cnt = 0;
 	while($row = db_fetch_array($res)){
 		$sql_ins = "INSERT INTO gui_wms (fkey_gui_id,fkey_wms_id,gui_wms_position,gui_wms_mapformat,";
@@ -160,7 +160,7 @@
 	while($row = db_fetch_array($res)){
 		$sql_ins = "INSERT INTO gui_layer (fkey_gui_id,fkey_layer_id,gui_layer_wms_id,gui_layer_status,gui_layer_selectable,";
 		$sql_ins .= "gui_layer_visible,gui_layer_queryable,gui_layer_querylayer,gui_layer_minscale,gui_layer_maxscale,gui_layer_priority) ";
-		$sql_ins .= "VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,10,$11)";
+		$sql_ins .= "VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)";
 		$v = array($guiList,$row["fkey_layer_id"],$wmsID,$row["gui_layer_status"],$row["gui_layer_selectable"],
 		$row["gui_layer_visible"],$row["gui_layer_queryable"],$row["gui_layer_querylayer"],$row["gui_layer_minscale"],
 		$row["gui_layer_maxscale"],$row["gui_layer_priority"]);