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

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

Return to bug 34869