[Mapbender-commits] r1801 - trunk/mapbender/http/php

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2007-11-14 05:42:50 -0500 (Wed, 14 Nov 2007)
New Revision: 1801

Modified:
   trunk/mapbender/http/php/mod_editGuiWms.php
Log:
removed bug in UPDATE statement for table_gui_layer (gui_layer_style is type string, not integer)

Modified: trunk/mapbender/http/php/mod_editGuiWms.php
===================================================================
--- trunk/mapbender/http/php/mod_editGuiWms.php	2007-11-13 16:16:16 UTC (rev 1800)
+++ trunk/mapbender/http/php/mod_editGuiWms.php	2007-11-14 10:42:50 UTC (rev 1801)
@@ -283,9 +283,14 @@
 			if($myKey[1]!="layer_parent" && $myKey[1]!='layer_id' ){
 				$sql = "UPDATE gui_layer SET ".$myKey[1]." = $1 WHERE fkey_gui_id = $2 AND fkey_layer_id = $3";
 				$v = array($val,$this_gui,preg_replace("/L_/","",$myKey[0]));
-				$t = array('i','s','i');
+				if($myKey[1]=='gui_layer_style'){
+					$t = array('s','s','i');
+				}
+				else{
+					$t = array('i','s','i');
+				}
 				if(!$res = db_prep_query($sql,$v,$t)){
-					echo "FEHLER in ZEILE 249";
+					echo "FEHLER in ZEILE 288";
 				}
 			}
 		}