[Koha-patches] [PATCH] Bug 1934: Final Patch - Fixed Default Values

[Nicole Engard]

>From 4cb953a537aa67f878f11a3178a7527e6d734f59 Mon Sep 17 00:00:00 2001
From: Nicole Engard <nengard at gmail.com>
Date: Sun, 30 Aug 2009 23:28:19 -0400
Subject: [PATCH] Bug 1934: Final Patch - Fixed Default Values
Content-Type: text/plain; charset="utf-8"

The default values had classes they didn't need assigned
to them.
---
 installer/data/mysql/en/mandatory/sysprefs.sql |    2 +-
 installer/data/mysql/updatedatabase.pl         |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/installer/data/mysql/en/mandatory/sysprefs.sql
b/installer/data/mysql/en/mandatory/sysprefs.sql
index caaf147..ab88869 100644
--- a/installer/data/mysql/en/mandatory/sysprefs.sql
+++ b/installer/data/mysql/en/mandatory/sysprefs.sql
@@ -256,6 +256,6 @@ INSERT INTO `systempreferences` ( `variable` ,
`value` , `options` , `explanatio
 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 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')
+INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
('OPACSearchForTitleIn','<li><a
href="http://worldcat.org/search?q={TITLE}" target="_blank">Other
Libraries (WorldCat)</a></li>\n<li><a
href="http://www.scholar.google.com/scholar?q={TITLE}"
target="_blank">Other Databases (Google Scholar)</a></li>\n<li><a
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');
 INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
('OPACPatronDetails','1','If OFF the patron details tab in the OPAC is
disabled.','','YesNo');
 INSERT INTO `systempreferences`
(variable,value,explanation,options,type) VALUES
('OPACFinesTab','1','If OFF the patron fines tab in the OPAC is
disabled.','','YesNo');
\ No newline at end of file
diff --git a/installer/data/mysql/updatedatabase.pl
b/installer/data/mysql/updatedatabase.pl
index 16cd3df..bfe92c0 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -2598,7 +2598,7 @@ if (C4::Context->preference("Version") <
TransformToNum($DBversion)) {

 $DBversion = '3.01.00.XXX';
      if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
-     $dbh->do("UPDATE systempreferences set explanation='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.', value='<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>' WHERE
variable='OPACSearchForTitleIn';");
+     $dbh->do("UPDATE systempreferences set explanation='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.', value='<li><a
href="http://worldcat.org/search?q={TITLE}" target="_blank">Other
Libraries (WorldCat)</a></li>\n<li><a
href="http://www.scholar.google.com/scholar?q={TITLE}"
target="_blank">Other Databases (Google Scholar)</a></li>\n<li><a
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>' WHERE
variable='OPACSearchForTitleIn';");
      SetVersion ($DBversion);
      print "Upgrade to $DBversion done (changed OPACSearchForTitleIn
per requests in bug 1934)\n";
      }
-- 
1.5.6.5
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0008-Bug-1934-Final-Patch-Fixed-Default-Values.patch
Type: application/octet-stream
Size: 5712 bytes
Desc: not available
URL: </pipermail/koha-patches/attachments/20090831/5ac85b1b/attachment-0001.obj>