Core/RBAC: Move misc commands to RBAC (using individual permissions)

2 files changed, 160 insertions, 0 deletions

diff --git a/sql/updates/auth/2013_09_10_03_auth_misc.sql b/sql/updates/auth/2013_09_10_03_auth_misc.sql
new file mode 100644
index 00000000000..553830f6ecb
--- /dev/null
+++ b/sql/updates/auth/2013_09_10_03_auth_misc.sql
@@ -0,0 +1,107 @@
+/* cs_misc.cpp */
+
+SET @id = 488;
+
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id` BETWEEN @id AND @id+47;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(@id+0, 'additem'),
+(@id+1, 'additemset'),
+(@id+2, 'appear'),
+(@id+3, 'aura'),
+(@id+4, 'bank'),
+(@id+5, 'bindsight'),
+(@id+6, 'combatstop'),
+(@id+7, 'cometome'),
+(@id+8, 'commands'),
+(@id+9, 'cooldown'),
+(@id+10, 'damage'),
+(@id+11, 'dev'),
+(@id+12, 'die'),
+(@id+13, 'dismount'),
+(@id+14, 'distance'),
+(@id+15, 'flusharenapoints'),
+(@id+16, 'freeze'),
+(@id+17, 'gps'),
+(@id+18, 'guid'),
+(@id+19, 'help'),
+(@id+20, 'hidearea'),
+(@id+21, 'itemmove'),
+(@id+22, 'kick'),
+(@id+23, 'linkgrave'),
+(@id+24, 'listfreeze'),
+(@id+25, 'maxskill'),
+(@id+26, 'movegens'),
+(@id+27, 'mute'),
+(@id+28, 'neargrave'),
+(@id+29, 'pinfo'),
+(@id+30, 'playall'),
+(@id+31, 'possess'),
+(@id+32, 'recall'),
+(@id+33, 'repairitems'),
+(@id+34, 'respawn'),
+(@id+35, 'revive'),
+(@id+36, 'saveall'),
+(@id+37, 'save'),
+(@id+38, 'setskill'),
+(@id+39, 'showarea'),
+(@id+40, 'summon'),
+(@id+41, 'unaura'),
+(@id+42, 'unbindsight'),
+(@id+43, 'unfreeze'),
+(@id+44, 'unmute'),
+(@id+45, 'unpossess'),
+(@id+46, 'unstuck'),
+(@id+47, 'wchange');
+
+-- Add permissions to "corresponding Commands Role"
+DELETE FROM `rbac_role_permissions` WHERE `permissionId` BETWEEN @id AND @id+47;
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
+(4, @id+0),
+(4, @id+1),
+(2, @id+2),
+(4, @id+3),
+(4, @id+4),
+(4, @id+5),
+(3, @id+6),
+(4, @id+7),
+(1, @id+8),
+(4, @id+9),
+(4, @id+10),
+(4, @id+11),
+(4, @id+12),
+(1, @id+13),
+(4, @id+14),
+(4, @id+15),
+(2, @id+16),
+(4, @id+17),
+(3, @id+18),
+(1, @id+19),
+(4, @id+20),
+(3, @id+21),
+(3, @id+22),
+(4, @id+23),
+(2, @id+24),
+(4, @id+25),
+(4, @id+26),
+(2, @id+27),
+(4, @id+28),
+(3, @id+29),
+(3, @id+30),
+(4, @id+31),
+(2, @id+32),
+(3, @id+33),
+(4, @id+34),
+(4, @id+35),
+(2, @id+36),
+(1, @id+37),
+(4, @id+38),
+(4, @id+39),
+(2, @id+40),
+(4, @id+41),
+(4, @id+42),
+(2, @id+43),
+(2, @id+44),
+(4, @id+45),
+(1, @id+46),
+(4, @id+47);
diff --git a/sql/updates/world/2013_09_10_05_world_command.sql b/sql/updates/world/2013_09_10_05_world_command.sql
new file mode 100644
index 00000000000..3cb64e7c02d
--- /dev/null
+++ b/sql/updates/world/2013_09_10_05_world_command.sql
@@ -0,0 +1,53 @@
+/* cs_misc.cpp */
+
+SET @id = 488;
+
+-- Update command table with new RBAC permissions
+UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'additem';
+UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'additemset';
+UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'appear';
+UPDATE `command` SET `permission` = @id+3 WHERE `name` = 'aura';
+UPDATE `command` SET `permission` = @id+4 WHERE `name` = 'bank';
+UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'bindsight';
+UPDATE `command` SET `permission` = @id+6 WHERE `name` = 'combatstop';
+UPDATE `command` SET `permission` = @id+7 WHERE `name` = 'cometome';
+UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'commands';
+UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'cooldown';
+UPDATE `command` SET `permission` = @id+10 WHERE `name` = 'damage';
+UPDATE `command` SET `permission` = @id+11 WHERE `name` = 'dev';
+UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'die';
+UPDATE `command` SET `permission` = @id+13 WHERE `name` = 'dismount';
+UPDATE `command` SET `permission` = @id+14 WHERE `name` = 'distance';
+UPDATE `command` SET `permission` = @id+15 WHERE `name` = 'flusharenapoints';
+UPDATE `command` SET `permission` = @id+16 WHERE `name` = 'freeze';
+UPDATE `command` SET `permission` = @id+17 WHERE `name` = 'gps';
+UPDATE `command` SET `permission` = @id+18 WHERE `name` = 'guid';
+UPDATE `command` SET `permission` = @id+19 WHERE `name` = 'help';
+UPDATE `command` SET `permission` = @id+20 WHERE `name` = 'hidearea';
+UPDATE `command` SET `permission` = @id+21 WHERE `name` = 'itemmove';
+UPDATE `command` SET `permission` = @id+22 WHERE `name` = 'kick';
+UPDATE `command` SET `permission` = @id+23 WHERE `name` = 'linkgrave';
+UPDATE `command` SET `permission` = @id+24 WHERE `name` = 'listfreeze';
+UPDATE `command` SET `permission` = @id+25 WHERE `name` = 'maxskill';
+UPDATE `command` SET `permission` = @id+26 WHERE `name` = 'movegens';
+UPDATE `command` SET `permission` = @id+27 WHERE `name` = 'mute';
+UPDATE `command` SET `permission` = @id+28 WHERE `name` = 'neargrave';
+UPDATE `command` SET `permission` = @id+29 WHERE `name` = 'pinfo';
+UPDATE `command` SET `permission` = @id+30 WHERE `name` = 'playall';
+UPDATE `command` SET `permission` = @id+31 WHERE `name` = 'possess';
+UPDATE `command` SET `permission` = @id+32 WHERE `name` = 'recall';
+UPDATE `command` SET `permission` = @id+33 WHERE `name` = 'repairitems';
+UPDATE `command` SET `permission` = @id+34 WHERE `name` = 'respawn';
+UPDATE `command` SET `permission` = @id+35 WHERE `name` = 'revive';
+UPDATE `command` SET `permission` = @id+36 WHERE `name` = 'saveall';
+UPDATE `command` SET `permission` = @id+37 WHERE `name` = 'save';
+UPDATE `command` SET `permission` = @id+38 WHERE `name` = 'setskill';
+UPDATE `command` SET `permission` = @id+39 WHERE `name` = 'showarea';
+UPDATE `command` SET `permission` = @id+40 WHERE `name` = 'summon';
+UPDATE `command` SET `permission` = @id+41 WHERE `name` = 'unaura';
+UPDATE `command` SET `permission` = @id+42 WHERE `name` = 'unbindsight';
+UPDATE `command` SET `permission` = @id+43 WHERE `name` = 'unfreeze';
+UPDATE `command` SET `permission` = @id+44 WHERE `name` = 'unmute';
+UPDATE `command` SET `permission` = @id+45 WHERE `name` = 'unpossess';
+UPDATE `command` SET `permission` = @id+46 WHERE `name` = 'unstuck';
+UPDATE `command` SET `permission` = @id+47 WHERE `name` = 'wchange';