Bugzilla – Attachment 150088 Details for
Bug 27634
Turn off patron self-registration if no default category is set
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 27634: Update PatronSelfRegistrationBorrowerUnwantedField's value
Bug-27634-Update-PatronSelfRegistrationBorrowerUnw.patch (text/plain), 1.54 KB, created by
Katrin Fischer
on 2023-04-22 20:13:08 UTC
(
hide
)
Description:
Bug 27634: Update PatronSelfRegistrationBorrowerUnwantedField's value
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2023-04-22 20:13:08 UTC
Size:
1.54 KB
patch
obsolete
>From 0516a649bfed869f32907f0d225a18bf470ad00c Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 5 Feb 2021 11:46:54 +0100 >Subject: [PATCH] Bug 27634: Update > PatronSelfRegistrationBorrowerUnwantedField's value > >Signed-off-by: David Nind <david@davidnind.com> >Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> >--- > .../data/mysql/atomicupdate/bug_27634.perl | 20 +++++++++++++++++++ > 1 file changed, 20 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_27634.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_27634.perl b/installer/data/mysql/atomicupdate/bug_27634.perl >new file mode 100644 >index 0000000000..b3c2d943d7 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_27634.perl >@@ -0,0 +1,20 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ >+ for my $f ( qw( categorycode dateexpiry ) ) { >+ my ( $exists ) = $dbh->selectrow_array(qq{ >+ SELECT value from systempreferences >+ WHERE variable="PatronSelfRegistrationBorrowerUnwantedField" >+ AND value LIKE "%$f%" >+ }); >+ unless ( $exists ) { >+ $dbh->do(q{ >+ UPDATE systempreferences >+ SET value = CONCAT(value, IF(value<>'','|',''), ?) >+ WHERE variable="PatronSelfRegistrationBorrowerUnwantedField" >+ }, undef, $f); >+ } >+ } >+ >+ NewVersion( $DBversion, 27634, "Add categorycode and dateexpiry to PatronSelfRegistrationBorrowerUnwantedField"); >+} >-- >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 27634
:
116378
|
116379
|
116380
|
116381
|
116382
|
116383
|
116491
|
145599
|
145600
|
145601
|
145602
|
145603
|
145604
|
145605
|
145922
|
147531
|
147532
|
147533
|
147534
|
147535
|
147536
|
147537
|
149746
|
149747
|
149748
|
149896
|
149897
|
149898
|
149899
|
149900
|
149901
|
149902
|
150083
|
150084
|
150085
|
150086
|
150087
|
150088
|
150089
|
150090
|
151046
|
151047
|
151048
|
151049
|
155863
|
155864
|
155865
|
155866
|
155867
|
155868
|
155869
|
155870
|
156203