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

(-)a/installer/data/mysql/atomicupdate/bug_24221_move-opacmysummarynote-to-addtional-contents.pl (-7 / +7 lines)
Lines 11-23 return { Link Here
11
            SELECT value FROM systempreferences WHERE variable='OPACMySummaryNote';
11
            SELECT value FROM systempreferences WHERE variable='OPACMySummaryNote';
12
        |);
12
        |);
13
        if( $opacmysummarynote ){
13
        if( $opacmysummarynote ){
14
            # Insert any values found from system preference into additional_contents
14
            $dbh->do(q{
15
            foreach my $lang ( 'default' ) {
15
                INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on )
16
                $dbh->do( "INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on ) VALUES ('html_customizations', 'OpacMySummaryNote', 'OpacMySummaryNote', NULL, ?, ?, ?, CAST(NOW() AS date) )", undef, "OpacMySummaryNote $lang", $opacmysummarynote, $lang );
16
                VALUES ('html_customizations', 'OpacMySummaryNote', 'OpacMySummaryNote', NULL, ?, ?, ?, CAST(NOW() AS date) )
17
            }
17
            }, undef, "OpacMySummaryNote default", $opacmysummarynote, 'default');
18
            # Remove old system preference
18
            # Remove old system preference
19
            $dbh->do("DELETE FROM systempreferences WHERE variable='OPACMySummaryNote'");
19
            $dbh->do(q{
20
            say $out "Bug 24221 update done";
20
                DELETE FROM systempreferences WHERE variable='OPACMySummaryNote'
21
            });
21
        }
22
        }
22
    }
23
    }
23
}
24
}
24
- 

Return to bug 24221