aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2025-04-05 18:36:28 +0200
committerOvahlord <dreadkiller@gmx.de>2025-04-05 18:36:28 +0200
commitc8c5af648cd86d1766ba5ab075c2e27d451bb1ef (patch)
treea6ca2ab301e69b3958a6c79f98cac2ee86409faa
parentc5b07d27de86d7908a5cafdf08aa572312f1517b (diff)
DB/Quests: added quest data from mass parses
-rw-r--r--sql/updates/world/cata_classic/2025_04_05_02_world.sql216
1 files changed, 216 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_04_05_02_world.sql b/sql/updates/world/cata_classic/2025_04_05_02_world.sql
new file mode 100644
index 00000000000..b9499d24ceb
--- /dev/null
+++ b/sql/updates/world/cata_classic/2025_04_05_02_world.sql
@@ -0,0 +1,216 @@
+DELETE FROM `quest_offer_reward` WHERE `ID` IN (29516 /*Keeping the Faire Sparkling*/, 29512 /*Putting the Carnies Back Together Again*/, 29518 /*Rearm, Reuse, Recycle*/, 30104 /*Documenting the Timeways*/, 30103 /*To Wyrmrest!*/, 30105 /*The Twilight Prophet*/, 30102 /*The Hour of Twilight*/, 30101 /*The Path to the Dragon Soul*/, 30100 /*The Vainglorious*/, 30099 /*In Unending Numbers*/, 30098 /*The Well of Eternity*/, 30096 /*Murozond*/, 30097 /*Archival Purposes*/);
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(29516, 1, 1, 0, 0, 0, 0, 0, 0, 'Very nice work, $N. You\'ve quite a talent for this.', 59536), -- Keeping the Faire Sparkling
+(29512, 1, 2, 0, 0, 0, 0, 0, 0, 'Thank you for your help, $N. It takes all of us to keep the faire up and running.', 59536), -- Putting the Carnies Back Together Again
+(29518, 1, 1, 0, 0, 0, 0, 0, 0, 'There\'s a good bit of scrap here. Thanks for your help. It\'ll be a big help when I refit the steam tonks.$B$BPlease take this as a reward for your help.', 59536), -- Rearm, Reuse, Recycle
+(30104, 2, 21, 0, 0, 0, 0, 0, 0, 'We rarely enjoy the opportunity to employ a brave $c like you. Our archive grows more thorough, thanks to your efforts.', 59185), -- Documenting the Timeways
+(30103, 1, 1, 0, 0, 0, 0, 0, 0, 'I owe my life to you, heroes.$b$bNow that we hold the Dragon Soul safely within Wyrmrest, it may be that all of Azeroth owes their lives to you.', 59185), -- To Wyrmrest!
+(30105, 1, 0, 0, 0, 0, 0, 0, 0, 'It is truly as we foresaw: Benedictus was the Twilight Prophet. And now he is no more.$b$bWe dealt a mighty bow to the Twilight\'s Hammer today. Let us hope that it was a deathblow.', 59185), -- The Twilight Prophet
+(30102, 6, 0, 0, 0, 0, 0, 0, 0, 'You\'ve arrived.$b$bGood, let us begin.', 59185), -- The Hour of Twilight
+(30101, 1, 0, 0, 0, 0, 0, 0, 0, 'Thank you for your help, stranger.$b$bYou fight well. I hope to fight with you again in the future.', 59185), -- The Path to the Dragon Soul
+(30100, 1, 0, 0, 0, 0, 0, 0, 0, 'We are but moments away from the Dragon Soul.', 59185), -- The Vainglorious
+(30099, 273, 1, 0, 0, 0, 0, 0, 0, 'Good. We march on.', 59185), -- In Unending Numbers
+(30098, 1, 0, 0, 0, 0, 0, 0, 0, 'Let us proceed.', 59185), -- The Well of Eternity
+(30096, 1, 0, 0, 0, 0, 0, 0, 0, 'Murozond is no more. The timeways are open to me once again.', 59185), -- Murozond
+(30097, 1, 1, 0, 0, 0, 0, 0, 0, '<Alurmi collects the vessel from you.>$b$bI will handle these from here. Of course, they must be properly labeled, documented, and stored.', 59185); -- Archival Purposes
+
+UPDATE `quest_offer_reward` SET `RewardText`='Apothecary Hanes is alive? You burned the Alliance supplies to the ground? He must\'ve gotten a real kick out of that.$B$BAt any rate, the Royal Apothecary Society is in your debt, $N. We thank you from the bottom of our black, black hearts.', `VerifiedBuild`=59962 WHERE `ID`=11241; -- Trail of Fire
+UPDATE `quest_offer_reward` SET `RewardText`='I hope you\'re ready to fight, $N. The Queen\'s fleet needs you!', `VerifiedBuild`=59962 WHERE `ID`=11229; -- The Windrunner Fleet
+UPDATE `quest_offer_reward` SET `RewardText`='You continue to prove your competence, $N. Hopefully this toxin will be enough to boost our plague to the levels that we need to.$B$BAt the very least it should help weaken the recipient and make them more susceptible to infection.', `VerifiedBuild`=59962 WHERE `ID`=11168; -- Spiking the Mix
+UPDATE `quest_offer_reward` SET `Emote1`=2, `VerifiedBuild`=59536 WHERE `ID`=29436; -- The Humanoid Cannonball
+UPDATE `quest_offer_reward` SET `RewardText`='HA! You did it! The soldiers at the Wrathgate are indebted to you, $N! This\'ll surely buy a few of them another day above ground.', `VerifiedBuild`=59536 WHERE `ID`=12097; -- Sarathstra, Scourge of the North
+UPDATE `quest_offer_reward` SET `RewardText`='About time someone put a stop to that filthy beast\'s killing spree! A job well done, $N.', `VerifiedBuild`=59536 WHERE `ID`=12091; -- Wanted: Dreadtalon
+UPDATE `quest_offer_reward` SET `RewardText`='Kel\'Thuzad? So it\'s true - Naxxramas returns...$B$BPerhaps I underestimated you, $N. You\'ve done the Horde a great service. The Warchief would be proud!$B$B<Garrosh pauses to think.>$B$BIf Kel\'Thuzad is controlling these Scourge, there\'s no telling what else the Lich King has in store for us... I\'ll need time to think through this new information, $N. You are dismissed.', `VerifiedBuild`=59346 WHERE `ID`=11652; -- The Plains of Nasam
+UPDATE `quest_offer_reward` SET `RewardText`='NO MERCY FOR THE DEAD!$B$BNone of \'em had the guts to stay behind to defend our glorious tanks after Hellscream deemed the coast \'condemned.\' It\'s mostly quiet here, seein\' as how the Scourge are formin\' up ranks to assault Warsong Hold. Sometimes I get a stray zombie or ghoul, but they don\'t last very long.$B$B\'Course, there\'s the mist...', `VerifiedBuild`=59346 WHERE `ID`=11636; -- Magic Carpet Ride
+UPDATE `quest_offer_reward` SET `RewardText`='You\'re a true hero, $N. My kodos would have died out there without you. You have my thanks and the thanks of all the soldiers and journeymen that will use these kodos to strengthen our presence in Northrend!', `VerifiedBuild`=59346 WHERE `ID`=11690; -- Bring 'Em Back Alive
+UPDATE `quest_offer_reward` SET `RewardText`='Each prisoner saved is one less undead aberration that we have to deal with, $N. You\'ve done a great service for the Horde.', `VerifiedBuild`=59346 WHERE `ID`=11676; -- Merciful Freedom
+UPDATE `quest_offer_reward` SET `RewardText`='They just keep on coming, despite our best efforts. Something\'s gotta give, $N.', `VerifiedBuild`=59346 WHERE `ID`=11602; -- Cutting Off the Source
+UPDATE `quest_offer_reward` SET `RewardText`='Ah, so you managed to recover the staff. Impressive, $N. Perhaps you are the one I\'ve been looking for.$B$BOh yes, your reward...$B$B<Ravandwyr presses a few coins into your palm.>$B$BNo doubt you had higher expectations, but that too will come with time. For now, consider opportunity the true reward.', `VerifiedBuild`=59346 WHERE `ID`=10173; -- The Archmage's Staff
+
+DELETE FROM `quest_details` WHERE `ID` IN (29516 /*Keeping the Faire Sparkling*/, 29512 /*Putting the Carnies Back Together Again*/, 29518 /*Rearm, Reuse, Recycle*/, 11979 /*The Taunka and the Tauren*/, 12189 /*Imbeciles Abound!*/, 11711 /*Coward Delivery... Under 30 Minutes or it's Free*/, 11574 /*Too Close For Comfort*/, 11709 /*Nork Bloodfrenzy's Charge*/, 12486 /*To Bor'gorok Outpost, Quickly!*/, 11662 /*Seek Out Karuk!*/, 11661 /*Orabus the Helmsman*/, 11652 /*The Plains of Nasam*/, 11656 /*Burn in Effigy*/, 11651 /*Tanks a lot...*/, 11664 /*Escaping the Mist*/, 11644 /*Super Strong Metal Plates!*/, 11643 /*Mobu's Pneumatic Tank Transjigamarig*/, 11660 /*Horn of the Ancient Mariner*/, 11655 /*Into the Mist*/, 11642 /*Tank Ain't Gonna Fix Itself*/, 11705 /*Foolish Endeavors*/, 11703 /*Get to Getry*/, 11690 /*Bring 'Em Back Alive*/, 11676 /*Merciful Freedom*/, 11688 /*Damned Filthy Swine*/, 11686 /*The Warsong Farms*/, 11636 /*Magic Carpet Ride*/, 29609 /*Friends in Dalaran*/, 11618 /*Reinforcements Incoming...*/, 11616 /*Message to Hellscream*/, 11634 /*Wind Master To'bor*/, 11615 /*Nerub'ar Secrets*/, 11614 /*Untold Truths*/, 11602 /*Cutting Off the Source*/, 11608 /*Bury Those Cockroaches!*/, 11888 /*Ride to Taunka'le Village*/, 11611 /*Taken by the Scourge*/, 11606 /*Patience is a Virtue that We Don't Need*/, 11598 /*Taking Back Mightstone Quarry*/, 11596 /*The Defense of Warsong Hold*/, 11585 /*Hellscream's Vigil*/, 28711 /*Warchief's Command: Northrend!*/, 30105 /*The Twilight Prophet*/, 30103 /*To Wyrmrest!*/, 30102 /*The Hour of Twilight*/, 30101 /*The Path to the Dragon Soul*/, 30100 /*The Vainglorious*/, 30104 /*Documenting the Timeways*/, 30099 /*In Unending Numbers*/, 30098 /*The Well of Eternity*/, 30097 /*Archival Purposes*/, 30096 /*Murozond*/);
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(29516, 1, 1, 0, 0, 0, 0, 0, 0, 59536), -- Keeping the Faire Sparkling
+(29512, 1, 1, 0, 0, 0, 0, 0, 0, 59536), -- Putting the Carnies Back Together Again
+(29518, 1, 1, 0, 0, 0, 0, 0, 0, 59536), -- Rearm, Reuse, Recycle
+(11979, 5, 1, 1, 1, 0, 0, 0, 0, 59536), -- The Taunka and the Tauren
+(12189, 1, 1, 1, 0, 0, 0, 0, 0, 59536), -- Imbeciles Abound!
+(11711, 1, 1, 1, 1, 0, 0, 0, 0, 59346), -- Coward Delivery... Under 30 Minutes or it's Free
+(11574, 5, 5, 1, 0, 0, 1000, 1000, 0, 59346), -- Too Close For Comfort
+(11709, 0, 0, 0, 0, 0, 0, 0, 0, 59346), -- Nork Bloodfrenzy's Charge
+(12486, 6, 1, 1, 25, 0, 2000, 0, 0, 59346), -- To Bor'gorok Outpost, Quickly!
+(11662, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Seek Out Karuk!
+(11661, 0, 0, 0, 0, 0, 0, 0, 0, 59346), -- Orabus the Helmsman
+(11652, 1, 1, 1, 5, 0, 0, 0, 0, 59346), -- The Plains of Nasam
+(11656, 1, 1, 5, 0, 0, 0, 0, 0, 59346), -- Burn in Effigy
+(11651, 1, 1, 0, 0, 0, 0, 0, 0, 59346), -- Tanks a lot...
+(11664, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Escaping the Mist
+(11644, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Super Strong Metal Plates!
+(11643, 1, 1, 1, 1, 0, 0, 0, 0, 59346), -- Mobu's Pneumatic Tank Transjigamarig
+(11660, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Horn of the Ancient Mariner
+(11655, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Into the Mist
+(11642, 0, 0, 0, 0, 0, 0, 0, 0, 59346), -- Tank Ain't Gonna Fix Itself
+(11705, 1, 1, 6, 1, 0, 0, 0, 0, 59346), -- Foolish Endeavors
+(11703, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Get to Getry
+(11690, 1, 1, 1, 1, 0, 0, 0, 0, 59346), -- Bring 'Em Back Alive
+(11676, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Merciful Freedom
+(11688, 5, 1, 1, 5, 0, 0, 0, 0, 59346), -- Damned Filthy Swine
+(11686, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- The Warsong Farms
+(11636, 1, 1, 1, 1, 0, 0, 0, 0, 59346), -- Magic Carpet Ride
+(29609, 1, 1, 0, 0, 0, 0, 0, 0, 59346), -- Friends in Dalaran
+(11618, 1, 1, 1, 25, 0, 0, 0, 0, 59346), -- Reinforcements Incoming...
+(11616, 0, 0, 0, 0, 0, 0, 0, 0, 59346), -- Message to Hellscream
+(11634, 1, 1, 1, 1, 0, 0, 0, 0, 59346), -- Wind Master To'bor
+(11615, 0, 0, 0, 0, 0, 0, 0, 0, 59346), -- Nerub'ar Secrets
+(11614, 1, 1, 1, 1, 0, 0, 0, 0, 59346), -- Untold Truths
+(11602, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Cutting Off the Source
+(11608, 1, 1, 1, 5, 0, 0, 0, 0, 59346), -- Bury Those Cockroaches!
+(11888, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Ride to Taunka'le Village
+(11611, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Taken by the Scourge
+(11606, 1, 1, 1, 1, 0, 0, 0, 0, 59346), -- Patience is a Virtue that We Don't Need
+(11598, 1, 1, 1, 25, 0, 0, 0, 0, 59346), -- Taking Back Mightstone Quarry
+(11596, 1, 274, 1, 1, 0, 0, 0, 0, 59346), -- The Defense of Warsong Hold
+(11585, 5, 1, 1, 66, 0, 0, 0, 0, 59346), -- Hellscream's Vigil
+(28711, 1, 1, 1, 0, 0, 0, 0, 0, 59346), -- Warchief's Command: Northrend!
+(30105, 0, 0, 0, 0, 0, 0, 0, 0, 59185), -- The Twilight Prophet
+(30103, 1, 1, 0, 0, 0, 0, 0, 0, 59185), -- To Wyrmrest!
+(30102, 1, 6, 0, 0, 0, 0, 0, 0, 59185), -- The Hour of Twilight
+(30101, 1, 1, 1, 1, 0, 0, 0, 0, 59185), -- The Path to the Dragon Soul
+(30100, 0, 0, 0, 0, 0, 0, 0, 0, 59185), -- The Vainglorious
+(30104, 0, 0, 0, 0, 0, 0, 0, 0, 59185), -- Documenting the Timeways
+(30099, 1, 1, 0, 0, 0, 0, 0, 0, 59185), -- In Unending Numbers
+(30098, 1, 1, 0, 0, 0, 0, 0, 0, 59185), -- The Well of Eternity
+(30097, 0, 0, 0, 0, 0, 0, 0, 0, 59185), -- Archival Purposes
+(30096, 0, 0, 0, 0, 0, 0, 0, 0, 59185); -- Murozond
+
+DELETE FROM `quest_request_items` WHERE `ID` IN (30112 /*A Score to Settle*/, 30105 /*The Twilight Prophet*/, 30104 /*Documenting the Timeways*/, 30103 /*To Wyrmrest!*/, 30101 /*The Path to the Dragon Soul*/, 30100 /*The Vainglorious*/, 30099 /*In Unending Numbers*/, 30097 /*Archival Purposes*/, 30096 /*Murozond*/, 29163 /*Rage Against the Flames*/, 29162 /*Nature's Blessing*/, 29161 /*Those Bears Up There*/, 29142 /*Traitors Return*/, 29825 /*Pupil No More*/, 29808 /*Don't Forget the Eggs!*/, 29518 /*Rearm, Reuse, Recycle*/, 29516 /*Keeping the Faire Sparkling*/, 29512 /*Putting the Carnies Back Together Again*/, 29463 /*It's Hammer Time*/, 29438 /*He Shoots, He Scores!*/);
+INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES
+(30112, 0, 0, 0, 0, 'Is it done, $N?', 60142), -- A Score to Settle
+(30105, 0, 0, 0, 0, 'I have my suspicions about this Twilight Prophet.', 60142), -- The Twilight Prophet
+(30104, 0, 0, 0, 0, 'Our repository is never full.', 60142), -- Documenting the Timeways
+(30103, 0, 0, 0, 0, 'Come, $N. We do not have much further to travel.', 60142), -- To Wyrmrest!
+(30101, 0, 0, 0, 0, 'What?', 60142), -- The Path to the Dragon Soul
+(30100, 0, 0, 0, 0, 'Azshara and her fawners have long prepared for this day. She will not take our interference lightly.', 60142), -- The Vainglorious
+(30099, 0, 0, 0, 0, 'You should temporarily lay aside any prejudices you may carry against Illidan. Remember, you are ten thousand years in your past, and he must not be punished for any future crimes.', 60142), -- In Unending Numbers
+(30097, 0, 0, 0, 0, 'Nozdormu is acting with haste. This is something that Nozdormu does not usually do.$b$bNormally I would be more thorough with my archival. However, given the circumstances, we are forced to pick and choose what we record... and to employ the help of mercenaries like you.', 60142), -- Archival Purposes
+(30096, 0, 0, 0, 0, 'This is a future of Azeroth, yes... but not an inevitable one.$b$bThis future is what my fellow aspects are trying to avoid.', 60142), -- Murozond
+(29163, 0, 0, 0, 0, 'There isn\'t time to waste, $r.', 60142), -- Rage Against the Flames
+(29162, 0, 0, 0, 0, 'Want to frolic a little after this?', 60142), -- Nature's Blessing
+(29161, 0, 0, 0, 0, '<Mylune gives you the big eyes.>', 60142), -- Those Bears Up There
+(29142, 0, 0, 0, 0, 'How does the front look?', 60142), -- Traitors Return
+(29825, 0, 0, 0, 0, 'Is the mighty Nadox dead for good?', 60142), -- Pupil No More
+(29808, 0, 0, 0, 0, 'Were you able to rid our home of the scourged eggs?', 60142), -- Don't Forget the Eggs!
+(29518, 1, 1, 0, 0, 'Did you manage to find any scrap? The grounds are full of it.', 60142), -- Rearm, Reuse, Recycle
+(29516, 6, 6, 0, 0, 'Were you able to craft any replacement gems for the performers\' jewelry?', 60142), -- Keeping the Faire Sparkling
+(29512, 0, 1, 0, 0, 'Did you see to the needs of the injured workers?', 60142), -- Putting the Carnies Back Together Again
+(29463, 0, 1, 0, 0, 'How did you do out there?', 60142), -- It's Hammer Time
+(29438, 0, 0, 0, 0, 'Shooting static targets isn\'t always as easy at it seems.', 60142); -- He Shoots, He Scores!
+
+UPDATE `quest_request_items` SET `EmoteOnComplete`=1, `EmoteOnIncomplete`=1, `VerifiedBuild`=60142 WHERE `ID`=29288; -- Starting Young
+UPDATE `quest_request_items` SET `CompletionText`='Yes, $N?', `VerifiedBuild`=60142 WHERE `ID`=25472; -- The Flameseer's Staff
+UPDATE `quest_request_items` SET `CompletionText`='Is it done yet, $N?', `VerifiedBuild`=60142 WHERE `ID`=25464; -- The Return of Baron Geddon
+UPDATE `quest_request_items` SET `EmoteOnIncomplete`=6, `CompletionText`='What? What?! Be quick about it... there\'s so much to do around here.$B$BI want to get this thing off the ground some day, you know?', `VerifiedBuild`=60142 WHERE `ID`=10701; -- Breaking Down Netherock
+UPDATE `quest_request_items` SET `CompletionText`='Is it done, $N?', `VerifiedBuild`=60142 WHERE `ID`=25323; -- Flamebreaker
+UPDATE `quest_request_items` SET `CompletionText`='Is it done, $N?', `VerifiedBuild`=60142 WHERE `ID`=25319; -- War on the Twilight's Hammer
+UPDATE `quest_request_items` SET `CompletionText`='Have you created some havoc down there, $N?', `VerifiedBuild`=60142 WHERE `ID`=25234; -- In the Rear With the Gear
+UPDATE `quest_request_items` SET `EmoteOnComplete`=1, `EmoteOnIncomplete`=1, `VerifiedBuild`=60142 WHERE `ID`=11262; -- Ingvar Must Die!
+UPDATE `quest_request_items` SET `CompletionText`='Please, $n, tell me you\'ve found the book...' WHERE `ID`=13095;
+UPDATE `quest_request_items` SET `CompletionText`='Are the Alliance leaders dead, $N? Do not return until they are.', `VerifiedBuild`=60142 WHERE `ID`=11233; -- Landing the Killing Blow
+UPDATE `quest_request_items` SET `CompletionText`='Have you obtained the toxin glands I seek, $N?', `VerifiedBuild`=60142 WHERE `ID`=11168; -- Spiking the Mix
+UPDATE `quest_request_items` SET `EmoteOnIncomplete`=1, `VerifiedBuild`=60142 WHERE `ID`=29436; -- The Humanoid Cannonball
+
+DELETE FROM `quest_template` WHERE `ID` IN (88800 /*Warchief's Command Board*/, 88797 /*Hero's Call Board*/, 88796 /*Hero's Call Board*/, 88789 /*Talented*/, 88787 /*Talented*/, 88786 /*Talented*/, 88785 /*Combat Training*/, 88784 /*Combat Training*/, 88783 /*Combat Training*/, 88782 /*Tools for Survival*/, 88781 /*Tools for Survival*/, 88780 /*Tools for Survival*/, 88779 /*A New Beginning*/, 88778 /*A New Beginning*/, 88777 /*A New Beginning*/, 88776 /*A New Beginning*/, 86600 /*Daily Heroic Random (1st) (Cataclysm)*/, 30118 /*Patricide*/, 30116 /*Sharpening Your Fangs*/, 30113 /*Victory in the Depths*/, 30109 /*Blood of the Betrayer*/, 30108 /*Our Man in Karazhan*/, 30107 /*Cluster Clutch*/, 30106 /*The Deed is Done*/, 30105 /*The Twilight Prophet*/, 30104 /*Documenting the Timeways*/, 30103 /*To Wyrmrest!*/, 30102 /*The Hour of Twilight*/, 30101 /*The Path to the Dragon Soul*/, 30100 /*The Vainglorious*/, 30099 /*In Unending Numbers*/, 30098 /*The Well of Eternity*/, 30097 /*Archival Purposes*/, 30096 /*Murozond*/, 30095 /*The End Time*/, 30094 /*The End Time*/, 30093 /*Assassinate Creed*/, 30092 /*Our Man in Gilneas*/, 29934 /*To Ravenholdt*/, 29847 /*To Catch a Thief*/, 29802 /*A Hidden Message*/, 6065 /*The Hunter's Path*/, 3841 /*An Orphan Looking For a Home*/, 2847 /*Wild Leather Armor*/, 1047 /*The New Frontier*/);
+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
+(88800, 2, 85, 0, 85, 0, 85, 1637, 0, 0, 0, 1, 1, 0, 1, 453126, 0, 0, 0, 0, 1, 0, 0x2300008, 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, 3, 'Warchief\'s Command Board', 'Head to the Valley of Strength in Orgrimmar and speak to the Warchief\'s Herald.', 'By the order of Warchief Garrosh Hellscream, I have been tasked with dispatching any and all $C\'s to take arms and aid in the Horde\'s campaigns across Azeroth!\n\nYou are ready, $p.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Warchief's Command Board
+(88797, 2, 85, 0, 85, 0, 85, 1519, 0, 0, 0, 1, 1, 0, 1, 453126, 0, 0, 0, 0, 1, 0, 0x2200000, 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, 6130900294268439629, 3, 'Hero\'s Call Board', 'Use the scroll of teleportation from your inventory to reach Stormwind City and speak to Melris Malagan.', 'King Varian Wrynn has asked of The Knights of the Ebon Blade to dispatch any and all $C\'s to take arms and aid in the Alliance\'s campaigns across Azeroth!\n\nYou are ready, $p.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Hero's Call Board
+(88796, 2, 85, 0, 85, 0, 85, 1519, 0, 0, 0, 1, 1, 0, 1, 453126, 0, 0, 0, 0, 1, 0, 0x2300008, 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, 3, 'Hero\'s Call Board', 'Head to the Trade District in Stormwind and speak to Melris Malagan.', 'By the order of King Varian Wrynn, I have been tasked with dispatching any and all $C\'s to take arms and aid in the Alliance\'s campaigns across Azeroth!\n\nYou are ready, $p.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Hero's Call Board
+(88789, 2, 85, 0, 85, 0, 85, 1637, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2100008, 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, 2, 'Talented', 'Activate the Talents interface and allocate 5 Talent Points.', 'Every $C makes use of different abilities, talents and capabilities. We differ from each other in that we have unique interests and inclinations.\n\nWhen you level up in power, you can enhance and specialize your abilities through your talents, without the instruction of a trainer.\n\nIf you change your mind on these talents, you can speak with a $C trainer to rework them.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Talented
+(88787, 2, 85, 0, 85, 0, 85, 4342, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2100008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 224452, 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, 6130900294268439629, 2, 'Talented', 'Activate the Talents interface and allocate 5 Talent Points.', 'Every $C makes use of different abilities, talents and capabilities. We differ from each other in that we have unique interests and inclinations.\n\nWhen you level up in power, you can enhance and specialize your abilities through your talents, without the instruction of a trainer.\n\nIf you change your mind on these talents, you can speak with a $C trainer to rework them.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Talented
+(88786, 2, 85, 0, 85, 0, 85, 1519, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2100008, 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, 2, 'Talented', 'Activate the Talents interface and allocate 5 Talent Points.', 'Every $C makes use of different abilities, talents and capabilities. We differ from each other in that we have unique interests and inclinations.\n\nWhen you level up in power, you can enhance and specialize your abilities through your talents, without the instruction of a trainer.\n\nIf you change your mind on these talents, you can speak with a $C trainer to rework them.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Talented
+(88785, 2, 85, 0, 85, 0, 85, 1637, 0, 0, 0, 1, 1, 6, 1.714300036430358886, 0, 0, 0, 0, 0, 1, 0, 0x2100000, 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, 2, 'Combat Training', 'Train a spell by speaking to a $C trainer.', 'As you grow in power, so does your capabilities of being a skillful $C.\n\nYou can find trainers all around Azeroth, and in capital cities such as here in Orgrimmar, Thunder Bluff, or the Undercity.\n\nThere\'s a price to this knowledge, but I will reimburse you just this once. When you are ready, speak with me again to train your abilities.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Combat Training
+(88784, 2, 85, 0, 85, 0, 85, 4342, 0, 0, 0, 1, 1, 6, 1.714300036430358886, 0, 0, 0, 0, 0, 1, 0, 0x2100000, 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, 2, 'Combat Training', 'Train a spell by speaking to a $C trainer.', 'As you grow in power, so does your capabilities of being a skillful $C.\n\nThere\'s a price to this knowledge, but I will reimburse you just this once. When you are ready, speak with me again to train your abilities.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Combat Training
+(88783, 2, 85, 0, 85, 0, 85, 1519, 0, 0, 0, 1, 1, 6, 1.714300036430358886, 0, 0, 0, 0, 0, 1, 0, 0x2100000, 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, 2, 'Combat Training', 'Train a spell by speaking to a $C trainer.', 'As you grow in power, so does your capabilities of being a skillful $C.\n\nYou can find trainers all around Azeroth, and in capital cities such as here in Stormwind, Darnassus, or Ironforge.\n\nThere\'s a price to this knowledge, but I will reimburse you just this once. When you are ready, speak with me again to train your abilities.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Combat Training
+(88782, 2, 85, 0, 85, 0, 85, 1637, 0, 0, 88785, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2000000, 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, 2, 'Tools for Survival', 'Open the survival kit and equip a weapon.', 'Before we begin, you need to be equipped with weapons and armor suited to your talents. The life of an adventurer is never dull, and you never know what will happen next!\n\nI\'ve prepared a survival kit for your adventures. It contains additional weapons, armor, and rations. I trust that you will make use of it well.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Tools for Survival
+(88781, 2, 85, 0, 85, 0, 85, 4342, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2000000, 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, 2, 'Tools for Survival', 'Open the survival kit and equip a weapon.', 'Before we begin, you need to be equipped with weapons and armor suited to your talents. The life of an adventurer is never dull, and you never know what will happen next!\n\nI\'ve prepared a survival kit for your adventures. It contains additional weapons, armor, and rations. I trust that you will make use of it well.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Tools for Survival
+(88780, 2, 85, 0, 85, 0, 85, 1519, 0, 0, 88783, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2000000, 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, 2, 'Tools for Survival', 'Open the survival kit and equip a weapon.', 'Before we begin, you need to be equipped with weapons and armor suited to your talents. The life of an adventurer is never dull, and you never know what will happen next!\n\nI\'ve prepared a survival kit for your adventures. It contains additional weapons, armor, and rations. I trust that you will make use of it well.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Tools for Survival
+(88779, 2, 85, 0, 85, 0, 85, 1638, 0, 0, 88782, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2080000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 237808, 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, 2, 'A New Beginning', 'Meet with a $C trainer in Thunder Bluff.', 'A letter magically appears in the lining of your armor. It reads:\n\n\"Welcome to Thunder Bluff, capital to the Tauren!\n\nMeet with a $C trainer to begin your training. They will help prepare you for your journey across Azeroth and beyond.\"', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- A New Beginning
+(88778, 2, 85, 0, 85, 0, 85, 1637, 0, 0, 88782, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2080000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 237808, 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, 2, 'A New Beginning', 'Meet with a $C trainer in Orgrimmar.', 'A letter magically appears in the lining of your armor. It reads:\n\n\"Welcome to Orgrimmar, capital of the Horde!\n\nMeet with a $C trainer to begin your training. They will help prepare you for your journey across Azeroth and beyond.\"', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- A New Beginning
+(88777, 2, 85, 0, 85, 0, 85, 4342, 0, 0, 88781, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2080000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 237808, 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, 2, 'A New Beginning', 'Meet with a $C trainer in Acherus: The Ebon Hold.', 'A letter magically appears in the lining of your armor. It reads:\n\n\"Welcome to Acherus: The Ebon Hold, the sanctuary for all Death Knights who denounce the Lich King!\"\n\nMeet with a $C trainer to begin your training. They will help prepare you for your journey across Azeroth and beyond.\"', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- A New Beginning
+(88776, 2, 85, 0, 85, 0, 85, 1519, 0, 0, 88780, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x2080000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 237808, 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, 2, 'A New Beginning', 'Meet with a $C trainer in Stormwind.', 'A letter magically appears in the lining of your armor. It reads:\n\n\"Welcome to the city of Stormwind, capital of the Alliance! \n\nMeet with a $C trainer to begin your training. They will help prepare you for your journey across Azeroth and beyond.\"', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- A New Beginning
+(86600, 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, 60142), -- Daily Heroic Random (1st) (Cataclysm)
+(30118, 2, 85, 0, 255, 0, 85, -162, 83, 0, 0, 5, 1, 5, 1, 109916, 0, 0, 0, 0, 1, 0, 0x300040, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 77949, 77950, 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, 349, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Patricide', 'Destroy Deathwing and retrieve a Fragment of Deathwing\'s Jaw. ', 'Your next target has claimed the lives of all of my other assassins. I need you to kill my father himself.$B$BYou must destroy Deathwing.$B$BWe are out of time. His madness has already corrupted all the others of my kind, and his darkness will consume the world if he is not stopped.$B$BIf you by some miracle succeed, and can retrieve for me a piece of him - perhaps a fragment of the armor he uses to disguise his true chaotic nature - the reward I give you will be without equal. ', '', 'Take the Fragment of Deathwing\'s Jaw, along with your daggers The Sleeper and The Dreamer, to Wrathion at Ravenholdt Manor in Hillsbrad Foothills.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Patricide
+(30116, 2, 85, 0, 255, 0, 85, -162, 83, 0, 0, 5, 1, 5, 1, 109676, 0, 0, 0, 0, 1, 0, 0x2200000, 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, 349, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Sharpening Your Fangs', 'Collect 60 Elementium Gem Clusters from creatures in the Dragon Soul Raid encounter.', 'Do you understand why I have you assassinate the dragons, yet spare the mortals? It isn\'t their fault. They must seek out their own destiny, free from the meddling of my kind.$B$BWe are nearing the end of our mission, and it is time for you to seek out your own destiny as well. I can continue to augment your weapons, but collecting shadowy gems won\'t be enough. My work will require entire clusters. Gather them from my father\'s minions...', '', 'Bring the clusters to Wrathion in Ravenholdt Manor in Hillsbrad Foothills.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Sharpening Your Fangs
+(30113, 2, 85, 0, 255, 0, 85, -162, 83, 0, 0, 3, 1, 3, 1, 109658, 0, 0, 78339, 0, 1, 0, 0x200000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 77947, 77948, 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, 349, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Victory in the Depths', 'Take the Vial of Preserved Dragonsblood, along with your daggers Fear and Vengeance, to Wrathion at Ravenholdt Manor in Hillsbrad Foothills.', '<Zazzo performs an enchantment on the vial of blood, then quickly hands it back to you, as though it\'s toxic.>$B$BDone! You\'ll want to get this back to Wrathion as soon as possible, along with those two daggers of yours.$B$BI don\'t know what he plans to do with this stuff. Between you and me, sometimes that little dragon kid creeps me out. Good luck!', '', 'Take the Vial of Preserved Dragonsblood, along with your daggers Fear and Vengeance, to Wrathion at Ravenholdt Manor in Hillsbrad Foothills.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Victory in the Depths
+(30109, 2, 85, 0, 255, 0, 85, -162, 83, 0, 30113, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 0x100000, 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, 349, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Blood of the Betrayer', 'Sneak into the Master\'s Cellar in the ruins around Karazhan, defeat Nalice, and acquire a Vial of Black Dragonsblood.', 'I\'ve pinpointed Nalice to the Master\'s Cellar, an extended basement you\'ll find in the ruins up ahead.$B$BDragon cultists are everywhere, and Nalice has set up some strange arcane storage devices throughout the area. Perhaps you can use those to your advantage?$B$BSneak past the cultists, obliterate Nalice, and grab a vial of her blood for Wrathion.$B$BI\'ll keep my eyes on you and pull you out if you get into any trouble. But I\'m NOT coming in there with you!', '', 'Take the vial to Zazzo Twinklefingers at Karazhan in Deadwind Pass.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Blood of the Betrayer
+(30108, 2, 85, 0, 255, 0, 85, -162, 83, 0, 30109, 3, 1, 3, 1, 0, 0, 0, 0, 0, 1, 0, 0x400000, 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, 349, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Our Man in Karazhan', 'Report to Zazzo Twinklefingers in the ruins just southeast of Karazhan.', 'Your next target is the Black Dragon Nalice, who is engaged in some sort of arcane debauchery beneath the ruined tower of Karazhan.$B$BYour primary mission is to destroy her, but if you can bring me back a vial of her blood, I\'ll be able to use it to augment the power of the daggers I\'ve given you.$B$BYour accomplice Zazzo has already been dispatched to the scene and awaits you there. He\'ll have more details.', '', 'Report to Zazzo Twinklefingers in the ruins just southeast of Karazhan.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Our Man in Karazhan
+(30107, 2, 85, 0, 255, 0, 85, -162, 83, 0, 0, 5, 1, 5, 1, 109309, 0, 0, 0, 0, 1, 0, 0x2200000, 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, 349, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Cluster Clutch', 'Collect 333 Shadowy Gems by looting Elementium Gem Clusters from creatures in the Dragon Soul Raid encounter. ', 'The daggers I have given you are lifeless shells. They can do great things, once they are given a means to contain the power I have in mind.$B$BI need for you to acquire Shadowy Gems for me. The facets of these unusual stones are like windows into the infinite. They are often used by minions of the Twilight\'s Hammer to control the most powerful of elementals.$B$BA great battle is raging around Wyrmrest temple. Collect Elementium Gem Clusters from Deathwing\'s minions and bring the gems to me.', '', 'Bring the Shadowy Gems to Prince Wrathion at Ravenholdt Manor in Hillsbrad Foothills.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Cluster Clutch
+(30106, 2, 85, 0, 255, 0, 85, -162, 83, 0, 0, 3, 1, 3, 1, 109275, 0, 0, 0, 0, 1, 0, 0x300000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 77945, 77946, 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, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'The Deed is Done', 'Report your success to Prince Wrathion at Ravenholdt Manor in Hillsbrad Foothills.', 'Prince Wrathion will be pleased to hear that you\'ve succeeded. You should report back to him at Ravenholdt Manor.$B$BThe Prince has been known to be extremely generous to those who help him. ', '', 'Report your success to Prince Wrathion at Ravenholdt Manor in Hillsbrad Foothills.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The Deed is Done
+(30105, 2, 85, 0, 255, 0, 85, 5844, 81, 0, 0, 8, 1, 8, 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, 77957, 0, 0, 0, 1, 0, 0, 72884, 72886, 76153, 0, 0, 0, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'The Twilight Prophet', 'Find and unmask the Twilight Prophet.', 'The missive reads as follows:$b$b\"The Hour of Twilight is upon us. The world-shaman Thrall approaches Wyrmrest with the Dragon Soul in hand, feebly whimpering one final threat to destroy our glorious master.\"$b$b\"Stop Thrall, and we win our war. I will be watching you from nearby.\"$b$b ~ The Twilight Prophet', '', 'Speak with Thrall at the Hour of Twilight.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The Twilight Prophet
+(30104, 2, 85, 0, 255, 0, 85, 5788, 81, 0, 0, 8, 1, 8, 1, 0, 0, 0, 77955, 0, 1, 0, 0x8, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 77955, 0, 0, 0, 1, 0, 0, 0, 72880, 72881, 72882, 72883, 0, 0, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Documenting the Timeways', 'Slay a Legion Demon, a Royal Handmaiden, and Captain Varo\'then, then allow Alurmi\'s Vessel to archive their information.', 'You... $N, was it? You assisted with our archival in the past. Well, technically it was the future, but I believe you understand. Time is highly relative.$b$bI require more information for our archive. While you and Nozdormu don\'t intend to overwrite this timestrand, as you did in the End Time, we can still benefit from more data.$b$bI require information on Captain Varo\'then, one of Azshara\'s pretty little handmaidens, and... hmm... oh, how about that big felguard, just down those stairs?', '', 'Bring Alurmi\'s Vessel back to Alurmi near the Well of Eternity.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Documenting the Timeways
+(30103, 2, 85, 0, 255, 0, 85, 5844, 81, 0, 0, 8, 1, 8, 1, 0, 0, 0, 0, 0, 1, 0, 0x1000008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 72858, 72887, 72888, 0, 0, 0, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'To Wyrmrest!', 'Escort Thrall safely to Wyrmrest Temple.', 'The Dragon Soul... a weapon with enough power to defeat Deathwing. Thanks to you, it is now safely in our hands.$b$bCome! The aspects await us. We must bring the Dragon Soul to Wyrmrest Temple, in the center of Dragonblight.', '', 'Speak with Thrall at the Hour of Twilight.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- To Wyrmrest!
+(30102, 2, 85, 0, 255, 0, 85, 5844, 81, 0, 30103, 1, 1, 1, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'The Hour of Twilight', 'Speak with Thrall at the Hour of Twilight.', 'There\'s no need to stand around here forever. Have you forgotten? We can CONTROL TIME. Especially since you got rid of that Murozond fellow, back in the future.$b$bThat Dragon Soul that you just liberated? Thrall already has it, back in your present day. And he\'s going to need your help.$b$bYou ready to go?', '', 'Speak with Thrall at the Hour of Twilight.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The Hour of Twilight
+(30101, 2, 85, 0, 255, 0, 85, 5788, 81, 0, 0, 8, 1, 8, 1, 81040, 0, 0, 0, 0, 1, 0, 0x200008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 72876, 72877, 72878, 72879, 0, 0, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'The Path to the Dragon Soul', 'Slay Mannoroth.', 'I cannot simply fly up and grab the Dragon Soul. The old gods protect it.$b$bTo make matters worse, their shield is strengthened by the swirling, arcane energies that emanate from the Well of Eternity, and those energies are being focused by the great demon Mannoroth.$b$bDistract Mannoroth, and the link between the Dragon Soul and the Well will be broken. Without the Well\'s power, the old gods\' ward will be weakened, and the Dragon Soul will be vulnerable.$b$bAnd then I will take it.', '', 'Speak with Illidan at the Well of Eternity.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The Path to the Dragon Soul
+(30100, 2, 85, 0, 255, 0, 85, 5788, 81, 0, 30101, 8, 1, 8, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'The Vainglorious', 'Dispatch of Queen Azshara.', 'Queen Azshara and her royal guard lie ahead of us. We cannot afford the possibility of any interference with our plan. So we will take the fight to her, before she has a chance to meddle.$b$bIt is quite unlikely that you will kill Queen Azshara today; very few coherent timelines exist along that branch. Consider it a victory if you are simply able to occupy her attention, however temporarily.', '', 'Speak with Nozdormu at the Well of Eternity.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The Vainglorious
+(30099, 2, 85, 0, 255, 0, 85, 5788, 81, 0, 30100, 8, 1, 8, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'In Unending Numbers', 'Disable the three demon portals, then slay Peroth\'arn.', 'Between us and the Dragon Soul lies a legion of demons. They will have to be dispatched before we proceed.$b$bIf my timing is correct - and it usually is - a young night elf named Illidan Stormrage should be crossing our path shortly. He will undoubtedly be of some use when it comes to demon hunting.$b$bHelp Illidan disable the demons\' portals, then slay their leader, Peroth\'arn.', '', 'Speak with Nozdormu near the Well of Eternity.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- In Unending Numbers
+(30098, 2, 85, 0, 255, 0, 85, 5788, 81, 0, 30099, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0x20000008, 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, 3, 'The Well of Eternity', 'Speak with Nozdormu at the Well of Eternity.', 'We must move quickly, before any remaining Infinite agents intervene. Time is precious.$b$bI will now take you from your distant future into your distant past... the War of the Ancients. Our goal is the Dragon Soul, an artifact of immense power... enough power to break Deathwing, and end his reign over your present.', '', 'Speak with Nozdormu at the Well of Eternity.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The Well of Eternity
+(30097, 2, 85, 0, 255, 0, 85, 5789, 81, 0, 0, 8, 1, 8, 1, 0, 0, 0, 77955, 0, 1, 0, 0x8, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 77939, 77940, 77941, 77942, 1, 1, 1, 1, 72852, 72871, 72872, 0, 0, 0, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Archival Purposes', 'Slay two of the Echoes within the End Time, then allow Alurmi\'s Vessel to archive their information.', 'From what I understand, you intend to avoid this future. If this is true, then we must archive data from this timestrand before it is lost to us.$b$bWe believe that the most interesting and valuable elements of this future are the powerful \"echoes\" that roam the dragonshrines.$b$bTake this vessel with you as you silence these echoes. A portion of their energies will be archived within the Bronze Dragonflight\'s depository.', '', 'Return to Alurmi within the End Time.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Archival Purposes
+(30096, 2, 85, 0, 255, 0, 85, 5789, 81, 0, 30098, 8, 1, 8, 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, 72873, 72874, 72875, 76152, 0, 0, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 3, 'Murozond', 'Slay Murozond.', 'If we are to destroy Deathwing, we will need the power of the Dragon Soul. To obtain the Dragon Soul, I would have to take you back to the Sundering, ten thousand years in the past... but that time passage is blocked to me.$b$bThe creature that blocks us from accessing this time passage is named Murozond. He must be slain, here, in this twisted future, before we can continue our plot to unmake Deathwing.$b$bThis is why you were brought here, $N.', '', 'Speak with Nozdormu at the Bronze Dragonshrine in the End Time.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Murozond
+(30095, 2, 85, 0, 255, 0, 85, 5789, 81, 0, 30096, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0x20000008, 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, 3, 'The End Time', 'Speak with Nozdormu at the End Time.', 'Nozdormu, the bronze aspect, has asked for help from the champions of the Alliance. You are on his short list. I can share few other details.$b$bIt is uncharacteristic of my master to request the assistance of mortals, but I suppose that all things change with time... even the Aspect of Time himself.$b$bHe awaits you at the End Time, in the distant future. I can help you to travel there, if you so choose.', '', 'Speak with Nozdormu at the End Time.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The End Time
+(30094, 2, 85, 0, 255, 0, 85, 5789, 81, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0x20000008, 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, 946, 3, 'The End Time', 'Speak with Nozdormu at the End Time.', 'Nozdormu, the bronze aspect, has asked for help from the champions of the Horde. You are on his short list. I can share few other details.$b$bIt is uncharacteristic of my master to request the assistance of mortals, but I suppose that all things change with time... even the Aspect of Time himself.$b$bHe awaits you at the End Time, in the distant future. I can help you to travel there, if you so choose.', '', 'Speak with Nozdormu at the End Time.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The End Time
+(30093, 2, 85, 0, 255, 0, 85, -162, 83, 0, 30106, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 0x500000, 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, 349, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'Assassinate Creed', 'Stealth into the ruins of Gilneas City and slay Hiram Creed within the military district.', 'The city has been in chaos for days now. Hiram Creed, disguised as a Gilnean, has infected the lot of those dogs with his own draconic blood. Even the Forsaken are having trouble routing him out.$B$BOnly a surgical assassination can end this!$B$BThe bridge behind me is relatively unguarded. Slip in through merchant\'s square and head south - you\'ll find Creed in the middle of the military district.$B$BI\'ll keep an eye on you and pull you out if there\'s any trouble.$B$B...There WILL be trouble!', '', 'Talk to Zazzo Twinklefingers northeast of Gilneas City in the Ruins of Gilneas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Assassinate Creed
+(30092, 2, 85, 0, 255, 0, 85, -162, 83, 0, 30093, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x100000, 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, 'Our Man in Gilneas', 'Seek out Zazzo Twinklefingers near the ruins of Gilneas City in Gilneas.', 'If you wish to join my cause and slaughter the black dragons in hiding, prove yourself by taking down Hiram Creed. He\'s amassing an army in Gilneas.$B$BWe haven\'t been able to slip past his defenders, but we\'ve got a man on the scene keeping an eye on him. Zazzo Twinklefingers, a very crafty arcane mage, is waiting for us to contact him just outside of the ruins of the Gilnean capital.$B$BFind him and he\'ll direct you to the target.', '', 'Seek out Zazzo Twinklefingers near the ruins of Gilneas City in Gilneas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Our Man in Gilneas
+(29934, 2, 85, 0, 255, 0, 85, -162, 83, 0, 29847, 2, 1, 2, 1, 0, 0, 0, 0, 0, 1, 0, 0x0, 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, 'To Ravenholdt', 'Speak to Mostrasz at the Vermillion Redoubt and fly to Ravenholdt Manor together. ', 'If the egg is in Ravenholdt Manor, we can\'t risk torching it in an all-out assault. I\'ll need someone slippery to get in there and find out for sure.$B$BThat\'s you, $N.$B$BMostrasz will help you infiltrate the compound. Speak to him just outside and fly to Ravenholdt together. Good luck!', '', 'Talk to Mostrasz within the cave just outside of Ravenholdt Manor in the Hillsbrad Foothills.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- To Ravenholdt
+(29847, 2, 85, 0, 255, 0, 85, -162, 83, 0, 30092, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 0x500000, 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, 349, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'To Catch a Thief', 'Infiltrate Ravenholdt Manor and locate the missing black dragon egg.', 'Just beyond this cave lies Ravenholdt Manor. You need to get inside without being seen!$B$B<Mostrasz places an enchantment on you.>$B$BThere - now I\'ll be able to keep an eye on you and communicate as you venture into the compound. Now sneak into that manor, locate the egg, and don\'t get caught...', '', 'Follow Wrathion upstairs and speak with him at Ravenholdt Manor in the Hillsbrad Foothills.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- To Catch a Thief
+(29802, 2, 85, 0, 255, 0, 85, -162, 83, 0, 29934, 5, 1, 5, 1, 0, 0, 0, 74256, 0, 1, 0, 0x2100000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 74750, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 3, 'A Hidden Message', 'Charge your Cryptomancer\'s Decoder Ring and use it to decode the Corastrasza\'s Singed Cipher.', 'Corastrasza, currently stationed at the Vermillion Redoubt in the Twilight Highlands, has intercepted a coded message of grave importance. I\'ll let her explain the full situation, but we need your expertise to unravel the cipher!$B$BTake your decoder ring to an ethereal thaumaturge in your capital city - he should know how to charge it. Acquire the encoded cipher from Corastrasza and use the ring to decode it for her. Hurry! Time is ticking...', '', 'Deliver the Solved Cipher to Corastrasza at the Vermillion Redoubt in Twilight Highlands.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- A Hidden Message
+(6065, 2, -1, 0, 255, 0, 10, -261, 0, 0, 6061, 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, 32, 0, 'The Hunter\'s Path', 'Speak with Yaw Sharpmane at Bloodhoof Village in Mulgore.', 'Hello, young hunter. You look to me like you are skilled enough to handle a beast and train it as your companion.$B$BYou must see Yaw Sharpmane in Bloodhoof Village. He can put you on the path to earning a pet of your own.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- The Hunter's Path
+(3841, 2, 47, 0, 255, 0, 38, 357, 0, 0, 3842, 2, 1, 0, 1, 0, 0, 0, 11102, 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, 69, 0, 0, 0, 0, 2, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'An Orphan Looking For a Home', 'Speak to Quentin in Thousand Needles.', 'Oh, hello, $N. I\'m so glad to see you again. How was your trip to Darnassus?$B$BWell, you\'ll be happy to know that we\'ve made quite a bit of progress while you\'ve been gone. We even saved a nest full of eggs. Unfortunately, the mother died before we got to her.$B$BSay, would you want one for a pet? They look to hatch soon, so they\'ll need a good $Gfather:mother;. What do you say?$B$BIf you\'re really interested, take one of the eggs to Quentin at the race tracks in Shimmering Flats. He\'ll tell you more.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- An Orphan Looking For a Home
+(2847, 2, 45, 0, 255, 0, 30, -182, 0, 0, 0, 3, 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, 'Wild Leather Armor', 'Bring 10 Thick Leather to Pratt McGrubben in Feathermoon Stronghold.', '$n, you\'re becoming quite skilled as a leatherworker! I know some patterns you might be interested in... Wild Leather armor! Wild Leather taps into the potent and chaotic properties of wildvines, found in areas of lush vegetation and on some of the creatures there. The armor made using it is second to none for people of your skill, guaranteed.$B$BI\'ll teach this to you, but you\'ll be working for me for a while. The first cost is simply ten pieces of thick leather. After this, we\'ll talk specifics.', '', 'Return to Pratt McGrubben at Feathermoon Stronghold in Feralas.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142), -- Wild Leather Armor
+(1047, 2, 55, 0, 255, 0, 54, 1657, 0, 0, 6761, 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 New Frontier', 'Speak with Arch Druid Fandral Staghelm at the Cenarion Enclave of Darnassus about the Cenarion Circle\'s call to explore the frontiers of Kalimdor.', 'Attention, heroes!$B$BThe Cenarion Circle seeks able bodied individuals to assist them in exploring the vast new frontiers of Kalimdor! A forbidden wasteland of unimaginable dangers lies far to the west of Tanaris and Gadgetzan, and the Circle needs willing and honorable proxies to act in their stead.$B$BAll interested individuals should seek audience with the Cenarion Circle. Speak with the Arch Druid in Darnassus, Fandral Staghelm, for more information!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 60142); -- The New Frontier
+
+UPDATE `quest_template` SET `Flags`=0x40, `FlagsEx`=0x100, `QuestCompletionLog`='Bring the ring to Lord Devrestrasz at Wyrmrest Temple within the Dragon Soul raid encounter.', `VerifiedBuild`=60142 WHERE `ID`=29801; -- Proving Your Worth
+UPDATE `quest_template` SET `AreaDescription`='', `VerifiedBuild`=60142 WHERE `ID` IN (29415, 29392); -- Missing Heirlooms
+
+DELETE FROM `quest_objectives` WHERE `ID` IN (459080 /*459080*/, 459081 /*459081*/, 459084 /*459084*/, 459085 /*459085*/, 459088 /*459088*/, 459089 /*459089*/, 459091 /*459091*/, 459093 /*459093*/, 459095 /*459095*/, 459098 /*459098*/, 459100 /*459100*/, 459104 /*459104*/, 443167 /*443167*/, 443168 /*443168*/, 443169 /*443169*/, 443192 /*443192*/, 443205 /*443205*/, 443206 /*443206*/, 443207 /*443207*/, 443208 /*443208*/, 443209 /*443209*/, 443210 /*443210*/, 443211 /*443211*/, 443212 /*443212*/, 443213 /*443213*/, 443214 /*443214*/, 443215 /*443215*/, 443216 /*443216*/, 443217 /*443217*/, 443218 /*443218*/, 443219 /*443219*/, 443220 /*443220*/, 443221 /*443221*/, 443222 /*443222*/, 443224 /*443224*/, 443225 /*443225*/, 443226 /*443226*/, 443227 /*443227*/, 443228 /*443228*/, 443229 /*443229*/, 443230 /*443230*/, 381922 /*381922*/, 383375 /*383375*/);
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(459080, 88780, 14, 0, 0, 207668, 1, 0, 0, 0, 'Open the Survival Kit', 60142), -- 459080
+(459081, 88780, 14, 1, 1, 207671, 1, 0, 0, 0, '', 60142), -- 459081
+(459084, 88781, 14, 0, 0, 207675, 1, 0, 0, 0, 'Open the Survival Kit', 60142), -- 459084
+(459085, 88781, 14, 1, 1, 207678, 1, 0, 0, 0, '', 60142), -- 459085
+(459088, 88782, 14, 0, 0, 207682, 1, 0, 0, 0, 'Open the Survival Kit', 60142), -- 459088
+(459089, 88782, 14, 1, 1, 207685, 1, 0, 0, 0, '', 60142), -- 459089
+(459091, 88783, 14, 0, 0, 207689, 1, 0, 0, 0, 'Train a Spell', 60142), -- 459091
+(459093, 88784, 14, 0, 0, 207700, 1, 0, 0, 0, 'Train a Spell', 60142), -- 459093
+(459095, 88785, 14, 0, 0, 207711, 1, 0, 0, 0, 'Train a Spell', 60142), -- 459095
+(459098, 88786, 14, 0, 0, 207722, 1, 0, 0, 0, '', 60142), -- 459098
+(459100, 88787, 14, 0, 0, 207724, 1, 0, 0, 0, '', 60142), -- 459100
+(459104, 88789, 14, 0, 0, 207728, 1, 0, 0, 0, '', 60142), -- 459104
+(443167, 29802, 0, 0, 0, 55691, 1, 0, 0, 0, 'Decoder Ring Charged', 60142), -- 443167
+(443168, 29802, 0, 1, 1, 55690, 1, 0, 0, 0, 'Acquire the Singed Cipher', 60142), -- 443168
+(443169, 29802, 1, 2, 2, 74752, 1, 0, 1, 0, '', 60142), -- 443169
+(443192, 29847, 0, 0, 0, 56426, 1, 0, 0, 0, 'Egg Located', 60142), -- 443192
+(443205, 29934, 0, 0, 0, 56314, 1, 0, 0, 0, 'Speak with Mostrasz', 60142), -- 443205
+(443206, 30093, 0, 0, 0, 57802, 1, 0, 0, 0, '', 60142), -- 443206
+(443207, 30096, 0, 0, 0, 54432, 1, 0, 0, 0, '', 59185), -- 443207
+(443208, 30097, 0, 0, 0, 57855, 2, 0, 0, 0, 'Echo archived', 59185), -- 443208
+(443209, 30097, 1, 1, 1, 77955, 1, 0, 1, 0, '', 59185), -- 443209
+(443210, 30099, 0, 0, 0, 58239, 1, 0, 0, 0, 'First portal disabled', 59185), -- 443210
+(443211, 30099, 0, 1, 1, 58240, 1, 0, 0, 0, 'Second portal disabled', 59185), -- 443211
+(443212, 30099, 0, 2, 2, 58241, 1, 0, 0, 0, 'Third portal disabled', 59185), -- 443212
+(443213, 30099, 0, 3, 3, 55085, 1, 0, 0, 0, '', 59185), -- 443213
+(443214, 30100, 0, 0, 0, 54853, 1, 0, 0, 0, 'Queen Azshara defeated', 59185), -- 443214
+(443215, 30101, 0, 0, 0, 54969, 1, 0, 0, 0, '', 59185), -- 443215
+(443216, 30103, 0, 0, 0, 54938, 1, 0, 0, 0, 'Escort Thrall safely to Wyrmrest', 59185), -- 443216
+(443217, 30104, 0, 0, 0, 57856, 1, 0, 0, 0, 'Legion Demon archived', 59185), -- 443217
+(443218, 30104, 0, 1, 1, 57857, 1, 0, 0, 0, 'Royal Handmaiden archived', 59185), -- 443218
+(443219, 30104, 0, 2, 2, 57858, 1, 0, 0, 0, 'Captain Varo\'then archived', 59185), -- 443219
+(443220, 30105, 0, 0, 0, 57854, 1, 0, 0, 0, 'The Twilight Prophet unmasked', 59185), -- 443220
+(443221, 30107, 1, 0, 0, 77951, 333, 0, 0, 0, '', 60142), -- 443221
+(443222, 30109, 1, 0, 0, 77954, 1, 0, 1, 0, '', 60142), -- 443222
+(443224, 30113, 1, 0, 0, 78339, 1, 0, 1, 0, '', 60142), -- 443224
+(443225, 30113, 1, 1, 1, 77945, 1, 0, 0, 0, '', 60142), -- 443225
+(443226, 30113, 1, 2, 2, 77946, 1, 0, 0, 0, '', 60142), -- 443226
+(443227, 30116, 1, 0, 0, 77952, 60, 0, 0, 0, '', 60142), -- 443227
+(443228, 30118, 1, 0, 0, 78352, 1, 0, 1, 0, '', 60142), -- 443228
+(443229, 30118, 1, 1, 1, 77947, 1, 0, 0, 0, '', 60142), -- 443229
+(443230, 30118, 1, 2, 2, 77948, 1, 0, 0, 0, '', 60142), -- 443230
+(381922, 2847, 1, 0, 0, 4304, 10, 0, 0, 0, '', 60142), -- 381922
+(383375, 3841, 1, 0, 0, 11102, 1, 0, 0, 0, '', 60142); -- 383375