From 386ec582334818bb46582290e9daecb19f453897 Mon Sep 17 00:00:00 2001
From: Treeston <treeston.mmoc@gmail.com>
Date: Wed, 24 Jan 2018 22:52:42 +0100
Subject: Scripts/Commands: new command '.debug instancespawn'

(cherry picked from commit 6ce078d8e885f61ebdff3eb905e4cf6a2911da90)
---
 sql/base/auth_database.sql                                        | 3 +++
 sql/updates/auth/master/2018_01_24_00_auth.sql                    | 8 ++++++++
 .../world/master/2021_06_16_12_world_2018_01_24_06_world.sql      | 6 ++++++
 3 files changed, 17 insertions(+)
 create mode 100644 sql/updates/auth/master/2018_01_24_00_auth.sql
 create mode 100644 sql/updates/world/master/2021_06_16_12_world_2018_01_24_06_world.sql

(limited to 'sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 7da5fa1a7b4..79040edc640 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1196,6 +1196,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (196,872),
 (196,881),
 (196,870),
+(196,871),
 (197,232),
 (197,236),
 (197,237),
@@ -2125,6 +2126,7 @@ INSERT INTO `rbac_permissions` VALUES
 (868,'Command: modify power'),
 (869,'Command: debug send playerchoice'),
 (870,'Command: debug threatinfo'),
+(871,'Command: debug instancespawn'),
 (872,'Command: server debug'),
 (881,'Command: reload vehicle_template');
 /*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */;
@@ -2339,6 +2341,7 @@ INSERT INTO `updates` VALUES
 ('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_01_24_00_auth.sql','167B17D8A253D62A8112F8A7EB21C6E99CAEF1E4','RELEASED','2018-01-24 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/updates/auth/master/2018_01_24_00_auth.sql b/sql/updates/auth/master/2018_01_24_00_auth.sql
new file mode 100644
index 00000000000..119db7ae391
--- /dev/null
+++ b/sql/updates/auth/master/2018_01_24_00_auth.sql
@@ -0,0 +1,8 @@
+-- 
+DELETE FROM `rbac_permissions` WHERE `id`=871;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(871, 'Command: debug instancespawn');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=871;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196,871);
diff --git a/sql/updates/world/master/2021_06_16_12_world_2018_01_24_06_world.sql b/sql/updates/world/master/2021_06_16_12_world_2018_01_24_06_world.sql
new file mode 100644
index 00000000000..f8599a2952c
--- /dev/null
+++ b/sql/updates/world/master/2021_06_16_12_world_2018_01_24_06_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `command` WHERE `name`="debug instancespawn";
+INSERT INTO `command`(`name`,`permission`,`help`) VALUES
+('debug instancespawn',871,'Syntax: .debug instancespawn [<groupID>/explain]
+
+Displays information about the spawn groups being managed by the current instance script. If groupID is specified, additionally explains why that spawn group is in the listed state. If "explain" is specified, explains all spawn groups.');
-- 
cgit v1.2.3