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

2 files changed, 139 insertions, 0 deletions

diff --git a/sql/updates/auth/2013_09_02_01_auth_misc.sql b/sql/updates/auth/2013_09_02_01_auth_misc.sql
new file mode 100644
index 00000000000..7d13404d087
--- /dev/null
+++ b/sql/updates/auth/2013_09_02_01_auth_misc.sql
@@ -0,0 +1,93 @@
+/* cs_debug.cpp */
+
+SET @id = 300;
+
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id` BETWEEN @id AND @id+40;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(@id+0, 'debug'),
+(@id+1, 'debug anim'),
+(@id+2, 'debug areatriggers'),
+(@id+3, 'debug arena'),
+(@id+4, 'debug bg'),
+(@id+5, 'debug entervehicle'),
+(@id+6, 'debug getitemstate'),
+(@id+7, 'debug getitemvalue'),
+(@id+8, 'debug getvalue'),
+(@id+9, 'debug hostil'),
+(@id+10, 'debug itemexpire'),
+(@id+11, 'debug lootrecipient'),
+(@id+12, 'debug los'),
+(@id+13, 'debug mod32value'),
+(@id+14, 'debug moveflags'),
+(@id+15, 'debug play'),
+(@id+16, 'debug play cinematics'),
+(@id+17, 'debug play movie'),
+(@id+18, 'debug play sound'),
+(@id+19, 'debug send'),
+(@id+20, 'debug send buyerror'),
+(@id+21, 'debug send channelnotify'),
+(@id+22, 'debug send chatmessage'),
+(@id+23, 'debug send equiperror'),
+(@id+24, 'debug send largepacket'),
+(@id+25, 'debug send opcode'),
+(@id+26, 'debug send qinvalidmsg'),
+(@id+27, 'debug send qpartymsg'),
+(@id+28, 'debug send sellerror'),
+(@id+29, 'debug send setphaseshift'),
+(@id+30, 'debug send spellfail'),
+(@id+31, 'debug setaurastate'),
+(@id+32, 'debug setbit'),
+(@id+33, 'debug setitemvalue'),
+(@id+34, 'debug setvalue'),
+(@id+35, 'debug setvid'),
+(@id+36, 'debug spawnvehicle'),
+(@id+37, 'debug threat'),
+(@id+38, 'debug update'),
+(@id+39, 'debug uws'),
+(@id+40, 'wpgps');
+
+-- Add permissions to "corresponding Commands Role"
+DELETE FROM `rbac_role_permissions` WHERE `permissionId` BETWEEN @id AND @id+40;
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
+(2, @id+0),
+(3, @id+1),
+(4, @id+2),
+(4, @id+3),
+(4, @id+4),
+(4, @id+5),
+(4, @id+6),
+(4, @id+7),
+(4, @id+8),
+(4, @id+9),
+(4, @id+10),
+(3, @id+11),
+(2, @id+12),
+(4, @id+13),
+(4, @id+14),
+(2, @id+15),
+(2, @id+16),
+(2, @id+17),
+(2, @id+18),
+(4, @id+19),
+(4, @id+20),
+(4, @id+21),
+(4, @id+22),
+(4, @id+23),
+(4, @id+24),
+(4, @id+25),
+(4, @id+26),
+(4, @id+27),
+(4, @id+28),
+(4, @id+29),
+(4, @id+30),
+(4, @id+31),
+(4, @id+32),
+(4, @id+33),
+(4, @id+34),
+(4, @id+35),
+(4, @id+36),
+(4, @id+37),
+(4, @id+38),
+(4, @id+39),
+(4, @id+40);
diff --git a/sql/updates/world/2013_09_02_02_world_command.sql b/sql/updates/world/2013_09_02_02_world_command.sql
new file mode 100644
index 00000000000..af7b68a87da
--- /dev/null
+++ b/sql/updates/world/2013_09_02_02_world_command.sql
@@ -0,0 +1,46 @@
+/* cs_debug.cpp */
+
+SET @id = 300;
+
+-- Update command table with new RBAC permissions
+UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'debug';
+UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'debug anim';
+UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'debug areatriggers';
+UPDATE `command` SET `permission` = @id+3 WHERE `name` = 'debug arena';
+UPDATE `command` SET `permission` = @id+4 WHERE `name` = 'debug bg';
+UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'debug entervehicle';
+UPDATE `command` SET `permission` = @id+6 WHERE `name` = 'debug getitemstate';
+UPDATE `command` SET `permission` = @id+7 WHERE `name` = 'debug getitemvalue';
+UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'debug getvalue';
+UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'debug hostil';
+UPDATE `command` SET `permission` = @id+10 WHERE `name` = 'debug itemexpire';
+UPDATE `command` SET `permission` = @id+11 WHERE `name` = 'debug lootrecipient';
+UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'debug los';
+UPDATE `command` SET `permission` = @id+13 WHERE `name` = 'debug mod32value';
+UPDATE `command` SET `permission` = @id+14 WHERE `name` = 'debug moveflags';
+UPDATE `command` SET `permission` = @id+15 WHERE `name` = 'debug play';
+UPDATE `command` SET `permission` = @id+16 WHERE `name` = 'debug play cinematics';
+UPDATE `command` SET `permission` = @id+17 WHERE `name` = 'debug play movie';
+UPDATE `command` SET `permission` = @id+18 WHERE `name` = 'debug play sound';
+UPDATE `command` SET `permission` = @id+19 WHERE `name` = 'debug send';
+UPDATE `command` SET `permission` = @id+20 WHERE `name` = 'debug send buyerror';
+UPDATE `command` SET `permission` = @id+21 WHERE `name` = 'debug send channelnotify';
+UPDATE `command` SET `permission` = @id+22 WHERE `name` = 'debug send chatmessage';
+UPDATE `command` SET `permission` = @id+23 WHERE `name` = 'debug send equiperror';
+UPDATE `command` SET `permission` = @id+24 WHERE `name` = 'debug send largepacket';
+UPDATE `command` SET `permission` = @id+25 WHERE `name` = 'debug send opcode';
+UPDATE `command` SET `permission` = @id+26 WHERE `name` = 'debug send qinvalidmsg';
+UPDATE `command` SET `permission` = @id+27 WHERE `name` = 'debug send qpartymsg';
+UPDATE `command` SET `permission` = @id+28 WHERE `name` = 'debug send sellerror';
+UPDATE `command` SET `permission` = @id+29 WHERE `name` = 'debug send setphaseshift';
+UPDATE `command` SET `permission` = @id+30 WHERE `name` = 'debug send spellfail';
+UPDATE `command` SET `permission` = @id+31 WHERE `name` = 'debug setaurastate';
+UPDATE `command` SET `permission` = @id+32 WHERE `name` = 'debug setbit';
+UPDATE `command` SET `permission` = @id+33 WHERE `name` = 'debug setitemvalue';
+UPDATE `command` SET `permission` = @id+34 WHERE `name` = 'debug setvalue';
+UPDATE `command` SET `permission` = @id+35 WHERE `name` = 'debug setvid';
+UPDATE `command` SET `permission` = @id+36 WHERE `name` = 'debug spawnvehicle';
+UPDATE `command` SET `permission` = @id+37 WHERE `name` = 'debug threat';
+UPDATE `command` SET `permission` = @id+38 WHERE `name` = 'debug update';
+UPDATE `command` SET `permission` = @id+39 WHERE `name` = 'debug uws';
+UPDATE `command` SET `permission` = @id+40 WHERE `name` = 'wpgps';