[Mapbender-commits] r7997 - branches/2.7/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-07-26 01:52:31 -0700 (Tue, 26 Jul 2011)
New Revision: 7997

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
Log:
added exportGUI to Administration and Administration_DE

Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-07-25 14:32:06 UTC (rev 7996)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-07-26 08:52:31 UTC (rev 7997)
@@ -146,14 +146,14 @@
 -- add CustomizeTree to Administration and Administration_de
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Administration_DE','CustomizeTree_icon',2,1,'icon','','img','../img/gnome/preferences-desktop-personal.png','',0,0,NULL ,NULL,2,'','','','','','','','');
 
-INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Administration_DE','CustomizeTree_collection',2,1,'Put existing divs in new div object. List the elements comma-separated under target, and make sure they have a title.','','div','','',200,0,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','CustomizeTree,CustomizeTree_icon','','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Administration_DE','CustomizeTree_collection',2,1,'Put existing divs in new div object. List the elements comma-separated under target, and make sure they have a title.','','div','','',250,0,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','CustomizeTree,CustomizeTree_icon','','');
 
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Administration_DE','CustomizeTree',2,1,'Customize Tree','Baumstruktur konfigurieren','a','','href = "../php/mod_customTree.php?elementID=Customize Tree&sessionID"
 ',80,15,NULL ,NULL,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','Customize Tree','a','','','','','http://www.mapbender.org/CustomTree');
 
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Administration','CustomizeTree_icon',2,1,'icon','','img','../img/gnome/preferences-desktop-personal.png','',0,0,NULL ,NULL,2,'','','','','','','','');
 
-INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Administration','CustomizeTree_collection',2,1,'Put existing divs in new div object. List the elements comma-separated under target, and make sure they have a title.','','div','','',190,0,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','CustomizeTree,CustomizeTree_icon','','');
+INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Administration','CustomizeTree_collection',2,1,'Put existing divs in new div object. List the elements comma-separated under target, and make sure they have a title.','','div','','',250,0,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','CustomizeTree,CustomizeTree_icon','','');
 
 INSERT INTO gui_element (fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title, e_element,e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires,e_url) VALUES ('Administration','CustomizeTree',2,1,'Customize Tree','Baumstruktur konfigurieren','a','','href = "../php/mod_customTree.php?elementID=Customize Tree&sessionID"
 ',80,15,NULL ,NULL,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','Customize Tree','a','','','','','http://www.mapbender.org/CustomTree');
@@ -164,8 +164,8 @@
 where fkey_gui_id IN ('Administration','Administration_DE') AND e_id = 'menu_gui';
 
 -- provide more space for the collections
-Update gui_element set e_left = 200 where e_left = 150 and fkey_gui_id = 'Administration_DE' and e_element = 'div';
-Update gui_element set e_left = 200 where e_left = 150 and fkey_gui_id = 'Administration' and e_element = 'div';
+Update gui_element set e_left = 250 where e_left = 150 and fkey_gui_id = 'Administration_DE' and e_element = 'div';
+Update gui_element set e_left = 250 where e_left = 150 and fkey_gui_id = 'Administration' and e_element = 'div';
 
 --
 -- rename Customize Tree to CustomizeTree
@@ -311,3 +311,67 @@
 --386
 UPDATE translations set msgstr = 'Sélectionner la carte d`arrière-plan'
 where locale = 'fr' and msgid = 'Set Background';
+
+-- add exportGUI to Administration and Administration_de
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 
+e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, 
+e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, 
+e_requires, e_url) VALUES('Administration_DE','exportGUI_collection',2,1,'Put 
+existing divs in new div object. List the elements comma-separated under 
+target, and make sure they have a title.','','div','','',240,40,200,30,NULL 
+,'','','div','../plugins/mb_div_collection.js','','exportGUI,exportGUI_icon','','');
+
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 
+e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, 
+e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, 
+e_requires, e_url) 
+VALUES('Administration_DE','exportGUI_icon',2,1,'icon','','img','../img/gnome/exportGui2Sql.png','',0,0,NULL 
+,NULL ,2,'','','','','','','','');
+
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 
+e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, 
+e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, 
+e_requires, e_url) VALUES('Administration_DE','exportGUI',2,1,'Anwendung exportieren (SQL)','Anwendung exportieren (SQL)','a','','href = 
+"../php/mod_exportGUI.php?sessionID"',80,15,190,20,10,'font-family: Arial, 
+Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: 
+#808080;','Anwendung exportieren (SQL)','a','','','','','http://www.mapbender.org/exportGUI');
+
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, 
+context, var_type) VALUES('Administration_DE', 'exportGUI', 'cssfile', 
+'../css/administration_alloc.css', 'css file for admin module' ,'file/css');
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 
+e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, 
+e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, 
+e_requires, e_url) VALUES('Administration','exportGUI_collection',2,1,'Put 
+existing divs in new div object. List the elements comma-separated under 
+target, and make sure they have a title.','','div','','',240,40,200,30,NULL 
+,'','','div','../plugins/mb_div_collection.js','','exportGUI,exportGUI_icon','','');
+
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 
+e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, 
+e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, 
+e_requires, e_url) 
+VALUES('Administration','exportGUI_icon',2,1,'icon','','img','../img/gnome/exportGui2Sql.png','',0,0,NULL 
+,NULL ,2,'','','','','','','','');
+
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, 
+e_title, e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, 
+e_z_index, e_more_styles, e_content, e_closetag, e_js_file, e_mb_mod, e_target, 
+e_requires, e_url) VALUES('Administration','exportGUI',2,1,'Export application (SQL)','Export application (SQL)','a','','href = 
+"../php/mod_exportGUI.php?sessionID"',80,15,190,20,10,'font-family: Arial, 
+Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: 
+#808080;','Export application (SQL)','a','','','','','http://www.mapbender.org/exportGUI');
+
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, 
+context, var_type) VALUES('Administration', 'exportGUI', 'cssfile', 
+'../css/administration_alloc.css', 'css file for admin module' ,'file/css');
+
+-- update
+UPDATE gui_element set 
+e_target= 'newGui_collection,rename_copy_gui_collection,delete_filteredGui_collection,editElements_collection,category_filteredGui_collection,deleteCategory_collection,CustomizeTree_collection,exportGUI_collection'
+where fkey_gui_id IN ('Administration','Administration_DE') AND e_id = 'menu_gui';