aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql4
-rw-r--r--sql/updates/auth/3.3.5/2018_01_09_00_auth.sql8
-rw-r--r--sql/updates/world/3.3.5/2018_01_09_00_world.sql6
3 files changed, 17 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 7273a4c0147..69e11cb61a7 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -817,6 +817,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
(196,843),
(196,866),
(196,867),
+(196,870),
(197,232),
(197,236),
(197,237),
@@ -1707,7 +1708,8 @@ INSERT INTO `rbac_permissions` VALUES
(864,'Command: group set mainassist'),
(865,'Command: npc showloot'),
(866,'Command: list spawnpoints'),
-(867,'Command: reload quest_greeting_locale');
+(867,'Command: reload quest_greeting_locale'),
+(870,'Command: debug threatinfo');
/*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/updates/auth/3.3.5/2018_01_09_00_auth.sql b/sql/updates/auth/3.3.5/2018_01_09_00_auth.sql
new file mode 100644
index 00000000000..aac66eaaa2b
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2018_01_09_00_auth.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `rbac_permissions` WHERE `id`=870;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(870, 'Command: debug threatinfo');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=870;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196,870);
diff --git a/sql/updates/world/3.3.5/2018_01_09_00_world.sql b/sql/updates/world/3.3.5/2018_01_09_00_world.sql
new file mode 100644
index 00000000000..3e524284dea
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_01_09_00_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `command` WHERE `name`="debug threatinfo";
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('debug threatinfo', 870, 'Syntax: .debug threatinfo
+
+Displays various debug information about the target\'s threat state, modifiers, redirects and similar.');