DB/Undercity: Update Hallows End stuff (Dragonflight)

1 files changed, 130 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_10_23_01_world.sql b/sql/updates/world/master/2023_10_23_01_world.sql
new file mode 100644
index 00000000000..89effbda05b
--- /dev/null
+++ b/sql/updates/world/master/2023_10_23_01_world.sql
@@ -0,0 +1,130 @@
+-- Creature templates
+DELETE FROM `creature_template` WHERE `entry`=203463;
+INSERT INTO `creature_template` (`entry`, `KillCredit1`, `KillCredit2`, `name`, `femaleName`, `subname`, `TitleAlt`, `IconName`, `RequiredExpansion`, `VignetteID`, `unit_class`, `WidgetSetID`, `WidgetSetUnitConditionID`, `rank`, `family`, `type`, `RacialLeader`, `movementId`, `VerifiedBuild`) VALUES
+(203463, 0, 0, 'Arfus', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, 0, 12, 0, 100, 51754); -- Arfus
+
+UPDATE `creature_template` SET `npcflag`=3 WHERE `entry`=53865; -- Orphan Matron Nanee
+UPDATE `creature_template` SET `faction`=35, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048 WHERE `entry`=203463; -- Arfus
+
+DELETE FROM `creature_template_addon` WHERE `entry`=203463;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(203463, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 203463 (Arfus)
+
+-- Gossips
+UPDATE `gossip_menu` SET `VerifiedBuild`=51754 WHERE (`MenuID`=12929 AND `TextID`=18183) OR (`MenuID`=6537 AND `TextID`=7740) OR (`MenuID`=12932 AND `TextID`=18190) OR (`MenuID`=6536 AND `TextID`=7739) OR (`MenuID`=12937 AND `TextID`=18200);
+
+UPDATE `gossip_menu_option` SET `GossipOptionID`=40456, `VerifiedBuild`=51754 WHERE (`MenuID`=12929 AND `OptionID`=0);
+
+UPDATE `creature_template_gossip` SET `VerifiedBuild`=51754 WHERE (`CreatureID`=53764 AND `MenuID`=12929) OR (`CreatureID`=15197 AND `MenuID`=6537) OR (`CreatureID`=53763 AND `MenuID`=12932) OR (`CreatureID`=15195 AND `MenuID`=6536) OR (`CreatureID`=53865 AND `MenuID`=12937);
+
+-- Difficulties
+DELETE FROM `creature_template_difficulty` WHERE (`Entry`=203463 AND `DifficultyID`=0);
+INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES
+(203463, 0, 0, 0, 371, 9, 0.200000002980232238, 1, 232560, 0, 0, 51754); -- Arfus
+
+UPDATE `creature_template_difficulty` SET `VerifiedBuild`=51754 WHERE (`DifficultyID`=0 AND `Entry` IN (153285,23103,5670,5668,36225,7395,2458,4600,4601,4602,36226,61169,4605,2308,5700,53528,4596,5674,4580,4076,15683,4597,23713,11048,15682,6741,11049,5821,4577,4562,5819,4576,4561,5669,4560,10053,61753,40435,4603,49965,19178,4558,4570,5754,54244,5701,5707,5706,4571,16030,5727,53762,53761,51384,5726,5704,5705,43359,53517,54207,5702,37543,36213,61366,53591,54043,37574,51720,51702,61905,53764,51731,53763,15195,20725,15197,51703,51730,109688,4075,121541,53865,53756,53760,53757,15309));
+
+-- Models
+DELETE FROM `creature_template_model` WHERE (`CreatureID`=203463 AND `Idx`=0);
+INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES
+(203463, 0, 111022, 1, 1, 51754); -- Arfus
+
+UPDATE `creature_template_model` SET `VerifiedBuild`=51754 WHERE (`Idx`=0 AND `CreatureID` IN (4596,5819,19178,4558,4580,5707,51384,40625,153285,53528,5700,6741,53761,54207,51731,53756,4571,43359,53764,28363,4560,61753,23713,53591,53757,36225,53762,20725,71486,10053,5726,37543,51720,53763,68288,36226,5669,5702,47654,5701,61905,53865,7395,4562,4576,54423,15682,109688,11048,65011,4075,2458,4076,49965,15195,121541,5821,165189,53517,51730,64993,53760,5670,61169,15683,54244,25064,4602,36213,37574,14505,4601,4603,11049,54043,54741,5706,51703,18379,40435,5705,59072,4605,5704,15309,5674,5754,5727,40165,4600,4577,15197,56921,35362,304,23103,2308,4570,16030,61366,51702,356,5668,4597,4561,305)) OR (`Idx`=1 AND `CreatureID` IN (19178,54207,43359,61753,53591,37543,4075,49965,51730,54244,37574,40165,16030,61366)) OR (`Idx`=3 AND `CreatureID` IN (54207,51730)) OR (`Idx`=2 AND `CreatureID` IN (54207,4075,49965,51730,61366));
+
+DELETE FROM `creature_model_info` WHERE `DisplayID`=111022;
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(111022, 0.218090236186981201, 0, 0, 51754);
+
+UPDATE `creature_model_info` SET `VerifiedBuild`=51754 WHERE `DisplayID` IN (28048, 11466, 4005, 4004, 30072, 2645, 2628, 2627, 2616, 30073, 2615, 1585, 4057, 38381, 2632, 3020, 2668, 2177, 7995, 2649, 8848, 10580, 15780, 5449, 10581, 4381, 2671, 4060, 2652, 4378, 2634, 2622, 4010, 22381, 2654, 9273, 31851, 2643, 22380, 2666, 2673, 1141, 4150, 4122, 4123, 4058, 9906, 4064, 4063, 2640, 9904, 2346, 21957, 38521, 37960, 1566, 850, 4061, 4062, 38376, 22201, 4059, 22769, 37692, 11686, 37638, 24719, 45952, 38522, 37642, 38487, 37640, 1418, 10699, 37639, 4732, 15349, 20024, 37641, 19314, 2176, 27823, 38528, 19315, 20545, 14589, 14616);
+
+-- Vendor data
+DELETE FROM `npc_vendor` WHERE (`entry`=53757 AND `item`=204336 AND `ExtendedCost`=5797 AND `type`=1) OR (`entry`=53757 AND `item`=208735 AND `ExtendedCost`=3545 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(53757, 22, 204336, 0, 5797, 1, 0, 0, 51754), -- Awakened Heirloom Armor Casing
+(53757, 1, 208735, 0, 3545, 1, 0, 0, 51754); -- Bucket of Morbid Treats
+
+UPDATE `npc_vendor` SET `VerifiedBuild`=51754 WHERE (`entry`=53756 AND `item`=139004 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=128644 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=128645 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=128646 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=116854 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=116853 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=116851 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=116850 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=116848 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=20397 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=20398 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=20399 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=20409 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=20410 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=20411 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=20413 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53756 AND `item`=20414 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=109688 AND `item`=139036 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=109688 AND `item`=116812 AND `ExtendedCost`=3547 AND `type`=1) OR (`entry`=109688 AND `item`=116811 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=109688 AND `item`=116810 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=109688 AND `item`=151269 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=109688 AND `item`=116801 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=109688 AND `item`=116804 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=109688 AND `item`=70908 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=109688 AND `item`=33154 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=53760 AND `item`=49216 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=49215 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20573 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20574 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20568 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20567 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20572 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20571 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20570 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20569 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20564 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20563 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20566 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20565 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=49210 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=49212 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20391 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20392 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20561 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=20562 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=34003 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=34001 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=34002 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=34000 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53760 AND `item`=69195 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=53760 AND `item`=69194 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=53760 AND `item`=69193 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=53760 AND `item`=69192 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=53760 AND `item`=69190 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=53760 AND `item`=69189 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=53760 AND `item`=69188 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=53760 AND `item`=69187 AND `ExtendedCost`=3403 AND `type`=1);
+UPDATE `npc_vendor` SET `slot`=21, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=187997 AND `ExtendedCost`=5797 AND `type`=1); -- Eternal Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=167731 AND `ExtendedCost`=5797 AND `type`=1); -- Battle-Hardened Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=151614 AND `ExtendedCost`=5797 AND `type`=1); -- Weathered Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=122340 AND `ExtendedCost`=5797 AND `type`=1); -- Timeworn Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=122338 AND `ExtendedCost`=5796 AND `type`=1); -- Ancient Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=163045 AND `ExtendedCost`=3545 AND `type`=1); -- Headless Horseman's Hearthstone
+UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=151270 AND `ExtendedCost`=3545 AND `type`=1); -- Horse Tail Costume
+UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=151271 AND `ExtendedCost`=3545 AND `type`=1); -- Horse Head Costume
+UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=70722 AND `ExtendedCost`=3546 AND `type`=1); -- Little Wickerman
+UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=37011 AND `ExtendedCost`=3547 AND `type`=1); -- Magic Broom
+UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=37604 AND `ExtendedCost`=3404 AND `type`=1); -- Tooth Pick
+UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=37583 AND `ExtendedCost`=3404 AND `type`=1); -- G.N.E.R.D.S.
+UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=37584 AND `ExtendedCost`=3404 AND `type`=1); -- Soothing Spearmint Candy
+UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=37582 AND `ExtendedCost`=3404 AND `type`=1); -- Pyroblast Cinnamon Ball
+UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=37585 AND `ExtendedCost`=3404 AND `type`=1); -- Chewy Fel Taffy
+UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=151268 AND `ExtendedCost`=5339 AND `type`=1); -- Exquisite Costume Set: "Xavius"
+UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=138990 AND `ExtendedCost`=5339 AND `type`=1); -- Exquisite Costume Set: "Grommash"
+UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=128643 AND `ExtendedCost`=5339 AND `type`=1); -- Exquisite Costume Set: "Deathwing"
+UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=116828 AND `ExtendedCost`=5339 AND `type`=1); -- Exquisite Costume Set: "The Lich King"
+UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=51754 WHERE (`entry`=53757 AND `item`=33292 AND `ExtendedCost`=3546 AND `type`=1); -- Hallowed Helm
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `VerifiedBuild`=51754 WHERE `entry` IN (36086, 113753, 36071, 98343, 101851, 267746, 180047, 177044, 180471, 186234, 267749, 20655, 208841, 36095, 175761, 113752, 20649, 58619, 267748, 20653, 208828, 20654, 180431, 98349, 267745, 36090, 177064, 20651, 208198, 58629, 20652, 180437, 180411, 208876, 180426, 113576, 208840, 180410, 267747, 36083, 180434, 58600, 101850, 208200, 180432, 180472, 176594, 267744, 180415, 204332, 267751, 180433, 180428, 36082, 180408, 180414, 180406, 208839, 36093, 136101, 20657, 113574, 208965, 77813, 208963, 208842, 58617, 180427, 190217, 180409, 208874, 180407, 204333, 36105, 190071, 20650, 180405, 180412, 52176, 267750, 208394, 36102, 113754, 36091, 180425, 20656, 180523);
+
+UPDATE `gameobject_questitem` SET `VerifiedBuild`=51754 WHERE (`Idx`=0 AND `GameObjectEntry` IN (208839,208876,208874,208828));
+
+UPDATE `gameobject_template_addon` SET `faction`=0 WHERE `entry`=101851; -- Armory Door
+UPDATE `gameobject_template_addon` SET `faction`=0 WHERE `entry`=101850; -- Cathedral Door
+
+-- Quests
+DELETE FROM `quest_template` WHERE `ID`=76075;
+INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `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`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES
+(76075, 2, 0, 425, -21, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 206596, 0, 1, 0, 33554440, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 206596, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 9, 0, 0, 'A Ghostly Message', 'Look for Thomas Thomson near the Scarlet Monastery in Tirisfal Glades.', 'Excuse me, $n is it? You\'ve made quite a name for yourself lately, for both the living and the dead. \n\nI have in my possession the Tome of Thomas Thomson. For years it has been in my library, a reminder of times we must not forget. Imagine my surprise when the tome flings itself to the floor, falling open to a page with a single name on it.\n\nYours, $n.\n\nIf Thomas\' spirit is trying to reach you, then I think you should take this tome. Perhaps he awaits at the Scarlet Monastery?', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 51754); -- A Ghostly Message
+
+UPDATE `quest_template` SET `VerifiedBuild`=51754 WHERE `ID` IN (29376, 29374, 26801, 26953, 26999, 24974, 26934, 29377, 24983, 24975, 26931, 26922, 25056, 26921, 24978, 25090, 51443, 25003, 47514, 24979, 42985, 26965, 46277, 27000, 46735, 29431, 24992, 46736, 29375, 24994, 53435, 25030, 32009, 24997, 65435, 26923, 54759, 24981, 49930, 8312, 32008);
+UPDATE `quest_template` SET `LogDescription`='Speak with Darkcaller Yanka in the Ruins of Lordaeron.', `QuestDescription`='Well met, $c.$B$BHallow\'s End is a time for celebration and reflection, though some have no idea why. The burning of the Wickerman in particular is a mystery to many outside the Forsaken.$B$BTravel to the Ruins of Lordaeron and speak to Darkcaller Yanka.  She can tell you more about the Wickerman ceremony.', `VerifiedBuild`=51754 WHERE `ID`=53122; -- A Season for Celebration
+
+DELETE FROM `quest_objectives` WHERE `ID`=436723;
+INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES
+(436723, 76075, 19, 0, 0, 29233, 0, 0, 0, 0, 'Find Thomas Thomson', 51754); -- 436723
+
+UPDATE `quest_objectives` SET `VerifiedBuild`=51754 WHERE `ID` IN (252149, 254025, 254024, 255427, 265962, 267638, 254100, 262424, 262423, 262422, 265751, 265750, 266885, 266884, 266883, 267187, 267186, 264903, 264902, 264901, 264900, 266407, 266652, 258622, 258621, 258179, 267216, 267215, 267214, 255140, 253494, 253485, 253484, 255548, 265639, 335884, 335883, 256833, 256832, 256831, 256830, 266699, 289535, 266110, 289167, 289536, 255431, 267622, 341368);
+
+DELETE FROM `quest_visual_effect` WHERE (`ID`=436723 AND `Index`=0);
+INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES
+(436723, 0, 23775, 51754);
+
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=51754 WHERE (`ID`=258621 AND `Index`=0) OR (`ID`=335884 AND `Index` IN (2,1,0)) OR (`ID`=335883 AND `Index`=0);
+
+UPDATE `quest_reward_display_spell` SET `VerifiedBuild`=51754 WHERE (`QuestID`=54759 AND `Idx`=0);
+
+DELETE FROM `quest_poi` WHERE (`QuestID`=76075 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=76075 AND `BlobIndex`=0 AND `Idx1`=0);
+INSERT INTO `quest_poi` (`QuestID`, `BlobIndex`, `Idx1`, `ObjectiveIndex`, `QuestObjectiveID`, `QuestObjectID`, `MapID`, `UiMapID`, `Priority`, `Flags`, `WorldEffectID`, `PlayerConditionID`, `NavigationPlayerConditionID`, `SpawnTrackingID`, `AlwaysAllowMergingBlobs`, `VerifiedBuild`) VALUES
+(76075, 0, 1, 0, 436723, 29233, 0, 18, 0, 2, 0, 0, 0, 0, 0, 51754), -- A Ghostly Message
+(76075, 0, 0, -1, 0, 0, 0, 18, 0, 2, 0, 0, 0, 0, 0, 51754); -- A Ghostly Message
+
+UPDATE `quest_poi` SET `VerifiedBuild`=51754 WHERE (`QuestID`=29377 AND `BlobIndex`=1 AND `Idx1`=3) OR (`QuestID`=29377 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=29377 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29377 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=29376 AND `BlobIndex`=1 AND `Idx1`=3) OR (`QuestID`=29376 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=29376 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29376 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=29375 AND `BlobIndex`=1 AND `Idx1`=7) OR (`QuestID`=29375 AND `BlobIndex`=0 AND `Idx1`=6) OR (`QuestID`=29375 AND `BlobIndex`=4 AND `Idx1`=5) OR (`QuestID`=29375 AND `BlobIndex`=3 AND `Idx1`=4) OR (`QuestID`=29375 AND `BlobIndex`=2 AND `Idx1`=3) OR (`QuestID`=29375 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=29375 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29375 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=29374 AND `BlobIndex`=1 AND `Idx1`=3) OR (`QuestID`=29374 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=29374 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29374 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=29431 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=29431 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29431 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=8312 AND `BlobIndex`=1 AND `Idx1`=6) OR (`QuestID`=8312 AND `BlobIndex`=0 AND `Idx1`=5) OR (`QuestID`=8312 AND `BlobIndex`=0 AND `Idx1`=4) OR (`QuestID`=8312 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=8312 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=8312 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=8312 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=32008 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=32008 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=65435 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=65435 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=54759 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=54759 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=53435 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=53435 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=49930 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=49930 AND `BlobIndex`=0 AND `Idx1`=0);
+
+DELETE FROM `quest_poi_points` WHERE (`QuestID`=76075 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=76075 AND `Idx1`=0 AND `Idx2`=0);
+INSERT INTO `quest_poi_points` (`QuestID`, `Idx1`, `Idx2`, `X`, `Y`, `Z`, `VerifiedBuild`) VALUES
+(76075, 1, 0, 2494, -635, 72, 51754), -- A Ghostly Message
+(76075, 0, 0, 2496, -638, 74, 51754); -- A Ghostly Message
+
+UPDATE `quest_poi_points` SET `VerifiedBuild`=51754 WHERE (`QuestID`=29377 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=29377 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29377 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29377 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=29376 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=29376 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29376 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29376 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=29375 AND `Idx1`=7 AND `Idx2`=0) OR (`QuestID`=29375 AND `Idx1`=6 AND `Idx2`=0) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=11) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=10) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=9) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=8) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=7) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=6) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=5) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=4) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=3) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=2) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=1) OR (`QuestID`=29375 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=11) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=10) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=9) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=8) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=7) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=6) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=5) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=4) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=3) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=2) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=1) OR (`QuestID`=29375 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=11) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=10) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=9) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=8) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=7) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=6) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=5) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=4) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=3) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=2) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=1) OR (`QuestID`=29375 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=11) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=10) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=9) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=8) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=7) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=6) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=5) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=4) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=3) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=2) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=1) OR (`QuestID`=29375 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=11) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=10) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=9) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=29375 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29375 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=29374 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=29374 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=11) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=10) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=9) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=29374 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29374 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=29431 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29431 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29431 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=8312 AND `Idx1`=6 AND `Idx2`=0) OR (`QuestID`=8312 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=8312 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=8312 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=8312 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=8312 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=8312 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=32008 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=32008 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=65435 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=65435 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=54759 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=54759 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=53435 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=53435 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=49930 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=49930 AND `Idx1`=0 AND `Idx2`=0);
+
+DELETE FROM `quest_details` WHERE `ID`=76075;
+INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES
+(76075, 1, 0, 0, 0, 0, 0, 0, 0, 51754); -- A Ghostly Message
+
+UPDATE `quest_details` SET `VerifiedBuild`=51754 WHERE `ID` IN (29377, 29376, 29375, 29374, 29431, 8312);
+
+UPDATE `quest_request_items` SET `VerifiedBuild`=51754 WHERE `ID` IN (29377, 29376, 29375, 29374);
+
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=51754 WHERE `ID`=29376;
+
+UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID`=29376;
+
+DELETE FROM `creature_queststarter` WHERE (`id`=53865 AND `quest`=76075);
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(53865, 76075, 51754); -- A Ghostly Message offered Orphan Matron Nanee
+
+UPDATE `creature_queststarter` SET `VerifiedBuild`=51754 WHERE (`id`=15197 AND `quest` IN (29377,29376)) OR (`id`=53763 AND `quest` IN (29375,29374,29431)) OR (`id`=15309 AND `quest`=8312);
+
+UPDATE `creature_questender` SET `VerifiedBuild`=51754 WHERE (`id`=15197 AND `quest` IN (29376,29377)) OR (`id`=53763 AND `quest` IN (29375,29374)) OR (`id`=15309 AND `quest`=8312);