[Mapbender-commits] r7861 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2011-06-14 04:31:18 -0700 (Tue, 14 Jun 2011)
New Revision: 7861

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
Log:
new possibility to allow metadata publishing to other user

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-06-10 16:37:28 UTC (rev 7860)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-06-14 11:31:18 UTC (rev 7861)
@@ -29,9 +29,26 @@
 
 ALTER TABLE mb_metadata ADD COLUMN update_frequency character varying(100);
 
+
+
+-- new option for metadata publishing in Administration_DE GUI
+
+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','allowPublishMetadata_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','','',0,115,200,30,NULL ,'','','div','../plugins/mb_div_collection.js','','allowPublishMetadata,allowPublishMetadata_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','allowPublishMetadata',2,1,'Einrichtungen erlauben im Auftrag <br>Metadaten zu veröffentlichen','Einrichtungen erlauben im Auftrag <br>Metadaten zu veröffentlichen','a','','href = "../geoportal/mod_allow_publishing_metadata.php?sessionID&e_id_css=allow_publishing_metadata" ',80,15,200,20,NULL ,'font-family: Arial, Helvetica, sans-serif; font-size : 12px; text-decoration : none; color: #808080;','Einrichtungen erlauben im Auftrag <br>Metadaten zu veröffentlichen','a','','','','AdminFrame','http://www.mapbender.org/index.php/user');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('Administration_DE','allowPublishMetadata','adminGroupId','25','','php_var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('Administration_DE','allowPublishMetadata','authorizeRoleId','3','','php_var');
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES ('Administration_DE','allowPublishMetadata','file css','../css/allow_publishing_metadata.css','file css','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_DE','allowPublishMetadata_icon',2,1,'icon','','img','../img/gnome/emblem-shared.png','',0,0,NULL ,NULL,2,'','','','','','','','');
+
+UPDATE gui_element SET e_target = 'filteredGui_user_collection,filteredGui_group_collection,filteredGui_filteredGroup_collection,gui_owner_collection,allowPublishMetadata_collection' WHERE fkey_gui_id = 'Administration_DE' AND e_id = 'menu_auth'; 
+
+
+
 -- set width and height of body element to 0 for Gui admin2_de, otherwise this gui is not displayed correctly in IE8
 UPDATE gui_element set e_width = 0, e_height = 0
 where fkey_gui_id = 'admin2_de' and e_id ='body' ;
 
 -- delete old entries from old treeConfiguration
 DELETE FROM gui_treegde WHERE my_layer_title ILIKE 'new' AND wms_id IS NULL;
+