Attachment 6053 Details for Bug 7079 – Bug 7079: [SIGNED-OFF] Default values for German system preferences

[patch] Bug 7079: [SIGNED-OFF] Default values for German system preferences

Bug-7079-SIGNED-OFF-Default-values-for-German-syst.patch (text/plain), 2.98 KB, created by Magnus Enger on 2011-10-25 17:44:15 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Magnus Enger

Created: 2011-10-25 17:44:15 UTC

Size: 2.98 KB

patch

obsolete

>From 4aa7e733e41176a898165daf3b18c394bc17e366 Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <Katrin.Fischer.83@web.de>
>Date: Mon, 24 Oct 2011 14:57:52 +0200
>Subject: [PATCH] Bug 7079: [SIGNED-OFF] Default values for German system
> preferences
>
>Patch adds updates for system preferences to the sql file
>in the installer directory:
>
>- New: AmazonLocale: DE
>- borrowerRelationship: Vater|Mutter
>- BorrowersTitles: Herr|Frau
>- New: CurrencyFormat: FR
>- New: dateformat: metric
>- New: DefaultClassificationSource: z
>- New: OpacMainUserBlock: translated content
>- New: OpacNav: translated content
>- New: OpacNavBottom: translated content
>- New: OPACSearchForTitleIn: translated content
>
>To test:
>A) Do a full installation with German sample files
>B) Run the sql file 'system_preferences.sql' against your database
>
>Verfy values of system preferences have been changed.
>
>Signed-off-by: Magnus Enger <magnus@enger.priv.no>
>Patch applied cleanly. I ran through the webinstaller in German on an empty
>database, and made sure system_preferences were loaded. No complaints from
>the database and the systprefs are set to the right values when I check in the
>staff client.
>---
> .../mysql/de-DE/mandatory/system_preferences.sql   |   12 ++++++++++++
> 1 files changed, 12 insertions(+), 0 deletions(-)
>
>diff --git a/installer/data/mysql/de-DE/mandatory/system_preferences.sql b/installer/data/mysql/de-DE/mandatory/system_preferences.sql
>index d0e08a9..0e304ed 100644
>--- a/installer/data/mysql/de-DE/mandatory/system_preferences.sql
>+++ b/installer/data/mysql/de-DE/mandatory/system_preferences.sql
>@@ -16,5 +16,17 @@
> -- with Koha; if not, write to the Free Software Foundation, Inc.,
> -- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
> 
>+UPDATE systempreferences SET value = 'DE' WHERE variable = 'AmazonLocale';
> UPDATE systempreferences SET value = 'Vater|Mutter' WHERE variable = 'borrowerRelationship';
> UPDATE systempreferences SET value = 'Herr|Frau' WHERE variable = 'BorrowersTitles';
>+UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat';
>+UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';
>+UPDATE systempreferences SET value = 'z' WHERE variable = 'DefaultClassificationSource';
>+UPDATE systempreferences SET value = 'Willkommen im Koha-Katalog! (OpacMainUserBlock)' WHERE variable = 'OpacMainUserBlock';
>+UPDATE systempreferences SET value = 'Wichtige Links hier...(OpacNav)' WHERE variable = 'OpacNav';
>+UPDATE systempreferences SET value = '...oder hier (OpacNavBottom)' WHERE variable = 'OpacNavBottom';
>+UPDATE systempreferences SET value = 
>+    '<li><a href="http://worldcat.org/search?q={TITLE}" target="_blank">Andere Bibliotheken (WorldCat)</a></li>
>+    <li><a href="http://www.scholar.google.com/scholar?q={TITLE}" target="_blank">Google Scholar</a></li>
>+    <li><a href="http://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr" target="_blank">Online-Buchhandel (Bookfinder.com)</a></li>' 
>+    WHERE variable = 'OPACSearchForTitleIn';
>-- 
>1.7.5.4

Actions: View | Diff | Splinter Review

Attachments on bug 7079: 6030 | 6053