[Mapbender-commits] r2083 - branches/2.5/http/php

[svn_mapbender at osgeo.org]

Author: verenadiewald
Date: 2008-02-13 05:42:46 -0500 (Wed, 13 Feb 2008)
New Revision: 2083

Modified:
   branches/2.5/http/php/mod_editGuiWms.php
Log:
cleared prepared statement in line 425 ($2 and $3 were not set correctly)

Modified: branches/2.5/http/php/mod_editGuiWms.php
===================================================================
--- branches/2.5/http/php/mod_editGuiWms.php	2008-02-13 08:21:37 UTC (rev 2082)
+++ branches/2.5/http/php/mod_editGuiWms.php	2008-02-13 10:42:46 UTC (rev 2083)
@@ -422,9 +422,9 @@
    $cnt_wf++;
  }
 #gui_layer
-$sql_gl = "SELECT l.*, gl.*, sld.sld_user_layer_id, sld.use_sld FROM layer AS l, gui_layer AS gl left outer join sld_user_layer AS sld on sld.fkey_layer_id = gl.fkey_layer_id WHERE l.layer_id = gl.fkey_layer_id AND gl.gui_layer_wms_id = $1 AND gl.fkey_gui_id = $2 AND (sld.fkey_gui_id = $2 or sld.fkey_gui_id is NULL) AND (sld.fkey_mb_user_id = $3 or sld.fkey_mb_user_id is NULL) ORDER BY l.layer_pos";
-$v = array($wmsList,$guiList,$mb_user_id);
-$t = array('i','s','i');
+$sql_gl = "SELECT l.*, gl.*, sld.sld_user_layer_id, sld.use_sld FROM layer AS l, gui_layer AS gl left outer join sld_user_layer AS sld on sld.fkey_layer_id = gl.fkey_layer_id WHERE l.layer_id = gl.fkey_layer_id AND gl.gui_layer_wms_id = $1 AND gl.fkey_gui_id = $2 AND (sld.fkey_gui_id = $3 or sld.fkey_gui_id is NULL) AND (sld.fkey_mb_user_id = $4 or sld.fkey_mb_user_id is NULL) ORDER BY l.layer_pos";
+$v = array($wmsList,$guiList,$guiList,$mb_user_id);
+$t = array('i','s','s','i');
 
 $res_gl = db_prep_query($sql_gl,$v,$t);
 $gui_layer_status = array();