diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_21_00_world.sql | 170 |
1 files changed, 170 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_21_00_world.sql b/sql/updates/world/6.x/2016_09_21_00_world.sql new file mode 100644 index 00000000000..8cb251fefb8 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_21_00_world.sql @@ -0,0 +1,170 @@ +DELETE FROM `quest_template` WHERE `ID` IN (44192 /*-Unknown-*/, 44019 /*-Unknown-*/, 43802 /*-Unknown-*/, 43759 /*-Unknown-*/, 43756 /*-Unknown-*/, 43714 /*-Unknown-*/, 43638 /*-Unknown-*/, 43569 /*-Unknown-*/, 43568 /*-Unknown-*/, 43567 /*-Unknown-*/, 43565 /*-Unknown-*/, 43564 /*-Unknown-*/, 43563 /*-Unknown-*/, 43562 /*-Unknown-*/, 43502 /*-Unknown-*/, 43426 /*-Unknown-*/, 43417 /*-Unknown-*/, 43347 /*-Unknown-*/, 43091 /*-Unknown-*/, 43027 /*-Unknown-*/, 42799 /*-Unknown-*/, 42783 /*-Unknown-*/, 42723 /*-Unknown-*/, 42270 /*-Unknown-*/, 42081 /*-Unknown-*/, 41981 /*-Unknown-*/, 41930 /*-Unknown-*/, 41895 /*-Unknown-*/, 41818 /*-Unknown-*/, 41664 /*-Unknown-*/, 41650 /*-Unknown-*/, 41648 /*-Unknown-*/, 41569 /*-Unknown-*/, 41556 /*-Unknown-*/, 41536 /*-Unknown-*/, 41531 /*-Unknown-*/, 41486 /*-Unknown-*/, 41446 /*-Unknown-*/, 41344 /*-Unknown-*/, 41327 /*-Unknown-*/, 41315 /*-Unknown-*/, 41302 /*-Unknown-*/, 41267 /*-Unknown-*/, 41240 /*-Unknown-*/, 41211 /*-Unknown-*/, 41091 /*-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 +(44192, 3, 110, 0, 110, 8000, 136, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 226059, 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: Lysanis Shadesoul', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(44019, 3, 110, 0, 110, 7637, 109, 0, 0, 0, 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, 3, 3, 0, 0, 0, 0, 0, 0, -1, 29, 'WANTED: Lieutenant Strathmar', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43802, 3, 110, 0, 110, 7334, 136, 0, 0, 0, 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, 'Watery Graves', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43759, 3, 110, 0, 110, 7558, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 223891, 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, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4867, 0, -1, 27, 'Where''s the Reef?', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43756, 3, 110, 0, 110, 7558, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218973, 0, 0, 0, 0, 0, 0, 2184773888, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1090, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 18, 'Enigmatic', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43714, 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: Worst of the Worst', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43638, 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: Silver Serpent', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43569, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 140255, 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, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Arluin''s Request', 'Locate Arluelle and give her a piece of the Arcan''dor Fruit.', 'I never thought I would need to read this...\n\n<Vanthir hefts a scroll in his hand.>\n\nArluin made... plans... in the event he fell. It is not much, but I would like to honor his last request.\n\n<Vanthir hands you the scroll.>\n\nGo to the location marked on this map. Take this Arcan''dor Fruit and give it to a woman named Arluelle. Arluin was very specific that all rewards for his work be directed to her.\n\nI think he may have known what his sacrifice meant. I was wrong about him.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43568, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33685504, 8192, 0, 0, 0, 0, 140445, 0, 0, 0, 1, 0, 0, 0, 140315, 0, 0, 0, 3, 0, 0, 0, 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, 1860, 1919, 1862, 0, 0, 20000, 20000, 20000, 0, 7, 7, 7, 7, 7, 7, 3, 3, 3, 0, 0, 0, 0, -1, 0, 'Arcan''dor, Gift of the Ancient Magi', 'Pick the Fruit of the Arcan''dor and share it with Chief Telemancer Oculeth, Arcanist Valtrois, and First Arcanist Thalyssra.', 'Thousands of years ago, as the Quel''dorei were just beginning to unravel the mysteries of the arcane, a small enclave of druids met with the first of the elven magi.\n\nIn the pale moonlight, they formed an order that would seek to bring the arcane into balance - using nature itself as a vessel. Thus the arcan''dor were created.\n\nMy masters who belonged to this order have long since faded away. Yet their legacy remains.\n\nTheir gift will mend the spirit of the shal''dorei. Let them eat, and be made whole.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43567, 2, 110, 0, 110, 7637, 0, 0, 43568, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34603008, 0, 0, 0, 0, 0, 141684, 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, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'All In', 'Complete the "All In" scenario.$B$BChief Telemancer Oculeth can begin the scenario.', 'It is time to put our plan into action.\n\nOculeth will send you, Arluin and myself into the Arcway, where we shall trigger a manastorm in the Nightflow Conduit.\n\nValtrois will stay here and prepare Shal''Aran for a massive jolt of arcane power - hopefully enough to satisfy the arcan''dor.\n\n$p... We have a saying... "To lead is to stand alone." It means only those who bear the weight of leadership can truly appreciate it.\n\nThank you for standing beside me. In truth, I do not feel alone.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43565, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 140257, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 140255, 0, 0, 0, 1, 0, 0, 0, 140257, 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, 1859, 0, 0, 0, 0, 10000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Bring Home the Beacon', 'Use the Advanced Telemancy Beacon to survey Evermoon Commons, Evermoon Bazaar, and Siren''s Vigil in Suramar City.', 'The conduit we need is in the Arcway, and security in the Arcway has doubled since your last visit.\n\nOur only reasonable option is to teleport your strike team directly in. \n\nThis is a long-range teleport to a non-anchored destination. In other words, it will be hard.\n\nTake this beacon and survey the commons in Suramar City, then return the beacon to me so I can analyze the results. \n\nThis will help me teleport you as close as possible to the conduit!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43564, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 140255, 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, 1859, 0, 0, 0, 0, 10000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Flow Control', 'Seal off the Arcway Outlets in Lunastre Lane, The Parade Grounds, and the Midnight Court.', 'If all goes as planned, the manastorm will cause the leyline to flare up, sending a great surge of energy through the arcway.\n\nIn order for the surge to reach Shal''Aran, we must seal off any outlets along the way. If we miss even one, the mission fails - and hundreds of people will be vaporized by the energy blow off.\n\nThalyssra had better be sure about this tree.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43563, 2, 110, 0, 110, 7637, 1, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 141683, 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, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Ephemeral Manastorm Projector', 'Collect $1oa Warp-Resistant Plating from Chronarch Defenders.', 'Oculeth''s theory is sound. Reckless, but sound.\n\nA small warp-field could trap and excite ambient mana in the conduit, thus creating a manastorm similar to when the arcan''dor fell out of balance.\n\nI can build a device to generate the warp-field, but I need materials.\n\nSpecifically, warp-resistant alloys - such as the armor plating of high-end security constructs in the noble district.\n\nThose constructs are deadly. If anyone owes you a favor, now is the time to call it in.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43562, 2, 110, 0, 110, 7637, 0, 0, 43563, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 141682, 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, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Giving It All We''ve Got', 'Activate all of the leyline feeds in Suramar, then speak with Valtrois.', 'The arcan''dor is drawing incredible amounts of energy.\n\nEven with the leyline feed at full capacity, we may not have the power.\n\nLet us first ensure that all potential leyline conduits connecting to Shal''Aran are active.\n\nThen I can attempt to amplify the output and hopefully satisfy this insufferable plant.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43502, 2, 110, 0, 110, 7637, 0, 0, 43562, 1, 1, 19400, 1, 1, 18350, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 34603016, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 1, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'A Change of Seasons', 'Speak with Arcanist Valtrois.', 'It is time.\n\nThe arcan''dor is preparing to mature. With a final burst of growth, this gift will be fully realized.\n\nWe must make ready the leyline feed.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43426, 3, 110, 0, 110, 7334, 109, 0, 0, 0, 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, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 0, 0, -1, 21, 'WANTED: Brogozog', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43417, 2, -1, 0, 98, -406, 107, 0, 0, 1, 1, 19400, 1, 1, 18350, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 38797312, 33562880, 0, 0, 65199, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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 Spirits Call', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', 'King Anduin Wrynn', '', '', 890, 878, 22624), -- -Unknown- +(43347, 3, 110, 0, 110, 7558, 136, 0, 0, 0, 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: Rabxach', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43091, 3, 110, 0, 110, 8000, 136, 0, 0, 0, 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: Arcanor Prime', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(43027, 3, 110, 0, 110, 8000, 136, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 226059, 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: Mortiferous', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42799, 3, 110, 0, 110, 7637, 136, 0, 0, 0, 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, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 5, 0, 0, 0, 0, 0, 0, -1, 56, 'DANGER: Oglok the Furious', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42783, 3, 110, 0, 110, 8079, 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, 4761, 0, -1, 181, 'Court of Stars: They Bloom at Night', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42723, 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, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4699, 0, -1, 182, 'Eye of Azshara: A Tough Shell', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42270, 3, 110, 0, 110, 7541, 112, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 212447, 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, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 0, 0, -1, 16, 'Scourge of the Skies', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(42081, 2, 110, 0, 110, -181, 0, 0, 0, 5, 1, 0, 0, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37748744, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'In With the New', 'Bring the newly forged High-Capacity Decoction Conduit to Deucus in Dalaran.', 'Well, here''s your new conduit. Try not to break this one, I really don''t feel like making another.$b$bOh, and tell your boss, Deucus, that he owes me big time for this.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41981, 2, -1, 0, 103, -423, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 38797312, 33562624, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Traversing the Heavens', 'Escort Farseer Nobundo through the Vortex Pinnacle.', 'If you are not opposed, $n, I would accompany you on your journey through Skywall.$b$bThere are wonders here that my eyes have never before beheld, and it would be my great honor to join you.$b$bOur quest to resurrect the mighty Thunderaan and unite the four great elemental lords will be no easy task.$b$bLead the way, Farseer, and I shall follow.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41930, 3, 110, 0, 110, 7541, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 208788, 0, 0, 0, 0, 0, 0, 41484544, 8192, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 122612, 0, 0, 0, 99, 0, 0, 0, 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, 4306, 0, -1, 25, 'Valor Calls', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41895, 3, 110, 0, 110, 7637, 115, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 208633, 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, 'The Master of Pets', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41818, 3, 110, 0, 110, 7503, 109, 0, 0, 0, 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, 3, 3, 0, 0, 0, 0, 0, 0, -1, 23, 'WANTED: Majestic Elderhorn', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41664, 3, 110, 0, 110, 7558, 126, 0, 0, 0, 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, 87, 'Vantus Rune Work Order: Dragons of Nightmare', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41650, 3, 110, 0, 110, 7502, 121, 0, 0, 0, 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, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4216, 0, -1, 105, 'Work Order: Silkweave Hood', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41648, 3, 110, 0, 110, 7541, 121, 0, 0, 0, 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, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4394, 0, -1, 107, 'Work Order: Silkweave Bracers', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41569, 3, 110, 0, 110, 7541, 124, 0, 0, 0, 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, 22624), -- -Unknown- +(41556, 3, 110, 0, 110, 7541, 131, 0, 0, 0, 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, 22624), -- -Unknown- +(41536, 3, 110, 0, 110, 7541, 119, 0, 0, 0, 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, 4627, 0, -1, 146, 'Pungent Fjarnskaggl', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41531, 3, 110, 0, 110, 7558, 119, 0, 0, 0, 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, 'Iridescent Dreamleaf', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41486, 3, 110, 0, 110, 7558, 120, 0, 0, 0, 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, 22624), -- -Unknown- +(41446, 3, 110, 0, 110, 7637, 120, 0, 0, 0, 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, 'Darkened Felslate Deposits', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41344, 3, 110, 0, 110, 7541, 124, 0, 0, 0, 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, 1948, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4394, 0, -1, 134, 'Work Order: Stormscales', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41327, 3, 110, 0, 110, 7334, 109, 0, 0, 0, 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, 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: Stormscales', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41315, 3, 110, 0, 110, 7334, 109, 0, 0, 0, 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, 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: Leystone', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41302, 3, 110, 0, 110, 7637, 119, 0, 0, 0, 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, 1859, 0, 0, 0, 0, 5000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 1, 0, 0, 0, 0, 0, 4583, 0, -1, 132, 'Work Order: Starlight Roses', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41267, 3, 110, 0, 110, 7334, 130, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 590080, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4221, 0, -1, 131, 'Work Order: Cursed Queenfish', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41240, 3, 110, 0, 110, 7503, 130, 0, 0, 0, 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, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 5, 0, 0, 0, 0, 0, 4350, 0, -1, 131, 'Work Order: Highmountain Salmon', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41211, 3, 110, 0, 110, 7546, 137, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 35193152, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4592, 0, -1, 184, 'Neltharion''s Lair: Neltharion''s Treasure', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624), -- -Unknown- +(41091, 3, 110, 0, 110, 7503, 136, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 204998, 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, 5, 0, 0, 0, 0, 0, 4550, 0, -1, 53, 'Lords of the Hills', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22624); -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (286373 /*286373*/, 286118 /*286118*/, 285821 /*285821*/, 285820 /*285820*/, 285760 /*285760*/, 285756 /*285756*/, 286415 /*286415*/, 285690 /*285690*/, 285689 /*285689*/, 285578 /*285578*/, 285577 /*285577*/, 286099 /*286099*/, 286094 /*286094*/, 286089 /*286089*/, 286088 /*286088*/, 286087 /*286087*/, 286719 /*286719*/, 286334 /*286334*/, 286567 /*286567*/, 286333 /*286333*/, 286332 /*286332*/, 286014 /*286014*/, 286013 /*286013*/, 286012 /*286012*/, 285945 /*285945*/, 285944 /*285944*/, 285943 /*285943*/, 285679 /*285679*/, 285509 /*285509*/, 285506 /*285506*/, 285505 /*285505*/, 285504 /*285504*/, 285503 /*285503*/, 285502 /*285502*/, 285501 /*285501*/, 285485 /*285485*/, 285254 /*285254*/, 285223 /*285223*/, 285037 /*285037*/, 285020 /*285020*/, 284770 /*284770*/, 284741 /*284741*/, 284740 /*284740*/, 284648 /*284648*/, 284647 /*284647*/, 284002 /*284002*/, 283287 /*283287*/, 283286 /*283286*/, 283273 /*283273*/, 283114 /*283114*/, 283113 /*283113*/, 283112 /*283112*/, 283111 /*283111*/, 283110 /*283110*/, 283109 /*283109*/, 283031 /*283031*/, 282880 /*282880*/, 282629 /*282629*/, 282615 /*282615*/, 282613 /*282613*/, 282526 /*282526*/, 282510 /*282510*/, 282493 /*282493*/, 282488 /*282488*/, 282436 /*282436*/, 282386 /*282386*/, 282235 /*282235*/, 282221 /*282221*/, 282207 /*282207*/, 282182 /*282182*/, 282147 /*282147*/, 282098 /*282098*/, 282985 /*282985*/, 282036 /*282036*/, 281826 /*281826*/, 281825 /*281825*/, 265143 /*265143*/, 260569 /*260569*/, 260568 /*260568*/, 260567 /*260567*/, 255974 /*255974*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(286373, 44192, 0, 0, 111939, 1, 1, 0, '', 22624), -- 286373 +(286118, 44019, 0, 0, 102303, 1, 1, 0, '', 22624), -- 286118 +(285821, 43802, 0, 1, 111641, 20, 0, 0, 'Saltsea Droplet slain', 22624), -- 285821 +(285820, 43802, 0, 0, 111644, 3, 0, 0, 'Restless Tides slain', 22624), -- 285820 +(285760, 43759, 0, 3, 111474, 15, 0, 0, '', 22624), -- 285760 +(285756, 43756, 0, 0, 110005, 1, 1, 0, 'Enigma Solved', 22624), -- 285756 +(286415, 43756, 0, 1, 113364, 3, 24, 0, 'Get Points', 22624), -- 286415 +(285690, 43714, 0, 4, 99611, 1, 0, 0, 'Dantallionax slain', 22624), -- 285690 +(285689, 43714, 0, 2, 111290, 1, 0, 0, '', 22624), -- 285689 +(285578, 43638, 0, 1, 98208, 1, 0, 0, 'Advisor Vandros slain', 22624), -- 285578 +(285577, 43638, 0, 0, 111052, 1, 0, 0, 'Silver Serpent slain', 22624), -- 285577 +(286099, 43569, 0, 1, 110698, 1, 2, 0, 'Share Arcan''dor Fruit with Arluelle', 22624), -- 286099 +(286094, 43569, 0, 0, 112173, 1, 0, 0, 'Locate Arluelle', 22624), -- 286094 +(286089, 43568, 0, 2, 97140, 1, 2, 0, 'Share Fruit with Thalyssra', 22624), -- 286089 +(286088, 43568, 0, 1, 103155, 1, 2, 0, 'Share Fruit with Valtrois', 22624), -- 286088 +(286087, 43568, 0, 0, 98548, 1, 0, 0, 'Share Fruit with Oculeth', 22624), -- 286087 +(286719, 43568, 1, 3, 140315, 3, 28, 0, '', 22624), -- 286719 +(286334, 43567, 0, 2, 113070, 1, 2, 0, 'Enter Shal''Aran', 22624), -- 286334 +(286567, 43567, 0, 3, 113061, 1, 28, 0, 'Arrival event', 22624), -- 286567 +(286333, 43567, 0, 1, 113062, 1, 2, 0, 'Check on Arluin', 22624), -- 286333 +(286332, 43567, 0, 0, 113069, 1, 0, 0, 'Nightflow Conduit sabotaged', 22624), -- 286332 +(286014, 43565, 0, 2, 111947, 100, 2, 0, 'Siren''s Vigil surveyed', 22624), -- 286014 +(286013, 43565, 0, 1, 111946, 100, 2, 0, 'Evermoon Bazaar surveyed', 22624), -- 286013 +(286012, 43565, 0, 0, 111945, 100, 0, 0, 'Evermoon Commons surveyed', 22624), -- 286012 +(285945, 43564, 2, 2, 252783, 1, 0, 0, 'Midnight Court outlet sealed', 22624), -- 285945 +(285944, 43564, 2, 1, 252779, 1, 0, 0, 'Parade Grounds outlet sealed', 22624), -- 285944 +(285943, 43564, 2, 0, 252776, 1, 0, 0, 'Lunastre Lane outlet sealed', 22624), -- 285943 +(285679, 43563, 1, 0, 139689, 4, 0, 0, '', 22624), -- 285679 +(285509, 43562, 0, 7, 103155, 1, 2, 0, 'Ask Valtrois to amplify the feed', 22624), -- 285509 +(285506, 43562, 14, 6, 50073, 1, 0, 0, 'Halls of the Eclipse', 22624), -- 285506 +(285505, 43562, 14, 5, 50071, 1, 0, 0, 'Falanaar Depths', 22624), -- 285505 +(285504, 43562, 14, 4, 50069, 1, 0, 0, 'Falanaar Arcway', 22624), -- 285504 +(285503, 43562, 14, 3, 50067, 1, 0, 0, 'Ley Station Aethenar', 22624), -- 285503 +(285502, 43562, 14, 2, 50065, 1, 0, 0, 'Ley Station Moonfall', 22624), -- 285502 +(285501, 43562, 14, 1, 50061, 1, 0, 0, 'Kel''balor', 22624), -- 285501 +(285485, 43562, 14, 0, 50054, 1, 0, 0, 'Elor''shan', 22624), -- 285485 +(285254, 43426, 0, 0, 91100, 1, 1, 0, 'Brogozog slain.', 22624), -- 285254 +(285223, 43347, 0, 0, 110342, 1, 1, 0, '', 22624), -- 285223 +(285037, 43091, 0, 0, 109641, 1, 0, 0, 'Arcanor Prime slain', 22624), -- 285037 +(285020, 43027, 0, 0, 93622, 1, 0, 0, 'Mortiferous slain', 22624), -- 285020 +(284770, 42799, 0, 0, 105899, 1, 1, 0, '', 22624), -- 284770 +(284741, 42783, 0, 1, 104218, 1, 0, 0, 'Advisor Melandrus slain', 22624), -- 284741 +(284740, 42783, 1, 0, 138435, 9, 0, 0, 'Cultivated Manabloom gathered', 22624), -- 284740 +(284648, 42723, 0, 1, 96028, 1, 0, 0, 'Wrath of Azshara slain', 22624), -- 284648 +(284647, 42723, 0, 0, 101467, 1, 0, 0, 'Jaggen-Ra', 22624), -- 284647 +(284002, 42270, 0, 0, 107023, 1, 0, 0, '', 22624), -- 284002 +(283287, 41981, 0, 2, 105659, 1, 2, 0, 'Thunder''s Rise explored', 22624), -- 283287 +(283286, 41981, 0, 0, 105658, 1, 2, 0, 'Nimbus Rise explored', 22624), -- 283286 +(283273, 41981, 0, 1, 105631, 1, 0, 0, 'Cyclone Summit explored', 22624), -- 283273 +(283114, 41930, 0, 5, 97949, 4, 92, 25, '', 22624), -- 283114 +(283113, 41930, 0, 4, 97948, 5, 92, 20, '', 22624), -- 283113 +(283112, 41930, 0, 3, 97947, 7, 92, 15, '', 22624), -- 283112 +(283111, 41930, 0, 2, 97946, 13, 92, 8, '', 22624), -- 283111 +(283110, 41930, 0, 1, 97945, 34, 92, 3, '', 22624), -- 283110 +(283109, 41930, 15, -1, 0, 1, 0, 0, 'Defend the Gates of Valor.', 22624), -- 283109 +(283031, 41895, 11, 0, 105250, 1, 0, 0, 'Defeat Aulier, Master of Pets', 22624), -- 283031 +(282880, 41818, 0, 0, 96410, 1, 1, 0, '', 22624), -- 282880 +(282629, 41664, 1, 0, 128990, 1, 0, 0, '', 22624), -- 282629 +(282615, 41650, 1, 0, 126990, 1, 0, 0, '', 22624), -- 282615 +(282613, 41648, 1, 0, 126994, 1, 0, 0, '', 22624), -- 282613 +(282526, 41569, 0, 0, 103686, 1, 0, 0, 'Skin the Felhide Gargantuan', 22624), -- 282526 +(282510, 41556, 1, 0, 135511, 1, 0, 0, '', 22624), -- 282510 +(282493, 41536, 1, 0, 140961, 10, 0, 0, '', 22624), -- 282493 +(282488, 41531, 1, 0, 140955, 10, 0, 0, '', 22624), -- 282488 +(282436, 41486, 0, 0, 103594, 1, 0, 0, 'Brimstone Destroyer Core mined', 22624), -- 282436 +(282386, 41446, 1, 0, 141249, 10, 0, 0, '', 22624), -- 282386 +(282235, 41344, 1, 0, 124115, 40, 0, 0, '', 22624), -- 282235 +(282221, 41327, 1, 0, 124115, 40, 0, 0, '', 22624), -- 282221 +(282207, 41315, 1, 0, 123918, 40, 0, 0, '', 22624), -- 282207 +(282182, 41302, 1, 0, 124105, 10, 0, 0, '', 22624), -- 282182 +(282147, 41267, 1, 0, 124107, 40, 0, 0, '', 22624), -- 282147 +(282098, 41240, 1, 0, 124109, 40, 0, 0, '', 22624), -- 282098 +(282985, 41211, 0, 1, 91007, 1, 1, 0, 'Dargrul the Underking slain', 22624), -- 282985 +(282036, 41211, 2, 0, 247348, 1, 0, 0, 'Treasure found.', 22624), -- 282036 +(281826, 41091, 0, 1, 96069, 1, 0, 0, 'Hill Prince Ruggu slain.', 22624), -- 281826 +(281825, 41091, 0, 0, 102886, 5, 0, 0, 'Hill Ettins slain.', 22624), -- 281825 +(265143, 24876, 0, 0, 38494, 1, 0, 0, '', 22624), -- 265143 +(260569, 8916, 8, -1, 0, 200000, 0, 0, '', 22624), -- 260569 +(260568, 8916, 1, 1, 16697, 1, 0, 0, '', 22624), -- 260568 +(260567, 8916, 1, 0, 22381, 15, 0, 0, '', 22624), -- 260567 +(255974, 1784, 1, 0, 6847, 1, 0, 0, '', 22624); -- 255974 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=286373 AND `Index`=0) OR (`ID`=286118 AND `Index`=0) OR (`ID`=285756 AND `Index`=0) OR (`ID`=285690 AND `Index`=0) OR (`ID`=285689 AND `Index`=0) OR (`ID`=285578 AND `Index`=0) OR (`ID`=285577 AND `Index`=0) OR (`ID`=286099 AND `Index`=0) OR (`ID`=286089 AND `Index`=0) OR (`ID`=286088 AND `Index`=0) OR (`ID`=286087 AND `Index`=0) OR (`ID`=286719 AND `Index`=0) OR (`ID`=286332 AND `Index`=0) OR (`ID`=285945 AND `Index`=0) OR (`ID`=285944 AND `Index`=0) OR (`ID`=285943 AND `Index`=0) OR (`ID`=285509 AND `Index`=0) OR (`ID`=285223 AND `Index`=0) OR (`ID`=285037 AND `Index`=0) OR (`ID`=285020 AND `Index`=0) OR (`ID`=284770 AND `Index`=0) OR (`ID`=284741 AND `Index`=0) OR (`ID`=284648 AND `Index`=0) OR (`ID`=284647 AND `Index`=0) OR (`ID`=284002 AND `Index`=0) OR (`ID`=283109 AND `Index`=7) OR (`ID`=283109 AND `Index`=6) OR (`ID`=283109 AND `Index`=5) OR (`ID`=283109 AND `Index`=4) OR (`ID`=283109 AND `Index`=3) OR (`ID`=283109 AND `Index`=2) OR (`ID`=283109 AND `Index`=1) OR (`ID`=283109 AND `Index`=0) OR (`ID`=283031 AND `Index`=0) OR (`ID`=282436 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(286373, 0, 2101, 22624), -- 286373 +(286118, 0, 2101, 22624), -- 286118 +(285756, 0, 6172, 22624), -- 285756 +(285690, 0, 2101, 22624), -- 285690 +(285689, 0, 2101, 22624), -- 285689 +(285578, 0, 2101, 22624), -- 285578 +(285577, 0, 2101, 22624), -- 285577 +(286099, 0, 5791, 22624), -- 286099 +(286089, 0, 5788, 22624), -- 286089 +(286088, 0, 5785, 22624), -- 286088 +(286087, 0, 5784, 22624), -- 286087 +(286719, 0, 5786, 22624), -- 286719 +(286332, 0, 5886, 22624), -- 286332 +(285945, 0, 2099, 22624), -- 285945 +(285944, 0, 2099, 22624), -- 285944 +(285943, 0, 2099, 22624), -- 285943 +(285509, 0, 2099, 22624), -- 285509 +(285223, 0, 2101, 22624), -- 285223 +(285037, 0, 2101, 22624), -- 285037 +(285020, 0, 2101, 22624), -- 285020 +(284770, 0, 6102, 22624), -- 284770 +(284741, 0, 2101, 22624), -- 284741 +(284648, 0, 2101, 22624), -- 284648 +(284647, 0, 2101, 22624), -- 284647 +(284002, 0, 2101, 22624), -- 284002 +(283109, 7, 4004, 22624), -- 283109 +(283109, 6, 4003, 22624), -- 283109 +(283109, 5, 4002, 22624), -- 283109 +(283109, 4, 4001, 22624), -- 283109 +(283109, 3, 4000, 22624), -- 283109 +(283109, 2, 3999, 22624), -- 283109 +(283109, 1, 3998, 22624), -- 283109 +(283109, 0, 3997, 22624), -- 283109 +(283031, 0, 4758, 22624), -- 283031 +(282436, 0, 6044, 22624); -- 282436 |