diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/cata_classic/2024_12_31_01_world.sql | 100 |
1 files changed, 100 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_12_31_01_world.sql b/sql/updates/world/cata_classic/2024_12_31_01_world.sql new file mode 100644 index 00000000000..211db3ad920 --- /dev/null +++ b/sql/updates/world/cata_classic/2024_12_31_01_world.sql @@ -0,0 +1,100 @@ +DELETE FROM `quest_template` WHERE `ID` IN (86554 /*Daily Heroic Random (1st) (Cataclysm)*/, 86553 /*Daily Heroic Random (1st) (Cataclysm)*/, 29440 /*The Call of the World-Shaman*/, 29439 /*The Call of the World-Shaman*/, 29437 /*The Fallen Guardian*/, 29337 /*Into Constant Earth*/, 29336 /*Into Coaxing Tides*/, 29335 /*Into Slashing Winds*/, 29331 /*Elemental Bonds: The Vow*/, 29330 /*Elemental Bonds: Fury*/, 29329 /*Elemental Bonds: Patience*/, 29328 /*Elemental Bonds: Desire*/, 29327 /*Elemental Bonds: Doubt*/, 29326 /*The Nordrassil Summit*/, 29312 /*The Stuff of Legends*/, 29309 /*The Stuff of Legends*/, 29308 /*Heart of Flame*/, 29307 /*Heart of Flame*/, 29285 /*Alignment*/, 29270 /*Time Grows Short*/, 29269 /*At One*/, 29240 /*Emergency Extraction*/, 29239 /*Nordrassil's Bough*/, 29234 /*Delegation*/, 29225 /*Actionable Intelligence*/, 29224 /*[DEPRICATED] NO LONGER USED*/, 29194 /*Through a Glass, Darkly*/, 29193 /*On a Wing and a Prayer*/, 11139 /*[DEPRECATED]Secondhand Diving Gear*/, 8906 /*An Earnest Proposition*/, 8575 /*Azuregos's Magical Ledger*/, 8552 /*The Monogrammed Sash*/, 8256 /*The Ichor of Undeath*/, 7725 /*Again With the Zapped Giants*/, 7045 /*A Smokywood Pastures' Thank You!*/, 6984 /*A Smokywood Pastures' Thank You!*/, 6761 /*The New Frontier*/, 4769 /*Vivian Lagrave and the Darkstone Tablet*/, 4736 /*In Search of Menara Voidrender*/, 4022 /*A Taste of Flame*/, 2999 /*Tome of Divinity*/, 2970 /*Doling Justice*/, 2857 /*Wild Leather Helmet*/, 2856 /*Wild Leather Vest*/, 2855 /*Wild Leather Shoulders*/, 1428 /*[DEPRECATED]Continued Threat*/, 1324 /*The Missing Diplomat*/, 778 /*This Is Going to Be Hard*/, 665 /*Sunken Treasure*/, 394 /*The Head of the Beast*/); +INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestLevel`, `QuestScalingFactionGroup`, `QuestMaxScalingLevel`, `QuestPackageID`, `MinLevel`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `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`, `Expansion`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(86554, 2, 85, 0, 255, 0, 85, 0, 0, 0, 0, 8, 1, 7, 1, 0, 0, 0, 0, 0, 1, 0, 0x1080, 0x8, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Daily Heroic Random (1st) (Cataclysm)', '', '', '', '', 396, 0, 0, 0, 24000, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Daily Heroic Random (1st) (Cataclysm) +(86553, 2, 85, 0, 255, 0, 85, 0, 0, 0, 0, 8, 1, 7, 1, 0, 0, 0, 0, 0, 1, 0, 0x80, 0x8, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Daily Heroic Random (1st) (Cataclysm)', '', '', '', '', 396, 0, 0, 0, 24000, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Daily Heroic Random (1st) (Cataclysm) +(29440, 2, 85, 0, 255, 0, 85, -381, 0, 0, 29326, 3, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x8, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'The Call of the World-Shaman', 'Speak with Thrall just south of the World Tree in Mount Hyjal.', 'The Earthen Ring calls to you once more, $N.$B$BThrall has cast aside his mantle as warchief of the Horde, but in his new role he needs the support of his people more than ever. He has requested one of the Horde\'s finest to accompany him in his next endeavor, a ritual of healing that will profoundly impact our world.$B$BYou will find him under the boughs of Nordrassil in Mount Hyjal, on the southern side of the tree. Heed the call!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Call of the World-Shaman +(29439, 2, 85, 0, 255, 0, 85, -381, 0, 0, 29326, 3, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x8, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'The Call of the World-Shaman', 'Speak with Thrall just south of the World Tree in Mount Hyjal.', 'The Earthen Ring calls to you once more, $N.$B$BAs a member of the Alliance, I know that you may have reservations working with the one you call Thrall, the former Warchief of the Horde. But he has specifically requested an Alliance hero to accompany him in his next endeavor, a ritual of healing that will profoundly impact our world.$B$BCast aside your doubts, $c, and heed the world-shaman\'s call.$B$BYou will find him under the boughs of Nordrassil in Mount Hyjal, on the southern side of the tree.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Call of the World-Shaman +(29437, 2, 85, 0, 255, 0, 85, 616, 0, 0, 0, 6, 1, 6, 1, 0, 0, 0, 0, 0, 1, 0, 0x10008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1158, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'The Fallen Guardian', 'Confront and slay Alysra at the Ruins of Lar\'donir in Mount Hyjal.', 'Fandral Staghelm was kept prisoner here in Hyjal. It was the green dragon Alysra - one of my very own! - who was in charge of keeping Fandral secure.$B$BWe can only conclude that the Twilight\'s Hammer has gotten to her. You must confront her, $N. Destroy her if you must - I cannot bear to see it.$B$BShe was last seen in the Ruins of Lar\'donir, west of the World Tree.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Fallen Guardian +(29337, 2, 85, 0, 255, 0, 85, -381, 0, 0, 0, 3, 1, 0, 1, 100168, 0, 0, 0, 0, 1, 0, 0x20200088, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Into Constant Earth', 'Speak with Therazane at Therazane\'s Throne in Deepholm.$b$bAggra can teleport you to Therazane\'s Throne from the Abyssal Breach.', 'Time is short! My love lies in Deepholm. I will take us there when you are ready, and we will speak with Therazane the Stonemother.', '', 'Speak with Therazane at Therazane\'s Throne in Deepholm.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Into Constant Earth +(29336, 2, 85, 0, 255, 0, 85, -381, 0, 0, 0, 3, 1, 0, 1, 100313, 0, 0, 0, 0, 1, 0, 0x20240088, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Into Coaxing Tides', 'Speak with Hydrius at the Abyssal Breach in the Abyssal Depths of Vashj\'ir.', 'Go\'el must be in the plane of water... the Abyssal Maw itself! I shudder to imagine what fate awaits him there.$b$bFind the elemental, Hydrius, near the Abyssal Breach. He knows of Go\'el and is sympathetic to our fight against Ragnaros. If anyone can help you there, it\'s him.$b$bI will meet you beneath the tides of Vashj\'ir, $r...', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Into Coaxing Tides +(29335, 2, 85, 0, 255, 0, 85, -381, 0, 0, 29327, 3, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x20040088, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Into Slashing Winds', 'Speak with Cyclonas on the Bluff of the South Wind in Uldum.', '$C, I refuse to believe my Go\'el is lost forever. His spirit has been scattered across the elemental planes. If even a part of him still exists, we can find him, but I will need your help.$b$bWe will start with the plane of air.$b$bSpeak to me and we will travel to the Vortex Pinnacle together. We must speak with an elemental, Cyclonas. He\'s capricious, but he sees everything in the realm of air. If my love is there, Cyclonas will know what\'s become of him.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Into Slashing Winds +(29331, 2, 85, 0, 255, 0, 85, -381, 0, 0, 0, 8, 1, 8, 1, 100807, 0, 0, 0, 0, 1, 0, 0x2C0080, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 71268, 71267, 71270, 71269, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 8, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Elemental Bonds: The Vow', 'Speak with Thrall at Nordrassil in Mount Hyjal.', 'Before he passed through the portal to Mount Hyjal, Thrall asked you to follow him. There is something he would like you to witness.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Elemental Bonds: The Vow +(29330, 2, 85, 0, 255, 0, 85, -381, 0, 0, 29331, 7, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x110008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Elemental Bonds: Fury', 'Kill fire elementals next to Aggra\'s Air Totem, on the western edge of the plateau, until it activates. Then continue to Aggra\'s Water Totem, Aggra\'s Earth Totem, and Aggra\'s Fire Totem.', 'The totems, $N! We need to activate them, or Go\'el is lost!$b$bKill the elementals next to each of my totems, located around the edges of this plateau. Once all four totems are activated, we should be able to free the last piece of Go\'el\'s soul!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Elemental Bonds: Fury +(29329, 2, 85, 0, 255, 0, 85, -381, 0, 0, 0, 6, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x20100008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 6, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Elemental Bonds: Patience', 'Speak with Aggra when you are ready to help Thrall. Then defeat the Elements of Patience and Corestones of Patience that are holding him captive.', 'With the Stonemother\'s blessing, I can take us to where Go\'el is being held.$b$bWe must be careful. The Twilight\'s Hammer has agents all around. You help me hold them off while I attempt to get through to Go\'el!$b$bSpeak with me when you are ready, and I will take you to him.', '', 'Speak with Aggra on the Staidridge in Deepholm.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Elemental Bonds: Patience +(29328, 2, 85, 0, 255, 0, 85, -381, 0, 0, 29337, 6, 1, 0, 1, 99730, 0, 0, 0, 0, 1, 0, 0x300008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 6, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Elemental Bonds: Desire', 'Slay the Tides of Longing and Vortexes of Longing near the Abyssal Breach until Thrall is free of their grasp.', 'Once again, $c, I cannot do this without your help. I will try to quiet this tempest, but you will need to fight back the unstable elementals that whirl around it. Only then can we free Go\'el!', '', 'Return to Aggra at the edge of the Abyssal Breach in the Abyssal Depths of Vashj\'ir.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Elemental Bonds: Desire +(29327, 2, 85, 0, 255, 0, 85, -381, 0, 0, 0, 6, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x20000000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 6, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Elemental Bonds: Doubt', 'Speak with Cyclonas to secure passage to Thrall. Then, fight the wind elementals that torment him until he is freed.', 'I do know the one you seek... but I do not know if it is wise for you to follow him. He has cast himself into the cyclone. The winds now tear at his body and mind, leaving nothing but shreds of flesh and doubt.$b$bChasing after him would only expose you to the same fate. The wind\'s edge leaves nothing uncut.$b$bYou have been warned. Now what will you do?', '', 'Speak with Aggra in Uldum.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Elemental Bonds: Doubt +(29326, 2, 85, 0, 255, 0, 85, -381, 0, 0, 29335, 4, 1, 4, 1, 81040, 0, 0, 0, 0, 1, 0, 0x20600008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1135, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'The Nordrassil Summit', 'Speak with Thrall under the World Tree in Mount Hyjal and witness the Earthen Ring ceremony.', 'Hello, $c! My brothers and sisters of the Earthen Ring have spoken well of your deeds in the wake of the Cataclysm. But much remains to be done if we are to heal this broken world.$B$BWalk with me, friend. Preparations for a ceremony are underway, a ritual that I hope will be a turning point in our battle against the Twilight\'s Hammer.$B$BWhen all is done, you will be able to spread the word about our triumph here.', '', 'Speak with Aggra under the World Tree in Mount Hyjal.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Nordrassil Summit +(29312, 2, 85, 0, 255, 0, 85, 1519, 62, 0, 0, 7, 1, 7, 1, 99869, 0, 0, 0, 0, 1, 0, 0x20A00008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 71086, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'The Stuff of Legends', 'Speak to Hallegosa.', 'It is an honor to make your acquaintance, $r.$b$bYour deeds echo in the ears of Azeroth\'s creatures, mortal and immortal alike.$b$bI shall present the heart of Ragnaros to Kalecgos when he arrives. Its power is to be harnessed to further endow your weapon.$b$bThe ceremony is to begin shortly. I have been appointed to escort you there when you are ready.', '', 'Speak with Hallegosa in Stormwind.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Stuff of Legends +(29309, 2, 85, 0, 255, 0, 85, 1637, 62, 0, 0, 7, 1, 7, 1, 99805, 0, 0, 0, 0, 1, 0, 0x20A00008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 71086, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'The Stuff of Legends', 'Speak to Hallegosa.', 'It is an honor to make your acquaintance, $r.$b$bYour deeds echo in the ears of Azeroth\'s creatures, mortal and immortal alike.$b$bI shall present the heart of Ragnaros to Kalecgos when he arrives. Its power is to be harnessed to further endow your weapon.$b$bThe ceremony is to begin shortly. I have been appointed to escort you there when you are ready.', '', 'Speak with Hallegosa in Orgrimmar.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Stuff of Legends +(29308, 2, 85, 0, 255, 0, 85, 4024, 62, 0, 29309, 7, 1, 7, 1, 0, 0, 0, 0, 0, 1, 0, 0x800048, 0x0, 0x0, 0, 0, 11121, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Heart of Flame', 'Empower the Runestaff of Nordrassil with 250 Soul Flame Essences and obtain the Heart of Flame.', 'You are the first mortal to witness a dragon council, $n, and among the only beings in Azeroth to take part in the choosing of an Aspect.$b$bMy ascension has endowed me with incredible power. I have taken the liberty to strengthen Tarecgosa\'s bond with you, though she will require a more... permanent home.$b$bI would have you venture one last time into the Plane of Fire and bring me the heart of Ragnaros.$b$bWhen next we meet, I will be able to suitably thank you for all that you have done.', '', 'Speak to Hallegosa in Orgrimmar.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Heart of Flame +(29307, 2, 85, 0, 255, 0, 85, 4024, 62, 0, 29312, 7, 1, 7, 1, 0, 0, 0, 0, 0, 1, 0, 0x800048, 0x0, 0x0, 0, 0, 11121, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Heart of Flame', 'Empower the Runestaff of Nordrassil with 250 Smouldering Essences and obtain the Heart of Flame.', 'You are the first mortal to witness a dragon council, $n, and among the only beings in Azeroth to take part in the choosing of an Aspect.$b$bMy ascension has endowed me with incredible power. I have taken the liberty to strengthen Tarecgosa\'s bond with you, though she will require a more... permanent home.$b$bI would have you venture one last time into the Plane of Fire and bring me the heart of Ragnaros.$b$bWhen next we meet, I will be able to suitably thank you for all that you have done.', '', 'Speak to Hallegosa in Stormwind.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Heart of Flame +(29285, 2, 85, 0, 255, 0, 85, 4024, 0, 0, 0, 7, 1, 7, 1, 100886, 0, 0, 0, 0, 1, 0, 0x20A00048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 71085, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Alignment', 'Accompany Kalecgos to the blue dragon council.$b$bSpeak to Kalecgos in Coldarra when ready.', 'The time of choosing has arrived, $n.$b$bWhile only members of the blue dragonflight may attend, Tarecgosa\'s binding makes your presence requisite.$b$bI must ask that you take on her form and vote on her behalf.$b$bDo not tarry. The moment of the eclipse draws near....', '', 'Speak to Kalecgos in Coldarra.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Alignment +(29270, 2, 85, 0, 255, 0, 85, 4024, 62, 0, 29285, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 0x800048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Time Grows Short', 'Collect 1000 Seething Cinders from the Firelands.', 'Tarecgosa is bound to you, $n, but only temporarily. An aspect\'s power is required to permanently seal her essence.$b$bMalygos\'s successor will not be chosen until Azeroth\'s moons next eclipse, and the bond you share will not last until then.$b$bFortunately, there is a way to buy us the time we need. Powerful elements exist that can extend the ritual\'s effects. Some of these can be found in the Plane of Fire, with which you\'ve become familiar.$b$bObtain them, $c, and sustain Tarecgosa until the eclipse.', '', 'Speak with Kalecgos in Coldarra', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Time Grows Short +(29269, 2, 85, 0, 255, 0, 85, 4024, 0, 0, 29270, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 0x20800048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'At One', 'Speak to Kalecgos to agree to his proposition.', 'I was charged with her protection, yet it was she who sacrificed herself for my sake.$b$bI cannot bear to lose her, $n. I must make a solemn request of you.$b$bNever has a mortal borne the essence of a true dragon, but with your permission I would make an exception.$b$bPlease, while there is life in her, will you allow me to bind Tarecgosa to you? ', 'Speak to Kalecgos in Coldarra.', 'Speak to Kalecgos in Coldarra.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- At One +(29240, 2, 85, 0, 255, 0, 85, 3537, 0, 0, 29269, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 0x800048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Emergency Extraction', 'Accompany Kalecgos to Coldarra.$b$bSpeak to him when you are ready.', 'Now, back to the matter at hand...$b$bI am convinced that the vision in the Nexus is one of Deathwing\'s illusions designed to bring conflict into our flight at a very fragile time.$b$bThe Worldbreaker would only be strengthened were we to fall to infighting.$b$bStill, a gnawing sense of unease tempts me to take a path of caution.$b$bIt would be wise for me to take Tarecgosa and withdraw until the time of choosing.', '', 'Speak to Kalecgos in Coldarra.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Emergency Extraction +(29239, 2, 85, 0, 255, 0, 85, 3537, 0, 0, 0, 7, 1, 7, 1, 81040, 0, 0, 0, 0, 1, 0, 0xA00048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 71084, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Nordrassil\'s Bough', 'Collect the Branch of Nordrassil at Amber Ledge in Borean Tundra.', 'Much has transpired since last we spoke.$b$bI have taken it upon myself to visit the Nexus and recover Anachronos\'s artifact, but not before using it for myself. Now I too have witnessed that which you have seen.$b$bBefore discussing the matter further, allow me to express my gratitude to you for your assistance, both here and in the Plane of Fire.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Nordrassil's Bough +(29234, 2, 85, 0, 255, 0, 85, 616, 62, 0, 29239, 7, 1, 7, 1, 0, 0, 0, 0, 0, 1, 0, 0x800048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Delegation', 'Recover the Branch of Nordrassil from the Firelands.', 'I am duty-bound to look into your claims immediately, $r, which means my mission here now must fall to you.$b$bA surge of ancient magic, far too strong to have occurred naturally, drew me here. I have since discovered a most troubling development.$b$bA bough from Nordrassil has been ripped from the tree and taken deep into the Firelands. There, a powerful ritual threatens to corrupt Nordrassil, consuming it in flame.$b$bYou must find a way to interrupt the ritual and reclaim the World Tree\'s branch.', '', 'Speak to Kalecgos at Amber Ledge in Borean Tundra.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Delegation +(29225, 2, 85, 0, 255, 0, 85, 4265, 0, 0, 29234, 3, 1, 3, 1, 0, 0, 0, 0, 0, 1, 0, 0x800048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Actionable Intelligence', 'Speak to Kalecgos at Nordrassil in Mount Hyjal.', '<Tarecgosa listens intently as you describe your vision.>$b$bImpossible!$b$bNot even Arygos would dare to go to such lengths.$b$bI do not question your integrity, $c, but you must understand - your mortal mind can easily be deceived.$b$bRegardless, Kalecgos must be informed of these events. You must travel to Nordrassil at once to seek him out.$b$bI shall remain here to conceal the evidence of our activities. Speak of this to no one else!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Actionable Intelligence +(29224, 2, 85, 0, 255, 0, 85, 4265, 0, 0, 0, 6, 1, 6, 1, 0, 0, 0, 0, 0, 1, 0, 0x88, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, '[DEPRICATED] NO LONGER USED', 'Gaze into the Timeless Eye.$b$bSpeak to Tarecgosa at the Rift to activate the artifact.', 'Here we are, mortal.$b$bThe rift emits intense energy that will shield the magic of your artifact.$b$bWhen you are ready, I will activate the Eye. Doing so will require all of my focus. You must witness the vision on your own.$b$bHurry now, $c. It is unsafe for us to tarry here.', '', 'Speak to Tarecgosa at the Rift in The Nexus.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- [DEPRICATED] NO LONGER USED +(29194, 2, 85, 0, 255, 0, 85, 4024, 81, 0, 29225, 6, 1, 6, 1, 0, 0, 0, 0, 0, 1, 0, 0x900048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2099199, 3, 'Through a Glass, Darkly', 'Look into the Eye of Eternity at the Nether Vortex in the Nexus.$b$bMeet Tarecgosa inside the Nexus where she will escort you to the rift.', '<Tarecgosa listens as you explain your presence in Coldarra.>$b$bYour tale rings true, $c. Much has changed since the death of Malygos - little of it for the better.$b$bI know of the device you carry, and I recognize Anachronos\' magic in its creation. There is but one place in all of Coldarra that would allow this Timeless Eye to be used discreetly.$b$bYou will require my assistance if you hope to succeed. Speak with me again inside the Nexus and you shall have it.', '', 'Speak to Tarecgosa at the Rift in the Nexus.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Through a Glass, Darkly +(29193, 2, 85, 0, 255, 0, 85, 2300, 0, 0, 29194, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 0x800048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69238, 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, 2099199, 3, 'On a Wing and a Prayer', 'Bring the Timeless Eye to Coldarra.', 'Time well spent, mortal.$b$bWhile you struggled in the Plane of Fire, my watchers and I were able to determine when and, most importantly, where our vision was obscured.$b$bWe discovered that the shroud was placed over the Nexus, far to the north in the realm of the blue dragonflight.$b$bI have attuned the Timeless Eye to show you the occurrences that remain hidden to us here.$b$bBring it to Coldarra at once and seek out a place suitable for its activation.$b$bGo, child. Time is of the essence...', '', 'Speak with Tarecgosa in Coldarra.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- On a Wing and a Prayer +(11139, 2, 37, 0, 255, 0, 32, 15, 0, 0, 11140, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2098253, 0, '[DEPRECATED]Secondhand Diving Gear', 'Bring the Tool Kit and Damaged Diving Gear to Renn McGill in the Dustwallow Marsh.', 'There\'s plenty of wreckage strewn across the bottom of the water from here to Alcaz, and the Defias have already got divers out there looking around. With the help of some of their gear, we can get you suited up and ready to join the hunt, but you\'ll have to do some creative \"borrowing\" first.$B$BSearch this island for a crate of diving gear and something to repair it with. When you\'ve got them, bring them to me and I\'ll have your gear ready in no time!', '', 'Return to Renn McGill at Dreadmurk Shore in Dustwallow Marsh.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- [DEPRECATED]Secondhand Diving Gear +(8906, 2, 60, 0, 255, 0, 58, 1537, 81, 0, 0, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4108, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 22011, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, 'An Earnest Proposition', 'Acquire 15 Winterspring Blood Samples and 20 gold and bring them along with a set of Beaststalker\'s Bindings to Deliana in Ironforge.', 'Well met, $c. I\'ve something that might interest you.$B$BI have in my possession a set of armor much like the one worn by those of your profession, but of much higher quality. I\'d be willing to trade the bracers for ordinary ones in exchange for a small favor.$B$BThe blood of the frostsabers and bears that inhabit Winterspring has properties I\'m in need of at the moment. Bring me a sizeable sample of it along with the bracers and a small amount of gold. You shall find the effort worth your while.', '', 'Return to Deliana at the High Seat in Ironforge.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- An Earnest Proposition +(8575, 2, 60, 0, 255, 0, 60, 16, 0, 0, 0, 5, 1, 0, 1, 0, 0, 0, 20949, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 910, 0, 0, 0, 0, 1, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 'Azuregos\'s Magical Ledger', 'Deliver Azuregos\'s Magical Ledger to Narain Soothfancy in Tanaris.', 'You cannot understand a single word on this ledger. You don\'t even know what language it is written in!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Azuregos's Magical Ledger +(8552, 2, 50, 0, 255, 0, 35, 33, 0, 0, 0, 3, 1, 0, 1, 0, 0, 0, 3985, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 87, 0, 0, 0, 3, -3, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'The Monogrammed Sash', 'Return the Monogrammed Sash to its owner.', 'This fine sash has the letters \"HS\" embroidered along its hem.', '', 'Find the Monogrammed Sash\'s owner at Booty Bay in Stranglethorn Vale.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Monogrammed Sash +(8256, 2, 52, 0, 255, 0, 50, -262, 0, 0, 8257, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 18446744073709551615, 0, 'The Ichor of Undeath', 'Acquire an Ichor of Undeath for Ogtinc in Azshara. Ogtinc resides atop the cliffs northeast the Ruins of Eldarath.', 'For this restorative salve, you must use a simple formula: one part poison, two parts cure. You have acquired one cure, now you must gather the poison.$b$bPowerful undead, such as the lingering highborne who wander the Ruins of Eldarath, are sometimes so infused with evil that it coalesces into a sickly greenish goo. To the living, this substance is known as ichor of undeath.$b$bDue to the potency of this vile element, I require only a single ichor.', '', 'Return to Ogtinc at The Shattered Strand in Azshara.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Ichor of Undeath +(7725, 2, 55, 0, 255, 0, 45, 357, 0, 0, 0, 0, 1, 2, 1, 0, 0, 0, 18904, 0, 1, 0, 0x4100, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 169, 0, 0, 0, 0, 2, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Again With the Zapped Giants', 'Use Zorbin\'s Ultra-Shrinker to zap any kind of giant found in Feralas into a more manageable form. Bring 10 Miniaturization Residues found on the zapped versions of these giants to Zorbin Fandazzle at the docks of the Forgotten Coast, Feralas.', 'I know you\'ve gathered residue for me already... but should you find yourself for want of an encore performance to a fun-time activity, I can always use more residue.$B$BWhile I can\'t offer nearly as much in the way of compensation again, I\'ll be more than happy to spread the good word of your service to all my goblin friends with ears.$B$BBelieve me $g sir : madam; when I say that these goblins have quite large ears.', '', 'Return to Zorbin Fandazzle at The Forgotten Coast in Feralas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Again With the Zapped Giants +(7045, 2, -1, 0, 255, 0, 30, -22, 0, 0, 0, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x8, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 17726, 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, 169, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'A Smokywood Pastures\' Thank You!', 'Speak with Greatfather Winter in Ironforge.', 'We at Smokywood Pastures appreciate the recovery of the stolen treats, $N. For that, we\'d like to offer you a special gift... presented by none other than Greatfather Winter himself!$B$BPlease, speak with Greatfather Winter, and he will give you your Feast of Winter Veil gift from us here at Smokywood Pastures. From our farm to your plate, it\'s always Smokywood Pastures wholesome goodness... thanks to you, of course!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- A Smokywood Pastures' Thank You! +(6984, 2, -1, 0, 255, 0, 30, -22, 0, 0, 0, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x8, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 17726, 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, 169, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'A Smokywood Pastures\' Thank You!', 'Speak with Great-father Winter in Orgrimmar.', 'We at Smokywood Pastures appreciate the recovery of the stolen treats, $N. For that, we\'d like to offer you a special gift... presented by none other than Great-father Winter himself!$B$BPlease, speak with Great-father Winter, and he will give you your Feast of Winter Veil gift from us here at Smokywood Pastures. From our farm to your plate, it\'s always Smokywood Pastures wholesome goodness... thanks to you, of course!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- A Smokywood Pastures' Thank You! +(6761, 2, 55, 0, 255, 0, 54, 1657, 0, 0, 6762, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 1, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'The New Frontier', 'Speak with Mathrengyl Bearwalker at the Cenarion Enclave of Darnassus.', 'I have relegated my second, Mathrengyl Bearwalker, to deal with Moonglade\'s call for aid. Speak to him on this matter - NOT me.$B$BLet me give you some... friendly... advice. It is I who led us out of the darkness - NOT the Cenarion Circle in Moonglade - when all was lost for our race. Teldrassil gives us all new life! They would have you believe otherwise, and to believe their propaganda would be a fool\'s task.$B$BI\'ll leave it to you to decide whether or not you\'re a fool.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The New Frontier +(4769, 2, 60, 0, 255, 0, 57, 1583, 62, 0, 4768, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4048, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68, 0, 0, 0, 0, 1, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Vivian Lagrave and the Darkstone Tablet', 'Speak with Shadowmage Vivian Lagrave.', 'Vivian Lagrave sent me word from Kargath, in the Badlands. Through her studies, she believes there is an ancient text within Blackrock Spire that would benefit our research. To confirm this, she will need someone to extract the text from the spire. No easy task.$B$BIf interested, then speak with Vivian in Kargath.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Vivian Lagrave and the Darkstone Tablet +(4736, 2, 31, 0, 255, 0, 31, -61, 0, 0, 1796, 2, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 18446744073709551615, 0, 'In Search of Menara Voidrender', 'Speak to Menara Voidrender in the Barrens.', 'Ah, hello, $N. You\'re progressing well in your training. So well in fact that I think you should be rewarded for your hard work--and for not becoming corrupted by the arcane yet.$B$BIf you\'re interested, seek out Menara Voidrender in Ratchet. She is currently staying at Strahad Farsan\'s tower overlooking the town.$B$BShe\'s not very friendly, $N, so don\'t expect any praise. But if you work hard, she\'ll make sure you\'re taken care of.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- In Search of Menara Voidrender +(4022, 2, 54, 0, 255, 0, 52, 46, 0, 0, 4024, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x400A, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 18446744073709551615, 0, 'A Taste of Flame', 'Show Cyrus Therepentous the Black Dragonflight Molt you received from Velarok Windblade.', 'The flight is aware of your work in the Searing Gorge.$B$BShow it to me, $r. The molt, imbecile.', 'Proof Presented', 'Speak to Cyrus Therepentous at Slither Rock in the Burning Steppes.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- A Taste of Flame +(2999, 2, -1, 0, 255, 0, 12, -141, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 4, 0, 'Tome of Divinity', 'Speak to Tiza Battleforge in Ironforge', 'Hello, $N. I know you\'re busy helping out the people of Dun Morogh, but when you have the time, you should go upstairs and speak to one of our most respected ilk: Tiza Battleforge. She\'s the one the younger paladins go to when it\'s time they learn more about the Light and what\'s expected of ya.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Tome of Divinity +(2970, 2, 47, 0, 255, 0, 38, 357, 0, 0, 0, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 4, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Doling Justice', 'Kill 12 Grimtotem Naturalists, 10 Grimtotem Raiders, and 6 Grimtotem Shamans before returning to Jer\'kai Moonweaver in Feralas.', 'As she\'s already told you, Kindal and I will now take the fight to the Grimtotem. Together, we should still be able to pick off some of the tauren without much threat to ourselves, but we\'d love some help if you\'re willing and able.$B$BYou\'ve seen the camp below us, but there are more to the east. Using your own tactics, deal as much damage to the tauren as you can. We can all meet back here after they\'ve felt the sting of Kindal\'s arrows and your own weapons.', '', 'Return to Jer\'kai Moonweaver in Feralas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Doling Justice +(2857, 2, 45, 0, 255, 0, 30, -182, 0, 0, 0, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 8405, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Wild Leather Helmet', 'Bring 2 Nightscape Tunics, 2 Nightscape Headbands, and a Wildvine to Jangdor Swiftstrider in Camp Mojache.', 'A Wild Leather helmet offers the wearer superior protection to the vital areas of the head without a sacrifice in comfort. As with all Wild Leather armor, the integrated wildvine yields a powerful but random magic imbuement to the helm\'s frame. Leather wearers will definitely want this piece!$B$BFor this pattern, I will need two Nightscape tunics, 2 Nightscape headbands, and a wildvine. Complete this lesson and the pattern will be yours!', '', 'Return to Jangdor Swiftstrider in Feralas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Wild Leather Helmet +(2856, 2, 45, 0, 255, 0, 30, -182, 0, 0, 0, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 8404, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Wild Leather Vest', 'Bring 2 Turtle Scale Breastplates, 2 Turtle Scale Gloves, and a Wildvine to Jangdor Swiftstrider in Camp Mojache.', 'Wild Leather vests are the staple of any Wild Leather armor set. The frame of the vest and the wildvine weave within it produces a product that offers maximum protection of the torso while allowing for potent magic to work its way through the garment.$B$BFor this pattern, I will require two Turtle Scale breastplates, two sets of Turtle Scale gloves, and a wildvine. This is not an easy lesson, but it is one you certainly have the skill to complete.', '', 'Return to Jangdor Swiftstrider in Feralas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Wild Leather Vest +(2855, 2, 45, 0, 255, 0, 30, -182, 0, 0, 0, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 8403, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Wild Leather Shoulders', 'Bring 6 Thick Armor Kits and a Wildvine to Jangdor Swiftstrider in Camp Mojache.', 'Wild Leather shoulders support a wearer\'s frame extremely well, offering superior protection of the upper arms as well as the shoulders. As with all Wild Leather armor, a random yet very potent enhancement is imbued within the item as the wildvine is stitched in.$B$BFor this pattern, I will require six thick armor kits and a wildvine. That shouldn\'t be too tall of an order for you to fill.', '', 'Return to Jangdor Swiftstrider in Feralas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Wild Leather Shoulders +(1428, 2, 45, 0, 255, 0, 35, 8, 0, 0, 0, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 76, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, '[DEPRECATED]Continued Threat', 'Kill 10 Marsh Inkspewers, 10 Marsh Flesheaters, and 10 Marsh Oracles, then return to Katar in the Swamp of Sorrows.', 'It pleases me to see your hatred for the fish men grows with mine.$B$BFind more of their kind along the beach, and when you\'ve had your fill of combat, return to me. We shall speak then of a reward for your diligence.', '', 'Return to Katar in Swamp of Sorrows.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- [DEPRECATED]Continued Threat +(1324, 2, 38, 0, 255, 0, 28, 1519, 0, 0, 0, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4002, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 4, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'The Missing Diplomat', 'Defeat Private Hendel in Dustwallow Marsh.', 'What?! You come here accusing me of allying with the Defias, and think I\'ll just stand here while you insult me?! Something tells me you\'ve had this coming for a long time.', 'Subdue Private Hendel', 'Return to Archmage Tervosh in Dustwallow Marsh.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- The Missing Diplomat +(778, 2, 45, 0, 255, 0, 35, 3, 0, 0, 0, 6, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 2820, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'This Is Going to Be Hard', 'Defeat the Fam\'retor Guardian and bring Lotwil\'s Shackles of Elemental Binding back to Lotwil Veriatus.', 'Haha! Done! The shackles are done!$B$BIt\'s time, Lucien. It\'s time, Servo!$B$BAre you ready to bear witness to the perfect blend of alchemy, engineering, and the arcane, $N?$B$BI shall summon forth a powerful elemental now. This is a groundbreaking day for all of us.', '', 'Return to Lotwil Veriatus at The Dustbowl in Badlands.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- This Is Going to Be Hard +(665, 2, 40, 0, 255, 0, 35, 45, 0, 0, 666, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4002, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 87, 0, 0, 0, 5, -5, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Sunken Treasure', 'Escort Professor Phizzlethorpe to the cave and back.', 'Now that we are full-fledged Blackwater Raiders it is our job to help Mr. O\'Breen locate the lost elven treasure.$b$bIt is next to impossible to find the gems in the dark sea without aid. The doctor has constructed some goggles that will help. He needs the goggles charged with the energy derived from the enchanted stone in the cave just up the hill.$b$bBut the cave is cursed! When we get close, we get ambushed. Defend me and I can harness the energy from the stone into the goggles.', 'Defend Professor Phizzlethorpe', 'Return to Doctor Draxlegauge at Faldir\'s Cove in Arathi Highlands.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916), -- Sunken Treasure +(394, 2, 31, 0, 255, 0, 16, 1519, 0, 0, 395, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 18446744073709551615, 0, 'The Head of the Beast', 'Speak to Mathias Shaw in Stormwind.', 'Find Shaw in Old Town. Let him know that the Lescovar threat has been dealt with and about your involvement in the Lord\'s plots against the city. I\'m sure he\'ll be proud to have another hero among Stormwind\'s citizens.$B$BHe\'ll more than likely send you off to meet with the Prince or some other noble. Don\'t let it get to your head, $N. The nobles can think they rule the city all they want, but some things remain out of their hands.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57916); -- The Head of the Beast + + +UPDATE `quest_template` SET `Flags`=0x1080, `RewardCurrencyQty1`=24000, `VerifiedBuild`=57916 WHERE `ID`=29185; -- Daily Tier 2 Heroic (1st) +UPDATE `quest_template` SET `RewardCurrencyQty1`=6000, `VerifiedBuild`=57916 WHERE `ID`=29183; -- Daily Tier 2 Heroic (Nth) +UPDATE `quest_template` SET `RewardXPDifficulty`=8, `RewardMoneyDifficulty`=7, `RewardCurrencyID1`=396, `RewardCurrencyQty1`=12000, `VerifiedBuild`=57916 WHERE `ID`=28906; -- Daily Heroic Random (Nth) +UPDATE `quest_template` SET `Flags`=0x1080, `VerifiedBuild`=57916 WHERE `ID`=28905; -- Daily Heroic Random (1st) (Cataclysm) +UPDATE `quest_template` SET `RewardArenaPoints`=100, `VerifiedBuild`=57916 WHERE `ID`=12493; -- PvP Test + +DELETE FROM `quest_objectives` WHERE `ID` IN (442894 /*442894*/, 442893 /*442893*/, 442891 /*442891*/, 442890 /*442890*/, 442889 /*442889*/, 442888 /*442888*/, 442887 /*442887*/, 442886 /*442886*/, 442869 /*442869*/, 442868 /*442868*/, 442852 /*442852*/, 442851 /*442851*/, 442830 /*442830*/, 442826 /*442826*/, 442821 /*442821*/, 442796 /*442796*/, 442795 /*442795*/, 410712 /*410712*/, 410711 /*410711*/, 390869 /*390869*/, 381468 /*381468*/, 381467 /*381467*/, 382374 /*382374*/, 382666 /*382666*/, 384158 /*384158*/, 383953 /*383953*/, 382108 /*382108*/, 382137 /*382137*/, 382136 /*382136*/, 382135 /*382135*/, 382316 /*382316*/, 382315 /*382315*/, 382314 /*382314*/, 382064 /*382064*/, 382063 /*382063*/, 381512 /*381512*/, 381511 /*381511*/, 381510 /*381510*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(442894, 29312, 1, 1, 1, 71085, 1, 0, 0, 0, '', 57916), -- 442894 +(442893, 29312, 0, 0, 0, 53715, 1, 0, 0, 0, 'Witnessed Dragonwrath Ceremony in Stormwind', 57916), -- 442893 +(442891, 29309, 1, 1, 1, 71085, 1, 0, 0, 0, '', 57916), -- 442891 +(442890, 29309, 0, 0, 0, 53715, 1, 0, 0, 0, 'Witnessed Dragonwrath Ceremony in Orgrimmar', 57916), -- 442890 +(442889, 29308, 1, 1, 1, 69848, 1, 0, 0, 0, '', 57916), -- 442889 +(442888, 29308, 0, 0, 0, 54198, 250, 0, 0, 0, 'Smouldering Essences Collected', 57916), -- 442888 +(442887, 29307, 1, 1, 1, 69848, 1, 0, 0, 0, '', 57916), -- 442887 +(442886, 29307, 0, 0, 0, 54198, 250, 0, 0, 0, 'Smouldering Essences Collected', 57916), -- 442886 +(442869, 29285, 1, 1, 1, 71084, 1, 0, 0, 0, '', 57916), -- 442869 +(442868, 29285, 0, 0, 0, 53227, 1, 0, 0, 0, 'Witnessed Kalecgos\'s Ascension', 57916), -- 442868 +(442852, 29270, 1, 0, 0, 69815, 1000, 0, 0, 0, '', 57916), -- 442852 +(442851, 29269, 0, 0, 0, 53182, 1, 0, 0, 0, 'Bonded with Tarecgosa\'s Essence', 57916), -- 442851 +(442830, 29240, 0, 0, 0, 53047, 1, 0, 0, 0, 'Accompanied Kalecgos to Coldarra', 57916), -- 442830 +(442826, 29234, 1, 0, 0, 69646, 1, 0, 1, 0, '', 57916), -- 442826 +(442821, 29224, 0, 0, 0, 52867, 1, 0, 0, 0, 'Timeless Eye Eveny Witnessed', 57916), -- 442821 +(442796, 29194, 0, 0, 0, 52867, 1, 0, 0, 0, 'Obscured Event Witnessed', 57916), -- 442796 +(442795, 29193, 0, 0, 0, 52832, 1, 0, 0, 0, 'Brought Timeless Eye to Coldarra', 57916), -- 442795 +(410712, 11139, 1, 1, 1, 33039, 1, 0, 1, 0, '', 57916), -- 410712 +(410711, 11139, 1, 0, 0, 33038, 1, 0, 1, 0, '', 57916), -- 410711 +(390869, 8906, 8, 2, 2, 0, 200000, 0, 0, 0, '', 57916), -- 390869 +(381468, 8906, 1, 1, 1, 16681, 1, 0, 0, 0, '', 57916), -- 381468 +(381467, 8906, 1, 0, 0, 21928, 15, 0, 1, 0, '', 57916), -- 381467 +(382374, 8575, 1, 0, 0, 20949, 1, 0, 0, 0, '', 57916), -- 382374 +(382666, 8552, 1, 0, 0, 3985, 1, 0, 0, 0, '', 57916), -- 382666 +(384158, 8256, 1, 0, 0, 7972, 1, 0, 0, 0, '', 57916), -- 384158 +(383953, 7725, 1, 0, 0, 18956, 10, 0, 1, 0, '', 57916), -- 383953 +(382108, 4022, 1, 0, 0, 10575, 1, 0, 0, 0, '', 57916), -- 382108 +(382137, 2970, 0, 2, 2, 7727, 6, 0, 0, 0, '', 57916), -- 382137 +(382136, 2970, 0, 1, 1, 7725, 10, 0, 0, 0, '', 57916), -- 382136 +(382135, 2970, 0, 0, 0, 7726, 12, 0, 0, 0, '', 57916), -- 382135 +(382316, 2857, 1, 2, 2, 8153, 1, 0, 0, 0, '', 57916), -- 382316 +(382315, 2857, 1, 1, 1, 8176, 2, 0, 0, 0, '', 57916), -- 382315 +(382314, 2857, 1, 0, 0, 8175, 2, 0, 0, 0, '', 57916), -- 382314 +(382064, 2855, 1, 1, 1, 8153, 1, 0, 0, 0, '', 57916), -- 382064 +(382063, 2855, 1, 0, 0, 8173, 6, 0, 0, 0, '', 57916), -- 382063 +(381512, 1428, 0, 2, 2, 752, 10, 0, 0, 0, '', 57916), -- 381512 +(381511, 1428, 0, 1, 1, 751, 10, 0, 0, 0, '', 57916), -- 381511 +(381510, 1428, 0, 0, 0, 750, 10, 0, 0, 0, '', 57916); -- 381510 |