From d0eb07711f53eadaf0307eb4c358e34434a7bb0b Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Mon, 18 Jun 2012 13:53:59 +0200 Subject: [PATCH] 8263 Make OPAC stylesheet preferences more consistent (dbrev) This patch handles the dbrev for this report. It optionally saves the value of the former opacstylesheet pref into opaclayoutstylesheet. June 21, 2012 & July 4, 2012: Rebased. Signed-off-by: Jonathan Druart --- installer/data/mysql/updatedatabase.pl | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index bb96644..567606d 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -5536,6 +5536,20 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { SetVersion($DBversion); } +$DBversion ="3.09.00.XXX"; +if(C4::Context->preference("Version") < TransformToNum($DBversion) ) { + my $query = "SELECT value FROM systempreferences WHERE variable='opacstylesheet'"; + my $remote= $dbh->selectrow_arrayref($query); + $dbh->do("DELETE from systempreferences WHERE variable='opacstylesheet'"); + if($remote && $remote->[0]) { + $query="UPDATE systempreferences SET value=? WHERE variable='opaclayoutstylesheet'"; + $dbh->do($query,undef,$remote->[0]); + print "NOTE: The URL of your remote opac css file has been moved to preference opaclayoutstylesheet.\n"; + } + print "Upgrade to $DBversion done (BZ 8263: Make OPAC stylesheet preferences more consistent)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) -- 1.7.7.3