1 files changed, 32 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_10_27_04_world.sql b/sql/updates/world/cata_classic/2024_10_27_04_world.sql
new file mode 100644
index 00000000000..08cea86013a
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_10_27_04_world.sql
@@ -0,0 +1,32 @@
+DELETE FROM `quest_template` WHERE `ID` IN (25773 /*A Natural Occurrence*/, 11321 /*Did Someone Say "Souvenir?"*/, 8923 /*A Supernatural Device*/, 6181 /*A Swift Message*/, 6148 /*The Scarlet Oracle, Demetria*/);
+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
+(25773, 1, -1, 0, 70, 0, 1, -23, 0, 0, 0, 5, 1, 5, 1, 0, 0, 0, 56008, 0, 1, 0, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 2099199, 0, 0, 'A Natural Occurrence', 'Take the Elemental Shard to an Earthen Ring Emissary in Ironforge, Stormwind, Exodar or Darnassus.', 'This shard is all that is left from the rift that stood here before.  The connection between the shard and the rift is unknown, but perhaps someone more versed in the elements would know more.$B$BSeek out an Earthen Ring Emissary at any capital city.  This could be exactly what they are looking for.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- A Natural Occurrence
+(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?"
+(8923, 2, 60, 0, 255, 0, 58, 440, 0, 0, 8921, 5, 1, 0, 1, 0, 0, 0, 22382, 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, 946, 0, 0, 'A Supernatural Device', 'Take the Sealed Venom Container to Mux Manascrambler in Gadgetzan.', 'You must be quite brave to have stuck around after that.  That or I\'ve piqued your interest with the piece of armor I gave you.  There is more from where that came from, if you\'re still interested in aiding me.$B$BThe venom samples you collected are for an acquaintance of mine, Mux Manascrambler, an engineer with an interest in the supernatural.  His latest project consists of a device that allows you to communicate with the dead!  My last hope is to contact Anthion and find out more about my situation.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- A Supernatural Device
+(6181, 2, 10, 0, 255, 0, 10, 40, 0, 0, 6281, 2, 1, 0, 1, 0, 0, 0, 15998, 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, 2, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 'A Swift Message', 'Bring Lewis\' Note to Thor the gryphon master.', 'Although we don\'t get much aid from Stormwind directly, I do have a contact in the city who helps supply us with armor.  His name is Osric Strang.  His shop, Limited Immunity, is in the Old Town of Stormwind.$B$BOur supply of armor dwindles, and I must contact Osric for more.  Can you take him this note?$B$BThe fastest way to Stormwind is through Thor, our gryphon master.  He\'s just down the hill; bring him my note, and then take a gryphon to Stormwind.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244), -- A Swift Message
+(6148, 2, 60, 0, 255, 0, 56, 139, 1, 0, 0, 6, 1, 6, 1, 0, 0, 0, 0, 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, 16996, 16997, 16998, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 68, 0, 0, 0, 0, 6, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 0, 'The Scarlet Oracle, Demetria', 'The Scarlet Crusade is on the move. Somewhere along the road from Tyr\'s Hand to Stratholme you will find the Oracle, Demetria, and her entourage. Hunt her down and slay her. Return to Nathanos Blightcaller should you succeed.', 'Demetria is chief advisor to the Grand Crusader. She is called the Oracle due to her \'otherworldly\' senses. She has successfully assisted the Crusade in several of their victories against the Scourge.$B$BWhile this ruse was successful in exposing her, if she truly does possess psychic powers, she will undoubtedly be expecting some sort of trouble. You are going to provide that \'trouble.\'$B$BTrack down the Oracle and terminate her. They should be moving out of Tyr\'s Hand as we speak. Make me proud, worm.\n', '', 'Return to Nathanos Blightcaller at Marris Stead in Eastern Plaguelands.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 57244); -- The Scarlet Oracle, Demetria
+
+UPDATE `quest_template` SET `VerifiedBuild`=57244 WHERE `ID` IN (27846, 24874, 14089, 13380, 13253, 13195, 12918, 12786, 11162, 10366, 9601, 8755, 6284, 6187, 5047, 3901, 1791, 1534, 1264, 1262, 1108, 571, 503, 474, 376, 321, 177, 155, 134);
+UPDATE `quest_template` SET `RewardArenaPoints`=0 WHERE `ID`=12493;
+
+DELETE FROM `quest_objectives` WHERE `ID` IN (439818 /*439818*/, 411016 /*411016*/, 383918 /*383918*/, 383606 /*383606*/, 383474 /*383474*/);
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(439818, 25773, 1, 0, 0, 56008, 1, 0, 1, 0, '', 57244), -- 439818
+(411016, 11321, 1, 0, 0, 33955, 1, 0, 1, 0, '', 57244), -- 411016
+(383918, 8923, 1, 0, 0, 22382, 1, 0, 1, 0, '', 57244), -- 383918
+(383606, 6181, 1, 0, 0, 15998, 1, 0, 1, 0, '', 57244), -- 383606
+(383474, 6148, 0, 0, 0, 12339, 1, 0, 0, 0, '', 57244); -- 383474
+
+UPDATE `quest_objectives` SET `VerifiedBuild`=57244 WHERE `ID` IN (441832, 426380, 426070, 425846, 425845, 425844, 425596, 425518, 425362, 425361, 425360, 425213, 410889, 410888, 384412, 383862, 383592, 382693, 381504, 383238, 381543, 380881, 381284, 385481, 380595, 381180, 380345, 380344, 380105, 380144);
+
+
+UPDATE `quest_reward_display_spell` SET `VerifiedBuild`=57244 WHERE (`QuestID`=12918 AND `Idx`=0);
+
+
+UPDATE `creature_template` SET `VerifiedBuild`=57244 WHERE `entry` IN (35845, 23909, 14721, 18406, 47841, 6499, 28569, 43277, 229834, 43294, 28596, 44245, 44246, 44247, 44249, 1976, 44251, 44252, 44256, 42421, 29582, 37865, 38821, 284, 307, 45338, 308, 332, 208033, 32520, 4959, 26125, 4075, 1323, 1324, 1325, 1326, 416, 13283, 1341, 42722, 35374, 454, 31717, 32638, 32639, 1412, 9690, 43693, 32666, 43694, 32667, 6946, 51998, 40054, 19848, 52027, 52028, 52029, 52030, 211026, 4269, 14394, 687, 46647, 51254, 51255, 17252, 51256, 721, 28302, 17280, 9018, 52216, 14559, 7207, 14560, 7208, 14561, 47652, 37543, 47653, 1721, 51348, 37574, 31144, 31146, 42177, 12778, 12779, 49540, 12780, 12781, 12783, 12784, 12785, 12786, 12787, 48632, 6368, 12805, 33029, 3626, 5479, 5480, 53276, 18357, 18359, 18360, 18362, 18375, 914, 18376, 918);
+UPDATE `creature_template` SET `VerifiedBuild`=57244 WHERE `entry`=8383; -- Master Wood
+
+
+UPDATE `gameobject_template` SET `VerifiedBuild`=57244 WHERE `entry` IN (207330, 207093, 202696, 202695, 202694, 202691, 207417, 206693, 204986, 202591, 196412, 196404, 196401, 196400, 196399, 195430, 195327, 201499, 190536, 209692, 209039, 176310, 206111, 203800, 201502, 201549, 201548, 201545, 200315, 200311, 200310, 200314, 201547, 201550, 200309, 200307, 201546, 200313, 200308, 203762, 200306, 201553, 201552, 200317, 200312, 179706, 124374, 201551, 201554, 205190, 201556, 201555, 201515, 200316, 201559, 201519, 201518, 201558, 201557, 201560, 201520, 201516, 200318, 200320, 200323, 200322, 200319, 200321, 200331, 200330, 200326, 201517, 200329, 200328, 200327);
+
+UPDATE `gameobject_questitem` SET `VerifiedBuild`=57244 WHERE (`Idx`=0 AND `GameObjectEntry` IN (203800,203762));