[Koha-patches] [PATCH] Fixed minor typos in new system preferences.

[Nicole Engard]

>From 84edc02cdc559fe766a093fc08bf328870d04af5 Mon Sep 17 00:00:00 2001
From: Nicole Engard <nengard at gmail.com>
Date: Sun, 23 Aug 2009 12:18:34 -0400
Subject: [PATCH] Fixed minor typos in new system preferences.
Content-Type: text/plain; charset="utf-8"

---
 installer/data/mysql/en/mandatory/sysprefs.sql |    4 ++--
 installer/data/mysql/updatedatabase.pl         |    8 ++++++++
 2 files changed, 10 insertions(+), 2 deletions(-)

diff --git a/installer/data/mysql/en/mandatory/sysprefs.sql
b/installer/data/mysql/en/mandatory/sysprefs.sql
index ec042d4..0adefbc 100644
--- a/installer/data/mysql/en/mandatory/sysprefs.sql
+++ b/installer/data/mysql/en/mandatory/sysprefs.sql
@@ -250,10 +250,10 @@ INSERT INTO systempreferences
(variable,value,explanation,options,type)VALUES('F
 INSERT INTO systempreferences
(variable,value,options,explanation,type)VALUES('SpineLabelFormat',
'<itemcallnumber><copynumber>', '30|10', 'This preference defines the
format for the quick spine label printer. Just list the fields you
would like to see in the order you would like to see them, surrounded
by <>, for example <itemcallnumber>.', 'Textarea');
 INSERT INTO systempreferences
(variable,value,options,explanation,type)VALUES('SpineLabelAutoPrint',
'0', '', 'If this setting is turned on, a print dialog will
automatically pop up for the quick spine label printer.', 'YesNo');
 INSERT INTO `systempreferences`
(variable,value,explanation,options,type)
VALUES('AWSPrivateKey','','See:  http://aws.amazon.com.  Note that
this is required after 2009/08/15 in order to retrieve any enhanced
content other than book covers from Amazon.','','free');
-INSERT INTO `systempreferences`
(variable,value,explanation,options,type)
VALUES('OPACFineNoRenewals','100','Fine Limit above which user canmot
renew books via OPAC','','Integer');
+INSERT INTO `systempreferences`
(variable,value,explanation,options,type)
VALUES('OPACFineNoRenewals','100','Fine limit above which user cannot
renew books via OPAC','','Integer');
 INSERT INTO `systempreferences` ( `variable` , `value` , `options` ,
`explanation` , `type` ) VALUES ( 'NewItemsDefaultLocation', '', '',
'If set, all new items will have a location of the given Location Code
( Authorized Value type LOC )', '');
 INSERT INTO `systempreferences` ( `variable` , `value` , `options` ,
`explanation` , `type` ) VALUES ( 'InProcessingToShelvingCart', '0',
'', 'If set, when any item with a location code of PROC is ''checked
in'', it''s location code will be changed to CART.', 'YesNo');
 INSERT INTO `systempreferences` ( `variable` , `value` , `options` ,
`explanation` , `type` ) VALUES ( 'ReturnToShelvingCart', '0', '', 'If
set, when any item is ''checked in'', it''s location code will be
changed to CART.', 'YesNo');
-INSERT INTO `systempreferences` ( `variable` , `value` , `options` ,
`explanation` , `type` ) VALUES ( 'DisplayClearScreenButton', '0', '',
'If set to yes, a clear screen button will appear on the circulation
page.', 'YesNo');
+INSERT INTO `systempreferences` ( `variable` , `value` , `options` ,
`explanation` , `type` ) VALUES ( 'DisplayClearScreenButton', '0', '',
'If set to ON, a clear screen button will appear on the circulation
page.', 'YesNo');
 INSERT INTO systempreferences
(variable,value,options,explanation,type)VALUES('HidePatronName', '0',
'', 'If this is switched on, patron''s cardnumber will be shown
instead of their name on the holds and catalog screens', 'YesNo');
 INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
('OPACSearchForTitleIn','<li class="yuimenuitem"><a target="_blank"
class="yuimenuitemlabel"
href="http://worldcat.org/search?q=TITLE"">Other Libraries
(WorldCat)</a></li>\n<li class="yuimenuitem"><a
class="yuimenuitemlabel"
href="http://www.scholar.google.com/scholar?q=TITLE"
target="_blank">Other Databases (Google Scholar)</a></li>\n<li
class="yuimenuitem"><a class="yuimenuitemlabel"
href="http://www.bookfinder.com/search/?author=AUTHOR&amp;title=TITLE&amp;st=xl&amp;ac=qr"
target="_blank">Online Stores (Bookfinder.com)</a></li>','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.','70|10','Textarea')
diff --git a/installer/data/mysql/updatedatabase.pl
b/installer/data/mysql/updatedatabase.pl
index 3323e3c..62952a1 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -2592,6 +2592,14 @@ $DBversion = '3.01.00.XXX';
      print "Upgrade to $DBversion done (Add OPACSearchForTitleIn syspref)\n";
      }

+$DBversion = '3.01.00.XXX';
+     if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
+     $dbh->do("UPDATE systempreferences SET explanation='Fine limit
above which user cannot renew books via OPAC' WHERE
variable='OPACFineNoRenewals';");
+     $dbh->do("UPDATE systempreferences SET explanation='If set to
ON, a clear screen button will appear on the circulation page.' WHERE
variable='DisplayClearScreenButton';");
+     SetVersion ($DBversion);
+     print "Upgrade to $DBversion done (fixed typos in new sysprefs)\n";
+     }
+
 =item DropAllForeignKeys($table)

   Drop all foreign keys of the table $table
-- 
1.5.6.5
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0006-Fixed-minor-typos-in-new-system-preferences.patch
Type: application/octet-stream
Size: 5316 bytes
Desc: not available
URL: </pipermail/koha-patches/attachments/20090823/0334e82a/attachment-0001.obj>