Core/RBAC: Create new permissions 'Instant .save', 'Allow params with .unstuck', 'Full HP after resurrect'

1 files changed, 32 insertions, 0 deletions

diff --git a/sql/updates/auth/2013_02_25_03_auth_misc.sql b/sql/updates/auth/2013_02_25_03_auth_misc.sql
new file mode 100644
index 00000000000..cf843b9769d
--- /dev/null
+++ b/sql/updates/auth/2013_02_25_03_auth_misc.sql
@@ -0,0 +1,32 @@
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id` IN (30, 31, 38);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(30, 'Save character without delay with .save command'),
+(31, 'Use params with .unstuck command'),
+(38, 'Resurrect with full Health Points');
+
+-- Add new role
+DELETE FROM `rbac_roles` WHERE `id` IN (11, 12, 13);
+INSERT INTO `rbac_roles` (`id`, `name`) VALUES
+(11, 'Instant .save'),
+(12, 'Allow params with .unstuck'),
+(13, 'Full HP after resurrect');
+
+-- Add the permission to the role
+DELETE FROM `rbac_role_permissions` WHERE `roleId` IN (11, 12, 13);
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
+(11, 30),
+(12, 31),
+(13, 38);
+
+-- Add it to all GM+ groups
+INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
+(2, 11),
+(3, 11),
+(4, 11),
+(2, 12),
+(3, 12),
+(4, 12),
+(2, 13),
+(3, 13),
+(4, 13);