diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2014-03-24 05:17:49 +0100 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2014-03-24 05:17:49 +0100 |
| commit | 9d0f59f55793d78fb498a1324a3bb1206c0c2a00 (patch) | |
| tree | 210f8561076a2ae83722bd72e70baf0749d9e435 | |
| parent | a777e4279656d7d79504041aa87ca078b46168f2 (diff) | |
DB/Quest: Fixes Gino's visibility and quest chain
By nelegalno and Rushor, closes #9030
| -rw-r--r-- | sql/updates/world/2014_03_24_02_world_quest.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2014_03_24_02_world_quest.sql b/sql/updates/world/2014_03_24_02_world_quest.sql new file mode 100644 index 00000000000..12bfb1dd1cb --- /dev/null +++ b/sql/updates/world/2014_03_24_02_world_quest.sql @@ -0,0 +1,16 @@ +-- Fix for Expression of Gratitude quest chain ( http://www.wowwiki.com/Quest:Expression_of_Gratitude ) +-- Cast Phase Shift: Garm Assault (54635) on player once Know No Fear (12822) quest is taken. +DELETE FROM `spell_area` WHERE `spell`=54635 AND `area`=4461; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES +(54635, 4461, 12822, 0, 0, 0, 2, 1, 74, 1); + +-- Ample Inspiration (12828) needs Expression of Gratitude (12836) quest completed (https://www.youtube.com/watch?v=lwHuQAL51m0, https://www.youtube.com/watch?v=K_rsnPXwouY) +UPDATE `quest_template` SET `PrevQuestId`=12836 WHERE `Id`=12828; + +-- Opening the Backdoor (12821) needs Ample Inspiration (12828) quest completed (https://www.youtube.com/watch?v=K_rsnPXwouY, https://www.youtube.com/watch?v=DzLrImBiYvM) +UPDATE `quest_template` SET `PrevQuestId`=12828 WHERE `Id`=12821; + +-- Overstock (12833) needs Demolitionist Extraordinaire (12824) quest completed (http://www.wowhead.com/quest=12833#comments:id=468099) +UPDATE `quest_template` SET `PrevQuestId`=12824 WHERE `Id`=12833; + +UPDATE `gameobject` SET `phaseMask`=3 WHERE `guid`=58035; |