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

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

2 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/auth/3.3.5/2017_08_01_00_auth.sql b/sql/updates/auth/3.3.5/2017_08_01_00_auth.sql
new file mode 100644
index 00000000000..3921ed76d5a
--- /dev/null
+++ b/sql/updates/auth/3.3.5/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/3.3.5/2017_08_01_00_world.sql b/sql/updates/world/3.3.5/2017_08_01_00_world.sql
new file mode 100644
index 00000000000..135a50ae851
--- /dev/null
+++ b/sql/updates/world/3.3.5/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.');