From 4cd1c5d95a210d5a5890ec43ed3e5889cebe0a20 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Thu, 23 Jan 2025 19:01:32 +0100 Subject: DB/Quests: added more quest data from mass parses --- .../world/cata_classic/2025_01_23_04_world.sql | 448 +++++++++++++++++++++ 1 file changed, 448 insertions(+) create mode 100644 sql/updates/world/cata_classic/2025_01_23_04_world.sql (limited to 'sql') diff --git a/sql/updates/world/cata_classic/2025_01_23_04_world.sql b/sql/updates/world/cata_classic/2025_01_23_04_world.sql new file mode 100644 index 00000000000..55c6ed4f656 --- /dev/null +++ b/sql/updates/world/cata_classic/2025_01_23_04_world.sql @@ -0,0 +1,448 @@ +DELETE FROM `quest_details` WHERE `ID` IN (29253 /*A Shiny Reward*/, 29252 /*Booty Bay's Interests*/, 29153 /*Booty Bay's Interests*/, 29152 /*Making Contact*/, 29151 /*Bad Supplies*/, 29150 /*Voodoo Zombies*/, 29133 /*To the Digsite*/, 29131 /*Defend the Rebel Camp*/, 29124 /*Warn the Rebel Camp*/, 29121 /*Bury Me With Me Boots...*/, 29213 /*How's the Hunter Holding Up?*/, 29120 /*Mauti*/, 29116 /*Follow That Cat*/, 29115 /*The Hunter's Revenge*/, 29114 /*Track the Tracker*/, 29105 /*Nesingwary Will Know*/, 29104 /*Spirits Are With Us*/, 29103 /*Serpents and Poison*/, 14285 /*Safety in Numbers*/, 14272 /*Eviscerate*/, 14269 /*Someone's Looking for You*/, 25936 /*Pay It Forward*/, 25929 /*Sea Legs*/, 27685 /*Good Deed Left Undone*/, 25467 /*Kliklak's Craw*/, 25949 /*Blood and Thunder!*/, 25948 /*Bring It On!*/, 25947 /*Finders, Keepers*/, 25946 /*Helm's Deep*/, 25944 /*Girding Our Loins*/, 25943 /*Traveling on Our Stomachs*/, 25942 /*Buy Us Some Time*/, 25941 /*Rest For the Weary*/, 25924 /*Call of Duty*/, 28654 /*The Heart of the Matter*/, 28633 /*The Coffer of Promise*/, 28622 /*Three if by Air*/, 28621 /*Put That Baby in the Cradle!*/, 28612 /*Harrison Jones and the Temple of Uldum*/, 27748 /*Fortune and Glory*/, 28613 /*See You on the Other Side!*/, 28497 /*Fire From the Sky*/, 28482 /*Sullah's Gift*/, 28404 /*I'll Do It By Hand*/, 28403 /*Bad Datas*/, 28402 /*Schnottz So Fast*/, 28367 /*Shroud of the Makers*/, 28363 /*Stirred the Hornet's Nest*/, 28272 /*Missing Pieces*/, 28271 /*Reduced Productivity*/, 28353 /*Jonesy Sent For You*/, 28351 /*Unlimited Potential*/, 28352 /*Camelraderie*/, 28350 /*Master Trapper*/, 28274 /*Two Tents*/, 28273 /*Friend of a Friend*/, 28269 /*Meet Me In Vir'sar*/, 28267 /*Firing Squad*/, 28195 /*Sending a Message*/, 28194 /*The Great Escape*/, 28193 /*Lockdown!*/, 28187 /*Missed Me By Zhat Much!*/, 27990 /*Battlezone*/, 28002 /*Crisis Management*/, 27969 /*Make Yourself Useful*/, 27950 /*Gobbles!*/, 27943 /*Angered Spirits*/, 27942 /*Idolatry*/, 27941 /*Fashionism*/, 27940 /*Dirty Birds*/, 27048 /*Underground Economy*/, 28133 /*Fury Unbound*/, 28123 /*The Demon Chain*/, 28043 /*How to Maim Your Dragon*/, 27375 /*The Weeping Wound*/, 27955 /*Eye Spy*/, 27954 /*The Eyes Have It*/, 27951 /*We All Must Sacrifice*/, 27947 /*A Vision of Twilight*/, 27945 /*Paint it Black*/, 28041 /*Bait and Throttle*/, 27750 /*War Forage*/, 27747 /*Total War*/, 27929 /*Drag 'em Down*/, 27751 /*Crushing the Wildhammer*/, 27690 /*Narkrall, the Drake-Tamer*/, 27606 /*Blast Him!*/, 27586 /*Shells on the Sea Shore*/, 27584 /*Blood in the Surf*/, 27607 /*The Southern Flank*/, 27583 /*The Northern Flank*/, 28909 /*Sauranok Will Point the Way*/, 27718 /*Warchief's Command: Vashj'ir!*/, 28293 /*That's No Pyramid!*/, 27059 /*The Wrong Sequence*/, 27043 /*Fight Fire and Water and Air with...*/, 27041 /*Decryption Made Easy*/, 27005 /*The Twilight Plot*/, 27008 /*Fly Over*/, 27953 /*The Reliquary*/, 28557 /*Warchief's Command: Uldum!*/, 27722 /*Warchief's Command: Deepholm!*/, 29194 /*Through a Glass, Darkly*/, 29193 /*On a Wing and a Prayer*/, 29234 /*Delegation*/, 29225 /*Actionable Intelligence*/, 26914 /*Immolation*/, 14286 /*Safety in Numbers*/, 14266 /*Charge*/, 14265 /*Your Instructor*/, 26385 /*Breaking Waves of Change*/, 28517 /*The Howling Oak*/, 29452 /*Your Time Has Come*/, 29088 /*Hyena Extermination*/, 29087 /*Sludge Investigation*/, 29111 /*Mor'shan Caravan Delivery*/, 29112 /*Demon Seed*/, 29110 /*Mor'shan Caravan Rescue*/, 29109 /*Mor'shan Caravan Pick-Up*/, 29095 /*Report to Thork*/, 876 /*Serena Bloodfeather*/, 875 /*Harpy Lieutenants*/, 867 /*Harpy Raiders*/, 29094 /*The Short Way Home*/, 29015 /*Miner's Fortune*/, 14006 /*Read the Manual*/, 14004 /*Return to Samophlanger*/, 29027 /*Nugget Slugs*/, 29026 /*Wenikee Boltbucket*/, 14003 /*Samophlange Repair*/, 29024 /*Samophlange*/, 29023 /*Samophlange*/, 29022 /*Samophlange*/, 863 /*The Escape*/, 29089 /*Sludge Beast!*/, 14042 /*Ammo Kerblammo*/, 14067 /*The Stolen Silver*/, 14068 /*Waptor Twapping*/, 869 /*To Track a Thief*/, 14038 /*Love it or Limpet*/, 26769 /*Raging River Ride*/, 14050 /*Gazlowe's Fortune*/, 14063 /*Mutiny, Mon!*/, 14057 /*Guns. We Need Guns.*/, 14056 /*Glomp is Sitting On It*/, 14052 /*Take it up with Tony*/, 866 /*Root Samples*/, 4021 /*Counterattack!*/, 855 /*Centaur Bracers*/, 852 /*Hezrul Bloodmark*/, 14073 /*Deathgate's Reinforcements*/, 13999 /*Who's Shroomin' Who?*/, 905 /*Into the Raptor's Den*/, 851 /*Verog the Dervish*/, 880 /*Altered Beings*/, 877 /*The Stagnant Oasis*/, 14072 /*Flushing Out Verog*/, 13995 /*King of Centaur Mountain*/, 850 /*Kolkar Leaders*/, 13992 /*A Little Diversion*/, 903 /*Hunting the Huntress*/, 845 /*The Zhevra*/, 26878 /*Disciples of Naralex*/, 870 /*The Forgotten Pools*/, 13971 /*The Kodo's Return*/, 13970 /*Animal Services*/, 13969 /*Grol'dom's Missing Kodo*/, 13968 /*The Tortusk Takedown*/, 13963 /*By Hook Or By Crook*/, 13975 /*Crossroads Caravan Delivery*/, 13961 /*Drag it Out of Them*/, 13949 /*Crossroads Caravan Pickup*/, 5041 /*Supplies for the Crossroads*/, 9403 /*The Purest Water*/, 9402 /*Fetch!*/, 9144 /*Missing in the Ghostlands*/, 9359 /*Farstrider Retreat*/, 8473 /*A Somber Task*/, 9067 /*The Party Never Ends*/, 9076 /*Wretched Ringleader*/, 8480 /*Lost Armaments*/, 8886 /*Grimscale Pirates!*/, 9135 /*Return to Sathiel*/, 9134 /*Skymistress Gloaming*/, 9066 /*Swift Discipline*/, 9133 /*Fly to Silvermoon City*/, 8892 /*Situation at Sunsail Anchorage*/, 9130 /*Goods from Silvermoon City*/, 9258 /*The Scorched Grove*/, 9358 /*Ranger Sareyn*/, 9395 /*Saltheril's Haven*/, 9254 /*The Wayward Apprentice*/, 8491 /*Pelt Collection*/, 9064 /*Taking the Fall*/, 9062 /*Soaked Pages*/, 8475 /*The Dead Scar*/, 9256 /*Fairbreeze Village*/, 8483 /*The Dwarven Spy*/, 8482 /*Incriminating Documents*/, 8486 /*Arcane Instability*/, 9119 /*Malfunction at the West Sanctum*/, 9352 /*Darnassian Intrusions*/, 8895 /*Delivery to the North Sanctum*/, 8463 /*Unstable Mana Crystals*/, 8468 /*Wanted: Thaelis the Hungerer*/, 9148 /*Delivery to Tranquillien*/, 8490 /*Powering our Defenses*/, 9253 /*Runewarden Deryan*/, 9147 /*The Fallen Courier*/, 9255 /*Research Notes*/, 8488 /*Unexpected Results*/, 8487 /*Corrupted Soil*/, 9252 /*Defending Fairbreeze Village*/, 9404 /*Recently Living*/, 9363 /*Warning Fairbreeze Village*/, 9360 /*Amani Invasion*/, 8479 /*Zul'Marosh*/, 8890 /*Word from the Spire*/, 8891 /*Abandoned Investigations*/, 8894 /*Cleaning up the Grounds*/, 9394 /*Where's Wyllithen?*/, 8889 /*Deactivating the Spire*/, 8888 /*The Magister's Apprentice*/, 8477 /*The Spearcrafter's Hammer*/, 8476 /*Amani Encroachment*/, 28170 /*Night Terrors*/, 65610 /*Wish You Were Here*/, 28166 /*Thog's Nightlight*/, 28151 /*Dressed to Kill*/, 28149 /*Whispers in the Wind*/, 28147 /*Purple is Your Color*/, 28790 /*A Personal Summons*/, 27721 /*Warchief's Command: Mount Hyjal!*/, 9171 /*Culinary Crunch*/, 9149 /*The Plagued Coast*/, 9155 /*Down the Dead Scar*/, 9173 /*Retaking Windrunner Spire*/, 9192 /*Trouble at the Underlight Mines*/, 9150 /*Salvaging the Past*/, 9151 /*The Sanctum of the Sun*/, 9139 /*Goldenmist Village*/, 9212 /*Escape from the Catacombs*/, 9161 /*The Traitor's Shadow*/, 9275 /*A Little Dash of Seasoning*/, 9214 /*Shadowpine Weaponry*/, 9215 /*Bring Me Kel'gash's Head!*/, 9276 /*Attack on Zeb'Tela*/, 9158 /*Bearers of the Plague*/, 9174 /*Vanquishing Aquantion*/, 9157 /*Forgotten Rituals*/, 9146 /*Report to Captain Helios*/, 9143 /*Dealing with Zeb'Sora*/, 9218 /*Spinal Dust*/, 9216 /*Rotting Hearts*/, 9156 /*Wanted: Knucklerot and Luzran*/, 9199 /*Troll Juju*/, 9193 /*Investigate the Amani Catacombs*/, 9152 /*Tomber's Supplies*/, 9138 /*Suncrown Village*/, 28259 /*Meet with Demisette Cloyce*/, 27272 /*Demisette Sends Word*/, 4487 /*Summon Felsteed*/, 26201 /*The Power of a Warlock*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(29253, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- A Shiny Reward +(29252, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Booty Bay's Interests +(29153, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Booty Bay's Interests +(29152, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Making Contact +(29151, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Bad Supplies +(29150, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Voodoo Zombies +(29133, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- To the Digsite +(29131, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Defend the Rebel Camp +(29124, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Warn the Rebel Camp +(29121, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Bury Me With Me Boots... +(29213, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- How's the Hunter Holding Up? +(29120, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Mauti +(29116, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Follow That Cat +(29115, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- The Hunter's Revenge +(29114, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Track the Tracker +(29105, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Nesingwary Will Know +(29104, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Spirits Are With Us +(29103, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Serpents and Poison +(14285, 0, 0, 0, 0, 0, 0, 0, 0, 54525), -- Safety in Numbers +(14272, 0, 0, 0, 0, 0, 0, 0, 0, 54525), -- Eviscerate +(14269, 0, 0, 0, 0, 0, 0, 0, 0, 54525), -- Someone's Looking for You +(25936, 396, 396, 5, 0, 500, 500, 0, 0, 55056), -- Pay It Forward +(25929, 396, 396, 396, 0, 0, 500, 500, 0, 55056), -- Sea Legs +(27685, 396, 396, 396, 0, 0, 500, 500, 0, 55006), -- Good Deed Left Undone +(25467, 0, 0, 0, 0, 0, 0, 0, 0, 55006), -- Kliklak's Craw +(25949, 5, 0, 0, 0, 0, 0, 0, 0, 55006), -- Blood and Thunder! +(25948, 5, 275, 0, 0, 0, 500, 0, 0, 55006), -- Bring It On! +(25947, 396, 396, 0, 0, 0, 500, 0, 0, 55006), -- Finders, Keepers +(25946, 0, 0, 0, 0, 0, 0, 0, 0, 55006), -- Helm's Deep +(25944, 396, 397, 396, 0, 0, 500, 100, 0, 55006), -- Girding Our Loins +(25943, 396, 396, 396, 0, 0, 500, 500, 0, 55006), -- Traveling on Our Stomachs +(25942, 396, 396, 396, 0, 0, 500, 500, 0, 55006), -- Buy Us Some Time +(25941, 396, 396, 396, 0, 0, 500, 500, 0, 55006), -- Rest For the Weary +(25924, 5, 5, 396, 0, 0, 1000, 1000, 0, 55006), -- Call of Duty +(28654, 396, 396, 6, 0, 0, 500, 500, 0, 54737), -- The Heart of the Matter +(28633, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Coffer of Promise +(28622, 396, 0, 0, 0, 0, 0, 0, 0, 54737), -- Three if by Air +(28621, 396, 6, 0, 0, 0, 1000, 0, 0, 54737), -- Put That Baby in the Cradle! +(28612, 396, 5, 0, 0, 0, 500, 0, 0, 54737), -- Harrison Jones and the Temple of Uldum +(27748, 396, 0, 0, 0, 0, 0, 0, 0, 54737), -- Fortune and Glory +(28613, 396, 0, 0, 0, 0, 0, 0, 0, 54737), -- See You on the Other Side! +(28497, 396, 0, 0, 0, 0, 0, 0, 0, 54737), -- Fire From the Sky +(28482, 396, 396, 0, 0, 0, 500, 0, 0, 54737), -- Sullah's Gift +(28404, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- I'll Do It By Hand +(28403, 396, 396, 0, 0, 0, 0, 0, 0, 54737), -- Bad Datas +(28402, 396, 396, 0, 0, 0, 0, 0, 0, 54737), -- Schnottz So Fast +(28367, 396, 396, 396, 0, 0, 1000, 1000, 0, 54737), -- Shroud of the Makers +(28363, 396, 396, 0, 0, 0, 500, 0, 0, 54737), -- Stirred the Hornet's Nest +(28272, 396, 396, 0, 0, 0, 1000, 0, 0, 54737), -- Missing Pieces +(28271, 396, 5, 396, 5, 0, 500, 500, 500, 54737), -- Reduced Productivity +(28353, 396, 0, 0, 0, 0, 0, 0, 0, 54737), -- Jonesy Sent For You +(28351, 396, 396, 5, 0, 0, 500, 500, 0, 54737), -- Unlimited Potential +(28352, 5, 396, 396, 0, 0, 1000, 1000, 0, 54737), -- Camelraderie +(28350, 396, 396, 396, 0, 0, 500, 500, 0, 54737), -- Master Trapper +(28274, 396, 396, 0, 0, 0, 1000, 0, 0, 54737), -- Two Tents +(28273, 396, 396, 0, 0, 0, 500, 0, 0, 54737), -- Friend of a Friend +(28269, 396, 396, 0, 0, 0, 500, 0, 0, 54737), -- Meet Me In Vir'sar +(28267, 396, 0, 0, 0, 0, 0, 0, 0, 54737), -- Firing Squad +(28195, 396, 396, 0, 0, 0, 500, 0, 0, 54737), -- Sending a Message +(28194, 396, 396, 0, 0, 0, 500, 0, 0, 54737), -- The Great Escape +(28193, 397, 5, 0, 0, 0, 1000, 0, 0, 54737), -- Lockdown! +(28187, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Missed Me By Zhat Much! +(27990, 396, 5, 0, 0, 0, 500, 0, 0, 54737), -- Battlezone +(28002, 5, 5, 0, 0, 0, 500, 0, 0, 54737), -- Crisis Management +(27969, 396, 396, 396, 0, 0, 1000, 1000, 0, 54737), -- Make Yourself Useful +(27950, 396, 396, 0, 0, 0, 500, 0, 0, 54737), -- Gobbles! +(27943, 396, 6, 396, 0, 0, 500, 500, 0, 54737), -- Angered Spirits +(27942, 396, 1, 5, 0, 0, 500, 1000, 0, 54737), -- Idolatry +(27941, 396, 0, 0, 0, 0, 500, 0, 0, 54737), -- Fashionism +(27940, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Dirty Birds +(27048, 5, 0, 0, 0, 0, 0, 0, 0, 54737), -- Underground Economy +(28133, 1, 274, 0, 0, 0, 0, 0, 0, 54737), -- Fury Unbound +(28123, 1, 5, 0, 0, 0, 0, 0, 0, 54737), -- The Demon Chain +(28043, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- How to Maim Your Dragon +(27375, 1, 5, 0, 0, 0, 0, 0, 0, 54737), -- The Weeping Wound +(27955, 5, 6, 25, 0, 0, 0, 0, 0, 54737), -- Eye Spy +(27954, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Eyes Have It +(27951, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- We All Must Sacrifice +(27947, 6, 5, 0, 0, 0, 0, 0, 0, 54737), -- A Vision of Twilight +(27945, 1, 274, 0, 0, 0, 0, 0, 0, 54737), -- Paint it Black +(28041, 1, 274, 5, 0, 0, 0, 0, 0, 54737), -- Bait and Throttle +(27750, 1, 274, 0, 0, 0, 0, 0, 0, 54737), -- War Forage +(27747, 1, 5, 0, 0, 0, 0, 0, 0, 54737), -- Total War +(27929, 6, 5, 0, 0, 0, 0, 0, 0, 54737), -- Drag 'em Down +(27751, 5, 1, 6, 0, 0, 0, 0, 0, 54737), -- Crushing the Wildhammer +(27690, 1, 5, 0, 0, 0, 0, 0, 0, 54737), -- Narkrall, the Drake-Tamer +(27606, 1, 11, 5, 0, 0, 0, 0, 0, 54737), -- Blast Him! +(27586, 1, 5, 0, 0, 0, 0, 0, 0, 54737), -- Shells on the Sea Shore +(27584, 25, 5, 15, 0, 0, 0, 0, 0, 54737), -- Blood in the Surf +(27607, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Southern Flank +(27583, 1, 5, 0, 0, 0, 0, 0, 0, 54737), -- The Northern Flank +(28909, 6, 1, 0, 0, 0, 0, 0, 0, 54737), -- Sauranok Will Point the Way +(27718, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Warchief's Command: Vashj'ir! +(28293, 274, 25, 0, 0, 0, 0, 0, 0, 54737), -- That's No Pyramid! +(27059, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Wrong Sequence +(27043, 6, 1, 25, 0, 0, 0, 0, 0, 54737), -- Fight Fire and Water and Air with... +(27041, 6, 0, 0, 0, 0, 0, 0, 0, 54737), -- Decryption Made Easy +(27005, 1, 25, 0, 0, 0, 0, 0, 0, 54737), -- The Twilight Plot +(27008, 6, 6, 0, 0, 0, 0, 0, 0, 54737), -- Fly Over +(27953, 1, 6, 0, 0, 0, 0, 0, 0, 54737), -- The Reliquary +(28557, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Warchief's Command: Uldum! +(27722, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Warchief's Command: Deepholm! +(29194, 1, 1, 1, 0, 0, 1000, 1000, 0, 58158), -- Through a Glass, Darkly +(29193, 1, 1, 1, 0, 0, 1500, 1500, 0, 58158), -- On a Wing and a Prayer +(29234, 1, 1, 0, 0, 0, 1000, 0, 0, 58158), -- Delegation +(29225, 1, 0, 0, 0, 0, 0, 0, 0, 58158), -- Actionable Intelligence +(26914, 1, 1, 0, 0, 0, 0, 0, 0, 54481), -- Immolation +(14286, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Safety in Numbers +(14266, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Charge +(14265, 0, 0, 0, 0, 0, 0, 0, 0, 55639), -- Your Instructor +(26385, 5, 2, 0, 0, 0, 60, 0, 0, 55639), -- Breaking Waves of Change +(28517, 1, 0, 0, 0, 0, 0, 0, 0, 55639), -- The Howling Oak +(29452, 0, 0, 0, 0, 0, 0, 0, 0, 57564), -- Your Time Has Come +(29088, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Hyena Extermination +(29087, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Sludge Investigation +(29111, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Mor'shan Caravan Delivery +(29112, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Demon Seed +(29110, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Mor'shan Caravan Rescue +(29109, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Mor'shan Caravan Pick-Up +(29095, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Report to Thork +(876, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Serena Bloodfeather +(875, 11, 0, 0, 0, 100, 0, 0, 0, 54737), -- Harpy Lieutenants +(867, 5, 0, 0, 0, 0, 0, 0, 0, 54737), -- Harpy Raiders +(29094, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Short Way Home +(29015, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Miner's Fortune +(14006, 5, 1, 0, 0, 0, 0, 0, 0, 54737), -- Read the Manual +(14004, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Return to Samophlanger +(29027, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Nugget Slugs +(29026, 1, 5, 0, 0, 0, 900, 0, 0, 54737), -- Wenikee Boltbucket +(14003, 6, 0, 0, 0, 0, 0, 0, 0, 54737), -- Samophlange Repair +(29024, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Samophlange +(29023, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Samophlange +(29022, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Samophlange +(863, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Escape +(29089, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Sludge Beast! +(14042, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Ammo Kerblammo +(14067, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Stolen Silver +(14068, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Waptor Twapping +(869, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- To Track a Thief +(14038, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Love it or Limpet +(26769, 1, 5, 0, 0, 0, 0, 0, 0, 54737), -- Raging River Ride +(14050, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Gazlowe's Fortune +(14063, 1, 11, 0, 0, 0, 0, 0, 0, 54737), -- Mutiny, Mon! +(14057, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Guns. We Need Guns. +(14056, 1, 25, 0, 0, 0, 0, 0, 0, 54737), -- Glomp is Sitting On It +(14052, 6, 388, 0, 0, 0, 0, 0, 0, 54737), -- Take it up with Tony +(866, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Root Samples +(4021, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Counterattack! +(855, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Centaur Bracers +(852, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Hezrul Bloodmark +(14073, 396, 0, 0, 0, 0, 0, 0, 0, 54737), -- Deathgate's Reinforcements +(13999, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Who's Shroomin' Who? +(905, 5, 0, 0, 0, 0, 0, 0, 0, 54737), -- Into the Raptor's Den +(851, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Verog the Dervish +(880, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Altered Beings +(877, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Stagnant Oasis +(14072, 1, 6, 0, 0, 0, 0, 0, 0, 54737), -- Flushing Out Verog +(13995, 1, 273, 0, 0, 0, 500, 0, 0, 54737), -- King of Centaur Mountain +(850, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Kolkar Leaders +(13992, 66, 1, 0, 0, 0, 800, 0, 0, 54737), -- A Little Diversion +(903, 5, 0, 0, 0, 100, 0, 0, 0, 54737), -- Hunting the Huntress +(845, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Zhevra +(26878, 1, 0, 0, 0, 0, 0, 0, 0, 54737), -- Disciples of Naralex +(870, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Forgotten Pools +(13971, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- The Kodo's Return +(13970, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Animal Services +(13969, 6, 273, 0, 0, 0, 1000, 0, 0, 54737), -- Grol'dom's Missing Kodo +(13968, 274, 1, 0, 0, 0, 1000, 0, 0, 54737), -- The Tortusk Takedown +(13963, 1, 274, 0, 0, 300, 1000, 0, 0, 54737), -- By Hook Or By Crook +(13975, 11, 1, 0, 0, 0, 900, 0, 0, 54737), -- Crossroads Caravan Delivery +(13961, 396, 0, 0, 0, 0, 0, 0, 0, 54737), -- Drag it Out of Them +(13949, 1, 25, 0, 0, 100, 900, 0, 0, 54737), -- Crossroads Caravan Pickup +(5041, 1, 1, 0, 0, 0, 500, 0, 0, 54737), -- Supplies for the Crossroads +(9403, 1, 1, 0, 0, 0, 0, 0, 0, 54901), -- The Purest Water +(9402, 1, 6, 25, 0, 0, 0, 0, 0, 54901), -- Fetch! +(9144, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Missing in the Ghostlands +(9359, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Farstrider Retreat +(8473, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- A Somber Task +(9067, 1, 0, 0, 0, 0, 0, 0, 0, 54901), -- The Party Never Ends +(9076, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Wretched Ringleader +(8480, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Lost Armaments +(8886, 5, 1, 6, 0, 0, 500, 500, 0, 54901), -- Grimscale Pirates! +(9135, 1, 0, 0, 0, 0, 0, 0, 0, 54901), -- Return to Sathiel +(9134, 1, 0, 0, 0, 0, 0, 0, 0, 54901), -- Skymistress Gloaming +(9066, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Swift Discipline +(9133, 1, 0, 0, 0, 0, 0, 0, 0, 54901), -- Fly to Silvermoon City +(8892, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Situation at Sunsail Anchorage +(9130, 1, 0, 0, 0, 0, 0, 0, 0, 54901), -- Goods from Silvermoon City +(9258, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- The Scorched Grove +(9358, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Ranger Sareyn +(9395, 5, 1, 1, 0, 0, 1000, 1000, 0, 54901), -- Saltheril's Haven +(9254, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- The Wayward Apprentice +(8491, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Pelt Collection +(9064, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Taking the Fall +(9062, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Soaked Pages +(8475, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- The Dead Scar +(9256, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Fairbreeze Village +(8483, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- The Dwarven Spy +(8482, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Incriminating Documents +(8486, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Arcane Instability +(9119, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Malfunction at the West Sanctum +(9352, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Darnassian Intrusions +(8895, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Delivery to the North Sanctum +(8463, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Unstable Mana Crystals +(8468, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Wanted: Thaelis the Hungerer +(9148, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Delivery to Tranquillien +(8490, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Powering our Defenses +(9253, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Runewarden Deryan +(9147, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- The Fallen Courier +(9255, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Research Notes +(8488, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Unexpected Results +(8487, 1, 5, 0, 0, 0, 100, 0, 0, 54901), -- Corrupted Soil +(9252, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Defending Fairbreeze Village +(9404, 5, 0, 0, 0, 0, 0, 0, 0, 54901), -- Recently Living +(9363, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Warning Fairbreeze Village +(9360, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Amani Invasion +(8479, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Zul'Marosh +(8890, 1, 1, 0, 0, 0, 500, 0, 0, 54901), -- Word from the Spire +(8891, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Abandoned Investigations +(8894, 5, 1, 0, 0, 0, 500, 0, 0, 54901), -- Cleaning up the Grounds +(9394, 1, 6, 0, 0, 0, 1000, 0, 0, 54901), -- Where's Wyllithen? +(8889, 1, 1, 6, 0, 0, 500, 500, 0, 54901), -- Deactivating the Spire +(8888, 1, 1, 1, 0, 0, 500, 500, 0, 54901), -- The Magister's Apprentice +(8477, 1, 0, 0, 0, 0, 0, 0, 0, 54901), -- The Spearcrafter's Hammer +(8476, 0, 0, 0, 0, 0, 0, 0, 0, 54901), -- Amani Encroachment +(28170, 1, 25, 5, 0, 0, 0, 0, 0, 54737), -- Night Terrors +(65610, 1, 18, 6, 0, 0, 0, 0, 0, 54737), -- Wish You Were Here +(28166, 1, 273, 0, 0, 0, 0, 0, 0, 54737), -- Thog's Nightlight +(28151, 1, 11, 0, 0, 0, 0, 0, 0, 54737), -- Dressed to Kill +(28149, 6, 1, 273, 0, 0, 0, 0, 0, 54737), -- Whispers in the Wind +(28147, 1, 25, 0, 0, 0, 0, 0, 0, 54737), -- Purple is Your Color +(28790, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- A Personal Summons +(27721, 0, 0, 0, 0, 0, 0, 0, 0, 54737), -- Warchief's Command: Mount Hyjal! +(9171, 5, 1, 0, 0, 0, 1000, 0, 0, 54647), -- Culinary Crunch +(9149, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- The Plagued Coast +(9155, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Down the Dead Scar +(9173, 1, 0, 0, 0, 0, 0, 0, 0, 54647), -- Retaking Windrunner Spire +(9192, 1, 5, 0, 0, 0, 1000, 0, 0, 54647), -- Trouble at the Underlight Mines +(9150, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Salvaging the Past +(9151, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- The Sanctum of the Sun +(9139, 1, 0, 0, 0, 0, 0, 0, 0, 54647), -- Goldenmist Village +(9212, 1, 0, 0, 0, 0, 0, 0, 0, 54647), -- Escape from the Catacombs +(9161, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- The Traitor's Shadow +(9275, 2, 1, 0, 0, 0, 1000, 0, 0, 54647), -- A Little Dash of Seasoning +(9214, 1, 0, 0, 0, 0, 0, 0, 0, 54647), -- Shadowpine Weaponry +(9215, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Bring Me Kel'gash's Head! +(9276, 1, 0, 0, 0, 0, 0, 0, 0, 54647), -- Attack on Zeb'Tela +(9158, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Bearers of the Plague +(9174, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Vanquishing Aquantion +(9157, 0, 0, 0, 0, 0, 0, 0, 0, 54647); -- Forgotten Rituals + +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(9146, 6, 0, 0, 0, 0, 0, 0, 0, 54647), -- Report to Captain Helios +(9143, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Dealing with Zeb'Sora +(9218, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Spinal Dust +(9216, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Rotting Hearts +(9156, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Wanted: Knucklerot and Luzran +(9199, 1, 0, 0, 0, 0, 0, 0, 0, 54647), -- Troll Juju +(9193, 1, 0, 0, 0, 0, 0, 0, 0, 54647), -- Investigate the Amani Catacombs +(9152, 0, 0, 0, 0, 0, 0, 0, 0, 54647), -- Tomber's Supplies +(9138, 1, 5, 0, 0, 0, 1000, 0, 0, 54647), -- Suncrown Village +(28259, 1, 1, 0, 0, 0, 0, 0, 0, 55639), -- Meet with Demisette Cloyce +(27272, 1, 1, 0, 0, 0, 0, 0, 0, 55639), -- Demisette Sends Word +(4487, 1, 1, 11, 1, 0, 0, 0, 0, 55639), -- Summon Felsteed +(26201, 5, 0, 0, 0, 0, 0, 0, 0, 55639); -- The Power of a Warlock + + +UPDATE `quest_details` SET `Emote1`=0, `VerifiedBuild`=54481 WHERE `ID`=28822; -- The Rear is Clear +UPDATE `quest_details` SET `Emote1`=1, `Emote2`=5, `VerifiedBuild`=54737 WHERE `ID`=887; -- Southsea Freebooters + +DELETE FROM `quest_request_items` WHERE `ID` IN (26971 /*The Binding*/, 28854 /*Closing a Dark Chapter*/, 28693 /*Finish The Job*/, 28689 /*The Forgotten*/, 28686 /*Not The Friendliest Town*/, 28682 /*Claiming The Keep*/, 28681 /*Shark Tank*/, 28679 /*Rattling Their Cages*/, 28668 /*Prison Revolt*/, 28660 /*Clearing the Depths*/, 28659 /*The Leftovers*/, 28657 /*A Huge Problem*/, 24627 /*At Our Doorstep*/, 24593 /*Neither Human Nor Beast*/, 24575 /*Liberation Day*/, 28391 /*The Restless Brood*/, 24501 /*Queen-Sized Troubles*/, 24484 /*Pest Control*/, 24468 /*Stranded at the Marsh*/, 14416 /*The Hungry Ettin*/, 14412 /*Washed Up*/, 14386 /*Leader of the Pack*/, 14382 /*Two By Sea*/, 14369 /*Unleash the Beast*/, 14368 /*Save the Children!*/, 14348 /*You Can't Take 'Em Alone*/, 14347 /*Hold the Line*/, 14272 /*Eviscerate*/, 25411 /*A New Master*/, 29151 /*Bad Supplies*/, 29150 /*Voodoo Zombies*/, 29131 /*Defend the Rebel Camp*/, 27196 /*On to Something*/, 29120 /*Mauti*/, 29104 /*Spirits Are With Us*/, 29103 /*Serpents and Poison*/, 27050 /*Fungal Fury*/, 27049 /*Soft Rock*/, 27048 /*Underground Economy*/, 27047 /*Motes*/, 27046 /*Fear of Boring*/); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(26971, 0, 0, 0, 0, 'Stop Lorthuna! Don\'t let her interrupt the ritual!', 55639), -- The Binding +(28854, 0, 6, 0, 0, 'What of Erudax, $c?', 55639), -- Closing a Dark Chapter +(28693, 0, 0, 0, 0, 'Were you able to finish the job?', 55639), -- Finish The Job +(28689, 0, 0, 0, 0, 'Were you able to release our forgotten brothers in arms?', 55639), -- The Forgotten +(28686, 0, 0, 0, 0, 'Did you find out what\'s up with that village? Something seems off...', 55639), -- Not The Friendliest Town +(28682, 0, 0, 0, 0, 'Is keep lord farson dead?', 55639), -- Claiming The Keep +(28681, 0, 0, 0, 0, 'I don\'t think you guys have a chance against that shark.', 55639), -- Shark Tank +(28679, 0, 0, 0, 0, 'Any luck taking out those undead on the beach? They looked freaky to me...', 55639), -- Rattling Their Cages +(28668, 0, 0, 0, 0, 'Were you able to clear out that cellblock $n? We are waiting on you.', 55639), -- Prison Revolt +(28660, 0, 0, 0, 0, 'Did you take care of the ghosts down there yet? We have plenty of horde scum to fill that place up with once it\'s cleared out.', 55639), -- Clearing the Depths +(28659, 0, 0, 0, 0, 'Gah, the smell of their weak bodies is sickening me.', 55639), -- The Leftovers +(28657, 0, 0, 0, 0, 'Did you find problim yet? Pretty hard to miss that guy with how huge he is.', 55639), -- A Huge Problem +(24627, 0, 0, 0, 0, 'You\'re back, $N.', 55639), -- At Our Doorstep +(24593, 0, 0, 0, 0, 'It is always good to see you $g brother:sister;.', 55639), -- Neither Human Nor Beast +(24575, 0, 0, 0, 0, 'Have you freed the villagers, $N? I cannot imagine what duress they\'re enduring under the Forsaken.', 55639), -- Liberation Day +(28391, 0, 1, 0, 0, 'And so continues the cycle of the stone drakes. Tumultuous wills in stoic frames.', 55639), -- The Restless Brood +(24501, 0, 0, 0, 0, 'Did you take care of Rygna, $N?', 55639), -- Queen-Sized Troubles +(24484, 0, 0, 0, 0, 'You\'re back, $N. Have the spiders been taken care of?', 55639), -- Pest Control +(24468, 0, 0, 0, 0, 'Were any of the passengers still alive?', 55639), -- Stranded at the Marsh +(14416, 0, 0, 0, 0, 'You\'re back, $N.', 55639), -- The Hungry Ettin +(14412, 0, 0, 0, 0, 'Bloody Forsaken! Not even the ocean wants them!', 55639), -- Washed Up +(14386, 0, 0, 0, 0, 'Is it done yet, $N?', 55639), -- Leader of the Pack +(14382, 0, 0, 0, 0, 'You\'re back, $N. How\'s the situation outside?', 55639), -- Two By Sea +(14369, 0, 0, 0, 0, 'Did you take care of the Forsaken scum, $N?', 55639), -- Unleash the Beast +(14368, 0, 0, 0, 0, 'I... I don\'t know if I can go on without them.', 55639), -- Save the Children! +(14348, 0, 0, 0, 0, 'They just keep coming, don\'t they?', 55639), -- You Can't Take 'Em Alone +(14347, 0, 0, 0, 0, 'These blaggards aren\'t so tough now, are they?', 55639), -- Hold the Line +(14272, 0, 0, 0, 0, 'Keep your head down and maybe the worgen will go for some other poor fool instead of us.', 55639), -- Eviscerate +(25411, 0, 16, 0, 0, '$B$B', 55639), -- A New Master +(29151, 0, 0, 0, 0, '', 55639), -- Bad Supplies +(29150, 0, 0, 0, 0, 'Dis be a rush job wit da voodoo. But it still be dangerous.', 55639), -- Voodoo Zombies +(29131, 0, 0, 0, 0, 'There is no end to these trolls, $n.', 55639), -- Defend the Rebel Camp +(27196, 0, 0, 0, 0, 'Alright, now let\'s see what this staff can show us...', 55639), -- On to Something +(29120, 0, 0, 0, 0, 'Mauti, she got some powerful mojo, $n.', 55639), -- Mauti +(29104, 0, 0, 0, 0, 'Stranglethorn be in some bad shape, $n.', 55639), -- Spirits Are With Us +(29103, 0, 0, 0, 0, 'It doesn\'t look like there is an end to these serpents.', 55639), -- Serpents and Poison +(27050, 0, 1, 0, 0, 'See to it that no further corruption spreads.', 55639), -- Fungal Fury +(27049, 0, 1, 0, 0, 'If they continue to rise, we will continue to destroy them.', 55639), -- Soft Rock +(27048, 1, 1, 0, 0, 'Boom?', 55639), -- Underground Economy +(27047, 1, 1, 0, 0, 'Painite is one of the most valuable materials to us, particularly due to our inability to reach most of the deposits on our own.', 55639), -- Motes +(27046, 0, 1, 0, 0, 'Your flesh is well suited for the task. It does not corrode from their attacks as our rockskin does. ', 55639); -- Fear of Boring + + +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=6, `VerifiedBuild`=55639 WHERE `ID`=28853; -- Kill the Courier +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=6 WHERE `ID`=26858; +UPDATE `quest_request_items` SET `EmoteOnComplete`=6, `CompletionText`='Do you have the living branch? Hand it over quickly!' WHERE `ID`=9404; -- Recently Living +UPDATE `quest_request_items` SET `EmoteOnComplete`=6, `CompletionText`='Only water from the Elrendar Falls has the purity required for use with magic. Do you have it?' WHERE `ID`=9403; -- The Purest Water +UPDATE `quest_request_items` SET `EmoteOnComplete`=0 WHERE `ID` IN (9402, 9360, 9255, 9218, 9216, 9174, 9147, 9076, 9066, 9064, 9062, 8895, 8491, 8490, 8487, 8483, 8482, 8480, 8477, 8472, 8468, 8463); +UPDATE `quest_request_items` SET `CompletionText`='Do I have to go in there and do it myself, $N?', `VerifiedBuild`=55639 WHERE `ID`=26770; -- Mystic Masters +UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `CompletionText`='Have you uncovered anything? Are the night elves behind this?', `VerifiedBuild`=55639 WHERE `ID`=9352; -- Darnassian Intrusions +UPDATE `quest_request_items` SET `CompletionText`='This is a most grim and undignified business, $c. I trust that you will complete this task to milady\'s complete satisfaction?' WHERE `ID`=9193; +UPDATE `quest_request_items` SET `CompletionText`='Did you retrieve the codex, $N?', `VerifiedBuild`=55639 WHERE `ID`=28500; -- The Cypher of Keset +UPDATE `quest_request_items` SET `CompletionText`='You\'re back, $N. Is your prowess as great as I\'ve heard?', `VerifiedBuild`=55639 WHERE `ID`=28499; -- Punish the Trespassers +UPDATE `quest_request_items` SET `CompletionText`='Hail, $N!', `VerifiedBuild`=55639 WHERE `ID`=28486; -- Salhet's Gambit +UPDATE `quest_request_items` SET `CompletionText`='It is good to see you once more, $N.', `VerifiedBuild`=55639 WHERE `ID`=28483; -- Bleeding the Enemy +UPDATE `quest_request_items` SET `CompletionText`='You\'ve returned, $N.', `VerifiedBuild`=55639 WHERE `ID`=28480; -- Lieutenants of Darkness +UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `CompletionText`='Have you obtained the medallions, $N? The drowned still haunt this lake!' WHERE `ID`=9157; -- Forgotten Rituals +UPDATE `quest_request_items` SET `EmoteOnComplete`=6 WHERE `ID` IN (9143, 9135, 9134, 9130, 9067, 8886); +UPDATE `quest_request_items` SET `EmoteOnComplete`=6 WHERE `ID`=26311; -- Unfamiliar Waters +UPDATE `quest_request_items` SET `EmoteOnComplete`=6, `EmoteOnIncomplete`=6, `VerifiedBuild`=55639 WHERE `ID`=8889; -- Deactivating the Spire +UPDATE `quest_request_items` SET `CompletionText`='We must make haste if we\'re to rebuild the World Pillar, $N.', `VerifiedBuild`=55639 WHERE `ID`=26256; -- Bleed the Bloodshaper +UPDATE `quest_request_items` SET `CompletionText`='Shhh, $N! Listen. Listen...', `VerifiedBuild`=55639 WHERE `ID`=28149; -- Whispers in the Wind +UPDATE `quest_request_items` SET `CompletionText`='This is good, $N. With heroes like you stirring up trouble out here, we\'ll keep the cult distracted from our main invasion.$B$BDo you have a disguise?', `VerifiedBuild`=55639 WHERE `ID`=28147; -- Purple is Your Color +UPDATE `quest_request_items` SET `CompletionText`='Did you obtain it, $N?', `VerifiedBuild`=55639 WHERE `ID`=28145; -- Venomblood Antidote +UPDATE `quest_request_items` SET `CompletionText`='Have you been to the nests, $N?', `VerifiedBuild`=55639 WHERE `ID`=905; -- Into the Raptor's Den +UPDATE `quest_request_items` SET `CompletionText`='How goes your hunt, $N?', `VerifiedBuild`=55639 WHERE `ID`=903; -- Hunting the Huntress +UPDATE `quest_request_items` SET `CompletionText`='Have you helped clear the skies, $N?', `VerifiedBuild`=55639 WHERE `ID`=27929; -- Drag 'em Down +UPDATE `quest_request_items` SET `CompletionText`='Did you swash some buckles, $N? Did you Buccan their neers?', `VerifiedBuild`=55639 WHERE `ID`=887; -- Southsea Freebooters +UPDATE `quest_request_items` SET `CompletionText`='The great cat calls to you, $N.', `VerifiedBuild`=55639 WHERE `ID`=881; -- Echeyakee +UPDATE `quest_request_items` SET `CompletionText`='Have you been to the Forgotten Pools, $N? Did you find anything?', `VerifiedBuild`=55639 WHERE `ID`=870; -- The Forgotten Pools +UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `CompletionText`='Hello, $N. Did you get those root samples?', `VerifiedBuild`=55639 WHERE `ID`=866; -- Root Samples +UPDATE `quest_request_items` SET `CompletionText`='Is Hezrul defeated, $N?', `VerifiedBuild`=55639 WHERE `ID`=852; -- Hezrul Bloodmark +UPDATE `quest_request_items` SET `CompletionText`='Hello, $N. Do you have Kodobane\'s head for me?', `VerifiedBuild`=55639 WHERE `ID`=850; -- Kolkar Leaders +UPDATE `quest_request_items` SET `CompletionText`='Do you have the spores, $N? My associates and I are eager to study this phenomenon...', `VerifiedBuild`=55639 WHERE `ID`=848; -- Fungal Spores +UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `VerifiedBuild`=55639 WHERE `ID`=8479; -- Zul'Marosh +UPDATE `quest_request_items` SET `CompletionText`='Did you succeed, $N? I estimated your chances of survival at 68.5%.', `VerifiedBuild`=55639 WHERE `ID`=27777; -- Core Access Codes +UPDATE `quest_request_items` SET `CompletionText`='Greetings, user $N. I am happy to see you are still unaffected by the effects of the expedition curse.', `VerifiedBuild`=55639 WHERE `ID`=27761; -- A Disarming Distraction +UPDATE `quest_request_items` SET `CompletionText`='Is it done, $N? The expedition members cannot be saved.', `VerifiedBuild`=55639 WHERE `ID`=27755; -- The Curse of the Tombs + +UPDATE `quest_request_items` SET `EmoteOnComplete`=0, `EmoteOnIncomplete`=6, `VerifiedBuild`=55639 WHERE `ID`=8345; -- The Shrine of Dath'Remar +UPDATE `quest_request_items` SET `EmoteOnIncomplete`=6, `VerifiedBuild`=55639 WHERE `ID`=8330; -- Solanian's Belongings +UPDATE `quest_request_items` SET `CompletionText`='Search those tents, $N. Try to ignore the stench.', `VerifiedBuild`=55639 WHERE `ID`=14072; -- Flushing Out Verog +UPDATE `quest_request_items` SET `EmoteOnComplete`=1 WHERE `ID`=11972; +UPDATE `quest_request_items` SET `EmoteOnComplete`=1, `VerifiedBuild`=55639 WHERE `ID`=27051; -- Through Persistence + +DELETE FROM `creature_queststarter` WHERE (`id`=19176 AND `quest`=11971) OR (`id`=26113 AND `quest` IN (11923,11922)) OR (`id`=459 AND `quest` IN (28788,26914)) OR (`id`=197 AND `quest`=3105) OR (`id`=15279 AND `quest`=10068) OR (`id`=15278 AND `quest`=8328) OR (`id`=3363 AND `quest`=65610) OR (`id`=5172 AND `quest`=4487); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(19176, 11971, 55141), -- The Spinner of Summer Tales offered by Tauren Commoner +(26113, 11923, 55141), -- Torch Catching offered by Master Flame Eater +(26113, 11922, 55141), -- Torch Tossing offered by Master Flame Eater +(459, 28788, 54481), -- Join the Battle! offered by Drusilla La Salle +(459, 26914, 54481), -- Immolation offered by Drusilla La Salle +(197, 3105, 54481), -- Tainted Letter offered by Marshal McBride +(15279, 10068, 54737), -- Arcane Missiles offered by Julia Sunstriker +(15278, 8328, 54737), -- Mage Training offered by Magistrix Erona +(3363, 65610, 54737), -- Wish You Were Here offered by Magar +(5172, 4487, 55639); -- Summon Felsteed offered by Briarthorn + +DELETE FROM `creature_questender` WHERE (`id`=459 AND `quest`=3105); +INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES +(459, 3105, 54481); -- Tainted Letter ended by Drusilla La Salle + +DELETE FROM `quest_template` WHERE `ID` IN (435 /*Escorting Erland*/, 327 /**/, 5146 /*Elemental Leatherworking*/, 8431 /*Battle of Warsong Gulch*/, 8434 /*Battle of Warsong Gulch*/, 9198 /*Craftsman's Writ - Thorium Tube*/, 8739 /*Hive'Ashi Scout Report*/, 8432 /*Battle of Warsong Gulch*/, 1841 /*Velora Nitely and the Brutal Legguards*/, 1818 /*Speak with Dillinger*/, 1795 /*The Binding*/, 1646 /*The Tome of Divinity*/, 1527 /*Call of Fire*/, 1473 /*Creature of the Void*/, 1450 /*Gryphon Master Talonaxe*/, 1440 /*Return to Vahlarriel*/, 1386 /*Assault on the Kolkar*/, 1114 /*Delivery to the Gnomes*/, 1080 /*Covert Ops - Beta*/, 1079 /*Covert Ops - Alpha*/, 1046 /*True Power of the Rod*/, 925 /*Cairne's Hoofprint*/, 911 /*Gateway to the Frontier*/, 910 /*Down at the Docks*/, 730 /*Trouble In Darkshore?*/, 728 /*To the Undercity for Yagyin's Digest*/, 723 /*Prospect of Faith*/, 700 /*A King's Tribute*/, 686 /*A King's Tribute*/, 522 /*[DEPRECATED] Assassin's Contract*/, 521 /*[DEPRECATED] The Crown of Will*/, 268 /*Return to Sven*/); +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 +(435, 2, 11, 0, 255, 0, 10, 130, 0, 0, 449, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4002, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 3455, 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, 68, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Escorting Erland', 'Escort Erland through the wolves, to Rane Yorick.', 'The wolves outside won\'t leave, and they eye me evilly every time I step foot out that door. They must be incredibly hungry to think I\'m worth eating.$B$BI have to report to my teammate, the Deathstalker Rane Yorick. And to get to Rane, I\'ll need help against those wolves.$B$BPlease escort me! And there are a lot of wolves out there, so we\'ll have a better chance if you have friends who can help...', 'Erland must reach Rane Yorick', 'Return to Rane Yorick in Silverpine Forest.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54525), -- Escorting Erland +(327, 0, 15, 0, 100, 0, 1, 38, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x8, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54525), -- +(5146, 2, 55, 0, 255, 0, 40, -182, 0, 0, 0, 4, 1, 0, 1, 10659, 0, 0, 0, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 83, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Elemental Leatherworking', 'Bring 2 Heart of Fire, 2 Globe of Water, 2 Core of Earth, and 2 Breath of Wind to Brumn Winterhoof in the Arathi Mountains.$B$BCompleting this quest will give you access to the Elemental Leatherworking arts.$B$BThe completion of this quest will prevent you from learning Dragonscale Leatherworking and Tribal Leatherworking; be sure this is the path you wish to follow before doing so.', 'Elemental leatherworking is what I know, and if you\'re willing to open your mind to the greater powers of substance, I will share with you all there is to learn.$B$BKnow this, $c: by choosing this path you agree never to learn dragonscale or tribal leatherworking; there is only room for practice of one of the three arts. Furthermore, I\'ll need adequate proof that you are in tune with the elements of nature; to that end, bring me the purest essences of fire, water, earth, and wind.', '', 'Return to Brumn Winterhoof at Boulder\'gor in Arathi Highlands.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 55006), -- Elemental Leatherworking +(8431, 0, 29, 0, 29, 0, 20, 3277, 41, 0, 0, 3, 1, 0, 1, 24961, 0, 0, 0, 0, 1, 0, 0x108, 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, 889, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 'Battle of Warsong Gulch', '', '', '', 'Return to Horde Warbringer.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54558), -- Battle of Warsong Gulch +(8434, 0, 59, 0, 59, 0, 50, 3277, 41, 0, 0, 3, 1, 0, 1, 24964, 0, 0, 0, 0, 1, 0, 0x108, 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, 889, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 'Battle of Warsong Gulch', '', '', '', 'Return to Horde Warbringer.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54558), -- Battle of Warsong Gulch +(9198, 2, 60, 0, 255, 0, 55, 139, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 22616, 0, 1, 0, 0x4040, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22524, 22523, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 529, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 'Craftsman\'s Writ - Thorium Tube', 'Deliver 14 Thorium Tubes and the Craftsman\'s Writ - Thorium Tube - to Packmaster Stonebruiser at Light\'s Hope Chapel in the Eastern Plaguelands.', 'The bearer of this writ is entitled to payment in the form of an insignia of their choice upon completion of the contracted work order.$B$BWork Order EN-558:$B$B14 Thorium Tubes.$B$BAll filled orders should be delivered to Packmaster Stonebruiser at Light\'s Hope Chapel in the Eastern Plaguelands.$B$BContract is null and void if tampered with or damaged.$B$B-Dispatch Commander Metz, The Argent Dawn', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54737), -- Craftsman's Writ - Thorium Tube +(8739, 2, 56, 0, 255, 0, 54, 1377, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 21167, 0, 1, 0, 0x4100, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 20801, 20809, 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, 609, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 'Hive\'Ashi Scout Report', 'Contact Cenarion Scout Jalia inside Hive\'Ashi and return the Hive\'Ashi Scout Report to Windcaller Proudhorn at Cenarion Hold. You must also bring Tactical Task Briefing VIII in order to complete this quest.', 'We\'ve sent our best scouts deep into the silithid hives to gather intelligence. Scout Jalia has been watching the silithid movements at Hive\'Ashi for several days now. Find her and obtain a written report. We need to be able to act on that information as soon as possible, $N.', '', 'Return to Windcaller Proudhorn at Cenarion Hold in Silithus.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54737), -- Hive'Ashi Scout Report +(8432, 0, 39, 0, 39, 0, 30, 3277, 41, 0, 0, 3, 1, 0, 1, 24962, 0, 0, 0, 0, 1, 0, 0x108, 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, 889, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 'Battle of Warsong Gulch', '', '', '', 'Return to Horde Warbringer.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54525), -- Battle of Warsong Gulch +(1841, 2, 30, 0, 255, 0, 20, -81, 0, 0, 1846, 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, 'Velora Nitely and the Brutal Legguards', 'Speak with Velora Nitely in the Undercity.', 'It is said that, before her death, Velora Nitely was one of the finest armorsmiths in Lordaeron. Death, it seems, has not decreased her talents. Speak with Velora--she will make your brutal legguards.$B$BVelora plies her trade in the Undercity of Lordaeron, in the trade quarter.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Velora Nitely and the Brutal Legguards +(1818, 2, -1, 0, 255, 0, 10, -81, 0, 0, 1819, 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, 'Speak with Dillinger', 'Speak with Deathguard Dillinger in Brill.', 'I was told Deathguard Dillinger has a job for someone like you. If you\'re willing to show your value to the Dark Lady\'s forces, then report to Dillinger immediately.$B$BDeathguard Dillinger\'s post is on the west end of Brill, near the graveyard.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Speak with Dillinger +(1795, 2, -1, 0, 255, 0, 30, -61, 0, 0, 0, 5, 1, 0, 1, 1373, 0, 0, 6999, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 22244, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'The Binding', 'Using the Tome of the Cabal, summon and subdue a felhunter, then return the Tome of the Cabal to Strahad Farsan in Ratchet.', 'If you are sufficiently prepared, then we should begin. Let me explain the process to you.$b$bI will begin by creating the basic summoning circle. When that is finished, my acolytes will use the rods of channeling to create the greater circle.$b$bOnce that is done, read the incantation from the Tome of the Cabal, and the felhunter will be pulled forth. Be careful, $n. A felhunter is a powerful foe, and I\'d like to see you keep your head on your shoulders.', '', 'Return to Strahad Farsan in The Barrens.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- The Binding +(1646, 2, -1, 0, 255, 0, 12, -141, 0, 0, 1647, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 'The Tome of Divinity', 'Speak to Tiza Battleforge in Ironforge.', 'In all things, a paladin must reflect the Light which supplements our strength. To strive to be divine for one of our kind does not mean we strive for godhood--we strive to be good in all actions.$B$BAlthough called upon to smite evil in these harsh times, you must always remember that it\'s aiding others that will truly set you apart from the citizens of Azeroth. Compassion, patience, bravery--these things mean as much to a paladin as strength in battle.$B$BKnow this well, and never forget it.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- The Tome of Divinity +(1527, 2, -1, 0, 255, 0, 10, -82, 0, 0, 0, 6, 1, 0, 1, 2075, 0, 0, 6654, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 5176, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Call of Fire', 'Bring the Torch of Eternal Flame to Kranal Fiss in the Barrens.', 'Torch firmly in hand, you turn away from the brazier and look out over Durotar. You feel an excitement tugging at your spirit as the wind picks up and forces the flame to dance violently.$B$BYou start off down the path back to the Barrens in search of Kranal Fiss.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Call of Fire +(1473, 2, -1, 0, 255, 0, 10, -61, 0, 0, 1471, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 'Creature of the Void', 'Recover Egalin\'s Grimoire and bring it to Carendin Halgar in the Temple of the Damned.', 'It seems the consensus that you are ready to learn to summon a voidwalker.$b$bA being created of the chaos that lies beyond, if you summon one but cannot control it, you will be torn asunder.$b$bThe first voidwalker was summoned by Egalin, and in his grimoire is the process explained.$b$bUnfortunately, it was stolen from us by an agent of the Scarlet Crusade who has it secreted away in his base at a tower to the west. Bring it to me, and I will impart the knowledge to you.', '', 'Return to Carendin Halgar in Tirisfal Glades.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Creature of the Void +(1450, 2, 43, 0, 255, 0, 38, 47, 0, 0, 1451, 2, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Gryphon Master Talonaxe', 'Speak with Gryphon Master Talonaxe inside the Aerie Peak Aviary.', 'So you\'re a glorified errand $g boy:girl; for some old Explorers\' League geezer, eh?$b$bWell you listen to me, $c. I don\'t know who your old buddy was flying around with down in Azeroth. Do I look like Gryphon Master Talonaxe to you? Do I?$b$bIf you\'re so interested in the flight assignments why don\'t you ask the gryphon master? If I catch you idling around here for much longer, I\'m going to put you to some real work.$b$bNow get a move on.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Gryphon Master Talonaxe +(1440, 2, 33, 0, 255, 0, 30, 405, 0, 0, 0, 6, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4002, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9687, 9698, 9699, 11884, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 6, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Return to Vahlarriel', 'Escort Dalinda Malem from Thunder Axe Fortress and then return to Vahlarriel Demonslayer in Desolace.', 'So, the time is now then? I appreciate your efforts, and if the situation does not lend itself, then allow me to thank you now for everything you\'ve done for me and my family. If you\'re ready, then there is nothing else for me here--we can leave when you feel the time is right.', 'Rescue Dalinda Malem', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Return to Vahlarriel +(1386, 2, 32, 0, 255, 0, 30, 405, 0, 0, 1369, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, 'Assault on the Kolkar', 'Maintain your reputation with the Magram. Kill 12 Kolkar Centaurs, 12 Kolkar Scouts and 6 Kolkar Maulers, then return to Warug in the Magram Village in Desolace.', 'The Kolkar think they are strong, but we laugh at them! We laugh and we kill them! You kill them too. Show me you can kill Kolkar like we do. Head north and slay them all!', '', 'Return to Warug at Magram Village in Desolace.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Assault on the Kolkar +(1114, 2, 36, 0, 255, 0, 30, 400, 0, 0, 0, 2, 1, 2, 1, 0, 0, 0, 5802, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Delivery to the Gnomes', 'Bring the Delicate Car Parts to Fizzle Brassbolts in Shimmering Flats.', 'Now that I have what I need, give these parts to Fizzle Brassbolts. He\'s been waiting a long time for them -- I\'m sure he won\'t miss the little piece I removed from his order...$B$BAnd I wouldn\'t bother mentioning it to him. It was small and worthless.$B$BTrust me.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Delivery to the Gnomes +(1080, 2, 22, 0, 255, 0, 17, 406, 0, 0, 0, 6, 1, 0, 1, 0, 0, 0, 5738, 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, 54, 0, 0, 0, 0, 6, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Covert Ops - Beta', 'Retrieve the Venture Co. Letters from Windshear Mine at the east end of Windshear Crag.', 'Plan Beta\'s just like Plan Alpha, $N.$B$BWe cause a distraction and then steal their precious letters.$B$BThe key is to get their letters... remember that.$B$BThe pages I gave you already will tell you where to plant the explosives. Just get back here alive and with those letters....', '', 'Return to Gaxim Rustfizzle at Webwinder Path in Stonetalon Mountains.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Covert Ops - Beta +(1079, 2, 22, 0, 255, 0, 17, 406, 0, 0, 0, 6, 1, 0, 1, 0, 0, 0, 5738, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5695, 5694, 5693, 5692, 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, 54, 0, 0, 0, 0, 6, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Covert Ops - Alpha', 'Retrieve the Venture Co.\'s Engineering Plans from the lumber mill in Windshear Crag.', 'This is it, $N. Pay close attention. The devices are done, and ready to be used.$B$BTake these pages--they\'ll explain more about the detonators and explosives, and where you should place them.$B$BRemember, the success of your mission doesn\'t depend on how much destruction you cause. Plan Alpha\'s success depends on you bringing back the Venture Co.\'s engineering plans from inside the lumber mill south of Cragpool Lake.', '', 'Return to Gaxim Rustfizzle at Webwinder Path in Stonetalon Mountains.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Covert Ops - Alpha +(1046, 2, 25, 0, 255, 0, 19, 331, 0, 0, 0, 7, 1, 7, 1, 0, 0, 0, 46781, 0, 1, 0, 0x400A, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56694, 56695, 56696, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 69, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, 'True Power of the Rod', 'Use Dartol\'s Rod and speak with Ota Wen. Convince him to rise up against his Horde oppressors.', 'Now, take the rod and while using its power, speak with my brother, Ota Wen.$B$BOta is amongst the other furbolg that the orcs have captured and have penned in the giant cage on the north side of Silverwind Refuge. The rod will allow you to convince Ota and the other furbolg to rise up and attack the Horde.$B$BThen you may go wherever your path leads you. Just know that you have found a new friend for that which you have done.', 'Furbolg uprising started.', 'Speak with Raene Wolfrunner at Astranaar in Ashenvale.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- True Power of the Rod +(925, 2, -1, 0, 255, 0, 10, -284, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 67, 0, 0, 0, 0, 4, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 946, 0, 'Cairne\'s Hoofprint', 'Travel to Thunder Bluff to see about getting Cairne Bloodhoof\'s hoofprint for your ward.', 'They say that Cairne Bloodhoof is one of the greatest heroes the Horde has ever seen. When I grow up, I wanna be a hero of the Horde too!$B$BDo you know Cairne, $N? Could you do me a favor, please? Could you get his hoofprint for me? I dunno how to ask him, and he\'d probably be too busy for someone like me... but you! You\'re an adventurer just like he is! I bet he\'d give you his hoofprint easy!$B$BPlease?', '', 'Return to Orcish Orphan.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Cairne's Hoofprint +(911, 2, -1, 0, 255, 0, 10, -284, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4002, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 67, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 946, 0, 'Gateway to the Frontier', 'Take your ward to the Mor\'shan Rampart in the northern part of the Barrens, just before entering Ashenvale.', 'They say that Ashenvale is the new frontier, and that the Mor\'shan Rampart in the Barrens is the gateway to it. That would be so cool to be a pioneer, carving everything you need out of the untamed wilds! They say that this is where the Horde and Alliance will clash the most in the future, and I want to be there $N!$B$BWould you take me to the Mor\'shan Rampart so I can see what the frontier looks like, please? I wanna see where the Horde is driving out those smelly night elves!', 'Go to the Mor\'shan Rampart in the Barrens.', 'Speak to your Orcish Orphan.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Gateway to the Frontier +(910, 2, -1, 0, 255, 0, 10, -284, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4002, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 67, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 946, 0, 'Down at the Docks', 'Take your ward to the docks of Ratchet in the Barrens.', 'I have heard tales of the mighty ships that sail between Ratchet and Booty Bay! That would be so cool to sail on the ocean and fight in many great sea battles. Maybe I will be a mighty Horde sailor when I grow up! Yeah!$B$BWould you take me to see the Ratchet docks, please? I promise I won\'t get into the water or cause any trouble - I just want to see the big boats and smell the salty sea water! Yeah!', 'Go to the docks of Ratchet in the Barrens.', 'Speak to your Orcish Orphan.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Down at the Docks +(730, 2, 14, 0, 255, 0, 14, 1657, 0, 0, 729, 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, 47, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Trouble In Darkshore?', 'Travel to Auberdine and look for signs of the dwarven excavation team.', 'How nice it is to see a $c interested in the great archeological wonders of our world.$b$bOftentimes our work is dismissed as mere hobby by our friends in the Alliance. But what many fail to realize is that recent discoveries in Khaz Modan have proven that a great and powerful force threatens all of Azeroth, from Lordaeron to Kalimdor.$b$bI am most worried about my crew that I sent to Darkshore. They haven\'t sent word in weeks.$b$bTravel to Auberdine and look for a clue as to their whereabouts.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Trouble In Darkshore? +(728, 2, 40, 0, 255, 0, 30, 3, 0, 0, 736, 2, 1, 0, 1, 0, 0, 0, 4648, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 946, 0, 'To the Undercity for Yagyin\'s Digest', 'Bring the Sigil of the Hammer to Keeper Bel\'dugur in the Undercity.', 'The tablet tells much. But not enough! Not nearly enough!$B$BThere is a book, a digest that Yagyin wrote in ages past. The... people I fled from... they keep this book in many places. And their most learned study it. It holds vast knowledge. Knowledge to protect us!$B$BGo to Keeper Bel\'dugur in the Undercity of Lordaeron. Show him this sigil and he\'ll think you one of them. Ask him for Yagin\'s Digest...and bring it to me!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- To the Undercity for Yagyin's Digest +(723, 2, 40, 0, 255, 0, 35, 3, 0, 0, 724, 4, 1, 0, 1, 0, 0, 0, 4635, 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, 47, 0, 0, 0, 0, 4, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Prospect of Faith', 'Take Hammertoe\'s Amulet to Prospector Ryedol in the Badlands.', '$B$BFind Ryedol, $N. Bring \'im me amulet. He\'ll... figure out what to do. He knows I was seeking the origins of our people, and he... ... knows it was also my mission to stop the Shadowforge clan. They must not be allowed to find the scrolls... ', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- Prospect of Faith +(700, 2, 31, 0, 255, 0, 25, 1537, 0, 0, 0, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0x4008, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 4535, 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, 47, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'A King\'s Tribute', 'Report to King Magni Bronzebeard.', 'Ah, such fine stone comes from Lordaeron. Such a shame the land is in such shambles.$b$bBut the Memorial came out quite well! I should think the King will be most pleased with it.$b$bNow if you will, please send word to His Majesty that the Memorial is complete as requested. ', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- A King's Tribute +(686, 2, 30, 0, 255, 0, 25, 1537, 0, 0, 689, 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, 47, 0, 0, 0, 0, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'A King\'s Tribute', 'King Magni Bronzebeard wants you to speak with Grand Mason Marblesten.', 'I do not expect good dwarves like Mrs. Balloo to understand why the travesties of war must be endured for the greater good of our people. The loss of her husband, and the loss of every dwarf that fights in the name of the Alliance, weighs heavy on my soul.$b$bWhile I cannot bring her husband back from the Twisting Nether, I can pay tribute to him.$b$bI am going to commission a memorial to Sully Balloo to be built by Grand Mason Marblesten.$b$bSend word to him now, $c. You shall be custodian of my bidding.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- A King's Tribute +(522, 2, 38, 0, 255, 0, 30, 36, 0, 0, 523, 2, 1, 0, 1, 0, 0, 0, 3668, 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, 72, 0, 0, 0, 0, 2, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, '[DEPRECATED] Assassin\'s Contract', 'Bring the Assassin\'s Contract to Magistrate Maleb in Southshore.', 'This is a contract for the assassination of Magistrate Henry Maleb. It was sealed and stamped in red wax, using a distinctive signet ring.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- [DEPRECATED] Assassin's Contract +(521, 2, 43, 0, 255, 0, 34, 267, 0, 0, 0, 5, 1, 0, 1, 0, 0, 0, 3554, 0, 1, 0, 0x4000, 0x0, 0x0, 0, 0, 0, 0, 0, 0, 4430, 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, 68, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, '[DEPRECATED] The Crown of Will', 'Deliver the Crown of Will to Sharlindra in the Undercity.', 'All that remains is to deliver the Crown of Will to Sharlindra in the Undercity. She will see that it is delivered to Lady Sylvanas. I would warn you against thinking to use it for your own purposes, $n, Mug\'Thol\'s fate should be illustration enough.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481), -- [DEPRECATED] The Crown of Will +(268, 2, 25, 0, 255, 0, 20, 10, 0, 0, 323, 2, 1, 0, 1, 0, 0, 0, 2560, 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, 72, 0, 0, 0, 0, 2, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 'Return to Sven', 'Return to Sven with Jitters\' completed journal.', 'The book you found was only half finished. I had to leave it at Sven\'s farm when I fled there...$B$BHere. Take my completed journal to Sven. It describes more fully what happened at his farm.$B$BAlthough this journal has been my only company these past weeks, if giving it up keeps me from having to face Sven and his wrath, then I do it willingly!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 54481); -- Return to Sven + +DELETE FROM `quest_objectives` WHERE `ID` IN (381789 /*381789*/, 381788 /*381788*/, 381787 /*381787*/, 381786 /*381786*/, 384199 /*384199*/, 384753 /*384753*/, 384343 /*384343*/, 384342 /*384342*/, 384419 /*384419*/, 384418 /*384418*/, 384200 /*384200*/, 381776 /*381776*/, 381775 /*381775*/, 381820 /*381820*/, 381612 /*381612*/, 381577 /*381577*/, 381576 /*381576*/, 381575 /*381575*/, 381574 /*381574*/, 381483 /*381483*/, 380924 /*380924*/, 381211 /*381211*/, 380495 /*380495*/, 385500 /*385500*/, 385501 /*385501*/, 380836 /*380836*/, 380647 /*380647*/, 380436 /*380436*/, 380420 /*380420*/, 380384 /*380384*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(381789, 5146, 1, 3, 3, 7081, 2, 0, 0, 0, '', 55006), -- 381789 +(381788, 5146, 1, 2, 2, 7075, 2, 0, 0, 0, '', 55006), -- 381788 +(381787, 5146, 1, 1, 1, 7079, 2, 0, 0, 0, '', 55006), -- 381787 +(381786, 5146, 1, 0, 0, 7077, 2, 0, 0, 0, '', 55006), -- 381786 +(384199, 8431, 4, 0, 0, 1901, 892, 0, 0, 0, '', 54558), -- 384199 +(384753, 8434, 4, 0, 0, 1901, 892, 0, 0, 0, '', 54558), -- 384753 +(384343, 9198, 1, 1, 1, 16000, 14, 0, 0, 0, '', 54737), -- 384343 +(384342, 9198, 1, 0, 0, 22616, 1, 0, 0, 0, '', 54737), -- 384342 +(384419, 8739, 1, 1, 1, 21167, 1, 0, 0, 0, '', 54737), -- 384419 +(384418, 8739, 1, 0, 0, 21161, 1, 0, 0, 0, '', 54737), -- 384418 +(384200, 8432, 4, 0, 0, 1901, 892, 0, 0, 0, '', 54525), -- 384200 +(381776, 1795, 1, 1, 1, 6999, 1, 0, 1, 0, '', 54481), -- 381776 +(381775, 1795, 0, 0, 0, 6268, 1, 0, 0, 0, '', 54481), -- 381775 +(381820, 1527, 1, 0, 0, 6654, 1, 0, 1, 0, '', 54481), -- 381820 +(381612, 1473, 1, 0, 0, 6285, 1, 0, 1, 0, '', 54481), -- 381612 +(381577, 1386, 6, 3, 3, 93, 3000, 0, 0, 0, '', 54481), -- 381577 +(381576, 1386, 0, 2, 2, 4634, 6, 0, 0, 0, '', 54481), -- 381576 +(381575, 1386, 0, 1, 1, 4633, 12, 0, 0, 0, '', 54481), -- 381575 +(381574, 1386, 0, 0, 0, 4632, 12, 0, 0, 0, '', 54481), -- 381574 +(381483, 1114, 1, 0, 0, 5802, 1, 0, 1, 0, '', 54481), -- 381483 +(380924, 1080, 1, 0, 0, 5717, 1, 0, 1, 0, '', 54481), -- 380924 +(381211, 1079, 1, 0, 0, 5718, 1, 0, 1, 0, '', 54481), -- 381211 +(380495, 925, 1, 0, 0, 18643, 1, 0, 1, 0, '', 54481), -- 380495 +(385500, 911, 10, 0, 0, 3549, 1, 0, 0, 0, '', 54481), -- 385500 +(385501, 910, 10, 0, 0, 3550, 1, 0, 0, 0, '', 54481), -- 385501 +(380836, 728, 1, 0, 0, 4648, 1, 0, 1, 0, '', 54481), -- 380836 +(380647, 723, 1, 0, 0, 4635, 1, 0, 1, 0, '', 54481), -- 380647 +(380436, 522, 1, 0, 0, 3668, 1, 0, 0, 0, '', 54481), -- 380436 +(380420, 521, 1, 0, 0, 3554, 1, 0, 1, 0, '', 54481), -- 380420 +(380384, 268, 1, 0, 0, 2560, 1, 0, 1, 0, '', 54481); -- 380384 + +DELETE FROM `quest_reward_display_spell` WHERE (`Idx`=0 AND `QuestID` IN (1795,1527)); +INSERT INTO `quest_reward_display_spell` (`QuestID`, `Idx`, `SpellID`, `VerifiedBuild`) VALUES +(1795, 0, 691, 54481), +(1527, 0, 3599, 54481); -- cgit v1.2.3