svn commit: r418 - trunk/mapbender/http/php/mod_exportGUI.php

[astrid_emde at osgeo.org]

Author: astrid_emde
Date: 2006-06-12 11:41:51+0000
New Revision: 418

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

Log:
There were errors in the sqls.

,, will be replaced ,NULL,

Modified: trunk/mapbender/http/php/mod_exportGUI.php
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/php/mod_exportGUI.php?view=diff&rev=418&p1=trunk/mapbender/http/php/mod_exportGUI.php&p2=trunk/mapbender/http/php/mod_exportGUI.php&r1=417&r2=418
==============================================================================
--- trunk/mapbender/http/php/mod_exportGUI.php	(original)
+++ trunk/mapbender/http/php/mod_exportGUI.php	2006-06-12 11:41:51+0000
@@ -77,7 +77,7 @@
 	$i = 0;
 	while ($row = db_fetch_row($res_gui)){
 		$insert =  "INSERT INTO gui (gui_id, gui_name, gui_description, gui_public) VALUES ";
-		$insert.= "('".db_result($res_gui, 0, 0)."','".db_result($res_gui, 0, 1)."','".db_result($res_gui, 0, 2)."',".db_result($res_gui, 0, 3).")";
+		$insert.= "('".db_result($res_gui, 0, 0)."','".db_result($res_gui, 0, 1)."','".db_result($res_gui, 0, 2)."',".db_result($res_gui, 0, 3).");\n";
 	}
 
 	//gui_element
@@ -112,8 +112,9 @@
 		$insert.="'".$row["e_mb_mod"]."',";
 		$insert.="'".$row["e_target"]."',";
 		$insert.="'".$row["e_requires"]."',";
-		$insert.="'".$row["e_url"]."',";
-		$insert.= ")";
+		$insert.="'".$row["e_url"]."'";
+		$insert.= ");\n";
+		$insert = str_replace(",,", ",NULL ,", $insert);
 	}