svn commit: r293 - trunk/mapbender/http/php/mb_listGUIs.php

[uli at osgeo.org]

Author: uli
Date: 2006-05-16 05:49:45+0000
New Revision: 293

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

Log:
db_prep_query included


Modified: trunk/mapbender/http/php/mb_listGUIs.php
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/php/mb_listGUIs.php?view=diff&rev=293&p1=trunk/mapbender/http/php/mb_listGUIs.php&p2=trunk/mapbender/http/php/mb_listGUIs.php&r1=292&r2=293
==============================================================================
--- trunk/mapbender/http/php/mb_listGUIs.php	(original)
+++ trunk/mapbender/http/php/mb_listGUIs.php	2006-05-16 05:49:45+0000
@@ -24,13 +24,17 @@
 	echo "</td><td>";
 	
 	if (count($arrayGUIs)>0){
+		$v = array();
+		$t = array();
 		$sql_list_guis = "SELECT DISTINCT gui_id,gui_name,gui_description FROM gui WHERE gui_id IN (";
 		for($i=0; $i<count($arrayGUIs); $i++){
 			if($i>0){$sql_list_guis .= ",";}
-			$sql_list_guis .= "'". $arrayGUIs[$i]."'";
+			$sql_list_guis .= "$".($i+1);
+			array_push($v,$arrayGUIs[$i]);
+			array_push($t,'s');
 		}
 		$sql_list_guis .= ") ORDER BY gui_name";
-		$res_list_guis = db_query($sql_list_guis);
+		$res_list_guis = db_prep_query($sql_list_guis,$v,$t);
 		echo "<a href=\"../php/mod_editSelf.php?".SID."\" class='list_guis' target=_blank>Change personal settings</a>";
 		echo "</td><td align = 'right'>";
 		echo "<a href=\"../php/mod_logout.php?".SID."\"><img src =\"../img/button_gray/logout_off.png\" border='0' onmouseover='this.src=\"../img/button_gray/logout_over.png\"' onmouseout='this.src=\"../img/button_gray/logout_off.png\"' title=\"Logout\"></a>";