From 54f7cc326f9aaf986a2fc1e20c2b03c95e020977 Mon Sep 17 00:00:00 2001 From: Spp Date: Mon, 25 Feb 2013 12:45:10 +0100 Subject: Core/RBAC: Create new permission 'Receive global GM messages/texts' --- sql/updates/auth/2013_02_25_04_auth_misc.sql | 2 +- sql/updates/auth/2013_02_25_05_auth_misc.sql | 18 ++++++++++++++++++ 2 files changed, 19 insertions(+), 1 deletion(-) create mode 100644 sql/updates/auth/2013_02_25_05_auth_misc.sql (limited to 'sql') diff --git a/sql/updates/auth/2013_02_25_04_auth_misc.sql b/sql/updates/auth/2013_02_25_04_auth_misc.sql index accacbb19d8..faaee3582ea 100644 --- a/sql/updates/auth/2013_02_25_04_auth_misc.sql +++ b/sql/updates/auth/2013_02_25_04_auth_misc.sql @@ -1,7 +1,7 @@ -- Add new permissions DELETE FROM `rbac_permissions` WHERE `id` IN (34, 37); INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(34, 'Check if shoul appear in list using .gm ingame command'), +(34, 'Check if should appear in list using .gm ingame command'), (37, 'Use staff badge in chat'); -- Add new role diff --git a/sql/updates/auth/2013_02_25_05_auth_misc.sql b/sql/updates/auth/2013_02_25_05_auth_misc.sql new file mode 100644 index 00000000000..e3ee3f00572 --- /dev/null +++ b/sql/updates/auth/2013_02_25_05_auth_misc.sql @@ -0,0 +1,18 @@ +-- Add new permission +DELETE FROM `rbac_permissions` WHERE `id` = 44; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (44, 'Receive global GM messages/texts'); + +-- Add new role +DELETE FROM `rbac_roles` WHERE `id` = 16; +INSERT INTO `rbac_roles` (`id`, `name`) VALUES (16, 'Receive global GM messages/texts'); + +-- Add the permission to the role +DELETE FROM `rbac_role_permissions` WHERE `roleId` = 16; +INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (16, 44); + +-- Add it to all GM+ groups +DELETE FROM `rbac_group_roles` WHERE `roleId` = 16; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES +(2, 16), +(3, 16), +(4, 16); -- cgit v1.2.3