From e9ca854c0288782aa47c9ae4b3bc70b7e367bf9e Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sun, 22 Dec 2019 13:05:34 +0000 Subject: [PATCH] Bug 24206: Update URLs for default options in OPACSearchForTitleIn - Worldcat: now https - BookFinder: now https - OpenLibrary: remove / before search parameters To test: - Verify changes to the installer files are correct - Bonus: run the web installer for en, de-DE and nb-NO and verfiy the content of OPACSearchForTitleIn is correct Signed-off-by: David Nind Signed-off-by: Jonathan Druart Signed-off-by: Martin Renvoize Signed-off-by: Joy Nelson (cherry picked from commit 60e9ae92eea75ded04af54bf36ecd8259365fc51) Signed-off-by: Lucas Gass --- installer/data/mysql/de-DE/mandatory/system_preferences.sql | 4 ++-- .../data/mysql/nb-NO/1-Obligatorisk/system_preferences.sql | 2 +- installer/data/mysql/sysprefs.sql | 2 +- 3 files changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/de-DE/mandatory/system_preferences.sql b/installer/data/mysql/de-DE/mandatory/system_preferences.sql index fce4047a98..8692c95a7e 100644 --- a/installer/data/mysql/de-DE/mandatory/system_preferences.sql +++ b/installer/data/mysql/de-DE/mandatory/system_preferences.sql @@ -27,9 +27,9 @@ UPDATE systempreferences SET value = 'Willkommen im Koha-Katalog!' WHERE variabl UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav'; UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom'; UPDATE systempreferences SET value = - '
  • Andere Bibliotheken (WorldCat)
    • + '
  • Andere Bibliotheken (WorldCat)
  • Google Scholar
    • -
  • Online-Buchhandel (Bookfinder.com)
    • ' +
  • Online-Buchhandel (Bookfinder.com)
    • ' WHERE variable = 'OPACSearchForTitleIn'; -- Sunday = 0, Monday = 1, etc. UPDATE systempreferences SET value = '1' WHERE variable = 'CalendarFirstDayOfWeek'; diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/system_preferences.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/system_preferences.sql index 7ccdd7e12b..9fc9143a99 100644 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/system_preferences.sql +++ b/installer/data/mysql/nb-NO/1-Obligatorisk/system_preferences.sql @@ -25,7 +25,7 @@ UPDATE systempreferences SET value = 'nb-NO' WHERE variable = 'language'; UPDATE systempreferences SET value = 'nb-NO' WHERE variable = 'opaclanguages'; UPDATE systempreferences SET value = '

    Velkommen til Koha...

    ' WHERE variable = 'OpacMainUserBlock'; UPDATE systempreferences SET value = '

    Viktige lenker kan plasseres her

    ' WHERE variable = 'OpacNav'; -UPDATE systempreferences SET value = '
  • Andre bibliotek (WorldCat)
  • Andre databaser (Google Scholar)
  • Nettbutikker (Bookfinder.com)
    • ' WHERE variable = 'OPACSearchForTitleIn'; +UPDATE systempreferences SET value = '
  • Andre bibliotek (WorldCat)
  • Andre databaser (Google Scholar)
  • Nettbutikker (Bookfinder.com)
    • ' WHERE variable = 'OPACSearchForTitleIn'; -- Sunday = 0, Monday = 1, etc. UPDATE systempreferences SET value = '1' WHERE variable = 'CalendarFirstDayOfWeek'; UPDATE systempreferences SET value = 'A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Æ Ø Å' WHERE variable = 'alphabet'; diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index d32fdbe455..b41c8e2f75 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -411,7 +411,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('OpacResetPassword','0','','Shows the ''Forgot your password?'' link in the OPAC','YesNo'), ('OPACResultsLibrary', 'homebranch', 'homebranch|holdingbranch', 'Defines whether the OPAC displays the holding or home branch in search results when using XSLT', 'Choice'), ('OPACResultsSidebar','','70|10','Define HTML to be included on the search results page, underneath the facets sidebar','Textarea'), -('OPACSearchForTitleIn','
  • Other Libraries (WorldCat)
    • \n
  • Other Databases (Google Scholar)
    • \n
  • Online Stores (Bookfinder.com)
    • \n
  • Open Library (openlibrary.org)
    • ','70|10','Enter the HTML that will appear in the \'Search for this title in\' box on the detail page in the OPAC. Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable \'More Searches\' menu.','Textarea'), +('OPACSearchForTitleIn','
  • Other Libraries (WorldCat)
    • \n
  • Other Databases (Google Scholar)
    • \n
  • Online Stores (Bookfinder.com)
    • \n
  • Open Library (openlibrary.org)
    • ','70|10','Enter the HTML that will appear in the \'Search for this title in\' box on the detail page in the OPAC. Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable \'More Searches\' menu.','Textarea'), ('OpacSeparateHoldings','0',NULL,'Separate current branch holdings from other holdings (OPAC)','YesNo'), ('OpacSeparateHoldingsBranch','homebranch','homebranch|holdingbranch','Branch used to separate holdings (OPAC)','Choice'), ('opacSerialDefaultTab','subscriptions','holdings|serialcollection|subscriptions','Define the default tab for serials in OPAC.','Choice'), -- 2.39.5