Bugzilla – Attachment 35306 Details for
Bug 8438
Allow staff to only claim serial issues of their own branch
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8438: Followup Set the superserials permission for all users with the claim_serials permission
Bug-8438-Followup-Set-the-superserials-permission-.patch (text/plain), 1.34 KB, created by
Jonathan Druart
on 2015-01-15 14:00:34 UTC
(
hide
)
Description:
Bug 8438: Followup Set the superserials permission for all users with the claim_serials permission
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2015-01-15 14:00:34 UTC
Size:
1.34 KB
patch
obsolete
>From e9b34fad1c8fa13902e79215ab3e3eb826a4915b Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Tue, 16 Oct 2012 10:43:16 +0200 >Subject: [PATCH] Bug 8438: Followup Set the superserials permission for all > users with the claim_serials permission > >--- > installer/data/mysql/updatedatabase.pl | 16 ++++++++++++++++ > 1 file changed, 16 insertions(+) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 4653c02..ccdfaa0 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -9669,6 +9669,22 @@ if ( CheckVersion($DBversion) ) { > SetVersion ($DBversion); > } > >+$DBversion = "3.19.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ my $borrowernumbers = $dbh->selectcol_arrayref(q| >+ SELECT DISTINCT borrowernumber >+ FROM user_permissions >+ WHERE module_bit=15 >+ AND code='claim_serials' >+ |); >+ my $sth = $dbh->prepare(q| >+ INSERT INTO user_permissions(borrowernumber, module_bit, code) VALUES (?, 15, 'superserials') >+ |); >+ $sth->execute( $_ ) for @$borrowernumbers; >+ print "Upgrade to $DBversion done (Bug 8438 - Set the superserials permission for all users with the claim_serials permission.)\n"; >+ SetVersion ($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >2.1.0
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 8438
:
11778
|
12842
|
24074
|
26399
|
26400
|
29098
|
29099
|
29191
|
29192
|
29211
|
29212
|
35177
|
35178
|
35305
|
35306
|
35311
|
35312
|
43560