From 4b04de209aa25816f5d97c05ce71ea9619027484 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Tue, 16 Feb 2010 10:02:47 +0100 Subject: [PATCH] updatedatabase : fixing XSLT syspref type XSLT* is now of type free and not Boolean letter added for staff hold spelling problem fixed --- installer/data/mysql/updatedatabase30.pl | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase30.pl b/installer/data/mysql/updatedatabase30.pl index 143bcfcd4f..9635daec41 100644 --- a/installer/data/mysql/updatedatabase30.pl +++ b/installer/data/mysql/updatedatabase30.pl @@ -709,6 +709,8 @@ $DBversion = "3.00.06.003"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("UPDATE systempreferences set value='../koha-tmpl/opac-tmpl/prog/en/xslt/".C4::Context->preference('marcflavour')."slim2OPACDetail.xsl',type='Free' where variable='XSLTDetailsDisplay' AND value=1;"); $dbh->do("UPDATE systempreferences set value='../koha-tmpl/opac-tmpl/prog/en/xslt/".C4::Context->preference('marcflavour')."slim2OPACResults.xsl',type='Free' where variable='XSLTResultsDisplay' AND value=1;"); + $dbh->do("UPDATE systempreferences set value='',type='Free' where variable='XSLTDetailsDisplay' AND value=0;"); + $dbh->do("UPDATE systempreferences set value='',type='Free' where variable='XSLTResultsDisplay' AND value=0;"); print "Upgrade to $DBversion done (Improve XSLT)\n"; SetVersion ($DBversion); } @@ -732,7 +734,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $DBversion = '3.00.06.006'; if (C4::Context->preference('Version') < TransformToNum($DBversion)){ $dbh->do(" - INSERT INTO `letter` (module, code, name, title, content) VALUES('reserves', 'STAFFHOLDPLACED', 'Hold Placed on Item (from staff)', 'Hold Placed on Item (from staff)','An hold has been placed on the following item from the intranet : <> (<<biblionumber>>) for the user <<firstname>> <<surname>> (<<cardnumber>>).'); + INSERT INTO `letter` (module, code, name, title, content) VALUES('reserves', 'STAFFHOLDPLACED', 'Hold Placed on Item (from staff)', 'Hold Placed on Item (from staff)','A hold has been placed on the following item from the intranet : <<title>> (<<biblionumber>>) for the user <<firstname>> <<surname>> (<<cardnumber>>).'); "); print "Upgrade to $DBversion done (Added notice for hold from staff)\n"; SetVersion ($DBversion); -- 2.20.1