aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authortreeston <treeston.mmoc@gmail.com>2017-06-12 17:12:02 +0200
committerCarbenium <carbenium@outlook.com>2020-07-16 22:00:29 +0200
commit60fadf8c71d3fda1bbb01d33cecb34f3bd158f16 (patch)
treecaffe33f81e291b6ddbd914c01eb4228d64149bc
parent17a0139b0e121b0d8d0f2a079fcfd49090ea35a4 (diff)
Insert dynamic_spawning RBACs (already reserved in RBAC.h as of 55d8c2b) into auth database to prevent constant base file conflicts on that branch.
(cherry picked from commit 06c5d139f6ad7fedb920e0bafda88be57050a970)
-rw-r--r--sql/base/auth_database.sql10
-rw-r--r--sql/updates/auth/master/2017_06_12_01_auth.sql12
2 files changed, 22 insertions, 0 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 14bd7660b40..0f8d8876224 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1263,6 +1263,11 @@ INSERT INTO `rbac_linked_permissions` VALUES
(197,819),
(197,821),
(197,827),
+(197,856),
+(197,857),
+(197,858),
+(197,859),
+(197,860)
(198,218),
(198,300),
(198,312),
@@ -2089,6 +2094,11 @@ INSERT INTO `rbac_permissions` VALUES
(853,'Command: .reload conversation_template'),
(854,'Command: .debug conversation'),
(855,'Command: debug play music'),
+(856,'Command: npc spawngroup'),
+(857,'Command: npc despawngroup'),
+(858,'Command: gobject spawngroup'),
+(859,'Command: gobject despawngroup'),
+(860,'Command: list respawns'),
(868,'Command: modify power'),
(869,'Command: debug send playerchoice'),
(872,'Command: server debug');
diff --git a/sql/updates/auth/master/2017_06_12_01_auth.sql b/sql/updates/auth/master/2017_06_12_01_auth.sql
new file mode 100644
index 00000000000..17c204b56af
--- /dev/null
+++ b/sql/updates/auth/master/2017_06_12_01_auth.sql
@@ -0,0 +1,12 @@
+--
+DELETE FROM `rbac_permissions` WHERE `id` BETWEEN 856 AND 860;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(856, 'Command: npc spawngroup'),
+(857, 'Command: npc despawngroup'),
+(858, 'Command: gobject spawngroup'),
+(859, 'Command: gobject despawngroup'),
+(860, 'Command: list respawns');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` BETWEEN 856 AND 860;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(197,856),(197,857),(197,858),(197,859),(197,860);