DB/Quest: Updated quest_template to 6.2.0.xxxxx

1 files changed, 19 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_19_01_world.sql b/sql/updates/world/2015_07_19_01_world.sql
new file mode 100644
index 00000000000..147a926c6c1
--- /dev/null
+++ b/sql/updates/world/2015_07_19_01_world.sql
@@ -0,0 +1,19 @@
+DELETE FROM `quest_template` WHERE `Id` IN (37625, 37839, 37975, 38458, 38462, 38463, 38561, 38876, 38877, 39003, 39021, 39293, 39295, 39394, 30342, 31148, 34079);
+INSERT INTO `quest_template` (`Id`, `QuestType`, `QuestLevel`, `QuestPackageID`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoney`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardBonusMoney`, `RewardDisplaySpell`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `Flags`, `FlagsEx`, `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`, `RewardTalents`, `RewardArenaPoints`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitTurnIn`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `QuestCompletionLog`, `VerifiedBuild`) VALUES
+(37625, 3, 100, 0, 100, -403, 0, 0, 0, 7, 1, 462000, 7, 1, 219450, 0, 81040, 0, 0, 0, 37552128, 524288, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1716, 0, 0, 0, 0, 8, 0, 0, 0, 0, 400000, 0, 0, 0, 0, 0, 823, 0, 0, 0, 800, 0, 0, 0, 890, 878, 3627, 0, 18875469, 'Assault on Magnarok', '', '', '', '', '', '', '', '', 20253), -- -Unknown-
+(37839, 2, 100, 0, 100, -344, 83, 0, 0, 7, 1, 462000, 7, 1, 219450, 0, 186691, 0, 0, 0, 35651592, 65792, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 124634, 124635, 124636, 124637, 124638, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 18875469, 'Light Be With You', 'Meet Yrel at the Coliseum of Light near the Temple of Karabor.', 'You''ve done everything I''ve asked, $n. I believe we can apply one final enchantment to your ring. But... we must be cautious. Last time I augmented your ring I killed you. (Sorry.) It will take a divine act to empower you further.$b$bFortunately, you''ve made some powerful allies during your time here. Travel to the Temple of Karabor, where Yrel is waiting for you. With the blessing of a Naaru your ring will become as powerful and unique as - well, as you yourself. Go to Karabor. You''ve earned it.', '', '', '', '', '', 'Speak with Khadgar.', 20253), -- -Unknown-
+(37975, 2, 100, 0, 100, -403, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 'Pet Battles Not Active', '', '', '', '', '', '', '', '', 20253), -- -Unknown-
+(38458, 2, 100, 0, 100, -401, 0, 0, 38462, 5, 1, 154000, 5, 1, 146300, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 33555378, 'Garrison Campaign: The Warlock', 'Speak with the warlock at Vol''mar in Tanaan Jungle.', 'Commander, you have a visitor. One of Gul''dan''s warlocks just walked up to the base and surrendered. He says he has information of a terrible event that is about to occur.\n\nI suggest you speak with him immediately.', '', '', '', '', '', 'Speak with Oronok at the Vault of the Earth in Tanaan Jungle.', 20253), -- -Unknown-
+(38462, 2, 100, 0, 100, -401, 0, 0, 38463, 5, 1, 154000, 5, 1, 146300, 0, 0, 0, 0, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 'Breaching the Barrier', 'Collect the Black Candle, the Tome of Protection, and the Shadowblade at the Fel Forge and bring them to Oronok.', 'The ritual site is already prepared, and it is protected by a barrier... one that I created. I can destroy the barrier, but I will need three items currently in use at Forge Camp Vengeance.\n\nIf you can get those ritual items, I will meet you at the Corrupted Refuge and remove the barrier. Even if it kills me.', '', '', '', '', '', 'Speak with Oronok in Tanaan Jungle.', 20253), -- -Unknown-
+(38463, 2, 100, 0, 100, -401, 0, 0, 0, 7, 1, 462000, 7, 1, 219450, 0, 0, 0, 0, 0, 34603016, 0, 124551, 128225, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1848, 0, 0, 0, 0, 5, 0, 0, 0, 0, 250000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 33555378, 'The Cipher of Damnation', 'Get Oronok and your ally to destroy the barrier, then stop Gul''dan.', 'Your ally and I will remove this barrier now, though it will take a greater part of our strength. What lies beyond will not be easy.\n\nGul''dan will have empowered an elemental lord with the Cipher, driving it insane. He will use it to destroy the link between the elements and Draenor. If you destroy that elemental, we could recover the Cipher.', '', '', '', '', '', 'Speak with Oronok at the Corrupted Refuge in Tanaan Jungle.', 20253), -- -Unknown-
+(38561, 2, 100, 0, 100, -401, 0, 0, 38462, 5, 1, 154000, 5, 1, 146300, 0, 0, 0, 0, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 18875469, 'Garrison Campaign: The Warlock', 'Speak with the warlock at Lion''s Watch in Tanaan Jungle.', 'Commander, you have a visitor. One of Gul''dan''s warlocks just walked up to the base and surrendered. He says he has information of a terrible event that is about to occur.\n\nI suggest you speak with him immediately.', '', '', '', '', '', 'Speak with Oronok at the Vault of the Earth in Tanaan Jungle.', 20253), -- -Unknown-
+(38876, 3, 100, 0, 100, -403, 0, 0, 0, 7, 1, 462000, 7, 1, 219450, 0, 190492, 0, 0, 0, 37289984, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1718, 0, 0, 0, 0, 8, 0, 0, 0, 0, 400000, 0, 0, 0, 0, 0, 1101, 823, 0, 0, 600, 2000, 0, 0, 890, 878, 4283, 0, 33555378, 'Assault on the Fel Forge', 'Assault the Iron Horde reinforcements at Ironhold Harbor in Tanaan Jungle.', 'The Iron Horde continue to bring in reinforcements from all over Draenor to reinforce their position at Hellfire Citadel. If we don''t cut off the flow of supplies then we risk losing control of our plans in Tanaan.\n\nA strategic attack to the supply lines at Ironhold Harbor is just the thing to keep the Iron Horde on the defensive and maintain our momentum.', '', '', '', '', '', 'Return to Vindicator Yrel at Lion''s Watch in Tanaan Jungle.', 20253), -- -Unknown-
+(38877, 3, 100, 0, 100, -403, 0, 0, 0, 7, 1, 462000, 7, 1, 219450, 0, 190492, 0, 0, 0, 37289984, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1718, 0, 0, 0, 0, 8, 0, 0, 0, 0, 400000, 0, 0, 0, 0, 0, 1101, 823, 0, 0, 600, 2000, 0, 0, 890, 878, 4283, 0, 18875469, 'Assault on the Fel Forge', 'Assault the Iron Horde reinforcements at Ironhold Harbor in Tanaan Jungle.', 'The Iron Horde continue to bring in reinforcements from all over Draenor to reinforce their position at Hellfire Citadel. If we don''t cut off the flow of supplies then we risk losing control of our plans in Tanaan.\n\nA strategic attack to the supply lines at Ironhold Harbor is just the thing to keep the Iron Horde on the defensive and maintain our momentum.', '', '', '', '', '', 'Return to Vindicator Yrel at Lion''s Watch in Tanaan Jungle.', 20253), -- -Unknown-
+(39003, 2, 100, 0, 100, -344, 83, 0, 0, 5, 1, 154000, 5, 1, 146300, 0, 0, 0, 0, 0, 38797320, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, -1, 'Cooking the Books', 'Deliver Gul''dan''s Library of Chaos to Cordana at Zangarra and ensure they are destroyed.', '$n, we''ve got to destroy these tomes. Many of them have actual tortured souls bound into the pages, so we can''t just burn them. Cordana will know what to do.$b$bTake these books to my tower in Zangarra and give them to Cordana. Let me know when the deed is done.', '', '', '', '', '', 'Return to Khadgar at your garrison''s shipyard.', 20253), -- -Unknown-
+(39021, 2, 100, 0, 100, -409, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 193102, 0, 0, 0, 35684360, 0, 127853, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1129, 0, 0, 0, 1, 0, 0, 0, 890, 878, 0, 0, -1, 'A Frozen Path Through Time', 'Complete 5 Timewalking dungeons.', 'The chill star shines upon the land with its cold light as even the spirits retreat to the shadows. This star is unlike any other in the skies, sapping warmth and life. While its influence holds, new paths may open up, to distant places and even distant times. No sage truly understands the nature of this sign, but fortune favors the daring.', '', '', '', '', '', 'Return to Seer Kazal at your garrison.', 20253), -- -Unknown-
+(39293, 2, 100, 0, 100, 6941, 0, 0, 38924, 5, 1, 0, 0, 1, 146300, 0, 0, 0, 0, 0, 134807616, 2097152, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 390, 0, 0, 0, 50000, 0, 0, 0, 890, 878, 0, 0, 33555378, 'Continue the Domination', 'Defeat the Alliance at all event locations in Ashran and kill Grand Marshal Tremblade.', 'The Alliance refuse to back down in Ashran. Teach them that the Horde will not stand aside while they plunder the power of the ancient ogre empire to use for their own schemes.', '', 'Grand Marshal Tremblade leads the Alliance forces in Ashran.', '', '', '', 'Return to Angry Zurge in the Horde base inside Ashran.', 20253), -- -Unknown-
+(39295, 2, 100, 0, 100, 6941, 0, 0, 38926, 5, 1, 0, 0, 1, 146300, 0, 0, 0, 0, 0, 134807616, 2097152, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 58184, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 390, 0, 0, 0, 50000, 0, 0, 0, 890, 878, 0, 0, 18875469, 'Continue the Domination', 'Defeat the Horde at all event locations in Ashran and kill High Warlord Volrath.', 'As we feared the Horde are trying to consolidate their position here on the island by looting it, just like we feared. Get out there and show them the Alliance won''t put up with their aggression.', '', 'Volrath leads the Horde forces in Ashran.', '', '', '', 'Return to Chris Clarkie in the Alliance base inside Ashran.', 20253), -- -Unknown-
+(39394, 2, 100, 0, 100, -401, 0, 0, 0, 7, 1, 462000, 7, 1, 219450, 0, 0, 0, 0, 0, 33554440, 0, 124551, 128225, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1847, 0, 0, 0, 0, 8, 0, 0, 0, 0, 250000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 18875469, 'The Cipher of Damnation', 'Get Oronok and your ally to destroy the barrier, then stop Gul''dan.', 'Your ally and I will remove this barrier now, though it will take a greater part of our strength. What lies beyond will not be easy.\n\nGul''dan will have empowered an elemental lord with the Cipher, driving it insane. He will use it to destroy the link between the elements and Draenor. If you destroy that elemental, we could recover the Cipher.', '', '', '', '', '', 'Speak with Oronok at the Corrupted Refuge in Tanaan Jungle.', 20253), -- -Unknown-
+(30342, 2, 90, 0, 90, 5840, 0, 0, 0, 5, 1, 114000, 5, 1, 4900, 0, 0, 0, 0, 0, 4104, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1269, 0, 0, 0, 0, 5, 0, 0, 0, 0, 10000, 0, 0, 0, 0, 0, 738, 0, 0, 0, 2, 0, 0, 0, 890, 878, 0, 0, -1, 'Fiery Tongue, Fragile Feet', 'Kill 6 Stillwater Crocolisks.', 'I was kicking the water for fun again when one of those vicious crocolisks lunged out to try to bite my foot off! Rude! I have proceeded to rest my weary soles a few feet farther from the water, but I already look back on my water-kicking days longingly.$B$BWould you be so kind as to kill a crocolisk or eight for me? I assure you they deserve it for frightening me though.', '', '', '', '', '', 'Return to Ren Firetongue at Whitepetal Lake in the Vale of Eternal Blossoms.', 20253), -- -Unknown-
+(31148, 2, 3, 0, 2, 154, 0, 0, 24961, 1, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2621440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 33555378, 'Novice Elreth', 'Speak to Novice Elreth at Deathknell in Tirisfal Glades.', 'Actually, before I go - you should speak with Novice Elreth. She had some work for you, and you would do well to help others and improve your skills.\n\nThe next time you see me, I will be in Undercity.', '', '', '', '', '', 'Speak to Novice Elreth at Deathknell in Tirisfal Glades.', 20253), -- -Unknown-
+(34079, 2, 92, 0, 90, 6720, 0, 0, 0, 1, 1, 12200, 1, 1, 3000, 0, 0, 0, 0, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 890, 878, 0, 0, 33555378, 'Mission Successful', 'Speak to Sergeant Gil''nath in Frostfire Ridge.', 'The Thunderlords are finished $n and our job is complete. I''ll stay here and watch over the area.$b$bYou should head back to Sergeant Gil''nath. I''m certain he will have another task for you.', '', '', '', '', '', 'Return to Sergeant Gil''nath in Frostfire Ridge.', 20253); -- -Unknown-