Scripts/Commands: New utility command: .list spawnpoints.

(I just needed it for dynspawn follow-up work, really.)

(cherry picked from commit fcd6fe0aac0b906e2cf8e2379d94a7d73384c160)

3 files changed, 17 insertions, 0 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index c0d955379fb..f9de965c980 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1181,6 +1181,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (196,840),
 (196,842),
 (196,843),
+(196,866),
 (196,869),
 (196,872),
 (197,232),
@@ -2107,6 +2108,7 @@ INSERT INTO `rbac_permissions` VALUES
 (859,'Command: gobject despawngroup'),
 (860,'Command: list respawns'),
 (865,'Command: npc showloot'),
+(866,'Command: list spawnpoints'),
 (868,'Command: modify power'),
 (869,'Command: debug send playerchoice'),
 (872,'Command: server debug');
@@ -2309,6 +2311,7 @@ INSERT INTO `updates` VALUES
 ('2017_06_25_00_auth.sql','A2DA6A64D4217992EF766915DEBD517DB0834E01','ARCHIVED','2017-06-25 00:54:10',0),
 ('2017_06_28_00_auth_master.sql','6E58300D4D4DAAEE89107ECB3CB7DA8529DA738F','ARCHIVED','2017-06-28 19:11:09',0),
 ('2017_06_28_00_auth_rbac.sql','D32EF80F57F629C23395D80F06E91D7E40719F83','ARCHIVED','2017-06-28 00:00:00',0),
+('2017_08_01_00_auth.sql','6ECE808AF52345177189E962C0606B769B6806A6','ARCHIVED','2017-08-01 00:00:00',0),
 ('2017_06_30_00_auth.sql','C73BD277D211DBE1BB86BB1B443CA8F292D8ADEE','ARCHIVED','2017-06-30 16:18:51',0),
 ('2017_08_04_00_auth.sql','2E994A704C64FECE3CE0883ED0CAC5E5A0E3A36C','ARCHIVED','2017-08-04 23:46:32',0),
 ('2017_08_13_00_auth_2016_09_22_00_auth.sql','70047954E3556BFA430ADD5680EF8797F74A4B9E','ARCHIVED','2017-08-13 12:00:00',0),
diff --git a/sql/updates/auth/master/2017_08_01_00_auth.sql b/sql/updates/auth/master/2017_08_01_00_auth.sql
new file mode 100644
index 00000000000..3921ed76d5a
--- /dev/null
+++ b/sql/updates/auth/master/2017_08_01_00_auth.sql
@@ -0,0 +1,8 @@
+-- 
+DELETE FROM `rbac_permissions` WHERE `id`=866;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(866, 'Command: list spawnpoints');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=866;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196,866);
diff --git a/sql/updates/world/master/2020_08_22_01_world_2017_08_01_00_world.sql b/sql/updates/world/master/2020_08_22_01_world_2017_08_01_00_world.sql
new file mode 100644
index 00000000000..135a50ae851
--- /dev/null
+++ b/sql/updates/world/master/2020_08_22_01_world_2017_08_01_00_world.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `command` WHERE `name`="list spawnpoints";
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('list spawnpoints', 866, 'Syntax: .list spawnpoints
+
+Lists all spawn points (both creatures and GOs) in the current zone.');