diff options
| -rw-r--r-- | sql/updates/world/master/2016_10_24_00_world.sql | 179 |
1 files changed, 179 insertions, 0 deletions
diff --git a/sql/updates/world/master/2016_10_24_00_world.sql b/sql/updates/world/master/2016_10_24_00_world.sql new file mode 100644 index 00000000000..cff7e9e6c42 --- /dev/null +++ b/sql/updates/world/master/2016_10_24_00_world.sql @@ -0,0 +1,179 @@ +DELETE FROM `quest_template` WHERE `ID` IN (41667 /*-Unknown-*/, 41554 /*-Unknown-*/, 42744 /*-Unknown-*/, 43617 /*-Unknown-*/, 41502 /*-Unknown-*/, 41175 /*-Unknown-*/, 42785 /*-Unknown-*/, 41570 /*-Unknown-*/, 41488 /*-Unknown-*/, 41272 /*-Unknown-*/, 41521 /*-Unknown-*/, 41610 /*-Unknown-*/, 44173 /*-Unknown-*/, 41176 /*-Unknown-*/, 41078 /*-Unknown-*/, 43193 /*-Unknown-*/, 43804 /*-Unknown-*/, 40951 /*-Unknown-*/, 41300 /*-Unknown-*/, 43641 /*-Unknown-*/, 41340 /*-Unknown-*/, 44030 /*-Unknown-*/, 41862 /*-Unknown-*/, 41242 /*-Unknown-*/, 44194 /*-Unknown-*/, 41174 /*-Unknown-*/, 41696 /*-Unknown-*/, 45775 /*-Unknown-*/, 44164 /*-Unknown-*/, 44154 /*-Unknown-*/, 44029 /*-Unknown-*/, 43642 /*-Unknown-*/, 43627 /*-Unknown-*/, 43346 /*-Unknown-*/, 42755 /*-Unknown-*/, 42019 /*-Unknown-*/, 42015 /*-Unknown-*/, 42013 /*-Unknown-*/, 41864 /*-Unknown-*/, 41687 /*-Unknown-*/, 41524 /*-Unknown-*/, 41434 /*-Unknown-*/, 41352 /*-Unknown-*/, 41208 /*-Unknown-*/, 43474 /*-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 +(41667, 3, 110, 0, 110, 7637, 126, 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, 88, 'Vantus Rune Work Order: Xavius', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41554, 3, 110, 0, 110, 7558, 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, 22810), -- -Unknown- +(42744, 3, 110, 0, 110, 7673, 137, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 215615, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4751, 0, -1, 179, 'Darkheart Thicket: Preserving the Preservers', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(43617, 3, 110, 0, 110, 7503, 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, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 48, 'WANTED: Devouring Darkness', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41502, 3, 110, 0, 110, 7558, 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, 'Leystone Basilisks', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41175, 2, 110, 0, 110, -377, 0, 0, 41176, 1, 1, 19400, 1, 1, 18350, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Fit for an Elven Queen', 'Fight your way through Suramar into the chamber that holds the crown. Inspect the crown and report your findings back to Tae''thelan.', 'The nightborne have dropped their shield allowing us to penetrate their city and learn their secrets.$b$bOne such secret I''ve discovered is a crown of immeasurable power.$b$bI''d like you to find this crown and report back to me on what it does.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(42785, 3, 110, 0, 110, 7541, 136, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 37290304, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5, 5, 0, 0, 0, 0, 0, 0, -1, 54, 'DANGER: Den Mother Ylva', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41570, 3, 110, 0, 110, 7541, 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, 22810), -- -Unknown- +(41488, 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, 0, 0, -1, 150, 'Brimstone Destroyer', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41272, 3, 110, 0, 110, 7558, 130, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 590144, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 131, 'Work Order: Mossgill Perch', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41521, 3, 110, 0, 110, 7541, 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, 22810), -- -Unknown- +(41610, 3, 110, 0, 110, 7334, 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, 0, 0, -1, 135, 'Huge Cursed Queenfish', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(44173, 2, 110, 0, 110, -409, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 193106, 0, 0, 0, 0, 1, 0, 35684424, 8388608, 0, 0, 0, 0, 137642, 141071, 141889, 0, 5, 1, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'A Call to Battle', 'Win 4 Battleground matches.', 'The favorite star of warlords and generals dominates the sky, offering good fortune to tacticians everywhere. Some say that the battle star hones the instincts of commanders to the point of near-prophecy. If ever you were going to test yourself on the field of battle, now is the time.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41176, 2, 110, 0, 110, -377, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 223876, 0, 0, 0, 0, 1, 0, 35651592, 8192, 0, 0, 0, 0, 131740, 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, 'Sifting Through the Rubble', 'Survey different areas around Suramar until you find the $1oa missing Jewels of the Crown.', 'Then I believe it''s clear what we must do next. Find the jewels.$b$bThey''re bound to be here somewhere in Suramar, so we better start looking.$b$bI''ll coordinate the search from here, while you and my assistants look for the jewels.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41078, 3, 110, 0, 110, 7503, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 206438, 0, 0, 0, 0, 0, 0, 36241664, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 3, 0, 0, 0, 0, 0, 4842, 0, -1, 23, 'Munitions Testing', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(43193, 3, 110, 0, 110, 7334, 112, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 226983, 0, 0, 0, 0, 0, 0, 37290304, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 0, -1, 16, 'Calamitous Intent', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(43804, 3, 110, 0, 110, 7334, 136, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 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, 1894, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 4872, 0, -1, 52, 'Hate the Hatecoil', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(40951, 3, 110, 0, 110, 7503, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 206660, 0, 0, 0, 0, 0, 0, 41484544, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 3, 0, 0, 0, 0, 0, 4340, 0, -1, 23, 'Bitestone Bazaar', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41300, 3, 110, 0, 110, 7541, 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, 4779, 0, -1, 146, 'Singed Fjarnskaggl', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(43641, 3, 110, 0, 110, 7855, 137, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 35192832, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 30000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4837, 0, -1, 185, 'The Arcway: Wandering Plague', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41340, 3, 110, 0, 110, 7541, 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, 4276, 0, -1, 142, 'Perfect Storm Drake Scale', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(44030, 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: Guardian Thor''el', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41862, 3, 110, 0, 110, 7558, 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, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 5, 'Only Pets Can Prevent Forest Fires', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41242, 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, 22810), -- -Unknown- +(44194, 3, 110, 0, 110, 8000, 136, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 218010, 0, 0, 0, 0, 0, 0, 37290304, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 0, 0, -1, 52, 'DANGER: Torrentius', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41174, 2, 110, 0, 110, -377, 0, 0, 41175, 1, 1, 19400, 1, 1, 18350, 0, 0, 0, 207606, 0, 0, 0, 0, 1, 0, 35651592, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Worth Its Weight', 'Meet with Tae''thelan in Suramar.', '$n, if you were a crate of black trilobites, where do you think I would have put you?$b$b<Dariness begins looking around the shop.>$b$bOh, that reminds me. Tae''thelan has requested your presence. He''s onto something in Suramar and needs your help.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41696, 3, 110, 0, 110, 7503, 136, 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, 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: Mawat''aki', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(45775, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1.5, 0, 0, 1.5, 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, 'FLAG (DNT)', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(44164, 2, 110, 0, 110, -409, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 193101, 0, 0, 0, 0, 1, 0, 35684360, 0, 0, 0, 0, 0, 139486, 140176, 0, 0, 1, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'A Burning Path Through Time', 'Complete 5 Timewalking dungeons.', 'The blazing star shines upon the land, searing the earth and parching the landscape. This star is relentless, malevolent almost. While its influence holds, new paths may open up, to distant places and even distant times. No sage truly understands the nature of this sign, but fortune favors the daring.', '', '', 1273, 0, 0, 0, 1, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(44154, 2, 110, 0, 110, -406, 107, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33619976, 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, 'The Rite of the Executioner', 'Interact with the Pile of Skulls and complete the Rite of the Executioner in the crypt near Morgan''s Plot in Deadwind Pass.', 'The skulls have been gathered and the ritual area is prepared.\n\nAll that is left is to perform the incantation, and Ulthalesh will become imbued with the essence of the Executioner.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(44029, 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: Hertha Grimdottir', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(43642, 3, 110, 0, 110, 7805, 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, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4838, 0, -1, 180, 'Black Rook Hold: The Sorrow', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(43627, 3, 110, 0, 110, 7541, 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, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 4, 0, 0, 0, 0, 0, 0, -1, 49, 'WANTED: Tiptog the Lost', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(43346, 3, 110, 0, 110, 7558, 136, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 226059, 0, 0, 0, 0, 1, 0, 37290304, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 0, 0, -1, 55, 'DANGER: Ealdis', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(42755, 3, 110, 0, 110, 8040, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4699, 0, -1, 182, 'Eye of Azshara: Azsunian Pearls', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(42019, 3, 110, 0, 110, 7334, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 209760, 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, 3, 0, 0, 0, 0, 0, 4223, 0, -1, 21, 'Tip the Scales', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(42015, 3, 110, 0, 110, 7637, 115, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 209711, 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, 1859, 0, 0, 0, 0, 5000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 1, 0, 0, 0, 0, 0, 0, 0, -1, 5, 'Threads of Fate', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(42013, 3, 110, 0, 110, 7541, 109, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 209589, 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, 3, 0, 0, 0, 0, 0, 4471, 0, -1, 25, 'The Helmouth', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41864, 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: Crystalline Crusher', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41687, 3, 110, 0, 110, 7503, 115, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 207213, 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, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 5, 'Snail Fight!', 'Defeat Grixis Tinypop in a pet battle.', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41524, 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, 151, 'Felwort', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41434, 3, 110, 0, 110, 7334, 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, 4194, 0, -1, 148, 'Glowing Leystone Deposits', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41352, 3, 110, 0, 110, 7637, 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, 149, 'Felslate Basilisks', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(41208, 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, 150, 'Brimstone Destroyer', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22810), -- -Unknown- +(43474, 0, 110, 0, 110, 7502, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 219723, 0, 0, 0, 0, 1, 0, 35651592, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Experimental Potion: Test Subjects Needed', '', '', '', '', 1149, 0, 0, 0, 150, 0, 0, 0, '', '', '', '', 890, 878, 22810); -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (282632 /*282632*/, 282508 /*282508*/, 286780 /*286780*/, 284675 /*284675*/, 285554 /*285554*/, 282452 /*282452*/, 282042 /*282042*/, 284744 /*284744*/, 282527 /*282527*/, 282438 /*282438*/, 282152 /*282152*/, 282477 /*282477*/, 282565 /*282565*/, 286329 /*286329*/, 282043 /*282043*/, 281925 /*281925*/, 281806 /*281806*/, 281859 /*281859*/, 281804 /*281804*/, 285092 /*285092*/, 285824 /*285824*/, 281748 /*281748*/, 281747 /*281747*/, 281736 /*281736*/, 281445 /*281445*/, 281729 /*281729*/, 282180 /*282180*/, 285586 /*285586*/, 285585 /*285585*/, 282231 /*282231*/, 286131 /*286131*/, 282974 /*282974*/, 282100 /*282100*/, 286375 /*286375*/, 282679 /*282679*/, 286324 /*286324*/, 286312 /*286312*/, 286305 /*286305*/, 286130 /*286130*/, 285592 /*285592*/, 285590 /*285590*/, 285564 /*285564*/, 285222 /*285222*/, 284703 /*284703*/, 284702 /*284702*/, 283614 /*283614*/, 283403 /*283403*/, 283402 /*283402*/, 283401 /*283401*/, 283399 /*283399*/, 283398 /*283398*/, 283397 /*283397*/, 283396 /*283396*/, 283381 /*283381*/, 285495 /*285495*/, 283369 /*283369*/, 283368 /*283368*/, 283367 /*283367*/, 283366 /*283366*/, 283365 /*283365*/, 282980 /*282980*/, 282979 /*282979*/, 282658 /*282658*/, 282480 /*282480*/, 282373 /*282373*/, 282243 /*282243*/, 282024 /*282024*/, 255706 /*255706*/, 259982 /*259982*/, 259981 /*259981*/, 259980 /*259980*/, 259979 /*259979*/, 260480 /*260480*/, 260479 /*260479*/, 260478 /*260478*/, 260477 /*260477*/, 259238 /*259238*/, 259237 /*259237*/, 259236 /*259236*/, 259235 /*259235*/, 258644 /*258644*/, 258643 /*258643*/, 258642 /*258642*/, 258641 /*258641*/, 258730 /*258730*/, 258729 /*258729*/, 258728 /*258728*/, 258727 /*258727*/, 258932 /*258932*/, 258931 /*258931*/, 258930 /*258930*/, 258929 /*258929*/, 258485 /*258485*/, 258484 /*258484*/, 258483 /*258483*/, 258482 /*258482*/, 260931 /*260931*/, 260930 /*260930*/, 260929 /*260929*/, 259645 /*259645*/, 259644 /*259644*/, 256469 /*256469*/, 256587 /*256587*/, 257717 /*257717*/, 257794 /*257794*/, 256694 /*256694*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(282632, 41667, 1, 0, 128991, 1, 0, 0, '', 22810), -- 282632 +(282508, 41554, 1, 0, 135511, 1, 0, 0, '', 22810), -- 282508 +(286780, 42744, 0, 1, 99192, 1, 0, 0, 'Shade of Xavius defeated', 22810), -- 286780 +(284675, 42744, 3, 0, 108460, 5, 1, 0, 'Revive Preservers', 22810), -- 284675 +(285554, 43617, 0, 0, 100495, 1, 1, 0, 'Devouring Darkness slain.', 22810), -- 285554 +(282452, 41502, 1, 0, 134104, 40, 0, 0, '', 22810), -- 282452 +(282042, 41175, 14, 0, 47157, 1, 0, 0, 'Crown of Mavrana Mooncrest', 22810), -- 282042 +(284744, 42785, 0, 0, 108790, 1, 1, 0, '', 22810), -- 284744 +(282527, 41570, 0, 0, 103686, 1, 0, 0, 'Skin the Felhide Gargantuan', 22810), -- 282527 +(282438, 41488, 0, 0, 103594, 1, 0, 0, 'Brimstone Destroyer Core mined', 22810), -- 282438 +(282152, 41272, 1, 0, 124108, 40, 0, 0, '', 22810), -- 282152 +(282477, 41521, 0, 0, 103647, 1, 0, 0, 'Felwort gathered', 22810), -- 282477 +(282565, 41610, 1, 0, 134565, 10, 0, 0, '', 22810), -- 282565 +(286329, 44173, 14, 0, 53035, 1, 0, 0, 'Battlegrounds won', 22810), -- 286329 +(282043, 41176, 1, 0, 134114, 6, 0, 0, '', 22810), -- 282043 +(281925, 41078, 0, 3, 97957, 5, 2, 0, 'Icefang Packleader slain', 22810), -- 281925 +(281806, 41078, 0, 0, 97976, 5, 2, 0, 'Bonebeak Hawk slain', 22810), -- 281806 +(281859, 41078, 2, 2, 246975, 1, 2, 0, 'Grab a prototype from Razik''s weapon rack', 22810), -- 281859 +(281804, 41078, 3, 1, 99468, 1, 0, 0, 'Speak to Gertie', 22810), -- 281804 +(285092, 43193, 0, 0, 109331, 1, 0, 0, '', 22810), -- 285092 +(285824, 43804, 0, 0, 111632, 15, 0, 0, 'Hatecoil Naga slain', 22810), -- 285824 +(281748, 40951, 0, 3, 102827, 15, 92, 7, '', 22810), -- 281748 +(281747, 40951, 2, 2, 246874, 10, 92, 10, 'Baby Basilisks released', 22810), -- 281747 +(281736, 40951, 2, 1, 246865, 20, 92, 5, '', 22810), -- 281736 +(281445, 40951, 0, 0, 98653, 15, 92, 7, '', 22810), -- 281445 +(281729, 40951, 15, -1, 0, 1, 0, 0, 'Havoc wrought', 22810), -- 281729 +(282180, 41300, 1, 0, 135500, 10, 0, 0, '', 22810), -- 282180 +(285586, 43641, 0, 1, 98208, 1, 0, 0, 'Advisor Vandros slain', 22810), -- 285586 +(285585, 43641, 0, 0, 111057, 1, 0, 0, 'The Rat King slain', 22810), -- 285585 +(282231, 41340, 1, 0, 134814, 8, 0, 0, '', 22810), -- 282231 +(286131, 44030, 0, 0, 110944, 1, 1, 0, '', 22810), -- 286131 +(282974, 41862, 11, 0, 105093, 1, 0, 0, 'Put Out the Forest Fire', 22810), -- 282974 +(282100, 41242, 1, 0, 135511, 1, 0, 0, '', 22810), -- 282100 +(286375, 44194, 0, 0, 102064, 1, 1, 0, '', 22810), -- 286375 +(282679, 41696, 0, 0, 104517, 1, 1, 0, 'Mawat''aki slain.', 22810), -- 282679 +(286324, 44164, 14, 0, 53000, 1, 0, 0, 'Timewalking dungeons completed', 22810), -- 286324 +(286312, 44154, 0, 1, 113001, 1, 0, 0, 'Essence of the Executioner', 22810), -- 286312 +(286305, 44154, 0, 0, 112862, 1, 0, 0, 'Ritual completed', 22810), -- 286305 +(286130, 44029, 0, 0, 103223, 1, 1, 0, '', 22810), -- 286130 +(285592, 43642, 0, 4, 99611, 1, 0, 0, 'Dantalionax slain', 22810), -- 285592 +(285590, 43642, 14, 2, 50285, 1, 0, 0, 'General Tel''arn and Ranger General Feleor slain', 22810), -- 285590 +(285564, 43627, 0, 0, 93166, 1, 1, 0, 'Tiptog the Lost slain.', 22810), -- 285564 +(285222, 43346, 0, 0, 110367, 1, 1, 0, '', 22810), -- 285222 +(284703, 42755, 0, 1, 96028, 1, 0, 0, 'Wrath of Azshara slain', 22810), -- 284703 +(284702, 42755, 1, 0, 138398, 5, 0, 0, 'Massive Azsunian Pearls claimed', 22810), -- 284702 +(283614, 42019, 1, 3, 136822, 17, 92, 6, '', 22810), -- 283614 +(283403, 42019, 0, 6, 89811, 25, 92, 4, 'Minus Mob Killed', 22810), -- 283403 +(283402, 42019, 0, 5, 89808, 10, 92, 10, '', 22810), -- 283402 +(283401, 42019, 2, 4, 239774, 20, 92, 5, 'Steal Trident', 22810), -- 283401 +(283399, 42019, 0, 1, 89802, 4, 92, 25, 'Giant Mob Killed', 22810), -- 283399 +(283398, 42019, 0, 2, 89803, 13, 92, 8, 'Heavy Mob Killed', 22810), -- 283398 +(283397, 42019, 0, 0, 89025, 17, 92, 6, 'Normal Mobs killed', 22810), -- 283397 +(283396, 42019, 15, -1, 0, 1, 0, 0, 'Disrupt the Hatecoil Warcamp', 22810), -- 283396 +(283381, 42015, 11, 0, 105779, 1, 0, 0, 'Defeat the Felsoul Seer', 22810), -- 283381 +(285495, 42013, 0, 4, 105749, 13, 92, 8, '', 22810), -- 285495 +(283369, 42013, 0, 3, 105751, 5, 92, 20, '', 22810), -- 283369 +(283368, 42013, 0, 2, 105532, 25, 92, 4, '', 22810), -- 283368 +(283367, 42013, 0, 1, 105748, 17, 92, 6, '', 22810), -- 283367 +(283366, 42013, 0, 0, 105746, 13, 92, 8, '', 22810), -- 283366 +(283365, 42013, 15, -1, 0, 1, 0, 0, 'Break the kvaldir forces.', 22810), -- 283365 +(282980, 41864, 0, 1, 91007, 1, 0, 0, 'Dargrul the Underking slain', 22810), -- 282980 +(282979, 41864, 0, 0, 103247, 1, 0, 0, 'Ultanok slain', 22810), -- 282979 +(282658, 41687, 11, 0, 104553, 1, 0, 0, 'Defeat Odrogg', 22810), -- 282658 +(282480, 41524, 0, 0, 103647, 1, 0, 0, 'Felwort gathered', 22810), -- 282480 +(282373, 41434, 1, 0, 141223, 10, 0, 0, '', 22810), -- 282373 +(282243, 41352, 1, 0, 134105, 40, 0, 0, '', 22810), -- 282243 +(282024, 41208, 0, 0, 103594, 1, 0, 0, 'Brimstone Destroyer Core mined', 22810), -- 282024 +(255706, 29051, 0, 0, 51763, 1, 0, 0, 'Try out Winterspring Cat Toy', 22810), -- 255706 +(259982, 9092, 1, 3, 15407, 2, 0, 0, '', 22810), -- 259982 +(259981, 9092, 1, 2, 14342, 3, 0, 0, '', 22810), -- 259981 +(259980, 9092, 1, 1, 22373, 8, 0, 0, '', 22810), -- 259980 +(259979, 9092, 1, 0, 22363, 1, 0, 0, '', 22810), -- 259979 +(260480, 9091, 1, 3, 20725, 1, 0, 0, '', 22810), -- 260480 +(260479, 9091, 1, 2, 15407, 5, 0, 0, '', 22810), -- 260479 +(260478, 9091, 1, 1, 22373, 8, 0, 0, '', 22810), -- 260478 +(260477, 9091, 1, 0, 22364, 1, 0, 0, '', 22810), -- 260477 +(259238, 9090, 1, 3, 15407, 2, 0, 0, '', 22810), -- 259238 +(259237, 9090, 1, 2, 14342, 3, 0, 0, '', 22810), -- 259237 +(259236, 9090, 1, 1, 22373, 12, 0, 0, '', 22810), -- 259236 +(259235, 9090, 1, 0, 22365, 1, 0, 0, '', 22810), -- 259235 +(258644, 9089, 1, 3, 20725, 1, 0, 0, '', 22810), -- 258644 +(258643, 9089, 1, 2, 15407, 5, 0, 0, '', 22810), -- 258643 +(258642, 9089, 1, 1, 22373, 12, 0, 0, '', 22810), -- 258642 +(258641, 9089, 1, 0, 22361, 1, 0, 0, '', 22810), -- 258641 +(258730, 9088, 1, 3, 20725, 2, 0, 0, '', 22810), -- 258730 +(258729, 9088, 1, 2, 15407, 6, 0, 0, '', 22810), -- 258729 +(258728, 9088, 1, 1, 22373, 15, 0, 0, '', 22810), -- 258728 +(258727, 9088, 1, 0, 22360, 1, 0, 0, '', 22810), -- 258727 +(258932, 9087, 1, 3, 20725, 1, 0, 0, '', 22810), -- 258932 +(258931, 9087, 1, 2, 15407, 8, 0, 0, '', 22810), -- 258931 +(258930, 9087, 1, 1, 22373, 20, 0, 0, '', 22810), -- 258930 +(258929, 9087, 1, 0, 22359, 1, 0, 0, '', 22810), -- 258929 +(258485, 9086, 1, 3, 20725, 2, 0, 0, '', 22810), -- 258485 +(258484, 9086, 1, 2, 15407, 6, 0, 0, '', 22810), -- 258484 +(258483, 9086, 1, 1, 22373, 25, 0, 0, '', 22810), -- 258483 +(258482, 9086, 1, 0, 22350, 1, 0, 0, '', 22810), -- 258482 +(260931, 8920, 8, -1, 0, 200000, 0, 0, '', 22810), -- 260931 +(260930, 8920, 1, 1, 16735, 1, 0, 0, '', 22810), -- 260930 +(260929, 8920, 1, 0, 22381, 15, 0, 0, '', 22810), -- 260929 +(259645, 8585, 1, 1, 21024, 20, 0, 0, '', 22810), -- 259645 +(259644, 8585, 1, 0, 21027, 1, 0, 0, '', 22810), -- 259644 +(256469, 8302, 1, 0, 20384, 200, 0, 0, '', 22810), -- 256469 +(256587, 8299, 4, -1, 392, 297, 0, 0, '', 22810), -- 256587 +(257717, 8047, 1, 0, 19585, 1, 0, 0, '', 22810), -- 257717 +(257794, 8046, 1, 0, 19579, 1, 0, 0, '', 22810), -- 257794 +(256694, 2967, 1, 0, 6064, 1, 0, 0, '', 22810); -- 256694 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=286780 AND `Index`=0) OR (`ID`=284675 AND `Index`=0) OR (`ID`=282042 AND `Index`=0) OR (`ID`=284744 AND `Index`=0) OR (`ID`=282438 AND `Index`=0) OR (`ID`=281859 AND `Index`=0) OR (`ID`=281804 AND `Index`=0) OR (`ID`=285092 AND `Index`=0) OR (`ID`=285586 AND `Index`=0) OR (`ID`=285585 AND `Index`=0) OR (`ID`=282974 AND `Index`=0) OR (`ID`=286375 AND `Index`=0) OR (`ID`=286305 AND `Index`=0) OR (`ID`=285590 AND `Index`=0) OR (`ID`=285222 AND `Index`=0) OR (`ID`=284703 AND `Index`=0) OR (`ID`=283396 AND `Index`=0) OR (`ID`=283381 AND `Index`=0) OR (`ID`=282658 AND `Index`=0) OR (`ID`=282024 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(286780, 0, 2101, 22810), +(284675, 0, 2100, 22810), +(282042, 0, 4592, 22810), +(284744, 0, 2101, 22810), +(282438, 0, 6044, 22810), +(281859, 0, 2099, 22810), +(281804, 0, 2099, 22810), +(285092, 0, 2101, 22810), +(285586, 0, 2101, 22810), +(285585, 0, 2101, 22810), +(282974, 0, 4724, 22810), +(286375, 0, 2101, 22810), +(286305, 0, 5866, 22810), +(285590, 0, 2101, 22810), +(285222, 0, 2101, 22810), +(284703, 0, 2101, 22810), +(283396, 0, 3219, 22810), +(283381, 0, 4829, 22810), +(282658, 0, 4649, 22810), +(282024, 0, 6044, 22810); |