diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2024_10_27_03_world.sql | 83 |
1 files changed, 83 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_10_27_03_world.sql b/sql/updates/world/cata_classic/2024_10_27_03_world.sql new file mode 100644 index 00000000000..2f37f01959c --- /dev/null +++ b/sql/updates/world/cata_classic/2024_10_27_03_world.sql @@ -0,0 +1,83 @@ +UPDATE `quest_poi` SET `VerifiedBuild`=57244 WHERE (`QuestID`=14138 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14449 AND `BlobIndex`=0 AND `Idx1`=0); + +UPDATE `quest_poi_points` SET `VerifiedBuild`=57244 WHERE (`QuestID`=14138 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14449 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_template` WHERE `ID` IN (24638 /*Crushing the Crown*/, 11321 /*Did Someone Say "Souvenir?"*/, 11140 /*[DEPRECATED]Recover the Cargo!*/, 10891 /*Imperial Plate Armor*/, 9465 /*Call of Fire*/, 9448 /*[DEPRECATED]Mercy for the Cursed*/, 9269 /*Atiesh, Greatstaff of the Guardian*/, 9111 /*Robe of Faith*/, 8907 /*An Earnest Proposition*/, 6604 /*Enraged Wildkin*/, 5931 /*Back to Darnassus*/, 5651 /*In Favor of Darkness*/, 5514 /*Mold Rhymes With...*/, 5465 /*Soulbound Keepsake*/, 5235 /*Target: Gahrron's Withering*/, 4904 /*Free at Last*/, 2998 /*Tome of Divinity*/, 1778 /*The Tome of Divinity*/, 1421 /*[DEPRECATED]The Lost Caravan*/, 1186 /*The Eighteenth Pilot*/, 1181 /*Goblin Sponsorship*/, 994 /*Escape Through Force*/, 660 /*Hints of a New Plague?*/, 417 /*A Pilot's Revenge*/, 407 /*Fields of Grief*/, 346 /*Return to Kristoff*/, 292 /*The Eye of Paleth*/, 32 /*Rise of the Silithid*/, 26 /*A Lesson to Learn*/); +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`, `TreasurePickerID`, `Expansion`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(24638, 2, -1, 0, 255, 0, 5, -376, 0, 0, 0, 5, 1, 5, 1, 0, 0, 0, 50130, 0, 1, 0, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 49927, 0, 0, 0, 5, 0, 0, 0, 50130, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, 'Crushing the Crown', 'Kill 5 Crown Lackeys and use Snagglebolt\'s Khorium Bomb to damage one Chemical Wagon just west of Orgrimmar\'s gates in Durotar, then return to Detective Snap Snagglebolt in Orgrimmar.', 'This ledger is full of locations, and I need you to investigate and take action, pal. This has gone on long enough.$b$bHere\'s an entry I want you to check out: it\'s right outside Orgrimmar\'s gates, to the west! That can\'t be good. Get out there and rough \'em up.$b$bOh, and if you see something big and dangerous enough that it needs destroying, toss this bomb at it.', '', 'Return to Detective Snap Snagglebolt in Orgrimmar\'s Valley of Strength.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Crushing the Crown +(11321, 2, -1, 0, 255, 0, 1, -370, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 33955, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 32912, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, 0, 'Did Someone Say \"Souvenir?\"', 'Redeem the Brewfest Stein Voucher with Belbi Quikswitch in the Brewfest camp.', 'Brewfest isn\'t just about racing rams, it\'s also about drinking! When you have a moment, take this voucher to Belbi Quikswitch. She\'s near the back of the Brewfest camp. If you can\'t see her, don\'t worry, she\'ll be sure to see you.$b$bIn any case, take this voucher to her to get your free Brewfest stein. She\'ll also be more than happy to handle any and all other Brewfest transactions.', '', 'Return to Belbi Quikswitch in Dun Morogh.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Did Someone Say "Souvenir?" +(11140, 2, 37, 0, 255, 0, 32, 15, 0, 0, 0, 5, 1, 5, 1, 0, 0, 0, 33045, 0, 1, 0, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 33040, 0, 0, 0, 1, 0, 0, 33267, 33259, 0, 0, 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, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, 0, '[DEPRECATED]Recover the Cargo!', 'Bring 6 Salvaged Strongboxes to Renn McGill in Dustwallow Marsh.', 'Well, I was able to make enough repairs to this gear to let you dive for awhile, anyway. I wouldn\'t count on it holding out for a long time, though.$B$BThe wreckage of the ship is strewn along the bottom from the east coast of this island out toward Alcaz Island. While that helm holds out, locate pieces of the wreckage on the bottom between this island and Alcaz. Use this salvage kit to search the wreckage for pieces of the cargo. Be careful not to venture too close to Alcaz Island. Those hydra are fierce.', '', 'Return to Renn McGill at Dreadmurk Shore in Dustwallow Marsh.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- [DEPRECATED]Recover the Cargo! +(10891, 2, 50, 0, 255, 0, 50, -121, 0, 0, 0, 4, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Imperial Plate Armor', 'Speak with Derotain Mudsipper at Gadgetzan in Tanaris.\n', 'There\'s a dwarf in Gadgetzan by the name of Derotain Mudsipper who\'ll teach you how to make imperial plate armor. All you gotta do is get to the Tanaris desert and find him. Interested?', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Imperial Plate Armor +(9465, 2, -1, 0, 255, 0, 10, -82, 0, 0, 9467, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16520, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1024, 0, 1, 'Call of Fire', 'Retrieve the Ritual Torch and return it to Temper at Emberglade on Azuremyst Isle.', 'One of my brethren, Hauteur, has gone insane, no doubt because of the crash of your ship. He\'s begun demanding that the local owlbeasts worship him.$B$BThis will not continue! None of us would ever impersonate a god! It falls to you to restore the balance.$B$BFirst, you must retrieve their ritual torch, which has been taken by the crazed wildkin inside Stillpine Hold to the west.$B$BReturn the torch to me.', '', 'Return to Temper at Emberglade in Azuremyst Isle.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Call of Fire +(9448, 2, 38, 0, 255, 0, 35, 8, 0, 0, 0, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 930, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, 0, '[DEPRECATED]Mercy for the Cursed', 'Slay 3 Cursed Lost Ones and then return to Anchorite Avuun at the Harborage in the Swamp of Sorrows.', 'That blood elf witch, Cersei Dusksinger, has been cursing the Lost Ones, I just know it! I don\'t know why or how, but the results are tragic. Several of the Lost Ones have now been further corrupted - cursed with even more fel energies!$B$B$C, can you find it in you to take pity on these poor creatures? They should not have to live out the rest of their lives in such a horrible condition.$B$BYou\'ll find these cursed Lost Ones at the Fallow Sanctuary, east down the path.', '', 'Return to Anchorite Avuun in Swamp of Sorrows.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- [DEPRECATED]Mercy for the Cursed +(9269, 2, 60, 0, 255, 0, 60, -344, 81, 0, 0, 7, 1, 0, 1, 0, 0, 0, 22737, 0, 1, 0, 8388608, 0, 0, 0, 0, 0, 0, 0, 0, 22632, 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, 910, 529, 0, 0, 0, 7, 7, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 3, 0, 0, 18446744073709551615, 0, 0, 'Atiesh, Greatstaff of the Guardian', 'Anachronos at the Caverns of Time in Tanaris wants you to take Atiesh, Greatstaff of the Guardian to Stratholme and use it on Consecrated Earth. Defeat the entity that is exorcised from the staff and return to him.', 'This final task will be the most difficult of all, $N. You have faced and defeated both an Old God and the Lich King\'s General, but now you must face the hand of Sargeras.$B$BTake the staff to Stratholme. It is there that you will find a piece of consecrated earth: ground where the greatest knights of Lordaeron were murdered. Place the befouled staff upon the holy ground and prepare for an entity of immense power to break from within... Defeat the demonic being that controls the staff and return to me.', '', 'Return to Anachronos at Caverns of Time in Tanaris.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Atiesh, Greatstaff of the Guardian +(9111, 2, 60, 0, 255, 0, 60, 3456, 62, 0, 0, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16448, 0, 0, 0, 0, 0, 0, 0, 0, 22512, 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, 529, 0, 0, 0, 0, 7, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 0, 'Robe of Faith', 'Father Inigo Montoy at Light\'s Hope Chapel in the Eastern Plaguelands will make a Robe of Faith if you bring him the following: 1 Desecrated Robe, 25 Wartorn Cloth Scraps, 4 Mooncloth and 2 Nexus Crystals.', '<Father Montoy makes some strange gestures in the air in front of you.>$B$BBlessed $g boy:girl;, have you found the vestments of the fallen? The poor souls whose last breaths were taken on the field of battle - stripped of everything including their dignity.$B$BBring me the desecrated remnants of the departed along with reagents of purification and you shall know faith.', '', 'Return to Father Inigo Montoy at Light\'s Hope Chapel in Eastern Plaguelands.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Robe of Faith +(8907, 2, 60, 0, 255, 0, 58, 1537, 81, 0, 0, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16648, 0, 0, 0, 0, 0, 0, 0, 0, 22063, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2098253, 0, 0, 'An Earnest Proposition', 'Acquire 15 Winterspring Blood Samples and 20 gold and bring them along with a set of Magister\'s Bindings to Deliana in Ironforge.', 'Well met, $c. I\'ve something that might interest you.$B$BI have in my possession a set of armor much like the one worn by those of your profession, but of much higher quality. I\'d be willing to trade the bracers for ordinary ones in exchange for a small favor.$B$BThe blood of the frostsabers and bears that inhabit Winterspring has properties I\'m in need of at the moment. Bring me a sizeable sample of it along with the bracers and a small amount of gold. You shall find the effort worth your while.', '', 'Return to Deliana at the High Seat in Ironforge.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- An Earnest Proposition +(6604, 2, 59, 0, 255, 0, 53, 618, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'Enraged Wildkin', 'Speak with Jaron Stoneshaper at Starfall Village.', 'Have you noticed the abandoned camp to the south of here? It looks like the wildkin went crazy and destroyed just about everything they could find!$B$BI heard a rumor that one of the survivors of the attack is resting at Starfall Village, west of here. I\'m sure curious about what happened... aren\'t you?', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Enraged Wildkin +(5931, 2, -1, 0, 255, 0, 10, -263, 0, 0, 6001, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 8, 0, 0, 'Back to Darnassus', 'Return to Darnassus and speak with Mathrengyl Bearwalker in the Cenarion Enclave.', 'The time has come for us to part ways, young one, as the application of your lessons takes you back to whom that sent you to me. Mathrengyl Bearwalker walks truly in balance with nature, even as he dwells precariously close to where the balance has faltered. Listen to his instructions, and you will soon complete your first lessons into your role as a protector of balance.$B$BGo now, young one. We shall meet again.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Back to Darnassus +(5651, 2, 4, 0, 255, 0, 5, -262, 0, 0, 5650, 2, 1, 2, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 'In Favor of Darkness', 'Speak to Dark Cleric Beryl in Tirisfal Glades.', 'There are many lessons that the Forsaken have learned through experience--things that some races can only begin to fathom. And although our path lies in darkness, you will find that a great many things rely on both the light and the dark. Your lessons shall teach you to use both... and with discretion. But heed my words: never forget we were forged in corruption and left to rot like so much carrion. The Darkness is our home.$B$BSeek out Dark Cleric Beryl in Brill when you\'re ready to learn more.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- In Favor of Darkness +(5514, 2, 57, 0, 255, 0, 55, 28, 0, 0, 5802, 1, 1, 0, 1, 0, 0, 0, 14628, 0, 1, 0, 16640, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Mold Rhymes With...', 'Bring the Imbued Skeletal Fragments and 15 gold coins to Krinkle Goodsteel in Gadgetzan.', 'The goblin you will need to speak with is Krinkle Goodsteel. He peddles his skills to the highest bidder in Gadgetzan, within the Tanaris desert. He\'ll likely be the only one who can produce the mold we need, and his services won\'t come cheap. We now ask for you to dig deep by footing whatever fee he will charge.$B$BI\'m an apothecary, not a banker. If I had gold lying around, I certainly wouldn\'t be here.$B$BI guess I said the quiet part out loud again. Oops.$B$BGadgetzan awaits you! Good luck!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Mold Rhymes With... +(5465, 2, 60, 0, 255, 0, 57, 28, 1, 0, 5466, 4, 1, 0, 1, 0, 0, 0, 13624, 0, 1, 0, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Soulbound Keepsake', 'Return to Magistrate Marduke in Caer Darrow. Show him the Soulbound Keepsake.', 'Return to Marduke with the keepsake, $N. He will instruct you in its use.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Soulbound Keepsake +(5235, 2, 58, 0, 255, 0, 50, 28, 0, 0, 5236, 5, 1, 0, 1, 0, 0, 0, 13189, 0, 1, 0, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 529, 0, 0, 0, 5, 5, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, 'Target: Gahrron\'s Withering', 'Go to Gahrron\'s Withering in Western Plaguelands to locate and defeat the Cauldron Lord present there, and use its key to gain access to the cauldron. You must have the Empty Gahrron\'s Withering Bottle with you to secure a sample of the poisons used inside the cauldron.', 'The last cauldron that remains is located on a farm now called Gahrron\'s Withering. It is guarded by some of the Scourge\'s tougher minions - specifically, wraiths and ghosts. They are not to be trifled with, $N.$B$BGahrron\'s Withering is far to the east of the Bulwark, close to where the Eastern Plaguelands begin; again, eliminate the cauldron lord present there for its key. Here is your empty sample bottle; bring it to me filled. May the shadows cloak you in safety for this dangerous mission, $c.', '', 'Unlock the Scourge Cauldron at Gahrron\'s Withering in Western Plaguelands.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Target: Gahrron's Withering +(4904, 2, 29, 0, 255, 0, 25, 400, 0, 0, 0, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16386, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15469, 15468, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 81, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, 'Free at Last', 'Escort Lakota Windsong from the Darkcloud Pinnacle, and then talk to Thalia Amberhide at Freewind Post.', 'Arnak thinks we\'re going to be married... but after I declined his offer he came back that night and kidnapped me. My brother tried to stop him, but Arnak was too strong. He... he slew my brother and then brought me here. My poor brother...$B$B$N, could you escort me out of the Darkcloud Pinnacle? Please... I need to get back to Thalia! She must be worried sick about me.', 'Escort Lakota Windsong from the Darkcloud Pinnacle.', 'Return to Thalia Amberhide at Freewind Post in Thousand Needles.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Free at Last +(2998, 2, -1, 0, 255, 0, 12, -141, 0, 0, 0, 2, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 1, 0, 0, 'Tome of Divinity', 'Speak to Duthorian Rall in Stormwind.', 'Greetings, $Gbrother:sister;. Duthorian Rall, one of our most influential paladins, was speaking about you recently. I overheard him talking about how it was time you be put to the test some... along with some very complimentary things about how well you\'ve performed thus far.$B$BIf I were you, I\'d head to Stormwind and speak to him when you have time. I\'m sure he\'s in the Cathedral of Light--that\'s where he spends most of his time.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Tome of Divinity +(1778, 2, -1, 0, 255, 0, 12, -141, 0, 0, 1779, 2, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0, 'The Tome of Divinity', 'Speak to Tiza Battleforge in Ironforge.', 'I\'m going to see about making plans to return home soon. Hopefully, Stephanie is doing well back in Stormwind. I can\'t wait to see her again. Till next we meet, $c.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- The Tome of Divinity +(1421, 2, 35, 0, 255, 0, 30, 8, 0, 0, 1398, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, '[DEPRECATED]The Lost Caravan', 'Find the Caravan Chest in the Fallow Sanctuary, obtain the Wizards\' Reagents and bring to Watcher Biggs.', 'I was stunned during the attack by the Lost Ones, but before my sight went black I spied one of our wagons being dragged to the Fallow Sanctuary, the lost one village to the north.$B$BA caravan chest with valuable reagents was in that wagon, reagents vital to the studies of the wizards of Nethergarde Keep. Find the chest and get those reagents, $N. Get them and bring them to me.', '', 'Return to Watcher Biggs in Swamp of Sorrows.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- [DEPRECATED]The Lost Caravan +(1186, 2, 37, 0, 255, 0, 29, 400, 0, 0, 1187, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'The Eighteenth Pilot', 'Speak with Razzeric on the Shimmering Flats in Thousand Needles.', 'I\'m going to be busy with working on integrating this new fuel regulator to our racer designs, but if you\'d like to help out the team some more, talk to Razzeric. He\'s our pilot--well, our eighteenth pilot, to be exact--and he likes to add his own little modifications to the racers.$b$bHe\'s a little off his rocker, though, so try not to act too surprised.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- The Eighteenth Pilot +(1181, 2, 37, 0, 255, 0, 29, 400, 0, 0, 1182, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 'Goblin Sponsorship', 'Speak with Baron Revilgaz in Booty Bay.', 'I\'m afraid I can\'t be of much more help to you, $n. If you\'d like to follow up on it more, I\'d suggest you go hit up the Baron himself. If there\'s anyone who knows Revilgaz\'s business, it\'s Revilgaz.$b$bYou\'ll find him at the tavern across the harbor, top floor.', '', 'Speak with Baron Revilgaz at Booty Bay in Stranglethorn Vale.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Goblin Sponsorship +(994, 2, 22, 0, 255, 0, 10, 148, 0, 0, 0, 5, 1, 5, 1, 0, 0, 0, 0, 0, 1, 0, 16386, 0, 0, 0, 0, 0, 0, 0, 0, 5609, 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, 69, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, 'Escape Through Force', 'Protect Volcor until you reach the road, then speak to Terenthis in Auberdine.', 'All right, $N, force it is. Let\'s get out of here as soon as you\'re ready. We\'ll fight our way down to the road--Grimclaw should still be there. Once there, we can part ways.$B$BTerenthis will want to hear your version of the story immediately, so head to Auberdine after we make it out of here.', 'Help Volcor to the road', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Escape Through Force +(660, 2, 37, 0, 255, 0, 30, 267, 0, 0, 661, 5, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16386, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, 'Hints of a New Plague?', 'Protect Kinelory until she returns to Quae.', 'All right, $N. I\'m ready if you are.$B$BShall we?', 'Protect Kinelory', 'Return to Quae in Arathi Highlands.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Hints of a New Plague? +(417, 2, 10, 0, 255, 0, 8, 1, 0, 0, 0, 5, 1, 0, 1, 0, 0, 0, 3117, 0, 1, 0, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 57560, 57566, 57562, 57563, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 47, 54, 0, 0, 0, 4, 4, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 3, 0, 0, 18446744073709551615, 0, 0, 'A Pilot\'s Revenge', 'Kill Mangeclaw.$B$BBring his Mangy Claw and Hildelve\'s Journal to Pilot Hammerfoot at the South Gate Outpost.', 'Hildelve wrote in his journal that he was attacked by Mangeclaw, a \"huge Ice Claw Bear.\" He drove off the beast, but not before it mauled him savagely.$B$BJudging from the state of Hildelve\'s body, Mangeclaw must have later returned and killed him.$B$BHowever, Hildelve wrote in his journal his one, final wish:$B$BRevenge against Mangeclaw.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- A Pilot's Revenge +(407, 2, 7, 0, 255, 0, 4, 85, 0, 0, 0, 2, 1, 0, 1, 0, 0, 0, 3035, 0, 1, 0, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 2, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 18446744073709551615, 0, 0, 'Fields of Grief', 'Take the Laced Pumpkin to the Captured Scarlet Zealot who is being held in the cellar of the Gallow\'s End Tavern.', 'Harmless pumpkins, right? Or so it would seem. If we are to defeat Arthas\'s advances from the North and the Human infestation from the South we need to start realizing the full potential of our gift of undeath.$b$bWith a little ingenuity a simple pumpkin becomes an agent for our Dark Lady. This pumpkin, laced with my latest formula, will prove to be quite a treat.$b$bYet another Scarlet Zealot has been captured and is being kept in the cellar of the Gallow\'s End Tavern. Take this pumpkin to the fool.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Fields of Grief +(346, 2, 24, 0, 255, 0, 20, 1519, 0, 0, 0, 5, 1, 0, 1, 0, 0, 0, 2795, 0, 1, 0, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 6095, 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, 72, 0, 0, 0, 0, 5, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, 'Return to Kristoff', 'Return to Brother Kristoff in the Cathedral Square. Give him the book The Stresses of Iron.', 'Now that I\'ve finished copying the book, here\'s the original Stresses of Iron. Thank you for your patience, and if you see Milton please tell him I\'m sorry for the long delay.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Return to Kristoff +(292, 2, 30, 0, 255, 0, 22, 11, 0, 0, 293, 3, 1, 0, 1, 0, 0, 0, 2944, 0, 1, 0, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 3, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, 'The Eye of Paleth', 'Bring the Cursed Eye of Paleth to Glorin Steelbrow at Menethil Harbor in Wetlands.', 'Opening the chest reveals a blackened orb, pulsing with an eerie light. It is the treasure of which Fitzsimmons spoke: a Cursed Eye of Paleth.$B$BTake the Cursed Eye of Paleth to the dwarven priest Glorin Steelbrow, in Menethil Harbor. Ask him how to remove the Eye\'s curse.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- The Eye of Paleth +(32, 2, 48, 0, 255, 0, 39, 440, 0, 0, 0, 6, 1, 0, 1, 0, 0, 0, 8594, 0, 1, 0, 16384, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 369, 67, 0, 0, 0, 6, 6, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 946, 0, 0, 'Rise of the Silithid', 'Take the report to Zilzibin Drumlore in Orgrimmar.', 'Here\'s your report. I urge you to take it to someone who might have working knowledge in this kind of thing.$B$BI know this troll scholar named Zilzibin Drumlore. He\'s spent a lot of time studying life forms that are unique to the ecology of Azeroth; he\'s a historian to boot! If you want someone to help figure out what exactly this threat is and how to stop it, give this report to him. We\'re going to need all the help we can get.$B$BZil lives in a house on the second tier of the Drag in Orgrimmar.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- Rise of the Silithid +(26, 2, -1, 0, 255, 0, 16, -263, 0, 0, 29, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 16392, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 8, 0, 0, 'A Lesson to Learn', 'Speak with Dendrite Starblaze in the village of Nighthaven, Moonglade.', '$N, I have been following your progress with much delight. You are most assuredly developing yourself into a valued protector of nature.$B$BThe time has come for you to learn more about one of the various animal aspects that Cenarius has blessed us with the ability to change into - one that affords you command and mastery of the water. For this, you must travel to the village of Nighthaven in Moonglade and speak with Dendrite Starblaze of the Cenarion Circle there. He will guide you further.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244); -- A Lesson to Learn + +UPDATE `quest_template` SET `VerifiedBuild`=57244 WHERE `ID` IN (82982, 64035, 64034, 63770, 29394, 27846, 27841, 25571, 24878, 24875, 24874, 24801, 24800, 24795, 24660, 24594, 24564, 24563, 24562, 24446, 14174, 14111, 14089, 14043, 14035, 13478, 13404, 13380, 13371, 13347, 13317, 13254, 13253, 13248, 13245, 13196, 13195, 13004, 12918, 12808, 12788, 12786, 12777, 12594, 12591, 12588, 11953, 11917, 11542, 11520, 11192, 11191, 10968, 10966, 10962, 10956, 10490, 10366, 10283, 9876, 9764, 9715, 9690, 9664, 9633, 9587, 9534, 9532, 9526, 9522, 9521, 9504, 9464, 9444, 9441, 9425, 9287, 9270, 9257, 9223, 9189, 9131, 9128, 9126, 9124, 9052, 8755, 8735, 8731, 8574, 8573, 8572, 8548, 8510, 8464, 8460, 8424, 8418, 8417, 8415, 8414, 8410, 8373, 8316, 8299, 8297, 8294, 8291, 8253, 8231, 8147, 8113, 8107, 8103, 8071, 8043, 7842, 7733, 7703, 7667, 7641, 7639, 7636, 7630, 7563, 7503, 7499, 7498, 7494, 7492, 7488, 7482, 7321, 7068, 6822, 6821, 6804, 6762, 6681, 6629, 6502, 6461, 6285, 6284, 6281, 6187, 6164, 6123, 6122, 6041, 6022, 6021, 6004, 6001, 5961, 5803, 5781, 5725, 5724, 5647, 5641, 5640, 5639, 5638, 5637, 5636, 5635, 5526, 5441, 5344, 5321, 5284, 5283, 5261, 5250, 5246, 5242, 5233, 5222, 5216, 5210, 5167, 5166, 5157, 5152, 5142, 5097, 5092, 5087, 5084, 5082, 5054, 5047, 5023, 4986, 4976, 4972, 4971, 4901, 4861, 4809, 4808, 4788, 4787, 4768, 4763, 4761, 4510, 4492, 4450, 4421, 4402, 4300, 4288, 4287, 4286, 4285, 4267, 4263, 4243, 4182, 4161, 4145, 4143, 4142, 4126, 4102, 4101, 3783, 3568, 3528, 3510, 3505, 3501, 3452, 3442, 3378, 3161, 3121, 3063, 3062, 3002, 2991, 2976, 2972, 2944, 2939, 2931, 2925, 2882, 2862, 2822, 2769, 2745, 2603, 2519, 2479, 2359, 2358, 2339, 2241, 2238, 2198, 2160, 2118, 2098, 2058, 1961, 1951, 1949, 1948, 1945, 1938, 1920, 1885, 1860, 1787, 1783, 1712, 1702, 1699, 1686, 1667, 1658, 1653, 1638, 1536, 1525, 1477, 1475, 1448, 1445, 1435, 1429, 1389, 1383, 1373, 1367, 1365, 1274, 1264, 1243, 1241, 1218, 1206, 1178, 1167, 1148, 1145, 1142, 1124, 1117, 1108, 1101, 1094, 1093, 1092, 1059, 1040, 1038, 1032, 1015, 1004, 1003, 995, 974, 966, 964, 943, 902, 884, 854, 830, 828, 792, 771, 766, 748, 707, 677, 672, 671, 643, 634, 633, 628, 625, 603, 601, 597, 591, 573, 571, 555, 536, 529, 523, 503, 474, 469, 440, 438, 434, 430, 429, 423, 420, 408, 404, 396, 393, 385, 382, 375, 371, 364, 363, 306, 293, 290, 288, 275, 272, 269, 262, 231, 225, 219, 211, 198, 179, 177, 175, 162, 158, 154, 153, 148, 146, 134, 105, 78, 74, 63, 39, 36, 7); +UPDATE `quest_template` SET `RewardArenaPoints`=0 WHERE `ID`=12493; + +DELETE FROM `quest_objectives` WHERE `ID` IN (426412 /*426412*/, 426411 /*426411*/, 411016 /*411016*/, 410902 /*410902*/, 410901 /*410901*/, 411506 /*411506*/, 411455 /*411455*/, 384865 /*384865*/, 384864 /*384864*/, 383061 /*383061*/, 383060 /*383060*/, 383059 /*383059*/, 383058 /*383058*/, 390873 /*390873*/, 382184 /*382184*/, 382183 /*382183*/, 390902 /*390902*/, 382835 /*382835*/, 382037 /*382037*/, 382491 /*382491*/, 382490 /*382490*/, 381722 /*381722*/, 381554 /*381554*/, 381553 /*381553*/, 380343 /*380343*/, 380198 /*380198*/, 381250 /*381250*/, 379958 /*379958*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(426412, 24638, 0, 1, 1, 37214, 5, 0, 0, 0, '', 57244), -- 426412 +(426411, 24638, 0, 0, 0, 38035, 1, 0, 0, 0, 'Chemical Wagon Destroyed', 57244), -- 426411 +(411016, 11321, 1, 0, 0, 33955, 1, 0, 1, 0, '', 57244), -- 411016 +(410902, 11140, 1, 1, 1, 33044, 1, 0, 1, 0, '', 57244), -- 410902 +(410901, 11140, 1, 0, 0, 33041, 6, 0, 1, 0, '', 57244), -- 410901 +(411506, 9465, 1, 0, 0, 23733, 1, 0, 1, 0, '', 57244), -- 411506 +(411455, 9448, 0, 0, 0, 17115, 3, 0, 0, 0, '', 57244), -- 411455 +(384865, 9269, 1, 1, 1, 22737, 1, 0, 0, 0, '', 57244), -- 384865 +(384864, 9269, 0, 0, 0, 16387, 1, 0, 0, 0, 'Atiesh Cleansed', 57244), -- 384864 +(383061, 9111, 1, 3, 3, 20725, 2, 0, 0, 0, '', 57244), -- 383061 +(383060, 9111, 1, 2, 2, 14342, 4, 0, 0, 0, '', 57244), -- 383060 +(383059, 9111, 1, 1, 1, 22376, 25, 0, 0, 0, '', 57244), -- 383059 +(383058, 9111, 1, 0, 0, 22351, 1, 0, 0, 0, '', 57244), -- 383058 +(390873, 8907, 8, 2, 2, 0, 200000, 0, 0, 0, '', 57244), -- 390873 +(382184, 8907, 1, 1, 1, 16683, 1, 0, 0, 0, '', 57244), -- 382184 +(382183, 8907, 1, 0, 0, 21928, 15, 0, 1, 0, '', 57244), -- 382183 +(390902, 5514, 8, 1, 1, 0, 150000, 0, 0, 0, '', 57244), -- 390902 +(382835, 5514, 1, 0, 0, 14628, 1, 0, 1, 0, '', 57244), -- 382835 +(382037, 5465, 1, 0, 0, 13624, 1, 0, 1, 0, '', 57244), -- 382037 +(382491, 5235, 1, 1, 1, 13189, 1, 0, 1, 0, '', 57244), -- 382491 +(382490, 5235, 1, 0, 0, 13196, 1, 0, 1, 0, '', 57244), -- 382490 +(381722, 1421, 1, 0, 0, 6170, 1, 0, 1, 0, '', 57244), -- 381722 +(381554, 417, 1, 1, 1, 3117, 1, 0, 1, 0, '', 57244), -- 381554 +(381553, 417, 1, 0, 0, 3183, 1, 0, 1, 0, '', 57244), -- 381553 +(380343, 407, 1, 0, 0, 3035, 1, 0, 1, 0, '', 57244), -- 380343 +(380198, 346, 1, 0, 0, 2795, 1, 0, 1, 0, '', 57244), -- 380198 +(381250, 292, 1, 0, 0, 2944, 1, 0, 0, 0, '', 57244), -- 381250 +(379958, 32, 1, 0, 0, 8594, 1, 0, 1, 0, '', 57244); -- 379958 + +UPDATE `quest_objectives` SET `VerifiedBuild`=57244 WHERE `ID` IN (450525, 420453, 420459, 441832, 441827, 439620, 426415, 426380, 426363, 426324, 426206, 426362, 426361, 426460, 426225, 426201, 426441, 438741, 426295, 426384, 426383, 426382, 426381, 426070, 426173, 426172, 426082, 426081, 425744, 425743, 425742, 425741, 425740, 425739, 425846, 425845, 425844, 425781, 425622, 425596, 425688, 425609, 425537, 425518, 425343, 425342, 425341, 425362, 425361, 425360, 425182, 425213, 424933, 425100, 425074, 410986, 410966, 410943, 410942, 410941, 410940, 411067, 410990, 410716, 410063, 409492, 409489, 380938, 380937, 380936, 380935, 411407, 411588, 411475, 411578, 411364, 411363, 411397, 411378, 411503, 411502, 384635, 384634, 384571, 384570, 382880, 382879, 411300, 383528, 382589, 382462, 382871, 384449, 384448, 384412, 384615, 384614, 384613, 384612, 384871, 383670, 383669, 383668, 383667, 383666, 383577, 383576, 383575, 383574, 383573, 383326, 383325, 383324, 383323, 380456, 380455, 380454, 380453, 383765, 384295, 384294, 384293, 384030, 384029, 384028, 382877, 382876, 382875, 380620, 380619, 380618, 382656, 384288, 384287, 384286, 384285, 382219, 382031, 384255, 384198, 384062, 382167, 383638, 383283, 383317, 383372, 383141, 383140, 382840, 383969, 384072, 383662, 384041, 384040, 383719, 383943, 383942, 383941, 383940, 383851, 383446, 383768, 383751, 383831, 383521, 383779, 384055, 381566, 381565, 381564, 381563, 382806, 382676, 382675, 383421, 383420, 382128, 382127, 383849, 382471, 382470, 383832, 383862, 383529, 383592, 383596, 383542, 383541, 383464, 381965, 383927, 381567, 383904, 383903, 383902, 383901, 383701, 383705, 383843, 383842, 383865, 381824, 383345, 383344, 381662, 383260, 382062, 382061, 382060, 382059, 381949, 381948, 381947, 383038, 383209, 383208, 383207, 382580, 382579, 382768, 382767, 382377, 382376, 382885, 382617, 382616, 382615, 382614, 382745, 382744, 382743, 382742, 382725, 382630, 382629, 382628, 382627, 382760, 382759, 382962, 382647, 382646, 382645, 382857, 382693, 382534, 382306, 382474, 382585, 382091, 382090, 382761, 383432, 383298, 383297, 383439, 383437, 380359, 383144, 382785, 382103, 382102, 382101, 382100, 382083, 382082, 382081, 382080, 383296, 383392, 383610, 383630, 383234, 383330, 383329, 383328, 383327, 382372, 383292, 383291, 383290, 383289, 383241, 383229, 382774, 381325, 380779, 380368, 382406, 382405, 382404, 382403, 382655, 382539, 382538, 382537, 385515, 382401, 382400, 382478, 382134, 383604, 383603, 382304, 382197, 382338, 381718, 381717, 381716, 381715, 381981, 382397, 382166, 382129, 382542, 382301, 382300, 382210, 382057, 382119, 380556, 380555, 381665, 381890, 381889, 381927, 382025, 382024, 382023, 382022, 381651, 381587, 381598, 381874, 381895, 381894, 381893, 381863, 381747, 381746, 381811, 416894, 381682, 381681, 382067, 381636, 381962, 381961, 381960, 381437, 381707, 381706, 381705, 381535, 385494, 381604, 381603, 381721, 385504, 381802, 381745, 381744, 381519, 381339, 381498, 381497, 381156, 381365, 381464, 381463, 381462, 381230, 381229, 381144, 381399, 381174, 381203, 381298, 381381, 381507, 381506, 381505, 380923, 381123, 380943, 380942, 380881, 381549, 381088, 381544, 380927, 381004, 381003, 380758, 380986, 380863, 380862, 380962, 381054, 381314, 381313, 380462, 380573, 380846, 380790, 380781, 380780, 381166, 381165, 381164, 381163, 380974, 380973, 380521, 380520, 380519, 381087, 380623, 380418, 380407, 381231, 380412, 380502, 380461, 380460, 381284, 380611, 381162, 381161, 380628, 380627, 380626, 380596, 385481, 380595, 381180, 380621, 380360, 380180, 380179, 381107, 380369, 380184, 380183, 380294, 380400, 380399, 380398, 380276, 380365, 380192, 380168, 380167, 380335, 381271, 381270, 380301, 380300, 380329, 380328, 380381, 380341, 380011, 381280, 381205, 380044, 380319, 380247, 380342, 380042, 381433, 380100, 380105, 380298, 380031, 380111, 380118, 380144, 380083, 380122, 379957, 381515, 381514, 381192, 380079); + + +UPDATE `quest_reward_display_spell` SET `VerifiedBuild`=57244 WHERE (`Idx`=0 AND `QuestID` IN (14111,13004,12918,5647,5641)); + + +UPDATE `creature_template` SET `VerifiedBuild`=57244 WHERE `entry` IN (47841, 30611, 45709, 19850, 3475, 45714, 38821, 45717, 45720, 46593, 46594, 46595, 51346, 45338, 45780, 30706, 229834, 30723, 1420, 45814, 45822, 45827, 45830, 44975, 14376, 44978, 14392, 49743, 45015, 32520, 45019, 45023, 45025, 45029, 4953, 9697, 8404, 7562, 7565, 7567, 47652, 47653, 31717, 18363, 18364, 53276, 18365, 211026, 49837, 33029, 29582, 18377, 18378, 18379, 18380, 3296, 28302, 12788, 12789, 12790, 208033, 12791, 12793, 12794, 12795, 12796, 12797, 12798, 45558, 45559, 5910, 42548, 45566, 52033, 45137, 45138, 45139, 14539, 52036, 14540, 14541, 41266, 6368, 51195, 358, 39605, 2110, 45211, 46078, 4271, 4272, 46080, 46082, 40054, 17213, 45659, 45661, 45662, 7311, 185317, 12922); + + +UPDATE `gameobject_template` SET `VerifiedBuild`=57244 WHERE `entry` IN (195489, 181886, 207627, 201798, 207262, 207261, 207260, 207253, 207252, 202594, 201735, 201734, 201733, 202586, 180643, 206110); + + +UPDATE `npc_text` SET `VerifiedBuild`=57244 WHERE `ID` IN (17552, 14681); |