@@ -, +, @@ --- .../atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl | 10 ++++++++++ installer/data/mysql/sysprefs.sql | 2 +- 2 files changed, 11 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl --- a/installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl +++ a/installer/data/mysql/atomicupdate/bug_16371-QOTD_for_the_staff_interface.perl @@ -0,0 +1,10 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + # you can use $dbh here like: + # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" ); + + $dbh->do( "UPDATE systempreferences SET value = '', options = 'intranet,opac', explanation = 'Enable or disable display of Quote of the Day on the OPAC and staff interface home page', type = 'multiple' WHERE variable = 'QuoteOfTheDay'" ); + + # Always end with this (adjust the bug info) + NewVersion( $DBversion, 16371, "Bug 16371 - Quote of the Day (QOTD) for the staff interface "); +} --- a/installer/data/mysql/sysprefs.sql +++ a/installer/data/mysql/sysprefs.sql @@ -520,7 +520,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('QueryRegexEscapeOptions', 'escape', 'dont_escape|escape|unescape_escaped', 'Escape option for regexps delimiters in Elasicsearch queries.', 'Choice'), ('QueryStemming','1',NULL,'If ON, enables query stemming','YesNo'), ('QueryWeightFields','1',NULL,'If ON, enables field weighting','YesNo'), -('QuoteOfTheDay','0',NULL,'Enable or disable display of Quote of the Day on the OPAC home page','YesNo'), +('QuoteOfTheDay','','intranet,opac','Enable or disable display of Quote of the Day on the OPAC and staff interface home page','multiple'), ('RandomizeHoldsQueueWeight','0',NULL,'if ON, the holds queue in circulation will be randomized, either based on all location codes, or by the location codes specified in StaticHoldsQueueWeight','YesNo'), ('RecordLocalUseOnReturn','0',NULL,'If ON, statistically record returns of unissued items as local use, instead of return','YesNo'), ('RefundLostOnReturnControl','CheckinLibrary','CheckinLibrary|ItemHomeBranch|ItemHoldingBranch','If a lost item is returned, choose which branch to pick rules for refunding.','Choice'), --