diff options
| author | Naddley <NaddleyTC@gmail.com> | 2022-12-21 00:27:14 +0100 |
|---|---|---|
| committer | Naddley <NaddleyTC@gmail.com> | 2022-12-21 00:27:38 +0100 |
| commit | cfab6de3f69181ec86ab847d6f675a2fa16c8d74 (patch) | |
| tree | 5c21261503920be4af8a90586de24576a1d5276d | |
| parent | dfd2e6d901d99d3aeaae4be96bbc33b39399db67 (diff) | |
DB/Quest: Added questchain for Dragonflight intro in Stormwind
| -rw-r--r-- | sql/updates/world/master/2022_12_21_00_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_21_00_world.sql b/sql/updates/world/master/2022_12_21_00_world.sql new file mode 100644 index 00000000000..9112fab1e0a --- /dev/null +++ b/sql/updates/world/master/2022_12_21_00_world.sql @@ -0,0 +1,19 @@ +-- Chain Quests +DELETE FROM `quest_template_addon` WHERE `ID` IN (66577, 66589, 72240, 66596); +INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `BreadcrumbForQuestId`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`, `ScriptName`) VALUES +(66577, 0, 0, 0, 65436, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(66589, 0, 0, 0, 66577, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(72240, 0, 0, 0, 66577, 67700, -72240, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(66596, 0, 0, 0, 66589, 67700, -72240, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); + +-- update Creature Movement +DELETE FROM `creature_movement_override` WHERE `SpawnId` IN (1250013, 1250012); +INSERT INTO `creature_movement_override` (`SpawnId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(1250013, 0, 0, 1, 1, 0, 0, NULL), +(1250012, 0, 0, 1, 0, 0, 0, NULL); + +-- Conditions +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 19329 AND `SourceEntry` = 1519); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES +(26, 19329, 1519, 0, 0, 47, 0, 72240, 64, 0, 0, 'Apply Phase 19329 If Quest 72240 is rewarded'), +(26, 19329, 1519, 0, 0, 47, 0, 66596, 64, 0, 1, 'Apply Phase 19329 If Quest 66596 is not rewarded'); |