Core/RBAC: Create new permission 'Receive global GM messages/texts'

2 files changed, 19 insertions, 1 deletions

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);