diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_12_00_world.sql | 102 |
1 files changed, 102 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_12_00_world.sql b/sql/updates/world/6.x/2016_09_12_00_world.sql new file mode 100644 index 00000000000..e54f8965f22 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_12_00_world.sql @@ -0,0 +1,102 @@ +DELETE FROM `quest_template` WHERE `ID` IN (44479 /*-Unknown-*/, 44416 /*-Unknown-*/, 44415 /*-Unknown-*/, 44156 /*-Unknown-*/, 44152 /*-Unknown-*/, 43753 /*-Unknown-*/, 43640 /*-Unknown-*/, 43614 /*-Unknown-*/, 43362 /*-Unknown-*/, 43361 /*-Unknown-*/, 43360 /*-Unknown-*/, 42982 /*-Unknown-*/, 42939 /*-Unknown-*/, 42781 /*-Unknown-*/, 42725 /*-Unknown-*/, 41703 /*-Unknown-*/, 41643 /*-Unknown-*/, 41560 /*-Unknown-*/, 41552 /*-Unknown-*/, 41534 /*-Unknown-*/, 41520 /*-Unknown-*/, 41501 /*-Unknown-*/, 41427 /*-Unknown-*/, 41416 /*-Unknown-*/, 41354 /*-Unknown-*/, 41228 /*-Unknown-*/, 40592 /*-Unknown-*/, 40125 /*-Unknown-*/, 39790 /*-Unknown-*/, 38807 /*-Unknown-*/, 30482 /*-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 +(44479, 2, 110, 18420, 110, -427, 98, 0, 0, 7, 3, 1746000, 7, 3, 823000, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37748736, 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, 'Ravencrest''s Legacy', 'Experience Ravencrest''s Legacy at Black Rook Hold in Val''sharah.', 'Years later, as the War of the Ancients raged on and the Burning Legion''s grip upon this world took hold, Illidan would meet a military leader known as Kur''talos Ravencrest. He too would see the potential within Illidan, eventually promoting him to captain of the Moon Guard: a powerful group of night elf sorcerers.$B$BWe must experience this memory in Black Rook Hold, located on the western shores of Val''sharah.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(44416, 2, -1, 18434, 98, 8406, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 38797312, 8192, 0, 0, 72964, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Hunter of Night', 'Defeat Malvingeroth', 'A glorious battle indeed!\n\nIf I am correct, we can expect something a bit more deadly at any moment.\n\nThe Legion often uses fodder such as these to prepare the way for a more worthy foe.\n\nMy axe is sharp and ready.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', 'Malvingeroth', '', '', 890, 878, 22566), -- -Unknown- +(44415, 2, -1, 0, 98, 8406, 0, 0, 44416, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37748736, 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, 'The Red Axe', 'Close the Unstable Portals and make your way to Broxigar the Red.', 'Broxigar the Red is cornered on the bridge. I am not sure he would ever admit that he needs our help, but I feel it only proper to lend him our aid.\n\nIf you wish to assist our ally, I would be humbled to accompany you in this endeavor.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(44156, 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, 2, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Another Arcan''dor Closes...', 'Return to Shal''aran.', 'I hope you have a better understanding of what is at stake.\n\nCome. There is no more for us to do here.\n\nMeet me in Shal''aran and we will discuss what steps we may take next.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(44152, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 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, 2, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'A Growing Crisis', 'Meet Valewalker Farodin at the Temple of Fala''dora using the teleporter in Shal''aran.', 'The Arcan''dor is failing.\n\nThis energy was once bound in its boughs and fueled its growth. There was balance, between life and arcane.\n\nNow that energy is breaking free. When the heart can no longer hold it, this tree will kill every living thing in this hall.\n\nI have seen this happen before and I must find a way to stop it from happening again. \n\nWe must go to the tree that came before. Its bones can guide us.\n\nMeet me at the temple of Fal''adora. We will descend together.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(43753, 3, 110, 0, 110, 7558, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218970, 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, 1090, 1883, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 3, 0, 0, 0, 0, 4273, 0, -1, 18, 'Ley Race', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(43640, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 4837, 0, -1, 185, 'The Arcway: Creeping Suspicions', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(43614, 3, 110, 0, 110, 7334, 135, 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, 4, 4, 0, 0, 0, 0, 0, 0, -1, 47, 'WANTED: Vorthax', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(43362, 2, 110, 0, 110, 8026, 62, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 225066, 0, 0, 0, 0, 1, 0, 35651592, 0, 0, 0, 0, 0, 140444, 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, 6, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'The Stuff of Dreams', 'Collect Purified Life Essence from the Emerald Dream, hidden inside the Emerald Nightmare Raid.', 'This arcan''dor is one of an ancient species. They were not bred, but created. In them the arcane and primitive druidic magics merged into something greater than both.\n\nThe arcane will soon devour it whole.\n\nWe can restore balance, but it will require wild magic. Magic trapped in another realm.\n\nYou must enter the Emerald Dream- the pure, unsullied vision of Azeroth - and bring back the essence of life itself.\n\nOnly then can the arcan''dor find stability and begin to thrive once more.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(43361, 2, 110, 0, 110, 7637, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 219956, 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, 1859, 0, 0, 0, 0, 5000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'Fragments of Disaster', 'Collect 5 Crystallized Bark.', 'In the hall beyond rests the bones of the failed arcan''dor.\n\nI will take fragments of the crystallized tree and attempt to read them. We must discover the root cause of this destruction.\n\nOnly then do we have any hope of preventing this disaster from repeating itself.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(43360, 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, 5000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'The Shardmaidens', 'Slay 6 Shardmaidens in the Shattered Locus.', 'Long have I walked this land and I have seen many forms of corruption.\n\nThe creatures that wander this hall are twisted by the magics unleashed by the failed arcan''dor. These dryads have lost their way, and cannot be saved.\n\nYou must destroy them. End their suffering.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(42982, 2, -1, 0, 98, -406, 107, 0, 0, 7, 1, 582000, 7, 1, 274350, 218022, 0, 0, 218022, 0, 0, 0, 0, 1, 0, 36700160, 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, 18875469, 0, 'The Victor''s Spoils', 'Raise your weapon and be recognized in Stormwind Keep.', 'It takes a true hero to put their life on the line day after day in defense of their home so that others do not have to.$B$BYou have dutifully safeguarded the people and interests of the Alliance, never faltering in your courage or devotion.$B$BAs a small token of our appreciation for your valiance, please turn to the gathered heroes before you, raise your weapon high, and be recognized.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(42939, 2, -1, 0, 98, -406, 107, 0, 40495, 1, 1, 19400, 1, 1, 18350, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37748736, 8448, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Tracking Down Uthalesh', 'Take the logbook to Calydus in Dreadscar Rift.', 'The logbook contains the latest information on Uthalesh. It appears to have been written by an extremely agitated, excited, or psychotic imp and is barely legible. Take this to Calydus for translation.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(42781, 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: Disarming the Watch', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(42725, 3, 110, 0, 110, 7637, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 222731, 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, 1859, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 4, 0, 0, 0, 0, 0, 4884, 0, -1, 51, 'Sharing the Wealth', 'Collect 20 Bottles of Arcwine.', 'Lately there have been a disturbing array of changes involving our most precious resource, Arcwine. \n\nI imagine Thalyssra has thoroughly educated you about what happens when a Nightborne does not have access to a source of power like Arcwine.\n\nWith the presence of the demons came rationing. There are many who do not have enough to sustain themselves.\n\nBring me as much Arcwine as you can carry. I will see that it gets to the right people.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41703, 3, 110, 0, 110, 7503, 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, 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: Ormagrogg', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41643, 3, 110, 0, 110, 7637, 117, 0, 0, 0, 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, 99, 'Work Order: Battlebound Leggings', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41560, 3, 110, 0, 110, 7503, 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, 22566), -- -Unknown- +(41552, 3, 110, 0, 110, 7334, 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, 22566), -- -Unknown- +(41534, 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, 4469, 0, -1, 146, 'Brambly Fjarnskaggl', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41520, 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, 0, 0, -1, 151, 'Felwort', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41501, 3, 110, 0, 110, 7334, 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, 148, 'Leystone Basilisks', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41427, 3, 110, 0, 110, 7541, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 206502, 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, 4697, 0, -1, 25, 'Get Vrekt', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41416, 3, 110, 0, 110, 7503, 109, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 207184, 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, 1828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 3, 0, 0, 0, 0, 0, 4604, 0, -1, 23, 'Retake the Skyhorn', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41354, 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, 4932, 0, -1, 149, 'Shattered Felslate Seams', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(41228, 3, 110, 0, 110, 7503, 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, 145, 'Foxflower Cluster', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(40592, 2, 110, 0, 110, 7637, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37814280, 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, 'Rusty Release DISABLED', 'Release Dagmyr and 5 Vrykul Prisoners in Azuregale Bay.', 'You fight alongside Brandolf, $r?$B$B<Dagmyr looks you over for a moment.>$B$BPerhaps there is more to you than what I see before me.$B$BWould you two get me out of this cage? I cannot slay naga from within these rusted confines.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(40125, 2, 110, 0, 110, 7637, 0, 0, 0, 5, 1, 194000, 5, 1, 182850, 223826, 0, 0, 0, 0, 0, 0, 0, 1, 0, 33554432, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Branch of the Arcan''dor', 'Speak with Thalyssra.', 'You have used the spellstone of Kel''danath to soothe countless withered. Yet it contains merely a shade of the arcan''dor''s power, drawn from its slumbering seed. \n\n<Thalyssra holds aloft a gleaming white branch.>\n\nThis fell from the tree. Though it is severed, it is not dead - invisible threads of magic bind all pieces of the arcan''dor together.\n\nI have enchanted this branch with a new iteration of Kel''danath''s charm spell. With it, you can mend the arcane essence of even more withered. Use it well.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(39790, 2, 110, 0, 110, -408, 0, 0, 39763, 5, 1, 194000, 5, 1, 182850, 0, 0, 0, 0, 0, 0, 128852, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 128852, 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, 'Infernal Brimstone Theory', 'Take the brimstone sample to Matthew Rabis in the Underbelly.', 'I''ve gone through all the research ye gathered for me and I''ve come up with a theory. As we know, the ore in this world develops over time, through pressure and environmental changes.$b$bBut the Infernal Brimstone ye gave me had its growth accelerated through demonic magic, much like the saronite of Icecrown.$b$bIf we''re wantin'' to test this out, we''ll have to get the help of some magic-users.$b$bTake this brimstone back and go see Matthew Rabis. He may know how to breathe life into it.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(38807, 2, 110, 0, 110, -408, 0, 0, 39790, 5, 1, 0, 0, 1, 182850, 191969, 0, 0, 191969, 0, 0, 0, 0, 1, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Infernal Brimstone Analysis', 'Collect the reports from Mama Diggs'' apprentices in Icecrown, Deepholm and Twilight Highlands.', 'In order to mine Infernal Brimstone, we first need to understand the way in which ore comes into being. I currently have three of my apprentices doing research on different ores around the world.$b$bFind Forinn Stoneheart in Deepholm, Rhol Landers in Twilight Highlands and Krul Rockhorn in Icecrown and collect any information they''ve gathered on the ore at those locations.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 22566), -- -Unknown- +(30482, 2, 90, 0, 90, 5840, 0, 0, 0, 6, 1, 228000, 6, 1, 700, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 134746112, 64, 0, 0, 45785, 0, 90625, 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, 1269, 0, 0, 0, 0, 20000, 0, 0, 0, 0, 7, 7, 7, 7, 7, 6, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'The Soul-Gatherer', 'Kill Shadowmaster Sydow and recover the beads from his corpse.', 'A single large mogu performing a ritual on the lake caught your attention while you were killing the other mogu in the area. It seems unwise to let his ritual complete.', '', '', 738, 0, 0, 0, 2, 0, 0, 0, '', '', '', '', 890, 878, 22566); -- -Unknown- + +DELETE FROM `quest_objectives` WHERE `ID` IN (286656 /*286656*/, 286620 /*286620*/, 286616 /*286616*/, 285753 /*285753*/, 285584 /*285584*/, 285583 /*285583*/, 285551 /*285551*/, 285234 /*285234*/, 286321 /*286321*/, 286310 /*286310*/, 285233 /*285233*/, 285232 /*285232*/, 285010 /*285010*/, 284735 /*284735*/, 284734 /*284734*/, 284650 /*284650*/, 282703 /*282703*/, 282608 /*282608*/, 282517 /*282517*/, 282506 /*282506*/, 282491 /*282491*/, 282476 /*282476*/, 282451 /*282451*/, 283901 /*283901*/, 282347 /*282347*/, 282346 /*282346*/, 282245 /*282245*/, 282076 /*282076*/, 280926 /*280926*/, 280930 /*280930*/, 279646 /*279646*/, 279641 /*279641*/, 279634 /*279634*/, 268164 /*268164*/, 254178 /*254178*/, 261154 /*261154*/, 261153 /*261153*/, 260928 /*260928*/, 260210 /*260210*/, 258031 /*258031*/, 258030 /*258030*/, 256035 /*256035*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(286656, 44479, 14, 0, 53653, 1, 0, 0, 'Experience Ravencrest''s Legacy', 22566), -- 286656 +(286620, 44416, 0, 1, 113825, 1, 1, 0, '', 22566), -- 286620 +(286616, 44415, 0, 0, 113824, 3, 0, 0, 'Unstable Portals closed', 22566), -- 286616 +(285753, 43753, 0, 0, 109958, 1, 1, 0, 'Ley Line Energy Collected', 22566), -- 285753 +(285584, 43640, 0, 1, 98208, 1, 0, 0, 'Advisor Vandros slain', 22566), -- 285584 +(285583, 43640, 1, 0, 139618, 1, 0, 0, 'Nightforged Keystone found', 22566), -- 285583 +(285551, 43614, 0, 0, 107113, 1, 1, 0, 'Vorthax slain.', 22566), -- 285551 +(285234, 43362, 1, 0, 139342, 1, 0, 0, '', 22566), -- 285234 +(286321, 43362, 0, 1, 103769, 1, 0, 0, '', 22566), -- 286321 +(286310, 43361, 0, 1, 110538, 1, 2, 0, 'Return to the Temple of Fal''adora', 22566), -- 286310 +(285233, 43361, 1, 0, 139340, 5, 0, 0, '', 22566), -- 285233 +(285232, 43360, 0, 0, 105554, 6, 0, 0, '', 22566), -- 285232 +(285010, 42982, 0, 0, 109518, 1, 0, 0, 'Be recognized', 22566), -- 285010 +(284735, 42781, 0, 1, 104218, 1, 0, 0, 'Advisor Melandrus slain', 22566), -- 284735 +(284734, 42781, 1, 0, 138432, 6, 0, 0, 'Nightwatch Weaponry recovered', 22566), -- 284734 +(284650, 42725, 1, 1, 137295, 20, 0, 0, 'Bottles of Arcwine Delivered to Deline', 22566), -- 284650 +(282703, 41703, 0, 0, 104524, 1, 1, 0, 'Ormagrogg slain.', 22566), -- 282703 +(282608, 41643, 1, 0, 128896, 1, 0, 0, '', 22566), -- 282608 +(282517, 41560, 0, 0, 103686, 1, 0, 0, 'Skin the Felhide Gargantuan', 22566), -- 282517 +(282506, 41552, 1, 0, 135511, 1, 0, 0, '', 22566), -- 282506 +(282491, 41534, 1, 0, 140959, 10, 0, 0, '', 22566), -- 282491 +(282476, 41520, 0, 0, 103647, 1, 0, 0, 'Felwort gathered', 22566), -- 282476 +(282451, 41501, 1, 0, 134104, 40, 0, 0, '', 22566), -- 282451 +(283901, 41427, 0, 1, 102542, 15, 0, 0, 'Rimescale naga slain', 22566), -- 283901 +(282347, 41416, 0, 1, 104314, 1, 0, 0, 'Reclaim the Skyhorn', 22566), -- 282347 +(282346, 41416, 0, 0, 104302, 5, 0, 0, '', 22566), -- 282346 +(282245, 41354, 1, 0, 141252, 6, 0, 0, '', 22566), -- 282245 +(282076, 41228, 0, 0, 103649, 1, 0, 0, 'Foxflower Cluster gathered', 22566), -- 282076 +(280926, 40592, 0, 0, 100644, 5, 2, 0, 'Vrykul Prisoner released', 22566), -- 280926 +(280930, 40592, 0, 1, 100681, 1, 0, 0, 'Dagmyr released', 22566), -- 280930 +(279646, 38807, 1, 2, 128405, 1, 0, 0, '', 22566), -- 279646 +(279641, 38807, 1, 1, 128396, 1, 0, 0, '', 22566), -- 279641 +(279634, 38807, 1, 0, 128392, 1, 0, 0, '', 22566), -- 279634 +(268164, 30482, 1, 0, 85161, 1, 0, 0, '', 22566), -- 268164 +(254178, 26398, 1, 0, 58366, 1, 0, 0, '', 22566), -- 254178 +(261154, 8937, 1, 1, 16737, 1, 0, 0, '', 22566), -- 261154 +(261153, 8937, 1, 0, 16736, 1, 0, 0, '', 22566), -- 261153 +(260928, 8922, 1, 0, 21985, 1, 0, 0, '', 22566), -- 260928 +(260210, 8729, 1, 0, 21137, 1, 0, 0, '', 22566), -- 260210 +(258031, 5524, 6, -1, 529, 42000, 0, 0, '', 22566), -- 258031 +(258030, 5524, 1, 0, 12844, 25, 0, 0, '', 22566), -- 258030 +(256035, 1678, 1, 0, 6799, 1, 0, 0, '', 22566); -- 256035 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=286616 AND `Index`=0) OR (`ID`=285753 AND `Index`=1) OR (`ID`=285753 AND `Index`=0) OR (`ID`=285584 AND `Index`=0) OR (`ID`=285583 AND `Index`=0) OR (`ID`=285234 AND `Index`=0) OR (`ID`=285233 AND `Index`=0) OR (`ID`=284735 AND `Index`=0) OR (`ID`=284650 AND `Index`=3) OR (`ID`=284650 AND `Index`=2) OR (`ID`=284650 AND `Index`=1) OR (`ID`=284650 AND `Index`=0) OR (`ID`=282347 AND `Index`=1) OR (`ID`=282347 AND `Index`=0) OR (`ID`=282076 AND `Index`=0) OR (`ID`=280926 AND `Index`=0) OR (`ID`=280930 AND `Index`=0) OR (`ID`=279646 AND `Index`=0) OR (`ID`=279641 AND `Index`=0) OR (`ID`=279634 AND `Index`=0) OR (`ID`=268164 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(286616, 0, 2099, 22566), -- 286616 +(285753, 1, 6217, 22566), -- 285753 +(285753, 0, 6215, 22566), -- 285753 +(285584, 0, 2101, 22566), -- 285584 +(285583, 0, 5625, 22566), -- 285583 +(285234, 0, 5538, 22566), -- 285234 +(285233, 0, 5537, 22566), -- 285233 +(284735, 0, 2101, 22566), -- 284735 +(284650, 3, 5913, 22566), -- 284650 +(284650, 2, 5038, 22566), -- 284650 +(284650, 1, 5031, 22566), -- 284650 +(284650, 0, 5030, 22566), -- 284650 +(282347, 1, 6213, 22566), -- 282347 +(282347, 0, 6212, 22566), -- 282347 +(282076, 0, 6053, 22566), -- 282076 +(280926, 0, 4265, 22566), -- 280926 +(280930, 0, 4264, 22566), -- 280930 +(279646, 0, 3738, 22566), -- 279646 +(279641, 0, 3730, 22566), -- 279641 +(279634, 0, 3720, 22566), -- 279634 +(268164, 0, 658, 22566); -- 268164 |