aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/world
diff options
context:
space:
mode:
authorSpp <spp@jorge.gr>2013-08-30 16:14:00 +0200
committerSpp <spp@jorge.gr>2013-08-30 16:14:00 +0200
commit2b69f83823af84da08be5888185b6da14742c387 (patch)
tree63a820c4c46a79db0460fad3e93d5037e39a9059 /sql/updates/world
parent109188a203d1745888596cac3bc78f1a057d934e (diff)
Core/RBAC: Move Achievements and Arena commands to RBAC (using individual permissions)
Diffstat (limited to 'sql/updates/world')
-rw-r--r--sql/updates/world/2013_08_30_05_world_command.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2013_08_30_05_world_command.sql b/sql/updates/world/2013_08_30_05_world_command.sql
new file mode 100644
index 00000000000..017ab4fa03e
--- /dev/null
+++ b/sql/updates/world/2013_08_30_05_world_command.sql
@@ -0,0 +1,10 @@
+-- Update command table with new RBAC permissions
+UPDATE `command` SET `permission` = 230 WHERE `name` = 'achievement';
+UPDATE `command` SET `permission` = 231 WHERE `name` = 'achievement add';
+UPDATE `command` SET `permission` = 232 WHERE `name` = 'arena';
+UPDATE `command` SET `permission` = 233 WHERE `name` = 'arena captain';
+UPDATE `command` SET `permission` = 234 WHERE `name` = 'arena create';
+UPDATE `command` SET `permission` = 235 WHERE `name` = 'arena disband';
+UPDATE `command` SET `permission` = 236 WHERE `name` = 'arena info';
+UPDATE `command` SET `permission` = 237 WHERE `name` = 'arena lookup';
+UPDATE `command` SET `permission` = 238 WHERE `name` = 'arena rename';