From 6a0870a9993f5a1016439644d4a9ab3fd89277e5 Mon Sep 17 00:00:00 2001
From: Treeston <treeston.mmoc@gmail.com>
Date: Thu, 30 Aug 2018 20:17:27 +0200
Subject: Scripts/Commands: New command ".go instance". Goes to an instance.

---
 sql/base/auth_database.sql                      | 4 +++-
 sql/updates/auth/3.3.5/2018_08_30_00_auth.sql   | 9 +++++++++
 sql/updates/world/3.3.5/2018_08_30_02_world.sql | 6 ++++++
 3 files changed, 18 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/auth/3.3.5/2018_08_30_00_auth.sql
 create mode 100644 sql/updates/world/3.3.5/2018_08_30_02_world.sql

(limited to 'sql')

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 22c3ae3ef74..53d407aa651 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -965,6 +965,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (198,760),
 (198,852),
 (198,855),
+(198,874),
 (199,217),
 (199,221),
 (199,222),
@@ -1664,7 +1665,8 @@ INSERT INTO `rbac_permissions` VALUES
 (870,'Command: debug threatinfo'),
 (871,'Command: debug instancespawn'),
 (872,'Command: server debug'),
-(873,'Command: reload creature_movement_override');
+(873,'Command: reload creature_movement_override'),
+(874,'Command: go instance');
 /*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql b/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql
new file mode 100644
index 00000000000..1ee1f8d7ee4
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql
@@ -0,0 +1,9 @@
+-- 
+DELETE FROM `rbac_permissions` WHERE `id`=874;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(874, "Command: go instance");
+
+SET @parent := (SELECT `id` FROM `rbac_linked_permissions` WHERE `linkedId`=852);
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=874;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(@parent, 874);
diff --git a/sql/updates/world/3.3.5/2018_08_30_02_world.sql b/sql/updates/world/3.3.5/2018_08_30_02_world.sql
new file mode 100644
index 00000000000..d8b3b9c4b10
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_08_30_02_world.sql
@@ -0,0 +1,6 @@
+-- 
+DELETE FROM `command` WHERE `name`="go instance";
+INSERT INTO `command` (`name`,`permission`,`help`) VALUES
+('go instance', 874, 'Syntax: .go instance [mapid | name]
+
+Teleports you to entrance of instance with script name matching input (or given mapid)');
-- 
cgit v1.2.3