aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/world
diff options
context:
space:
mode:
authorSpp <spp@jorge.gr>2013-09-02 11:17:15 +0200
committerSpp <spp@jorge.gr>2013-09-02 11:17:15 +0200
commit225691e0ae3b3efe271bd13bcb613405835a5041 (patch)
tree36e9a2537969204f4019d4f48e7002f2fbbb629b /sql/updates/world
parentcf9d01a0f3a9ae136854529eb1e52a0a8ffb08bb (diff)
Core/RBAC: Move disable commands to RBAC (using individual permissions)
Diffstat (limited to 'sql/updates/world')
-rw-r--r--sql/updates/world/2013_09_02_04_world_command.sql24
1 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/world/2013_09_02_04_world_command.sql b/sql/updates/world/2013_09_02_04_world_command.sql
new file mode 100644
index 00000000000..a4bc79b8a39
--- /dev/null
+++ b/sql/updates/world/2013_09_02_04_world_command.sql
@@ -0,0 +1,24 @@
+/* cs_disable.cpp */
+
+SET @id = 348;
+
+-- Update command table with new RBAC permissions
+UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'disable';
+UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'disable add';
+UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'disable add achievement_criteria';
+UPDATE `command` SET `permission` = @id+3 WHERE `name` = 'disable add battleground';
+UPDATE `command` SET `permission` = @id+4 WHERE `name` = 'disable add map';
+UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'disable add mmap';
+UPDATE `command` SET `permission` = @id+6 WHERE `name` = 'disable add outdoorpvp';
+UPDATE `command` SET `permission` = @id+7 WHERE `name` = 'disable add quest';
+UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'disable add spell';
+UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'disable add vmap';
+UPDATE `command` SET `permission` = @id+10 WHERE `name` = 'disable remove';
+UPDATE `command` SET `permission` = @id+11 WHERE `name` = 'disable remove achievement_criteria';
+UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'disable remove battleground';
+UPDATE `command` SET `permission` = @id+13 WHERE `name` = 'disable remove map';
+UPDATE `command` SET `permission` = @id+14 WHERE `name` = 'disable remove mmap';
+UPDATE `command` SET `permission` = @id+15 WHERE `name` = 'disable remove outdoorpvp';
+UPDATE `command` SET `permission` = @id+16 WHERE `name` = 'disable remove quest';
+UPDATE `command` SET `permission` = @id+17 WHERE `name` = 'disable remove spell';
+UPDATE `command` SET `permission` = @id+18 WHERE `name` = 'disable remove vmap');