|
Line 0
Link Here
|
|
|
1 |
-- Insert permission |
| 2 |
INSERT IGNORE INTO permissions (module_bit, code, description) VALUES |
| 3 |
(13, 'upload_general_files', 'Upload any file'), |
| 4 |
(13, 'upload_manage', 'Manage uploaded files'); |
| 5 |
|
| 6 |
-- Update user_permissions for current users (check count in uploaded_files) |
| 7 |
-- Note 9 == edit_catalogue and 13 == tools |
| 8 |
-- We do not insert if someone is superlibrarian, does not have edit_catalogue, |
| 9 |
-- or already has all tools |
| 10 |
INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) |
| 11 |
SELECT borrowernumber, 13, 'upload_general_files' |
| 12 |
FROM borrowers bo |
| 13 |
WHERE flags<>1 AND flags & POW(2,13) = 0 AND |
| 14 |
( flags & POW(2,9) > 0 OR ( |
| 15 |
SELECT COUNT(*) FROM user_permissions |
| 16 |
WHERE borrowernumber=bo.borrowernumber AND module_bit=9 ) > 0 ) |
| 17 |
AND ( SELECT COUNT(*) FROM uploaded_files ) > 0 |
| 18 |
|
| 19 |
# Copy-paste for RM use: |
| 20 |
# print "Upgrade to $DBversion done (Bug 14686 - New menu option and permission for file uploading)\n"; |