DB/Spell: Isle of Quel'Danas & Sunwell Plateau area spells

(cherry picked from commit 0d8792a8309bd25b9c947ee5cb39b09eebc8535e)

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_05_01_world_2020_12_18_01_world.sql b/sql/updates/world/master/2022_03_05_01_world_2020_12_18_01_world.sql
new file mode 100644
index 00000000000..19811fed705
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_01_world_2020_12_18_01_world.sql
@@ -0,0 +1,13 @@
+-- Missing Exalted Shattered Sun Offensive Aura
+DELETE FROM `spell_area` WHERE `spell` = 45087 AND `area` = 4080;
+INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`flags`,`quest_start_status`,`quest_end_status`) VALUES
+(45087,4080,0,0,0,0,2,3,64,11);
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 17 AND `SourceEntry` = 45087;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(17,0,45087,0,0,5,0,1077,128,0,0,0,0,"","Group 0: Spell 'Exalted Shattered Sun Offensive Aura' can be used if player is Exalted with Shattered Sun Offensive");
+
+-- K'iru's Song of Victory for Sunwell Plateau
+DELETE FROM `spell_area` WHERE `spell` = 46302 AND `area` = 4075;
+INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_end`,`aura_spell`,`racemask`,`gender`,`flags`,`quest_start_status`,`quest_end_status`) VALUES
+(46302,4075,0,0,0,0,2,3,64,11);