View | Details | Raw Unified | Return to bug 27466
Collapse All | Expand All

(-)a/installer/data/mysql/updatedatabase.pl (-6 / +7 lines)
Lines 22596-22611 if( CheckVersion( $DBversion ) ) { Link Here
22596
$DBversion = '20.06.00.023';
22596
$DBversion = '20.06.00.023';
22597
if( CheckVersion( $DBversion ) ) {
22597
if( CheckVersion( $DBversion ) ) {
22598
22598
22599
    my $QuoteOfTheDay = C4::Context->preference('QuoteOfTheDay');
22599
    my ( $QuoteOfTheDay ) = $dbh->selectrow_array(q|
22600
        SELECT value FROM systempreferences WHERE variable='QuoteOfTheDay'
22601
    |);
22602
    my $options = $QuoteOfTheDay ? 'opac' : '';
22600
    $dbh->do( q|
22603
    $dbh->do( q|
22601
        UPDATE systempreferences
22604
        UPDATE systempreferences
22602
        SET options = 'intranet,opac',
22605
        SET value = ?,
22606
            options = 'intranet,opac',
22603
            explanation = 'Enable or disable display of Quote of the Day on the OPAC and staff interface home page',
22607
            explanation = 'Enable or disable display of Quote of the Day on the OPAC and staff interface home page',
22604
            type = 'multiple'
22608
            type = 'multiple'
22605
        WHERE variable = 'QuoteOfTheDay'
22609
        WHERE variable = 'QuoteOfTheDay'
22606
    | );
22610
    |, undef, $options );
22607
22608
    C4::Context->set_preference('QuoteOfTheDay', $QuoteOfTheDay ? 'opac' : '');
22609
22611
22610
    NewVersion( $DBversion, 16371, "Quote of the Day (QOTD) for the staff interface " );
22612
    NewVersion( $DBversion, 16371, "Quote of the Day (QOTD) for the staff interface " );
22611
}
22613
}
22612
- 

Return to bug 27466