svn commit: r942 - trunk/mapbender/http/classes/class_wms.php

[christoph at osgeo.org]

Author: christoph
Date: 2006-11-23 12:47:51+0000
New Revision: 942

Modified:
   trunk/mapbender/http/classes/class_wms.php

Log:
* added missing line $res = db_prep_query($sql, $v, $t);
* changed 's' to 'i' for fkey_layer_id

Modified: trunk/mapbender/http/classes/class_wms.php
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/classes/class_wms.php?view=diff&rev=942&p1=trunk/mapbender/http/classes/class_wms.php&p2=trunk/mapbender/http/classes/class_wms.php&r1=941&r2=942
==============================================================================
--- trunk/mapbender/http/classes/class_wms.php	(original)
+++ trunk/mapbender/http/classes/class_wms.php	2006-11-23 12:47:51+0000
@@ -918,7 +918,8 @@
 function insertLayerEPSG($i){
 	$sql = "DELETE FROM layer_epsg WHERE fkey_layer_id = $1";
 	$v = array($this->objLayer[$i]->db_id);
-	$t = array('s');
+	$t = array('i');
+	$res = db_prep_query($sql,$v,$t);
 	for($j=0; $j<count($this->objLayer[$i]->layer_epsg);$j++){
 		$sql = "INSERT INTO layer_epsg (fkey_layer_id, epsg, minx, miny, maxx, maxy) ";
 		$sql .= "VALUES($1,$2,$3,$4,$5,$6)";
@@ -936,7 +937,7 @@
 function insertLayerStyle($i){
 	$sql = "DELETE FROM layer_style WHERE fkey_layer_id = $1";
 	$v = array($this->objLayer[$i]->db_id);
-	$t = array('s');
+	$t = array('i');
 	$res = db_prep_query($sql,$v,$t);
 	for($j=0; $j<count($this->objLayer[$i]->layer_style);$j++){
 		$sql = "INSERT INTO layer_style (fkey_layer_id, name, title, legendurl, legendurlformat) ";
@@ -955,7 +956,7 @@
 function insertLayerKeyword($i){
 	$sql = "DELETE FROM layer_keyword WHERE fkey_layer_id = $1";
 	$v = array($this->objLayer[$i]->db_id);
-	$t = array('s');
+	$t = array('i');
 	$res = db_prep_query($sql,$v,$t);
 		
 	$k = $this->objLayer[$i]->layer_keyword;