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

[svn_mapbender at osgeo.org]

Author: astrid_emde
Date: 2011-07-14 06:45:17 -0700 (Thu, 14 Jul 2011)
New Revision: 7940

Modified:
   branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
Log:
scaleSelect refers to script in plugins folder and e_attributes cleard and link to url in wiki

merged with trunk

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-14 13:42:24 UTC (rev 7939)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql	2011-07-14 13:45:17 UTC (rev 7940)
@@ -22,6 +22,25 @@
 -- replace too many ' in definition
 UPDATE gui_element set e_attributes = replace(e_attributes,'''"','"') where e_id IN ('updateWMSs','owsproxy','editGUI_WMS');
 
+--add possibility to edit cyclic update in inspire metadata addon editor (admin_wms_metadata):
+-- Column: update_frequency
+
+-- ALTER TABLE mb_metadata DROP COLUMN update_frequency;
+
+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=allowPublishMetadata" ',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 NULL for Gui admin2_de, otherwise this gui is not displayed correctly in IE8
 UPDATE gui_element set e_width = NULL, e_height = NULL
 where fkey_gui_id = 'admin2_de' and e_id ='body' ;
@@ -63,6 +82,9 @@
 	SELECT fkey_gui_id FROM gui_element WHERE e_id = 'jq_ui_dialog'
  ));
 
+-- Bugfix for ie9 startup problem. problem with dialogs remain - they cannot be dragged
+UPDATE gui_element SET e_mb_mod = '../../lib/printbox.js,../extensions/jquery-ui-1.7.2.custom/development-bundle/external/bgiframe/jquery.bgiframe.js,../extensions/jquery.form.min.js,../extensions/wz_jsgraphics.js' 
+WHERE e_id = 'printPDF' AND e_js_file = '../plugins/mb_print.php';
 
 -- new element var unlink for gui element template printPDF
 INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type)
@@ -98,12 +120,6 @@
 --
 ALTER TABLE mb_metadata ADD COLUMN responsible_party_name character varying(100);
 
--- ALTER TABLE mb_metadata DROP COLUMN update_frequency;
--- mb_metadata
--- new column update_frequency
-
-ALTER TABLE mb_metadata ADD COLUMN update_frequency character varying(100);
-
 UPDATE gui_element SET 
 e_attributes = '' ,
 e_url = 'http://www.mapbender.org/ScaleSelect',