Scripts/Commands: New command: .debug threatinfo

(cherry picked from commit f45c211987794ff7e4192e0d3d4ca6bf67335fb5)

3 files changed, 17 insertions, 0 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index bc508852ca1..7da5fa1a7b4 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1195,6 +1195,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (196,869),
 (196,872),
 (196,881),
+(196,870),
 (197,232),
 (197,236),
 (197,237),
@@ -2123,6 +2124,7 @@ INSERT INTO `rbac_permissions` VALUES
 (866,'Command: list spawnpoints'),
 (868,'Command: modify power'),
 (869,'Command: debug send playerchoice'),
+(870,'Command: debug threatinfo'),
 (872,'Command: server debug'),
 (881,'Command: reload vehicle_template');
 /*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */;
@@ -2336,6 +2338,7 @@ INSERT INTO `updates` VALUES
 ('2017_12_30_01_auth.sql','1E11C78BA6D1D8E8CED7423DF92D1D197D6061EE','ARCHIVED','2017-12-30 23:00:00',0),
 ('2017_12_31_00_auth.sql','1721ACBD35EB95FAE33B9E95F8C4E4B1FB70A5E4','ARCHIVED','2017-12-31 20:15:23',0),
 ('2018_01_02_00_auth.sql','CD9B826B9D95697DC412DEF780E814FA3991D6CD','ARCHIVED','2018-01-02 20:40:37',0),
+('2018_01_09_00_auth.sql','A5D4EC8FCFAB4F2DCE70EDCAD1ACBFB484FD68D5','RELEASED','2018-01-09 00:00:00',0),
 ('2018_02_18_00_auth.sql','8489DD3EFFE14A7486B593435F0BA2BC69B6EABF','ARCHIVED','2018-02-18 16:35:55',0),
 ('2018_02_19_00_auth.sql','07CE658C5EF88693D3C047EF8E724F94ADA74C15','ARCHIVED','2018-02-19 22:33:32',0),
 ('2018_02_28_00_auth.sql','E92EF4ABF7FA0C66649E1633DD0459F44C09EB83','ARCHIVED','2018-02-28 23:07:59',0),
diff --git a/sql/old/8.x/auth/20061_2020_08_14/2018_01_09_00_auth.sql b/sql/old/8.x/auth/20061_2020_08_14/2018_01_09_00_auth.sql
new file mode 100644
index 00000000000..aac66eaaa2b
--- /dev/null
+++ b/sql/old/8.x/auth/20061_2020_08_14/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/master/2021_05_16_11_world_2018_01_09_00_world.sql b/sql/updates/world/master/2021_05_16_11_world_2018_01_09_00_world.sql
new file mode 100644
index 00000000000..3e524284dea
--- /dev/null
+++ b/sql/updates/world/master/2021_05_16_11_world_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.');