From 890c800cdbe242032a5bcd29d4522cb90bc6ae84 Mon Sep 17 00:00:00 2001
From: Jinnaix <Jinnaix@users.noreply.github.com>
Date: Sat, 21 Mar 2020 14:09:14 +0100
Subject: DB/Quest: Arugal Must Die & Deathstalkers in Shadowfang

Closes #24341
---
 .../world/3.3.5/2020_03_21_00_world_335.sql        | 29 ++++++++++++++++++++++
 .../world/3.3.5/2020_03_21_01_world_335.sql        |  2 ++
 .../world/3.3.5/2020_03_21_03_world_335.sql        | 29 ----------------------
 3 files changed, 31 insertions(+), 29 deletions(-)
 create mode 100644 sql/updates/world/3.3.5/2020_03_21_00_world_335.sql
 create mode 100644 sql/updates/world/3.3.5/2020_03_21_01_world_335.sql
 delete mode 100644 sql/updates/world/3.3.5/2020_03_21_03_world_335.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2020_03_21_00_world_335.sql b/sql/updates/world/3.3.5/2020_03_21_00_world_335.sql
new file mode 100644
index 00000000000..d9dacc3b01c
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_03_21_00_world_335.sql
@@ -0,0 +1,29 @@
+-- Ragefire Chasm
+-- Correction of current linking
+
+-- As seen from entering the area
+-- Platform bottom right
+DELETE FROM `creature_formations` WHERE `memberGUID` IN (48702,48701);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(48702, 48702, 0, 0, 3, 0, 0),
+(48702, 48701, 0, 0, 3, 0, 0);
+
+-- Platform bottom left
+DELETE FROM `creature_formations` WHERE `memberGUID` IN (48693,48692,48705);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(48693, 48693, 0, 0, 3, 0, 0),
+(48693, 48692, 0, 0, 3, 0, 0),
+(48693, 48705, 0, 0, 3, 0, 0);
+
+-- Platform top right
+DELETE FROM `creature_formations` WHERE `memberGUID` IN (48721,48720,48719);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(48721, 48721, 0, 0, 3, 0, 0),
+(48721, 48720, 0, 0, 3, 0, 0),
+(48721, 48719, 0, 0, 3, 0, 0);
+
+-- Platform top left
+DELETE FROM `creature_formations` WHERE `memberGUID` IN (48710,48709);
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(48710, 48710, 0, 0, 3, 0, 0),
+(48709, 48709, 0, 0, 3, 0, 0);
diff --git a/sql/updates/world/3.3.5/2020_03_21_01_world_335.sql b/sql/updates/world/3.3.5/2020_03_21_01_world_335.sql
new file mode 100644
index 00000000000..6c4ef351424
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_03_21_01_world_335.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `quest_template` SET `AllowableRaces`=690 WHERE `ID` IN (1014, 1098);
diff --git a/sql/updates/world/3.3.5/2020_03_21_03_world_335.sql b/sql/updates/world/3.3.5/2020_03_21_03_world_335.sql
deleted file mode 100644
index d9dacc3b01c..00000000000
--- a/sql/updates/world/3.3.5/2020_03_21_03_world_335.sql
+++ /dev/null
@@ -1,29 +0,0 @@
--- Ragefire Chasm
--- Correction of current linking
-
--- As seen from entering the area
--- Platform bottom right
-DELETE FROM `creature_formations` WHERE `memberGUID` IN (48702,48701);
-INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
-(48702, 48702, 0, 0, 3, 0, 0),
-(48702, 48701, 0, 0, 3, 0, 0);
-
--- Platform bottom left
-DELETE FROM `creature_formations` WHERE `memberGUID` IN (48693,48692,48705);
-INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
-(48693, 48693, 0, 0, 3, 0, 0),
-(48693, 48692, 0, 0, 3, 0, 0),
-(48693, 48705, 0, 0, 3, 0, 0);
-
--- Platform top right
-DELETE FROM `creature_formations` WHERE `memberGUID` IN (48721,48720,48719);
-INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
-(48721, 48721, 0, 0, 3, 0, 0),
-(48721, 48720, 0, 0, 3, 0, 0),
-(48721, 48719, 0, 0, 3, 0, 0);
-
--- Platform top left
-DELETE FROM `creature_formations` WHERE `memberGUID` IN (48710,48709);
-INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
-(48710, 48710, 0, 0, 3, 0, 0),
-(48709, 48709, 0, 0, 3, 0, 0);
-- 
cgit v1.2.3