From 3232b69ff3b12441723349e2febe74f81d98cd24 Mon Sep 17 00:00:00 2001 From: Spp Date: Fri, 30 Aug 2013 13:47:43 +0200 Subject: Core/RBAC: Move commands security to RBAC (using generic RBAC Permissions) - Warning: This will break commands for any custom security level --- sql/updates/world/2013_08_30_01_world_command.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/2013_08_30_01_world_command.sql (limited to 'sql') diff --git a/sql/updates/world/2013_08_30_01_world_command.sql b/sql/updates/world/2013_08_30_01_world_command.sql new file mode 100644 index 00000000000..89f83d7e424 --- /dev/null +++ b/sql/updates/world/2013_08_30_01_world_command.sql @@ -0,0 +1,12 @@ +ALTER TABLE `command` CHANGE `security` `permission` UNSIGNED SMALLINT(5) DEFAULT 0 NOT NULL; + +-- Player commands +UPDATE `command` SET `permission` = 7 WHERE `permission` = 0; +-- Moderator commands +UPDATE `command` SET `permission` = 8 WHERE `permission` = 1; +-- GM commands +UPDATE `command` SET `permission` = 9 WHERE `permission` = 2; +-- administrator commands +UPDATE `command` SET `permission` = 10 WHERE `permission` = 3; +-- console commands +UPDATE `command` SET `permission` = 12 WHERE `permission` = 4; -- cgit v1.2.3