diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_10_09_00_world.sql | 154 |
1 files changed, 154 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_10_09_00_world.sql b/sql/updates/world/6.x/2016_10_09_00_world.sql new file mode 100644 index 00000000000..c4fe9f56bf9 --- /dev/null +++ b/sql/updates/world/6.x/2016_10_09_00_world.sql @@ -0,0 +1,154 @@ +DELETE FROM `quest_template` WHERE `ID` IN (45682 /*-Unknown-*/, 44175 /*-Unknown-*/, 44023 /*-Unknown-*/, 43721 /*-Unknown-*/, 43528 /*-Unknown-*/, 43527 /*-Unknown-*/, 43526 /*-Unknown-*/, 43525 /*-Unknown-*/, 43524 /*-Unknown-*/, 43523 /*-Unknown-*/, 43522 /*-Unknown-*/, 43454 /*-Unknown-*/, 42780 /*-Unknown-*/, 42063 /*-Unknown-*/, 42024 /*-Unknown-*/, 41865 /*-Unknown-*/, 41836 /*-Unknown-*/, 41649 /*-Unknown-*/, 41563 /*-Unknown-*/, 41549 /*-Unknown-*/, 41537 /*-Unknown-*/, 41511 /*-Unknown-*/, 41443 /*-Unknown-*/, 41305 /*-Unknown-*/, 41294 /*-Unknown-*/, 41292 /*-Unknown-*/, 41288 /*-Unknown-*/, 41253 /*-Unknown-*/, 41200 /*-Unknown-*/, 41093 /*-Unknown-*/, 40678 /*-Unknown-*/, 40675 /*-Unknown-*/, 40673 /*-Unknown-*/, 40672 /*-Unknown-*/, 40615 /*-Unknown-*/, 40614 /*-Unknown-*/, 40613 /*-Unknown-*/, 40608 /*-Unknown-*/, 40603 /*-Unknown-*/, 30385 /*-Unknown-*/); +INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `QuestPackageID`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardBonusMoney`, `RewardDisplaySpell1`, `RewardDisplaySpell2`, `RewardDisplaySpell3`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `QuestRewardID`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(45682, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33555464, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Looted Rogue Vault', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(44175, 2, 110, 0, 110, -409, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 193103, 0, 0, 0, 0, 1, 0, 35684360, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'The World Awaits', 'Complete 20 World Quests in the Broken Isles.', 'When the sign of the emissary shines in the night sky, the stars strengthen existing bonds and forge new ones. Friendship is still not cheaply won, and deeds will prove loyalty, but trust comes more readily during these days. Venture across the Broken Isles, and give aid where you may, to prove your worth.', '', '', 1220, 0, 0, 0, 5000, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(44023, 3, 110, 0, 110, 7637, 135, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 51, 'WANTED: Siegemaster Aedrin', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43721, 3, 110, 0, 110, 7541, 136, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 221795, 0, 0, 0, 0, 0, 0, 37290240, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4856, 0, -1, 54, 'The Helarjar Have Surfaced', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43528, 2, -1, 0, 110, -406, 107, 0, 0, 1, 1, 19400, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37748992, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Planning the Assault', 'Await the opening of the Nighthold, then meet Archmage Kalec in Shal''Aran.', 'Thanks to your tireless efforts the Heart of Zin-Azshari is ready to withstand the full power of the Legion. The final destination in our journey has stood defiantly in front of us from the moment we began - the Nighthold, now home to none other than Gul''dan himself.$B$BWe just need a way inside.$B$BI am working fervently with the rest of the Council of Six to secure an entrance. Once we have, we should reunite with the Moon Guard in Shal''Aran - we still have need of their skills.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43527, 2, -1, 0, 110, -406, 107, 0, 0, 1, 1, 19400, 1, 1, 0, 0, 0, 0, 81040, 0, 0, 0, 0, 1, 0, 39846144, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Saving the Guard', 'Complete the "Moon Guard Stronghold" storyline in Suramar, then meet Archmage Kalec in Shal''Aran.', 'The Moon Guard were once among the most powerful sorcerers on Azeroth. Most assumed their ranks demolished after the War of the Ancients, but it seems they have managed to survive in their ancient stronghold in Suramar!$B$BI believe they could be valuable allies in our quest if they still oppose the Legion.$B$B$n, if you can save what remains of the Guard, I will work to convince the Council of Six to lend us additional aid.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43526, 2, -1, 0, 110, -406, 107, 0, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 38797568, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'A True Test', 'Absorb the power from the Twisted Runebindings using the Heart of Zin-Azshari.', 'Vizuul''s runebindings are more potent than I had anticipated. Not a bad thing - more power is certainly welcome - but there''s certainly more potential for catastrophe if the spell matrix somehow becomes unstable.$B$BWe should be able to safely contain the fel energy within the containment field using the eon winder you recovered... but keep an eye open just in case.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43525, 2, -1, 0, 110, -406, 81, 5, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 81040, 0, 0, 0, 0, 1, 0, 36700416, 33554688, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Borrowing Without Asking', 'Recover a Containment Crystal from the Vault of the Wardens on Mythic difficulty.', 'The elusive Wardens run an immense secret prison facility deep underneath the mountains of Azsuna housing all manner of terrible creatures.$B$BPerhaps... ''used to run'' is more accurate.$B$BThis presents us with a unique opportunity. The wardens used powerful containment crystals to encase each prisoner in their cell. If any of them still remain intact, we could use one to safely contain the Heart''s power.$B$BThey certainly won''t be needing them.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43524, 2, -1, 0, 110, -406, 81, 5, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 81040, 0, 0, 0, 0, 1, 0, 36700416, 33554688, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Literary Perfection', 'Find Lothrius'' first edition copy of "Wards, Sigils, and the Nightborne Way" in the Court of Stars on Mythic difficulty.', 'Out of all the books, why that one?! Oh, Mother Moon, I am but a trusting fool.$B$BI apologize, you have no idea what I''m going on about.$B$BI lent my first edition copy of "Wards, Sigils, and the Nightborne Way" to a dear friend - well, former friend, I should say - just before the betrayal.$B$BAs fate would have it, there is an incantation in that book that I will need for my part of the ritual.$B$BPlease retrieve it if you can, but be careful - it is quite valuable!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43523, 2, -1, 0, 110, -406, 107, 0, 0, 1, 1, 19400, 1, 1, 0, 0, 0, 0, 81040, 0, 0, 0, 0, 1, 0, 39846144, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Repaid Debt', 'Meet Archmage Kalec in the Shal''Aran in Suramar.', 'The Moon Guard fought against the Legion many years ago, during the War of the Ancients. Their intimate knowledge of our enemies would be invaluable to our cause.$B$BThey have remained in Shal''Aran since you saved Thalrenus and his kin. Shall we pay them a visit and see what they can do?', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43522, 2, -1, 0, 110, -406, 107, 0, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 228551, 0, 0, 0, 0, 1, 0, 35651840, 37748996, 0, 0, 0, 0, 140305, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Essential Consumption', 'Absorb the combined power of the Corrupted Essences using the Heart of Zin-Azshari.', 'As before, $n, once you are ready raise your artifact and channel its energy upon the Heart of Zin-Azshari and we will unleash the power of the essence you gathered.$B$BDo not worry - we still have enough of the blood you gathered to ensure the ritual remains stable.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(43454, 3, 110, 0, 110, 7541, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 25, 'WANTED: Egyl the Enduring', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(42780, 3, 110, 0, 110, 7812, 137, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35193088, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4519, 0, -1, 183, 'Maw of Souls: From Hell''s Mouth', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(42063, 3, 110, 0, 110, 7334, 115, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3735808, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 5, 'Size Doesn''t Matter', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(42024, 3, 110, 0, 110, 7334, 136, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 209775, 0, 0, 0, 0, 0, 0, 37290240, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4194, 0, -1, 52, 'A Friend of My Enemy', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41865, 3, 110, 0, 110, 7546, 137, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35193088, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4592, 0, -1, 184, 'Neltharion''s Lair: Mother of Stone', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41836, 3, 110, 0, 110, 7503, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 23, 'WANTED: Bodash the Hoarder', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41649, 3, 110, 0, 110, 7637, 121, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 524544, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1859, 0, 0, 0, 0, 5000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 1, 0, 0, 0, 0, 0, 4583, 0, -1, 103, 'Work Order: Silkweave Slippers', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41563, 3, 110, 0, 110, 7334, 124, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 152, 'Felhide', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41549, 3, 110, 0, 110, 7503, 131, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 44, 'Slab of Bacon', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41537, 3, 110, 0, 110, 7637, 119, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 147, 'Lively Starlight Roses', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41511, 3, 110, 0, 110, 7503, 119, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 151, 'Felwort', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41443, 3, 110, 0, 110, 7541, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4647, 0, -1, 148, 'Ancient Leystone Deposits', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41305, 3, 110, 0, 110, 7637, 119, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 147, 'Nightborne Herb Trader', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41294, 3, 110, 0, 110, 7558, 119, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 144, 'Flourishing Dreamleaf', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41292, 3, 110, 0, 110, 7558, 119, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 524608, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4274, 0, -1, 132, 'Work Order: Dreamleaf', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41288, 3, 110, 0, 110, 7334, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 524544, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4221, 0, -1, 130, 'Supplies Needed: Aethril', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41253, 3, 110, 0, 110, 7503, 130, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4452, 0, -1, 137, 'Migrating Highmountain Salmon', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41200, 3, 110, 0, 110, 7503, 120, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 34144576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 148, 'Rough Leystone Outcropping', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(41093, 3, 110, 0, 110, 7503, 136, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 226059, 0, 0, 0, 0, 0, 0, 3735872, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1894, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 0, 0, -1, 53, 'DANGER: Durguth', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40678, 2, -1, 0, 110, -406, 107, 5, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554688, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 132749, 132750, 0, 0, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Twisted Power', 'Use a Greater Portal Stone to summon Vizuul the Twisted at the Altar of End Times in Faronaar and collect his runebindings.', 'It is time we put our work to the test by infusing the most potent source of power I know of - fel magic.$B$BRarely, the Legion''s minions will carry fragments of the greater portal stones used to usher in their eredar masters. If you gather enough to form a complete stone, you can use it in Faronaar to call forth the eredar lord Vizuul the Twisted at the Altar of End Times.$B$BThe bindings Vizuul wears to augment his power should push the Heart to its very limit.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40675, 2, -1, 0, 110, -406, 81, 5, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 81040, 0, 0, 0, 0, 1, 0, 35651840, 33554688, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Rite of the Captain', 'Take Advisor Vandros'' Eon Winder from The Arcway on Mythic difficulty.', 'Only a captain of the Guard may receive the power of our order - our ancient laws forbid otherwise.$B$BYou must complete the rite of the captain.$B$BTraditionally, aspirants patrol the Arcway for three weeks without rest, the vast labyrinth putting their skills as a Guard to the test. Our laws must still be honored, but I believe there another way you may prove yourself.$B$BElisandre''s advisor, Vandros, has recently descended into the Arcway''s depths. Kill him, and take his Eon Winder.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40673, 2, -1, 0, 110, -406, 107, 0, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 81040, 0, 0, 0, 0, 1, 0, 36700416, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Lost Knowledge', 'Obtain the Scroll of Elun''dris from First Arcanist Thalyssra.', 'We are indeed familiar with the Nightborne''s magic, but we were never allowed access to the Heart. It was a right reserved only for the Queen''s favored.$B$BHowever, we can still learn how to properly tap its magic.$B$BThousands of years ago, a Nightborne scholar studied the Heart and documented his findings in great detail. He was executed and the scroll of his writings banned, but the Nightfallen secreted it away in their escape.$B$BIf you obtain the scroll, we can help you.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40672, 2, -1, 0, 110, -406, 81, 5, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34603264, 33554688, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Presentation is Key', 'Retrieve 4 Adamantium Casing Scraps and defeat Dargrul the Underking in Neltharion''s Lair on Mythic difficulty.', 'Odyn will demand a feast worthy of the ancient trials you must complete; a feast''s merit begins not at the great beasts piled upon it, but at the dish used to serve it.$B$BDeep beneath Highmountain lies the former lair of Neltharion - you may know the infernal drake better as Deathwing. You will find remnants of the adamantium plating used to hold his molten skin together in the deepest recesses of his lair.$B$BThey will form a fine dish for the feast.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40615, 2, -1, 0, 110, -406, 81, 5, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 0, 0, 0, 132471, 0, 1, 0, 34603264, 33554688, 0, 0, 0, 0, 140306, 0, 0, 0, 1, 0, 0, 0, 132471, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Odyn''s Blessing', 'Obtain Odyn''s blessing in the Halls of Valor on Heroic or Mythic difficulty.', 'You are ready, $c.$B$BTravel to Odyn''s shining halls and offer the feast on the altar just inside. Mighty Odyn will then set his gaze upon you - you must pass the ancient trials of the Valarjar under his watch.$B$BOnly then will you receive Odyn''s blessing.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40614, 2, -1, 0, 110, -406, 107, 3, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34603264, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'A Feast Fit for Odyn', 'Acquire flank meat from Thunderhoof in Stormheim, Spinesever''s spine in Highmountain, and a steak from Leytusk in Azsuna.', 'It is customary in the Halls of Valor to feast after battle is finished. Presenting a truly glorious feast to Odyn from beasts worthy of his throne will show him your determination to earn his blessing.$B$BAcquire flank meat from Thunderhoof in Stormheim, Spinesever''s spine in Highmountain, and the finest cut of steak from Leytusk in Azsuna. They will make a feast worthy of the great battle to come.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40613, 2, -1, 0, 110, -406, 81, 5, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34603264, 33554688, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Retrieving the Svalnguard', 'Retrieve the Svalnguard and defeat Helya in the Maw of Souls on Mythic difficulty.', 'The Svalnguard was once Odyn''s shield; it is said that it hid the Halls of Valor from the endless darkness below his realm.$B$BHelya, who was cast from the shining halls long ago, stole the Svalnguard and keeps it on her accursed ship, the Naglfar.$B$BYou must board the Naglfar, defeat Helya, and retrieve the Svalnguard - it will make a worthy tribute for Odyn.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40608, 2, -1, 0, 110, -406, 107, 0, 0, 5, 1, 194000, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34603264, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'The Mark', 'Prove your worth to the Valarjar, then receive the Mark of the Valkyra from Eyir.', 'Your blade is powerful, but it has not yet met its full potential. The all-powerful Odyn in the Halls of Valor can bestow upon you his strength.$B$BIn order to seek this blessing, you must bring him a worthy tribute. I know where you may obtain such a gift, but in order to retrieve it you must first receive the mark of the Valkyra.$B$BProve yourself worthy of our mark, champion, then you may enter the Vault of Eyir- the goddess will guide you from there.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(40603, 2, -1, 0, 110, -406, 107, 0, 0, 1, 1, 19400, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 38797568, 37748992, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Seeking the Valkyra', 'Seek out Ashildir at the Vault of Eyir in Stormheim.', 'We simply cannot risk another catastrophe like that; we have to protect the Heart against fel energy before we continue our work.$B$BThe mighty Ashildir has proven willing to aid those who she deems worthy, and her master just may be able to help us protect the Heart.$B$BYou should seek her out at the Vault of Eyir in Stormheim. I''ll meet you there.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747), -- -Unknown- +(30385, 2, 90, 0, 90, 5840, 0, 0, 0, 3, 1, 57000, 3, 1, 280, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 4104, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Setting Sun Garrison', 'Speak to Anji Autumnlight at the Setting Sun Garrison.', 'I offer you my heartfelt appreciation for your aid. Anji awaits you in the Setting Sun Garrison to the west.$B$BMay the day favor you, young $c.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22747); -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (286331 /*286331*/, 286124 /*286124*/, 285703 /*285703*/, 285680 /*285680*/, 285763 /*285763*/, 286016 /*286016*/, 285738 /*285738*/, 285709 /*285709*/, 285708 /*285708*/, 285762 /*285762*/, 285286 /*285286*/, 284733 /*284733*/, 284732 /*284732*/, 283480 /*283480*/, 283625 /*283625*/, 283624 /*283624*/, 283623 /*283623*/, 282982 /*282982*/, 282981 /*282981*/, 282901 /*282901*/, 282614 /*282614*/, 282520 /*282520*/, 282503 /*282503*/, 282494 /*282494*/, 282467 /*282467*/, 282383 /*282383*/, 282185 /*282185*/, 282172 /*282172*/, 282170 /*282170*/, 282166 /*282166*/, 282125 /*282125*/, 282013 /*282013*/, 281827 /*281827*/, 281053 /*281053*/, 286017 /*286017*/, 285713 /*285713*/, 281047 /*281047*/, 281045 /*281045*/, 281044 /*281044*/, 280968 /*280968*/, 280967 /*280967*/, 280985 /*280985*/, 280984 /*280984*/, 280965 /*280965*/, 280976 /*280976*/, 280963 /*280963*/, 280983 /*280983*/, 280960 /*280960*/, 280959 /*280959*/, 262097 /*262097*/, 261045 /*261045*/, 261044 /*261044*/, 261043 /*261043*/, 261042 /*261042*/, 261041 /*261041*/, 261040 /*261040*/, 260769 /*260769*/, 260768 /*260768*/, 260767 /*260767*/, 260766 /*260766*/, 260765 /*260765*/, 256105 /*256105*/, 256104 /*256104*/, 256103 /*256103*/, 256102 /*256102*/, 258345 /*258345*/, 259183 /*259183*/, 257784 /*257784*/, 256416 /*256416*/, 256267 /*256267*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(286331, 44175, 14, 0, 53037, 1, 0, 0, 'World quests completed', 22747), -- 286331 +(286124, 44023, 0, 0, 110438, 1, 1, 0, '', 22747), -- 286124 +(285703, 43721, 0, 0, 111332, 15, 0, 0, 'Elite Helarjar kvaldir slain', 22747), -- 285703 +(285680, 43527, 14, 0, 50274, 1, 0, 0, 'Aid the Moon Guard in Suramar', 22747), -- 285680 +(285763, 43526, 0, 0, 111518, 1, 0, 0, 'Ritual performed', 22747), -- 285763 +(286016, 43525, 14, 1, 51278, 1, 0, 0, 'Defeat Cordana Felsong', 22747), -- 286016 +(285738, 43525, 1, 0, 139788, 1, 0, 0, '', 22747), -- 285738 +(285709, 43524, 14, 1, 50354, 1, 0, 0, 'Defeat Advisor Melandrus', 22747), -- 285709 +(285708, 43524, 1, 0, 139782, 1, 0, 0, '', 22747), -- 285708 +(285762, 43522, 0, 0, 111517, 1, 0, 0, 'Power absorbed', 22747), -- 285762 +(285286, 43454, 0, 0, 98188, 1, 1, 0, 'Egyl the Enduring slain.', 22747), -- 285286 +(284733, 42780, 0, 1, 96759, 1, 0, 0, 'Helya defeated.', 22747), -- 284733 +(284732, 42780, 0, 0, 103045, 1, 0, 0, 'Plaguemaw slain', 22747), -- 284732 +(283480, 42063, 12, 0, 1883, 1, 0, 0, 'Defeat Blottis', 22747), -- 283480 +(283625, 42024, 0, 4, 106194, 6, 0, 0, 'Cove Skrog slain', 22747), -- 283625 +(283624, 42024, 0, 3, 89884, 1, 0, 0, '', 22747), -- 283624 +(283623, 42024, 0, 2, 89101, 1, 0, 0, '', 22747), -- 283623 +(282982, 41865, 0, 1, 91007, 1, 0, 0, 'Dargrul the Underking slain', 22747), -- 282982 +(282981, 41865, 0, 0, 103271, 1, 0, 0, 'Kraxa slain', 22747), -- 282981 +(282901, 41836, 0, 0, 98299, 1, 1, 0, 'Bodash the Hoarder slain.', 22747), -- 282901 +(282614, 41649, 1, 0, 126988, 1, 0, 0, '', 22747), -- 282614 +(282520, 41563, 0, 0, 103686, 1, 0, 0, 'Skin the Felhide Gargantuan', 22747), -- 282520 +(282503, 41549, 1, 0, 135511, 1, 0, 0, '', 22747), -- 282503 +(282494, 41537, 1, 0, 140990, 10, 0, 0, '', 22747), -- 282494 +(282467, 41511, 0, 0, 103647, 1, 0, 0, 'Felwort gathered', 22747), -- 282467 +(282383, 41443, 1, 0, 141243, 10, 0, 0, '', 22747), -- 282383 +(282185, 41305, 1, 0, 135502, 1, 0, 0, '', 22747), -- 282185 +(282172, 41294, 1, 0, 140952, 10, 0, 0, '', 22747), -- 282172 +(282170, 41292, 1, 0, 124102, 40, 0, 0, '', 22747), -- 282170 +(282166, 41288, 1, 0, 124101, 40, 0, 0, '', 22747), -- 282166 +(282125, 41253, 0, 0, 103740, 12, 0, 0, 'Migrating Highmountain Salmon speared', 22747), -- 282125 +(282013, 41200, 1, 0, 141219, 1, 0, 0, '', 22747), -- 282013 +(281827, 41093, 0, 0, 96072, 1, 1, 0, 'Durguth slain.', 22747), -- 281827 +(281053, 40678, 1, 0, 132751, 1, 0, 0, '', 22747), -- 281053 +(286017, 40675, 14, 1, 51280, 1, 0, 0, 'Defeat Advisor Vandros', 22747), -- 286017 +(285713, 40675, 1, 0, 139787, 1, 0, 0, '', 22747), -- 285713 +(281047, 40673, 1, 0, 139780, 1, 0, 0, '', 22747), -- 281047 +(281045, 40672, 14, 2, 46383, 1, 0, 0, 'Defeat Dargrul the Underking', 22747), -- 281045 +(281044, 40672, 1, 0, 132744, 4, 0, 0, '', 22747), -- 281044 +(280968, 40615, 0, 1, 100782, 1, 2, 0, 'Earn Odyn''s favor', 22747), -- 280968 +(280967, 40615, 0, 0, 100781, 1, 0, 0, 'Feast presented to Odyn', 22747), -- 280967 +(280985, 40614, 1, 3, 132464, 1, 0, 0, '', 22747), -- 280985 +(280984, 40614, 1, 2, 132463, 1, 0, 0, '', 22747), -- 280984 +(280965, 40614, 1, 0, 132462, 1, 0, 0, '', 22747), -- 280965 +(280976, 40613, 14, 1, 46342, 1, 0, 0, 'Defeat Helya', 22747), -- 280976 +(280963, 40613, 1, 0, 132440, 1, 0, 0, '', 22747), -- 280963 +(280983, 40608, 0, 2, 100822, 1, 28, 0, '', 22747), -- 280983 +(280960, 40608, 0, 1, 100765, 1, 2, 0, 'Mark of the Valkyra received', 22747), -- 280960 +(280959, 40608, 6, -1, 1948, 21000, 0, 0, 'Revered with the Valarjar', 22747), -- 280959 +(262097, 9618, 1, 0, 23919, 1, 0, 0, '', 22747), -- 262097 +(261045, 9240, 8, -1, 0, 3000000, 0, 0, '', 22747), -- 261045 +(261044, 9240, 6, -1, 529, 42000, 0, 0, '', 22747), -- 261044 +(261043, 9240, 1, 3, 14227, 4, 0, 0, '', 22747), -- 261043 +(261042, 9240, 1, 2, 7080, 6, 0, 0, '', 22747), -- 261042 +(261041, 9240, 1, 1, 14048, 8, 0, 0, '', 22747), -- 261041 +(261040, 9240, 1, 0, 22682, 8, 0, 0, '', 22747), -- 261040 +(260769, 9239, 8, -1, 0, 2000000, 0, 0, '', 22747), -- 260769 +(260768, 9239, 1, 3, 14227, 2, 0, 0, '', 22747), -- 260768 +(260767, 9239, 1, 2, 7080, 4, 0, 0, '', 22747), -- 260767 +(260766, 9239, 1, 1, 14048, 4, 0, 0, '', 22747), -- 260766 +(260765, 9239, 1, 0, 22682, 5, 0, 0, '', 22747), -- 260765 +(256105, 8735, 1, 3, 21146, 1, 0, 0, '', 22747), -- 256105 +(256104, 8735, 1, 2, 21148, 1, 0, 0, '', 22747), -- 256104 +(256103, 8735, 1, 1, 21149, 1, 0, 0, '', 22747), -- 256103 +(256102, 8735, 1, 0, 21147, 1, 0, 0, '', 22747), -- 256102 +(258345, 8112, 1, 0, 19611, 1, 0, 0, '', 22747), -- 258345 +(259183, 7509, 1, 0, 18492, 1, 0, 0, '', 22747), -- 259183 +(257784, 5888, 1, 0, 11513, 4, 0, 0, '', 22747), -- 257784 +(256416, 3084, 1, 0, 9562, 1, 0, 0, '', 22747), -- 256416 +(256267, 1955, 0, 0, 6549, 1, 0, 0, '', 22747); -- 256267 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=285763 AND `Index`=1) OR (`ID`=285763 AND `Index`=0) OR (`ID`=286016 AND `Index`=1) OR (`ID`=286016 AND `Index`=0) OR (`ID`=285738 AND `Index`=0) OR (`ID`=285709 AND `Index`=1) OR (`ID`=285709 AND `Index`=0) OR (`ID`=285708 AND `Index`=0) OR (`ID`=285762 AND `Index`=0) OR (`ID`=284733 AND `Index`=0) OR (`ID`=284732 AND `Index`=0) OR (`ID`=283625 AND `Index`=0) OR (`ID`=283623 AND `Index`=0) OR (`ID`=282185 AND `Index`=0) OR (`ID`=282013 AND `Index`=0) OR (`ID`=281053 AND `Index`=1) OR (`ID`=281053 AND `Index`=0) OR (`ID`=286017 AND `Index`=1) OR (`ID`=286017 AND `Index`=0) OR (`ID`=285713 AND `Index`=0) OR (`ID`=281047 AND `Index`=0) OR (`ID`=281045 AND `Index`=1) OR (`ID`=281045 AND `Index`=0) OR (`ID`=281044 AND `Index`=3) OR (`ID`=281044 AND `Index`=2) OR (`ID`=281044 AND `Index`=1) OR (`ID`=281044 AND `Index`=0) OR (`ID`=280968 AND `Index`=3) OR (`ID`=280968 AND `Index`=2) OR (`ID`=280968 AND `Index`=1) OR (`ID`=280968 AND `Index`=0) OR (`ID`=280967 AND `Index`=0) OR (`ID`=280976 AND `Index`=1) OR (`ID`=280976 AND `Index`=0) OR (`ID`=280963 AND `Index`=0) OR (`ID`=280960 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(285763, 1, 5818, 22747), +(285763, 0, 5817, 22747), +(286016, 1, 6259, 22747), +(286016, 0, 5754, 22747), +(285738, 0, 5685, 22747), +(285709, 1, 6257, 22747), +(285709, 0, 5674, 22747), +(285708, 0, 5675, 22747), +(285762, 0, 5795, 22747), +(284733, 0, 2101, 22747), +(284732, 0, 2101, 22747), +(283625, 0, 5624, 22747), +(283623, 0, 2101, 22747), +(282185, 0, 5940, 22747), +(282013, 0, 5526, 22747), +(281053, 1, 5691, 22747), +(281053, 0, 4293, 22747), +(286017, 1, 6258, 22747), +(286017, 0, 5677, 22747), +(285713, 0, 5677, 22747), +(281047, 0, 5670, 22747), +(281045, 1, 6261, 22747), +(281045, 0, 4291, 22747), +(281044, 3, 4290, 22747), +(281044, 2, 4289, 22747), +(281044, 1, 4288, 22747), +(281044, 0, 4287, 22747), +(280968, 3, 6263, 22747), +(280968, 2, 6262, 22747), +(280968, 1, 5781, 22747), +(280968, 0, 4268, 22747), +(280967, 0, 4268, 22747), +(280976, 1, 6260, 22747), +(280976, 0, 4261, 22747), +(280963, 0, 4262, 22747), +(280960, 0, 4257, 22747); |