From f5ccf6beec40c089fcdd1e9395274e389b2ebcaa Mon Sep 17 00:00:00 2001 From: yashodha Date: Thu, 30 Jul 2015 13:45:02 +0530 Subject: [PATCH] CRM-16907: Improvements to in-app Help menu content ---------------------------------------- * CRM-16907: Improvements to in-app Help menu content https://issues.civicrm.org/jira/browse/CRM-16907 --- CRM/Upgrade/Incremental/sql/4.6.6.mysql.tpl | 33 +++++++++++++++++++++ xml/templates/civicrm_navigation.tpl | 17 ++++++----- 2 files changed, 43 insertions(+), 7 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.6.6.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.6.mysql.tpl index 3da4eb64e2..2e0516f0a1 100644 --- a/CRM/Upgrade/Incremental/sql/4.6.6.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.6.mysql.tpl @@ -1,3 +1,4 @@ + {* file to handle db changes in 4.6.6 during upgrade *} -- CRM-16846 - This upgrade may have been previously skipped so moving it to 4.6.6 @@ -9,3 +10,35 @@ UPDATE `civicrm_navigation` SET `permission` = 'edit message templates' WHERE `parent_id` = @messages_menu_id AND name = 'Message Templates'; + +-- CRM-16907 +SELECT @adminHelplastID := id FROM civicrm_navigation WHERE name = 'Help'; +UPDATE civicrm_navigation +SET name = 'Support', label = 'Support' +WHERE id = @adminHelplastID; + +DELETE FROM civicrm_navigation where parent_id = @adminHelplastID; + +INSERT INTO civicrm_navigation + ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) + VALUES + ( {$domainID}, 'http://civicrm.org/get-started?src=iam', '{ts escape="sql" skip="true"}Get started{/ts}', 'Get started', NULL, 'AND', @adminHelplastID, '1', NULL, 1 ), + ( {$domainID}, 'http://civicrm.org/documentation?src=iam', '{ts escape="sql" skip="true"}Documentation{/ts}', 'Documentation', NULL, 'AND', @adminHelplastID, '1', NULL, 2 ), + ( {$domainID}, 'http://civicrm.org/ask-a-question?src=iam', '{ts escape="sql" skip="true"}Ask a question{/ts}', 'Ask a question', NULL, 'AND', @adminHelplastID, '1', NULL, 3 ), + ( {$domainID}, 'http://civicrm.org/experts?src=iam', '{ts escape="sql" skip="true"}Get expert help{/ts}', 'Get expert help', NULL, 'AND', @adminHelplastID, '1', NULL, 4 ), + ( {$domainID}, 'http://civicrm.org/about?src=iam', '{ts escape="sql" skip="true"}About CiviCRM{/ts}', 'About CiviCRM', NULL, 'AND', @adminHelplastID, '1', 1, 5 ), + ( {$domainID}, 'http://civicrm.org/register-your-site?src=iam', '{ts escape="sql" skip="true"}Register your site{/ts}', 'Register your site', NULL, 'AND', @adminHelplastID, '1', NULL, 6 ), + ( {$domainID}, 'http://civicrm.org/become-member?src=iam', '{ts escape="sql" skip="true"}Join CiviCRM{/ts}', 'Join CiviCRM', NULL, 'AND', @adminHelplastID, '1', NULL, 7 ); + +INSERT INTO civicrm_navigation + ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) + VALUES + ( {$domainID}, NULL, '{ts escape="sql" skip="true"}Developer{/ts}', 'Developer', 'administer CiviCRM', '', @adminHelplastID, '1', 1, 8 ); + +SET @devellastID:=LAST_INSERT_ID(); +INSERT INTO civicrm_navigation + ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) + VALUES + ( {$domainID}, 'civicrm/api', '{ts escape="sql" skip="true"}API Explorer{/ts}','API Explorer', 'administer CiviCRM', '', @devellastID, '1', NULL, 1 ), + ( {$domainID}, 'http://civicrm.org/developer-documentation?src=iam', '{ts escape="sql" skip="true"}Developer Docs{/ts}', 'Developer Docs', 'administer CiviCRM', '', @devellastID, '1', NULL, 3 ); + \ No newline at end of file diff --git a/xml/templates/civicrm_navigation.tpl b/xml/templates/civicrm_navigation.tpl index 857f694af4..09a4841c36 100644 --- a/xml/templates/civicrm_navigation.tpl +++ b/xml/templates/civicrm_navigation.tpl @@ -605,28 +605,31 @@ VALUES INSERT INTO civicrm_navigation ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) VALUES - ( @domainID, NULL, '{ts escape="sql" skip="true"}Help{/ts}', 'Help', NULL, '', NULL, '1', NULL, 110); + ( @domainID, NULL, '{ts escape="sql" skip="true"}Support{/ts}', 'Support', NULL, '', NULL, '1', NULL, 110); SET @adminHelplastID:=LAST_INSERT_ID(); INSERT INTO civicrm_navigation ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) VALUES - ( @domainID, 'http://documentation.civicrm.org', '{ts escape="sql" skip="true"}Documentation{/ts}', 'Documentation', NULL, 'AND', @adminHelplastID, '1', NULL, 1 ), - ( @domainID, 'http://forum.civicrm.org', '{ts escape="sql" skip="true"}Community Forums{/ts}', 'Community Forums', NULL, 'AND', @adminHelplastID, '1', NULL, 2 ), - ( @domainID, 'http://civicrm.org/participate', '{ts escape="sql" skip="true"}Participate{/ts}', 'Participate', NULL, 'AND', @adminHelplastID, '1', NULL, 3 ), - ( @domainID, 'http://civicrm.org/what/whatiscivicrm', '{ts escape="sql" skip="true"}About{/ts}', 'About', NULL, 'AND', @adminHelplastID, '1', NULL, 4 ); + ( @domainID, 'http://civicrm.org/get-started?src=iam', '{ts escape="sql" skip="true"}Get started{/ts}', 'Get started', NULL, 'AND', @adminHelplastID, '1', NULL, 1 ), + ( @domainID, 'http://civicrm.org/documentation?src=iam', '{ts escape="sql" skip="true"}Documentation{/ts}', 'Documentation', NULL, 'AND', @adminHelplastID, '1', NULL, 2 ), + ( @domainID, 'http://civicrm.org/ask-a-question?src=iam', '{ts escape="sql" skip="true"}Ask a question{/ts}', 'Ask a question', NULL, 'AND', @adminHelplastID, '1', NULL, 3 ), + ( @domainID, 'http://civicrm.org/experts?src=iam', '{ts escape="sql" skip="true"}Get expert help{/ts}', 'Get expert help', NULL, 'AND', @adminHelplastID, '1', NULL, 4 ), + ( @domainID, 'http://civicrm.org/about?src=iam', '{ts escape="sql" skip="true"}About CiviCRM{/ts}', 'About CiviCRM', NULL, 'AND', @adminHelplastID, '1', 1, 5 ), + ( @domainID, 'http://civicrm.org/register-your-site?src=iam', '{ts escape="sql" skip="true"}Register your site{/ts}', 'Register your site', NULL, 'AND', @adminHelplastID, '1', NULL, 6 ), + ( @domainID, 'http://civicrm.org/become-member?src=iam', '{ts escape="sql" skip="true"}Join CiviCRM{/ts}', 'Join CiviCRM', NULL, 'AND', @adminHelplastID, '1', NULL, 7 ); INSERT INTO civicrm_navigation ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) VALUES - ( @domainID, NULL, '{ts escape="sql" skip="true"}Developer{/ts}', 'Developer', 'administer CiviCRM', '', @adminHelplastID, '1', NULL, 5 ); + ( @domainID, NULL, '{ts escape="sql" skip="true"}Developer{/ts}', 'Developer', 'administer CiviCRM', '', @adminHelplastID, '1', 1, 8 ); SET @devellastID:=LAST_INSERT_ID(); INSERT INTO civicrm_navigation ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) VALUES ( @domainID, 'civicrm/api', '{ts escape="sql" skip="true"}API Explorer{/ts}','API Explorer', 'administer CiviCRM', '', @devellastID, '1', NULL, 1 ), -( @domainID, 'http://wiki.civicrm.org/confluence/display/CRMDOC/Develop', '{ts escape="sql" skip="true"}Developer Docs{/ts}', 'Developer Docs', 'administer CiviCRM', '', @devellastID, '1', NULL, 3 ); +( @domainID, 'http://civicrm.org/developer-documentation?src=iam', '{ts escape="sql" skip="true"}Developer Docs{/ts}', 'Developer Docs', 'administer CiviCRM', '', @devellastID, '1', NULL, 3 ); INSERT INTO civicrm_navigation ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) -- 2.25.1