diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_04_19_02_world.sql | 203 |
1 files changed, 203 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_04_19_02_world.sql b/sql/updates/world/master/2017_04_19_02_world.sql new file mode 100644 index 00000000000..5d937a394ab --- /dev/null +++ b/sql/updates/world/master/2017_04_19_02_world.sql @@ -0,0 +1,203 @@ +DELETE FROM `quest_template` WHERE `ID` IN (47202, 47112, 47097, 47061, 47014, 47012, 46821, 46756, 46755, 46282, 46275, 46274, 46272, 46268, 46251, 45977, 45793, 45792, 45541); +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`, `Expansion`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(47202, 2, 110, 0, 110, 1519, 0, 0, 0, 4, 1, 0, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 40894976, 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, 18875469, 0, 6, 'A Personal Message', 'Speak with Prophet Velen.', 'The time has come for me to travel to the Broken Shore and see, for myself, the place where my father died.\n\nIf I am to be the king my father was... the king Stormwind deserves, I must know firsthand the threat my people face.\n\nPlease tell my advisors that I''ve gone to the Broken Shore. If I told them myself they''d only try and stop me.\n\nI''ll wait for you at Deliverance Point. Farewell.', '', 'Speak with Prophet Velen.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(47112, 2, 110, 0, 110, 7543, 0, 0, 0, 5, 1, 0, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 40894984, 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, 18875469, 0, 6, 'Lost Souls', 'Release $1oa Lost Souls.', 'Never in my life have I beheld such destruction... such misery. The very ground we walk on us paved with the bones of our allies.\n\nEven now I can see the lost spirits of Alliance soldiers wandering the ruins.\n\nI cannot leave this place without putting the souls of our brave soldiers to rest. We owe them... I owe them that much.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(47097, 2, 110, 0, 110, 7543, 0, 0, 0, 5, 1, 0, 5, 1, 0, 0, 0, 0, 242637, 0, 0, 0, 0, 1, 0, 40894984, 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, 18875469, 0, 6, 'A Walk to Remember', 'Escort King Anduin to Soul Ruin at the Broken Shore.', 'It''s good to have you at my side, $n.\n\nI''ve come to the Broken Shore to see, for myself, the price that my father... that the Alliance has paid to protect our world.\n\nAs long as I am blind to the suffering and sacrifices of my people, I will never be able to lead them to peace.\n\nTime is short, we should move onward.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(47061, 3, 110, 0, 110, 7543, 144, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 218041, 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, 2045, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5225, 0, -1, 359, 6, 'Apocron', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(47014, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 239969, 0, 0, 240686, 0, 0, 0, 0, 1, 0, 39845888, 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, 350, 6, 'Boon of the Nether Disruptor', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(47012, 0, -1, 0, 110, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 239968, 0, 0, 240686, 0, 0, 0, 0, 1, 0, 39845888, 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, 350, 6, 'Boon of the Nether Disruptor', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46821, 3, 110, 0, 110, 7543, 109, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 240321, 0, 0, 0, 0, 0, 0, 37421312, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5120, 0, -1, 339, 6, 'Creepy Crawlies', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46756, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239851, 0, 0, 0, 0, 0, 0, 37421312, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5088, 0, -1, 340, 6, 'Mission: Felrage Destruction', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46755, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 239849, 0, 0, 0, 0, 0, 0, 41615616, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5088, 0, -1, 356, 6, 'Mission: Felraging', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46282, 2, 110, 0, 110, 7543, 0, 0, 0, 5, 1, 0, 5, 1, 0, 0, 0, 0, 239856, 0, 0, 0, 0, 1, 0, 40894984, 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, 18875469, 0, 6, 'The King''s Path', 'Accompany King Anduin to the Tomb of Sargeras.', 'Now that I have seen the Broken Shore and the terror of the Burning Legion first hand, my eyes have been opened to the truth.\n\nI speak not of the unfathomable evil of the enemy, but of the bravery and sacrifice that such evil brings about in the hearts of our people.\n\nMy father once told me that every king must carry the weight of his own crown. Mine has never felt heavier than it does at this very moment...\n\nPlease take me to the place where my father died, so that I may honor his sacrifice.', '', 'Accompany King Anduin to the Tomb of Sargeras.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46275, 2, 110, 0, 110, 1519, 0, 0, 46282, 5, 1, 0, 5, 1, 0, 0, 0, 0, 239446, 0, 0, 0, 0, 1, 0, 40894984, 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, 18875469, 0, 6, 'A Kingdom''s Heart', 'Accompany King Anduin on his walk through Stormwind.', 'My father was a legend. He oversaw the rebuilding of Stormwind, stood toe-to-toe with dragons, led the Alliance to numerous victories.\n\nThen, one day, he was just... gone.\n\nI wear his crown, I hold his title. But I''ve done nothing to earn them... or the faith of my people.\n\nI''ve spent the war sequestered in the keep, surrounded by guards and advisors. I need to walk the streets of Stormwind, to know whether it is hope or fear that beats in the hearts of my people.\n\nI welcome your company.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46274, 2, 110, 0, 110, 1519, 0, 0, 46275, 4, 1, 146000, 4, 1, 137150, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 38797312, 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, 18875469, 0, 6, 'Consoling the King', 'Look for King Anduin Wrynn inside Stormwind Cathedral.', 'Anduin hasn''t been the same since you brought him his father''s compass. He has become listless... distracted.\n\nWe attempted to console him, to no avail. Yesterday morning, he left the keep without so much as a word.\n\nI ordered the guards to follow him, of course. He went to pray at the cathedral, where he''s remained ever since.\n\nYou brought this melancholy upon him! You must convince the boy to resume his duties. There''s a war to be won!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46272, 2, 110, 0, 110, 1519, 0, 0, 46274, 4, 1, 146000, 4, 1, 137150, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 37748744, 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, 18875469, 0, 6, 'Summons to the Keep', 'Meet with Genn Greymane at Stormwind Keep.', 'Greetings, $n.\n\nYour presence has been requested in the royal court. The crown has urgent need of you!\n\nPlease return to Stormwind at your earliest convenience.\n\nKing Greymane is anticipating your swift arrival.', '', 'Meet with Genn Greymane at Stormwind Keep.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46268, 2, 110, 0, 110, 1519, 0, 0, 0, 4, 1, 0, 4, 1, 0, 0, 0, 0, 239804, 0, 0, 146408, 0, 1, 0, 304087552, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 6, 'A Found Memento', 'Bring the compass to King Anduin Wrynn in Stormwind Keep.', '<The trinket''s fine brass exterior is inlaid with intricate filigree, though much of the detail has been battered by rocks and waves. Clearing away the grime and salt encrusting the clasp, you manage to open it.\n\nIt is a compass--or was, at least. The glass face is shattered, the needle bent, unmoving.\n\nSet into the lid is a portrait. The paint is faded and waterlogged, but the subject is unmistakable: the face of a young Anduin Wrynn.>', '', 'Bring the compass to King Anduin Wrynn in Stormwind Keep.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(46251, 2, 110, 0, 110, -428, 0, 0, 0, 0, 1, 0, 6, 1, 0, 0, 0, 0, 239972, 0, 0, 0, 0, 1, 0, 2097672, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2045, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 150000, 0, 0, 0, 0, 0, 0, 0, -1, 0, 6, 'Shard Times', 'Collect $1oa Nethershards on the Broken Shore.', 'As you have surely noticed, a slain demon leaves behind Nethershards, solidified residual energy from the Twisting Nether. I require a significant quantity of them for an experiment I''m conducting... $1oa shards, to be precise.$b$bWhy are you looking at me like that? We''ve had this conversation before. I did the math.$b$bI need exactly $1oa shards. Fewer would be inadequate. More would be absurd.$b$bDon''t question my methods. Go!', '', '', 1226, 0, 0, 0, 2499, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45977, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234992, 0, 0, 0, 0, 0, 0, 37290240, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5114, 0, -1, 340, 6, 'Where There is a Whip...', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45793, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 239027, 0, 0, 0, 0, 0, 0, 34144512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5036, 0, -1, 356, 6, 'Occultist Onslaught', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45792, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 239027, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5036, 0, -1, 340, 6, 'Occultist Onslaught', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911), +(45541, 3, 110, 0, 110, 7543, 135, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 234983, 0, 0, 0, 0, 0, 0, 37290240, 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, 2045, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 5114, 0, -1, 356, 6, 'How Do YOU Like It?!', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 23911); + +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41537; +UPDATE `quest_template` SET `RewardCurrencyID1`=0, `RewardCurrencyQty1`=0, `VerifiedBuild`=23911 WHERE `ID`=45747; +UPDATE `quest_template` SET `Flags`=39846400, `FlagsEx`=37757184 WHERE `ID`=45391; +UPDATE `quest_template` SET `Flags`=41484608 WHERE `ID`=45379; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=45046; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43766; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=4, `RewardFactionValue2`=4, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43612; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43458; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43453; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43098; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=43059; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=42743; +UPDATE `quest_template` SET `Expansion`=6, `LogTitle`='Darkheart Thicket: Mythana', `VerifiedBuild`=23911 WHERE `ID`=42714; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardXPMultiplier`=0, `RewardFactionValue1`=3, `RewardFactionValue2`=3, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41826; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardFactionValue1`=5, `RewardFactionValue2`=5, `RewardFactionOverride1`=0, `RewardFactionOverride2`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41816; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41612; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41603; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41602; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41598; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41570; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41490; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41304; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41296; +UPDATE `quest_template` SET `RewardXPDifficulty`=0, `RewardArtifactCategoryID`=0, `Expansion`=6, `VerifiedBuild`=23911 WHERE `ID`=41290; +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=38043; +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37974; +UPDATE `quest_template` SET `Expansion`=5, `VerifiedBuild`=23911 WHERE `ID`=37964; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=25248; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=24968; +UPDATE `quest_template` SET `Expansion`=1, `VerifiedBuild`=23911 WHERE `ID`=10178; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3922; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=3101; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=2983; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1699; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=1524; +UPDATE `quest_template` SET `RewardFactionValue1`=3, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1072; +UPDATE `quest_template` SET `RewardFactionValue1`=6, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=1009; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=943; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=841; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=677; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=591; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=539; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=429; +UPDATE `quest_template` SET `QuestInfoID`=21, `RewardBonusMoney`=0, `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `AllowableRaces`=-1, `QuestDescription`='I hear Lord Wishock enjoyed his beverage. $b$bYou have served us well, $n. The Warlocks of Stormwind will be able to practice our ways without disturbance, thanks to you. For your efforts, I have prepared a special gift for you. Speak with my servant, Zggi, and claim your reward.', `VerifiedBuild`=23911 WHERE `ID`=397; +UPDATE `quest_template` SET `RewardFactionValue1`=2, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=306; +UPDATE `quest_template` SET `RewardFactionValue1`=5, `RewardFactionOverride1`=0, `VerifiedBuild`=23911 WHERE `ID`=295; +UPDATE `quest_template` SET `RewardFactionCapIn1`=7, `RewardFactionCapIn2`=7, `RewardFactionCapIn3`=7, `RewardFactionCapIn4`=7, `RewardFactionCapIn5`=7, `VerifiedBuild`=23911 WHERE `ID`=238; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=145; +UPDATE `quest_template` SET `VerifiedBuild`=23911 WHERE `ID`=94; + +DELETE FROM `quest_objectives` WHERE `ID` IN (290092 /*290092*/, 290000 /*290000*/, 289949 /*289949*/, 290022 /*290022*/, 289933 /*289933*/, 289696 /*289696*/, 289651 /*289651*/, 289650 /*289650*/, 289649 /*289649*/, 289648 /*289648*/, 289643 /*289643*/, 289641 /*289641*/, 289639 /*289639*/, 289175 /*289175*/, 289537 /*289537*/, 289174 /*289174*/, 289170 /*289170*/, 289169 /*289169*/, 289293 /*289293*/, 289277 /*289277*/, 288769 /*288769*/, 288768 /*288768*/, 288767 /*288767*/, 289507 /*289507*/, 289505 /*289505*/, 289509 /*289509*/, 289508 /*289508*/, 288109 /*288109*/, 288110 /*288110*/, 288771 /*288771*/, 288108 /*288108*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(290092, 47112, 0, 1, 121634, 1, 2, 0, 0, 'Speak with Anduin', 23911), -- 290092 +(290000, 47112, 0, 0, 121315, 10, 0, 0, 0, 'Souls released', 23911), -- 290000 +(289949, 47097, 0, 1, 121240, 1, 2, 0, 0, 'Reach the Hijacked Portal', 23911), -- 289949 +(290022, 47097, 0, 0, 121401, 1, 0, 0, 0, 'Speak with King Anduin', 23911), -- 290022 +(289933, 47061, 0, 6, 121124, 1, 0, 0, 0, '', 23911), -- 289933 +(289696, 46821, 0, 1, 116951, 50, 0, 0, 0, '', 23911), -- 289696 +(289651, 46756, 0, 0, 120481, 20, 92, 0, 5, 'Captured Warriors Released', 23911), -- 289651 +(289650, 46756, 0, 3, 117413, 34, 92, 0, 3, '', 23911), -- 289650 +(289649, 46756, 0, 2, 117403, 10, 92, 0, 10, '', 23911), -- 289649 +(289648, 46756, 0, 1, 115624, 100, 92, 0, 1, 'Crates Destroyed', 23911), -- 289648 +(289643, 46756, 15, -1, 0, 1, 0, 0, 0, 'Disrupt the Felrage encampment', 23911), -- 289643 +(289641, 46755, 0, 1, 120967, 20, 0, 0, 0, 'Felrage insurgents killed', 23911), -- 289641 +(289639, 46755, 0, 0, 120461, 12, 0, 0, 0, 'Captured warrior squads rescued', 23911), -- 289639 +(289175, 46282, 0, 0, 119426, 1, 0, 0, 0, 'King Anduin escorted', 23911), -- 289175 +(289537, 46275, 0, 2, 119406, 1, 2, 0, 0, 'Anduin''s advisors heard', 23911), -- 289537 +(289174, 46275, 0, 3, 119418, 1, 2, 0, 0, 'Return to Stormwind Keep', 23911), -- 289174 +(289170, 46275, 0, 1, 119405, 1, 2, 0, 0, 'Escort Anduin to Lion''s Rest', 23911), -- 289170 +(289169, 46275, 0, 0, 119404, 1, 0, 0, 0, 'Speak with Anduin', 23911), -- 289169 +(289293, 46268, 1, 0, 146408, 1, 0, 1, 0, '', 23911), -- 289293 +(289277, 46251, 4, -1, 1226, 2500, 0, 0, 0, '', 23911), -- 289277 +(288769, 45977, 0, 0, 117165, 1, 1, 0, 0, '', 23911), -- 288769 +(288768, 45977, 0, 2, 117168, 8, 2, 0, 0, 'Dreadsoul demons slain', 23911), -- 288768 +(288767, 45977, 0, 1, 117100, 1, 0, 0, 0, 'Demonic Portal entered', 23911), -- 288767 +(289507, 45793, 0, 1, 120187, 5, 0, 0, 0, 'Fel Crystals absorbed', 23911), -- 289507 +(289505, 45793, 0, 0, 115874, 10, 0, 0, 0, '', 23911), -- 289505 +(289509, 45792, 2, 1, 268626, 5, 0, 0, 0, 'Fel Crystals destroyed', 23911), -- 289509 +(289508, 45792, 0, 0, 115874, 10, 0, 0, 0, '', 23911), -- 289508 +(288109, 45541, 0, 0, 117165, 1, 1, 0, 0, '', 23911), -- 288109 +(288110, 45541, 0, 2, 117168, 8, 2, 0, 0, 'Dreadsoul demons slain', 23911), -- 288110 +(288771, 45541, 14, 3, 56804, 1, 2, 0, 0, 'Enslave a Dreadsoul demon.', 23911), -- 288771 +(288108, 45541, 0, 1, 117100, 1, 0, 0, 0, 'Demonic Portal entered', 23911); -- 288108 + +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282494; -- 282494 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288439; -- 288439 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=287408; -- 287408 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=288967; -- 288967 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285773; -- 285773 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285549; -- 285549 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285290; -- 285290 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285285; -- 285285 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285041; -- 285041 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=285024; -- 285024 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286779; -- 286779 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284674; -- 284674 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=286777; -- 286777 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=284630; -- 284630 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282892; -- 282892 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282878; -- 282878 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282567; -- 282567 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282558; -- 282558 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282557; -- 282557 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282553; -- 282553 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282527; -- 282527 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282440; -- 282440 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282184; -- 282184 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282175; -- 282175 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=282168; -- 282168 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=278736; -- 278736 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277592; -- 277592 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277443; -- 277443 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277442; -- 277442 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277441; -- 277441 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277440; -- 277440 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277431; -- 277431 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277430; -- 277430 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277429; -- 277429 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277379; -- 277379 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=277378; -- 277378 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265442; -- 265442 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=265441; -- 265441 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255951; -- 255951 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255950; -- 255950 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=257997; -- 257997 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256541; -- 256541 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255658; -- 255658 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255891; -- 255891 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255457; -- 255457 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255645; -- 255645 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255644; -- 255644 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=254045; -- 254045 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253794; -- 253794 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253793; -- 253793 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253792; -- 253792 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253269; -- 253269 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255096; -- 255096 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=255095; -- 255095 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253464; -- 253464 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252922; -- 252922 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253232; -- 253232 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=253231; -- 253231 +UPDATE `quest_objectives` SET `Flags2`=1, `VerifiedBuild`=23911 WHERE `ID`=252583; -- 252583 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=252907; -- 252907 +UPDATE `quest_objectives` SET `VerifiedBuild`=23911 WHERE `ID`=256799; -- 256799 + +DELETE FROM `quest_visual_effect` WHERE (`ID`=290092 AND `Index`=0) OR (`ID`=290000 AND `Index`=0) OR (`ID`=290022 AND `Index`=0) OR (`ID`=289933 AND `Index`=0) OR (`ID`=289651 AND `Index`=0) OR (`ID`=289639 AND `Index`=0) OR (`ID`=289537 AND `Index`=1) OR (`ID`=289537 AND `Index`=0) OR (`ID`=289174 AND `Index`=0) OR (`ID`=289170 AND `Index`=2) OR (`ID`=289170 AND `Index`=1) OR (`ID`=289170 AND `Index`=0) OR (`ID`=289169 AND `Index`=1) OR (`ID`=289169 AND `Index`=0) OR (`ID`=289507 AND `Index`=0) OR (`ID`=289509 AND `Index`=0) OR (`ID`=288771 AND `Index`=0); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(290092, 0, 7297, 23911), +(290000, 0, 7268, 23911), +(290022, 0, 7276, 23911), +(289933, 0, 2101, 23911), +(289651, 0, 7168, 23911), +(289639, 0, 7163, 23911), +(289537, 1, 7314, 23911), +(289537, 0, 7313, 23911), +(289174, 0, 7126, 23911), +(289170, 2, 7299, 23911), +(289170, 1, 7292, 23911), +(289170, 0, 7125, 23911), +(289169, 1, 7292, 23911), +(289169, 0, 7125, 23911), +(289507, 0, 7102, 23911), +(289509, 0, 7101, 23911), +(288771, 0, 6838, 23911); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=287408 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=288967 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285773 AND `Index`=1); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285773 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285041 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=285024 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286779 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284674 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=286777 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=284630 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282440 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=282175 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=277430 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=277429 AND `Index`=0); +UPDATE `quest_visual_effect` SET `VerifiedBuild`=23911 WHERE (`ID`=277378 AND `Index`=0); |