diff options
| author | offl <offl@users.noreply.github.com> | 2020-12-18 01:59:08 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-12-18 01:59:08 +0200 |
| commit | 0d8792a8309bd25b9c947ee5cb39b09eebc8535e (patch) | |
| tree | b3815c6f888d4154965e03cfb57eba51c93ec9f1 | |
| parent | e51db5cb2491930340f534e53d94629f106ca90c (diff) | |
DB/Spell: Isle of Quel'Danas & Sunwell Plateau area spells
| -rw-r--r-- | sql/updates/world/3.3.5/2020_12_18_01_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_12_18_01_world.sql b/sql/updates/world/3.3.5/2020_12_18_01_world.sql new file mode 100644 index 00000000000..6b7ca320bcf --- /dev/null +++ b/sql/updates/world/3.3.5/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`,`autocast`,`quest_start_status`,`quest_end_status`) VALUES +(45087,4080,0,0,0,0,2,1,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`,`autocast`,`quest_start_status`,`quest_end_status`) VALUES +(46302,4075,0,0,0,0,2,1,64,11); |