Bugzilla – Attachment 157824 Details for
Bug 34869
Convert OPACResultsSidebar system preference to HTML customization
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 34869: (follow-up) Revise database update following Bug 31383
Bug-34869-follow-up-Revise-database-update-followi.patch (text/plain), 2.09 KB, created by
Owen Leonard
on 2023-10-25 15:50:55 UTC
(
hide
)
Description:
Bug 34869: (follow-up) Revise database update following Bug 31383
Filename:
MIME Type:
Creator:
Owen Leonard
Created:
2023-10-25 15:50:55 UTC
Size:
2.09 KB
patch
obsolete
>From 18f752989371612928f5e0bf7336bb8e69231f4e Mon Sep 17 00:00:00 2001 >From: Owen Leonard <oleonard@myacpl.org> >Date: Wed, 25 Oct 2023 14:33:05 +0000 >Subject: [PATCH] Bug 34869: (follow-up) Revise database update following Bug > 31383 > >--- > ...ove-opacresultssidebar-to-additional-contents.pl | 13 +++++++++++-- > 1 file changed, 11 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug-34869-move-opacresultssidebar-to-additional-contents.pl b/installer/data/mysql/atomicupdate/bug-34869-move-opacresultssidebar-to-additional-contents.pl >index 2003962bed..1c03c91872 100755 >--- a/installer/data/mysql/atomicupdate/bug-34869-move-opacresultssidebar-to-additional-contents.pl >+++ b/installer/data/mysql/atomicupdate/bug-34869-move-opacresultssidebar-to-additional-contents.pl >@@ -18,8 +18,17 @@ return { > # Insert any values found from system preference into additional_contents > foreach my $lang ('default') { > $dbh->do( >- "INSERT INTO additional_contents ( category, code, location, branchcode, title, content, lang, published_on ) VALUES ('html_customizations', 'OPACResultsSidebar', 'OPACResultsSidebar', NULL, ?, ?, ?, CAST(NOW() AS date) )", >- undef, "OPACResultsSidebar $lang", $opacresultssidebar, $lang >+ "INSERT INTO additional_contents ( category, code, location, branchcode, published_on ) VALUES ('html_customizations', 'OPACResultsSidebar', 'OPACResultsSidebar', NULL, CAST(NOW() AS date) )" >+ ); >+ >+ my ($insert_id) = $dbh->selectrow_array( >+ "SELECT id FROM additional_contents WHERE category = 'html_customizations' AND code = 'OPACResultsSidebar' AND location = 'OPACResultsSidebar' LIMIT 1", >+ {} >+ ); >+ >+ $dbh->do( >+ "INSERT INTO additional_contents_localizations ( additional_content_id, title, content, lang ) VALUES ( ?, ?, ?, ? )", >+ undef, $insert_id, "OPACResultsSidebar $lang", $opacresultssidebar, $lang > ); > } > >-- >2.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 34869
:
156104
|
156106
|
156108
|
156110
|
156126
|
156681
|
157564
|
157805
|
157821
|
157823
|
157824
|
157825
|
157907
|
157908
|
157909
|
158095
|
158096
|
158097
|
158444
|
158445
|
158446