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

(-)a/installer/data/mysql/atomicupdate/bug-23798-move-OpacMaintenanceNotice-to-additional-contents.pl (-3 / +11 lines)
Lines 17-24 return { Link Here
17
17
18
            # Insert any values found from system preference into additional_contents
18
            # Insert any values found from system preference into additional_contents
19
            $dbh->do(
19
            $dbh->do(
20
                "INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on ) VALUES ('html_customizations', 'OpacMaintenanceNotice', 'OpacMaintenanceNotice', NULL, 'OpacMaintenanceNotice default', ?, 'default', CAST(NOW() AS date) )",
20
                "INSERT INTO additional_contents ( category, code, location, branchcode, published_on ) VALUES ('html_customizations', 'OpacMaintenanceNotice', 'OpacMaintenanceNotice', NULL, CAST(NOW() AS date) )"
21
                undef, $opacmaintenancenotice
21
            );
22
23
            my ($insert_id) = $dbh->selectrow_array(
24
                "SELECT id FROM additional_contents WHERE category = 'html_customizations' AND code = 'OpacMaintenanceNotice' AND location = 'OpacMaintenanceNotice' LIMIT 1",
25
                {}
26
            );
27
28
            $dbh->do(
29
                "INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, 'OpacMaintenanceNotice default', ?, 'default' )",
30
                undef, $insert_id, $opacmaintenancenotice
22
            );
31
            );
23
32
24
            # Remove old system preference
33
            # Remove old system preference
25
- 

Return to bug 23798