DB/Quests: added more quest data from mass parses

1 files changed, 171 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2025_01_10_00_world.sql.sql b/sql/updates/world/cata_classic/2025_01_10_00_world.sql.sql
new file mode 100644
index 00000000000..3b2652d8960
--- /dev/null
+++ b/sql/updates/world/cata_classic/2025_01_10_00_world.sql.sql
@@ -0,0 +1,171 @@
+UPDATE `quest_offer_reward` SET `RewardText`='Veterans of Northrend, King Wrynn and the Alliance need your help! Stormwind and the Alliance face unprecedented threats from Deathwing and his Twilight\'s Hammer minions!$B$BPlease find the enclosed hearthstone and use it to transport yourself to Stormwind. The crown has arranged lodging for all returning heroes at the The Golden Keg in the Dwarven District.', `VerifiedBuild`=58158 WHERE `ID`=29071; -- Make Haste to Stormwind!
+UPDATE `quest_offer_reward` SET `RewardText`='Blessed Light! We have taken the pinnacle! Finally, construction of Justice Keep can begin. Highlord Fordring and the knights are already en route to our new base. You must meet them there, $N!', `VerifiedBuild`=58158 WHERE `ID`=13141; -- The Battle For Crusaders' Pinnacle
+UPDATE `quest_offer_reward` SET `RewardText`='Your assistance has been integral in securing the front. The first true victory of this war is close at hand - which is why our next step is the most crucial.$B$BRest assured, $N, the Scourge will not give up without a fight. Your most difficult challenge awaits.', `VerifiedBuild`=58158 WHERE `ID`=13139; -- Into The Frozen Heart Of Northrend
+UPDATE `quest_offer_reward` SET `RewardText`='A hard fought victory, $N! The lieutenants will be replaced, but at least for today the air about Scourgeholme stands still.', `VerifiedBuild`=58158 WHERE `ID`=13125; -- The Air Stands Still
+UPDATE `quest_offer_reward` SET `RewardText`='You have done well, $N. Keeping their numbers down will give the Argent Crusade the time that they need to set a foundation.', `VerifiedBuild`=58158 WHERE `ID`=13118; -- The Purging Of Scourgeholme
+UPDATE `quest_offer_reward` SET `RewardText`='Arthas... He strikes recklessly - without care or caution. We have caught him off guard.$B$B<Highlord Tirion Fordring pauses, lost in thought for a moment.>$B$BWe will bolster our defenses and weather the storm.$B$BHow good are you with a cannon, $N?', `VerifiedBuild`=58158 WHERE `ID`=13045; -- Into The Wild Green Yonder
+UPDATE `quest_offer_reward` SET `RewardText`='There are still many Argent Crusade soldiers out on that field and in Scourgeholme, $N. While your help is appreciated, there is still much left to be done.', `VerifiedBuild`=58158 WHERE `ID`=13008; -- Scourge Tactics
+UPDATE `quest_offer_reward` SET `RewardText`='Thank you, $N. I will begin the tests on these samples immediately. It is my hope that a cure will be found soon.', `VerifiedBuild`=58158 WHERE `ID`=13040; -- Curing The Incurable
+UPDATE `quest_offer_reward` SET `RewardText`='A... A storm giant? I don\'t know about this, $N. That sounds risky. On the other hand, I don\'t think we have too many other options.$B$BIf I do this you have to promise me that you will get your giant friend to help us deal with Navarius and his cronies.', `VerifiedBuild`=58158 WHERE `ID`=12912; -- A Great Storm Approaches
+UPDATE `quest_offer_reward` SET `RewardText`='<Zim\'Torga\'s thoughts pervade your own. She senses the offerings you are about give to her and is pleased.>$B$B<She conveys that you will be appropriately rewarded.>', `VerifiedBuild`=58158 WHERE `ID`=12615; -- The Blessing of Zim'Torga
+UPDATE `quest_offer_reward` SET `RewardText`='Rageclaw thank you, $N. Though Rageclaw Den probably lost forever and troll-Rageclaw friendship also lost forever... and also now I think of it, Ragemane lost forever too. Also brother-in-law. He gone. Hrm, have you seen Chief\'s mate? I think she gone too.$B$BMaybe you go now. Chief a little depressed.', `VerifiedBuild`=58158 WHERE `ID`=12861; -- Trolls Is Gone Crazy!
+UPDATE `quest_offer_reward` SET `Emote1`=1, `VerifiedBuild`=58158 WHERE `ID`=12792; -- First Things First
+UPDATE `quest_offer_reward` SET `RewardText`='You\'re a good $g man : woman;, $N. We\'re fortunate that you happened to stop by.$B$BStick around a while. I\'m sure that we have much that a capable $c such as yourself can do.', `VerifiedBuild`=58158 WHERE `ID`=12740; -- Parachutes for the Argent Crusade
+UPDATE `quest_offer_reward` SET `RewardText`='You must be $N. The queen informed me that you would be coming.$B$BIf you are willing, we are in great need of your assistance.', `VerifiedBuild`=58158 WHERE `ID`=12435; -- Report to Lord Devrestrasz
+UPDATE `quest_offer_reward` SET `RewardText`='Back so soon, $N?$B$BCeristrasz sent word ahead of you. Thank you for what you did at the Ruby Dragonshrine.', `VerifiedBuild`=58158 WHERE `ID`=12768; -- The Steward of Wyrmrest Temple
+UPDATE `quest_offer_reward` SET `RewardText`='You saw Nozdormu? That doesn\'t make any sense.$B$B<Chromie thinks a moment about what you\'ve said.>$B$BActually, that\'s great news! We had no idea of where or when the Lord of Time had gone to. We just knew that he had disappeared to deal with very important matters.$B$BSo, even though the leader of the Infinite Dragonflight wasn\'t revealed, you\'ve discovered that Nozdormu is alive and well, and fighting back against them!$B$BThank you, $N. I\'ll be seeing you soon!', `VerifiedBuild`=58158 WHERE `ID`=12470; -- Mystery of the Infinite
+UPDATE `quest_offer_reward` SET `RewardText`='You must be $N. I was told you\'d be coming.$B$BI have something that I think you\'re uniquely qualified to take care of and by doing it, you\'ll be ingratiating yourself with the dragons here.', `VerifiedBuild`=58158 WHERE `ID`=12766; -- Speak with your Ambassador
+UPDATE `quest_offer_reward` SET `RewardText`='With the high cultist destroyed, the rest of his forces can be mopped up and the land and its creatures will recover.$B$BThank you, $N. May the goddess illuminate your path.', `VerifiedBuild`=58158 WHERE `ID`=12169; -- The High Cultist
+UPDATE `quest_offer_reward` SET `RewardText`='How very odd that it imprinted this information upon you magically.$B$BSo, not only do we know that they\'ve redirected the flow of the power coming out of the Moonrest Gardens, but we now know that the power is being purposefully changed in some way. Just what are they up to with all of that magic?$B$BI don\'t like where this is leading, $N, not one bit!', `VerifiedBuild`=58158 WHERE `ID`=12065; -- The Focus on the Beach
+UPDATE `quest_offer_reward` SET `RewardText`='Oh no... and we sent you down there to kill her, didn\'t we?$B$B<The commander shakes her head and sighs.>$B$BI\'m sorry. I\'ll see to it that the letter is delivered to her father, Archmage Malin in Stormwind, right away. Don\'t worry, you won\'t be implicated... it wasn\'t your fault.$B$BTry to put it out of your mind. There was no way that you could have known, $N.', `VerifiedBuild`=58158 WHERE `ID`=12067; -- A Letter for Home
+UPDATE `quest_offer_reward` SET `RewardText`='$N, if I\'m not mistaken, you\'ve uncovered the key to allow us to discern exactly what the mage hunter forces are up to!', `VerifiedBuild`=58158 WHERE `ID`=12055; -- A Strange Device
+UPDATE `quest_offer_reward` SET `RewardText`='You have my deepest gratitude, $N.$B$BIf you haven\'t already, you should alert your betters to the danger that the blue dragonflight has unleashed. By blowing apart the ley line anchor underneath the gardens, they threaten to destroy us all!', `VerifiedBuild`=58158 WHERE `ID`=12013; -- End Arcanimus
+UPDATE `quest_offer_reward` SET `RewardText`='You saw them controlling the elements? The wind bent to their will?$B$B<Morgh is lost in thought for a moment.>$B$BThis is troubling, $N. I must consult with the others.$B$BWe thank you for your efforts, $N. Perhaps you should return to your village and see if they have any other information about the Murkbloods and their nefarious goals.', `VerifiedBuild`=58158 WHERE `ID`=9862; -- Murkblood Corrupters
+UPDATE `quest_offer_reward` SET `RewardText`='$N!  You bring joy to this old dwarf\'s heart.$B$BYou have now proven yourself; you\'ve joined the ranks of the elite!  Others ran away in fear, or died, trampled under the foot of the beast.  You used your mind, your cunning, your determination to prove your mastery of the hunt.$B$BTake this and know that you are always welcome to hunt at my side!', `VerifiedBuild`=58158 WHERE `ID`=9852; -- The Ultimate Bloodsport
+UPDATE `quest_offer_reward` SET `RewardText`='The Earthen Ring thanks you, $N. The elements also give their thanks. Your continued efforts in cleansing our world are appreciated and noted.\n', `VerifiedBuild`=58158 WHERE `ID`=9815; -- Muck Diving
+UPDATE `quest_offer_reward` SET `RewardText`='Her eye looks as if it is still alive.  Do you think that she can still see into your soul?$B$B$N, you can now count yourself as one of the elite safari hunters.  And you are another step closer to stalking the ultimate prey of this land, Tusker!$B$BYou\'ve earned the right to have this.  May it serve you well.', `VerifiedBuild`=58158 WHERE `ID`=9856; -- Windroc Mastery
+UPDATE `quest_offer_reward` SET `RewardText`='You did it!  You took down Banthar!  I never had a doubt, $N.$B$BHere, I think you\'ve more than earned this.', `VerifiedBuild`=58158 WHERE `ID`=9851; -- Clefthoof Mastery
+UPDATE `quest_offer_reward` SET `RewardText`='Excellent work, $N! We now have a point from which we can plan our counter-attack.', `VerifiedBuild`=58158 WHERE `ID`=9991; -- Survey the Land
+UPDATE `quest_offer_reward` SET `RewardText`='Well, I couldn\'t see if you helped out with saving Kristen, or not.  But if she handed you one of her bundles of skins then you\'re alright in my book.$B$BHere\'s your reward.', `VerifiedBuild`=58158 WHERE `ID`=9897; -- I'm Saved!
+UPDATE `quest_offer_reward` SET `RewardText`='The essence of Aggonar lived on in the form of his foul offspring Aggonis.  With your success in defeating the demon, we can begin to work towards restoring the pools to their former purity.$B$BYou have our thanks, $N.  Your work will have a deep impact in this world.', `VerifiedBuild`=58158 WHERE `ID`=9427; -- Cleansing the Waters
+UPDATE `quest_offer_reward` SET `RewardText`='Can I offer you any assistance, $N?  You sound troubled.', `VerifiedBuild`=58158 WHERE `ID`=9543; -- Atonement
+UPDATE `quest_offer_reward` SET `RewardText`='Yes, I feel the fel presence in the pools weakening.$B$BYou\'ve done well, $N.', `VerifiedBuild`=58158 WHERE `ID`=9426; -- The Pools of Aggonar
+UPDATE `quest_offer_reward` SET `RewardText`='Sedai, dear brother...$B$BThose cowardly orcs!  He was unarmed, how could they?$B$BLeave me be, $N.  I thank you for your assistance but I wish to be alone with my thoughts now.', `VerifiedBuild`=58158 WHERE `ID`=9423; -- Return to Obadei
+UPDATE `quest_offer_reward` SET `RewardText`='Well done, $N.  That should teach those beasts who\'s boss!', `VerifiedBuild`=58158 WHERE `ID`=9385; -- Rampaging Ravagers
+UPDATE `quest_offer_reward` SET `RewardText`='Great job, $N!  I hereby proclaim you an honorary Longbeard.$B$BStick around and have a drink with us, won\'t you?', `VerifiedBuild`=58158 WHERE `ID`=9417; -- The Arakkoa Threat
+UPDATE `quest_offer_reward` SET `RewardText`='Light be praised, I knew you\'d do it! Arazzius and his minions are no more! Soon, we\'ll have the Legion running for home and this battered world will be safe once more. Then, when justice has been met, we can return home as well. $B$BThank you, $N - the Alliance and the Sons of Lothar honor you this day! \n', `VerifiedBuild`=58158 WHERE `ID`=10400; -- Overlord
+UPDATE `quest_offer_reward` SET `RewardText`='I foresaw this great victory, $N. The blessed naaru smile upon you this day. \n', `VerifiedBuild`=58158 WHERE `ID`=10399; -- The Heart of Darkness
+UPDATE `quest_offer_reward` SET `RewardText`='We can only hope that with the quieting of the ghosts of the officers, the spirits of the foot soldiers will follow. Thank you once again for your help, $N.', `VerifiedBuild`=58158 WHERE `ID`=10057; -- Looking to the Leadership
+UPDATE `quest_offer_reward` SET `RewardText`='You have my sincere thanks for your efforts, $N. Though much remains to be done, it gladdens me to know we have helped some find their long-deserved rest.', `VerifiedBuild`=58158 WHERE `ID`=10047; -- The Path of Glory
+UPDATE `quest_offer_reward` SET `RewardText`='You\'ve done it!  Morkh is slain!  Now, we have a fighting chance against the fel orc beasts!$B$BThank you, $N.  Your aid to the war effort here is beyond measure.', `VerifiedBuild`=58158 WHERE `ID`=10485; -- Warlord of the Bleeding Hollow
+UPDATE `quest_offer_reward` SET `RewardText`='Thank you, $N.  My heart is saddened to see these talismans -- they underline the great losses we of Honor Hold have suffered against the fel orcs.  But I am heartened to see you successful against them.  If we can kill enough, perhaps we might emerge from this war victorious.', `VerifiedBuild`=58158 WHERE `ID`=10484; -- Cursed Talismans
+
+DELETE FROM `quest_details` WHERE `ID` IN (27729 /*Once More, With Eeling*/, 13073 /*The Keeper's Favor*/, 13072 /*A Hero Remains*/, 13280 /*King of the Mountain*/, 13292 /*The Solution Solution*/, 13288 /*That's Abominable!*/, 13294 /*Against the Giants*/, 13287 /*Poke and Prod*/, 13291 /*Borrowed Technology*/, 13290 /*Your Attention, Please*/, 13286 /*...All the Help We Can Get.*/, 13233 /*No Mercy!*/, 13232 /*Finish Me!*/, 13296 /*Get to Ymirheim!*/, 13231 /*The Broken Front*/, 13225 /*The Skybreaker*/, 13068 /*A Tale of Valor*/, 13157 /*The Crusaders' Pinnacle*/, 13141 /*The Battle For Crusaders' Pinnacle*/, 13139 /*Into The Frozen Heart Of Northrend*/, 13125 /*The Air Stands Still*/, 13110 /*The Restless Dead*/, 13135 /*It Could Kill Us All*/, 13130 /*The Stone That Started A Revolution*/, 13122 /*The Scourgestone*/, 13118 /*The Purging Of Scourgeholme*/, 13104 /*Once More Unto The Breach, Hero*/, 13086 /*The Last Line Of Defense*/, 13070 /*A Cold Front Approaches*/, 13045 /*Into The Wild Green Yonder*/, 13044 /*If There Are Survivors...*/, 13039 /*Defending The Vanguard*/, 13040 /*Curing The Incurable*/, 12551 /*Crocolisk Mastery: The Trial*/, 12634 /*Some Make Lemonade, Some Make Liquor*/, 12526 /*Rhino Mastery: The Chase*/, 12550 /*Dreadsaber Mastery: Stalking the Prey*/, 12696 /*Aerial Surveillance*/, 12592 /*The Great Hunter's Challenge*/, 12589 /*Kick, What Kick?*/, 12549 /*Dreadsaber Mastery: Becoming a Predator*/, 12520 /*Rhino Mastery: The Test*/, 12525 /*Wipe That Grin Off His Face*/, 12688 /*Engineering a Disaster*/, 12529 /*The Ape Hunter's Slave*/, 12528 /*Playing Along*/, 10426 /*Flora of the Eco-Domes*/, 29836 /*Just Checkin'*/, 12507 /*Strange Mojo*/, 12792 /*First Things First*/, 10004 /*Patience and Understanding*/, 10001 /*The Master Planner*/, 9999 /*Buying Time*/, 9991 /*Survey the Land*/, 9897 /*I'm Saved!*/, 10211 /*City of Light*/, 10443 /*Helping the Cenarion Post*/, 9417 /*The Arakkoa Threat*/);
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(27729, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- Once More, With Eeling
+(13073, 1, 0, 0, 0, 0, 0, 0, 0, 58158), -- The Keeper's Favor
+(13072, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- A Hero Remains
+(13280, 25, 1, 1, 0, 0, 0, 0, 0, 58158), -- King of the Mountain
+(13292, 396, 396, 0, 0, 0, 0, 0, 0, 58158), -- The Solution Solution
+(13288, 396, 396, 0, 0, 0, 0, 0, 0, 58158), -- That's Abominable!
+(13294, 396, 396, 396, 0, 0, 0, 0, 0, 58158), -- Against the Giants
+(13287, 396, 396, 396, 0, 0, 0, 0, 0, 58158), -- Poke and Prod
+(13291, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- Borrowed Technology
+(13290, 396, 396, 0, 0, 0, 0, 0, 0, 58158), -- Your Attention, Please
+(13286, 396, 396, 5, 0, 0, 0, 0, 0, 58158), -- ...All the Help We Can Get.
+(13233, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- No Mercy!
+(13232, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- Finish Me!
+(13296, 5, 1, 25, 0, 0, 0, 0, 0, 58158), -- Get to Ymirheim!
+(13231, 5, 6, 397, 0, 0, 0, 100, 0, 58158), -- The Broken Front
+(13225, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- The Skybreaker
+(13068, 1, 0, 0, 0, 0, 0, 0, 0, 58158), -- A Tale of Valor
+(13157, 1, 1, 66, 0, 0, 0, 0, 0, 58158), -- The Crusaders' Pinnacle
+(13141, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- The Battle For Crusaders' Pinnacle
+(13139, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- Into The Frozen Heart Of Northrend
+(13125, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- The Air Stands Still
+(13110, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- The Restless Dead
+(13135, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- It Could Kill Us All
+(13130, 1, 1, 1, 1, 0, 0, 0, 0, 58158), -- The Stone That Started A Revolution
+(13122, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- The Scourgestone
+(13118, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- The Purging Of Scourgeholme
+(13104, 1, 1, 397, 0, 0, 0, 0, 0, 58158), -- Once More Unto The Breach, Hero
+(13086, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- The Last Line Of Defense
+(13070, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- A Cold Front Approaches
+(13045, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- Into The Wild Green Yonder
+(13044, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- If There Are Survivors...
+(13039, 274, 1, 1, 0, 0, 0, 0, 0, 58158), -- Defending The Vanguard
+(13040, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- Curing The Incurable
+(12551, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Crocolisk Mastery: The Trial
+(12634, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Some Make Lemonade, Some Make Liquor
+(12526, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Rhino Mastery: The Chase
+(12550, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Dreadsaber Mastery: Stalking the Prey
+(12696, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- Aerial Surveillance
+(12592, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- The Great Hunter's Challenge
+(12589, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Kick, What Kick?
+(12549, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Dreadsaber Mastery: Becoming a Predator
+(12520, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Rhino Mastery: The Test
+(12525, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Wipe That Grin Off His Face
+(12688, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- Engineering a Disaster
+(12529, 1, 0, 0, 0, 0, 0, 0, 0, 58158), -- The Ape Hunter's Slave
+(12528, 1, 0, 0, 0, 0, 0, 0, 0, 58158), -- Playing Along
+(10426, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- Flora of the Eco-Domes
+(29836, 396, 396, 0, 0, 0, 0, 0, 0, 58158), -- Just Checkin'
+(12507, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- Strange Mojo
+(12792, 1, 1, 0, 0, 0, 0, 0, 0, 58158), -- First Things First
+(10004, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- Patience and Understanding
+(10001, 1, 1, 1, 1, 0, 0, 0, 0, 58158), -- The Master Planner
+(9999, 1, 1, 1, 0, 0, 0, 0, 0, 58158), -- Buying Time
+(9991, 1, 1, 1, 1, 0, 0, 0, 0, 58158), -- Survey the Land
+(9897, 1, 1, 0, 0, 0, 1000, 0, 0, 58158), -- I'm Saved!
+(10211, 0, 0, 0, 0, 0, 0, 0, 0, 58158), -- City of Light
+(10443, 1, 1, 6, 0, 0, 1000, 1000, 0, 58158), -- Helping the Cenarion Post
+(9417, 0, 0, 0, 0, 0, 0, 0, 0, 58158); -- The Arakkoa Threat
+
+UPDATE `quest_details` SET `Emote1`=5, `Emote2`=1, `Emote3`=1, `Emote4`=1, `VerifiedBuild`=58158 WHERE `ID`=13008; -- Scourge Tactics
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=1, `Emote4`=1, `VerifiedBuild`=58158 WHERE `ID`=13036; -- Honor Above All Else
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `VerifiedBuild`=58158 WHERE `ID`=12523; -- Have a Part, Give a Part
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `VerifiedBuild`=58158 WHERE `ID`=12654; -- The Part-time Hunter
+UPDATE `quest_details` SET `Emote1`=273, `Emote2`=1, `Emote3`=1, `EmoteDelay1`=2000, `VerifiedBuild`=58158 WHERE `ID`=12123; -- Informing the Queen
+UPDATE `quest_details` SET `Emote1`=1, `VerifiedBuild`=58158 WHERE `ID`=12768; -- The Steward of Wyrmrest Temple
+UPDATE `quest_details` SET `Emote1`=1, `VerifiedBuild`=58158 WHERE `ID`=12418; -- Through Fields of Flame
+UPDATE `quest_details` SET `Emote1`=1, `VerifiedBuild`=58158 WHERE `ID`=12417; -- Return to the Earth
+UPDATE `quest_details` SET `Emote1`=1, `VerifiedBuild`=58158 WHERE `ID`=12416; -- Heated Battle
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=1, `Emote4`=1, `VerifiedBuild`=58158 WHERE `ID`=12456; -- The Plume of Alystros
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=6, `Emote4`=1, `VerifiedBuild`=58158 WHERE `ID`=12454; -- Cycle of Life
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=25, `VerifiedBuild`=58158 WHERE `ID`=12458; -- Seeds of the Lashers
+UPDATE `quest_details` SET `Emote1`=1, `VerifiedBuild`=58158 WHERE `ID`=12460; -- Report to the Ruby Dragonshrine
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=6, `Emote3`=1, `EmoteDelay1`=1000, `VerifiedBuild`=58158 WHERE `ID`=12766; -- Speak with your Ambassador
+UPDATE `quest_details` SET `Emote1`=5, `Emote2`=1, `Emote3`=1, `Emote4`=2, `VerifiedBuild`=58158 WHERE `ID`=12119; -- Gaining an Audience
+UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=58158 WHERE `ID`=12107; -- The End of the Line
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=1, `VerifiedBuild`=58158 WHERE `ID`=12169; -- The High Cultist
+UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=58158 WHERE `ID`=12168; -- The Favor of Zangus
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=6, `Emote3`=1, `VerifiedBuild`=58158 WHERE `ID`=12098; -- Search Indu'le Village
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=1, `Emote4`=1, `VerifiedBuild`=58158 WHERE `ID`=12092; -- Strengthen the Ancients
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=1, `Emote4`=1, `VerifiedBuild`=58158 WHERE `ID`=12083; -- Atop the Woodlands
+UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=58158 WHERE `ID`=12067; -- A Letter for Home
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=6, `Emote3`=1, `VerifiedBuild`=58158 WHERE `ID`=12065; -- The Focus on the Beach
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=25, `Emote4`=1, `VerifiedBuild`=58158 WHERE `ID`=12060; -- Projections and Plans
+UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=58158 WHERE `ID`=12055; -- A Strange Device
+UPDATE `quest_details` SET `Emote1`=5, `Emote2`=1, `Emote3`=25, `VerifiedBuild`=58158 WHERE `ID`=12167; -- Kill the Cultists
+UPDATE `quest_details` SET `Emote1`=25, `Emote2`=1, `VerifiedBuild`=58158 WHERE `ID`=12004; -- Prevent the Accord
+UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=58158 WHERE `ID`=12013; -- End Arcanimus
+UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=58158 WHERE `ID`=12006; -- Avenge this Atrocity!
+UPDATE `quest_details` SET `Emote1`=5, `Emote2`=1, `Emote3`=1, `Emote4`=25, `VerifiedBuild`=58158 WHERE `ID`=12464; -- My Old Enemy
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=1, `Emote4`=5, `VerifiedBuild`=58158 WHERE `ID`=12237; -- Flight of the Wintergarde Defender
+UPDATE `quest_details` SET `Emote1`=1, `Emote2`=1, `Emote3`=1, `Emote4`=5, `VerifiedBuild`=58158 WHERE `ID`=12235; -- Naxxramas and the Fall of Wintergarde
+UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=58158 WHERE `ID`=9849; -- Shattering the Veil
+UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=58158 WHERE `ID`=9563; -- Gaining Mirren's Trust
+UPDATE `quest_details` SET `Emote1`=1, `VerifiedBuild`=58158 WHERE `ID`=9385; -- Rampaging Ravagers
+
+DELETE FROM `quest_request_items` WHERE `ID` IN (27992 /*Magnets, How Do They Work?*/, 27972 /*Boosting Morale*/, 27119 /*The Gordok Ogre Suit*/, 27051 /*Through Persistence*/, 27038 /*Missing Parts*/, 14457 /*The Sunreaver Plan*/, 14443 /*The Battered Hilt*/, 26329 /*One More Thing*/, 26222 /*Scrounging for Parts*/, 29685 /*Hard to Kill*/, 29262 /*Zul'Gurub Voodoo*/, 29261 /*Zul'Aman Voodoo*/, 29153 /*Booty Bay's Interests*/, 24796 /*A Victory For The Silver Covenant*/, 28807 /*Expert Opinion*/, 24553 /*The Purification of Quel'Delar*/, 24522 /*Journey To The Sunwell*/, 20438 /*A Suitable Disguise*/, 24454 /*Return To Caladis Brightspear*/);
+INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES
+(27992, 0, 0, 0, 0, 'Did that magnet contraption actually work?', 0), -- Magnets, How Do They Work?
+(27972, 0, 0, 0, 0, 'Were you able to recover the rum?  I would try but I am deathly afraid of the water.  Not to mention that crazy shark.', 0), -- Boosting Morale
+(27119, 0, 1, 0, 0, 'Just get me that Ogre Tannin, and I\'ll whip you up an ogre suit that will fool Captain Kromcrush into thinking you\'re one of his men.', 0), -- The Gordok Ogre Suit
+(27051, 0, 1, 0, 0, 'Have you done as I\'ve asked of you? We must weed out whatever growth agent remains within their possession.', 0), -- Through Persistence
+(27038, 6, 0, 0, 0, 'Eh wot?$B$BMy parts. Where are they? You can\'t build a tank without parts!$B$BIf yeh did, it\'d be small. An\' mostly inner-fectual.', 0), -- Missing Parts
+(14457, 0, 0, 0, 0, 'Did you find anything of use on that agent?', 0), -- The Sunreaver Plan
+(14443, 0, 0, 0, 0, 'What is it that you have there?', 0), -- The Battered Hilt
+(26329, 1, 0, 0, 0, 'Welcome back, $N.', 0), -- One More Thing
+(26222, 1, 0, 0, 0, 'Did you get those parts?', 0), -- Scrounging for Parts
+(29685, 396, 0, 0, 0, 'Well, $c, I must admit, I wasn\'t sure I\'d see you again.', 0), -- Hard to Kill
+(29262, 0, 0, 0, 0, 'This potent pile of voodoo witchery emanates strong mojo...', 0), -- Zul'Gurub Voodoo
+(29261, 0, 0, 0, 0, 'The maker of this voodoo pile perished in the process.  Perhaps if you could finish it, the spirits would protect you instead....', 0), -- Zul'Aman Voodoo
+(29153, 0, 0, 0, 0, 'Did you find something, $n?', 0), -- Booty Bay's Interests
+(24796, 1, 0, 0, 0, 'Is it true that you have restored Quel\'Delar?', 0), -- A Victory For The Silver Covenant
+(28807, 6, 0, 0, 0, 'What\'s this you\'ve brought me?', 0), -- Expert Opinion
+(24553, 1, 0, 0, 0, 'What happened during your time in the Sunwell?', 0), -- The Purification of Quel'Delar
+(24522, 1, 0, 0, 0, 'What brings you here?', 0), -- Journey To The Sunwell
+(20438, 1, 0, 0, 0, 'Was Shandy able to help you get a Sunreaver tabard?', 0), -- A Suitable Disguise
+(24454, 1, 0, 0, 0, 'We\'ve been expecting your return. What has kept you?', 0); -- Return To Caladis Brightspear
+
+UPDATE `quest_request_items` SET `CompletionText`='It is good to finally meet you in person, $N. I have known you since before you were born.' WHERE `ID`=12123;
+UPDATE `quest_request_items` SET `CompletionText`='Do you have the talismans, $N?  It pains me to know that those cursed orcs possess our soldiers insignias...' WHERE `ID`=10484;
+UPDATE `quest_request_items` SET `EmoteOnComplete`=0 WHERE `ID`=9897;
+UPDATE `quest_request_items` SET `CompletionText`='There\'s no shame in admitting that you haven\'t the spine to hunt the mightiest of animals this land has to offer, $N.' WHERE `ID`=9852;
+UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `VerifiedBuild`=58158 WHERE `ID`=9805; -- Blessing of Incineratus
+UPDATE `quest_request_items` SET `CompletionText`='You return, $N.  Are the waters cleansed?' WHERE `ID`=9427;
+UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `EmoteOnIncomplete`=1, `VerifiedBuild`=58158 WHERE `ID`=9385; -- Rampaging Ravagers
+UPDATE `quest_request_items` SET `CompletionText`='The key, $N.  Did you get it?', `VerifiedBuild`=58158 WHERE `ID`=25321; -- Twilight Captivity
+UPDATE `quest_request_items` SET `CompletionText`='Stand easy, $N. What have you to report?\n' WHERE `ID`=13139;
+UPDATE `quest_request_items` SET `CompletionText`='I sense something foul is near.$B$BIt is upon your person! What is it, $N?' WHERE `ID`=12168;