DB/Stormwind: Update Hallows End stuff (Dragonflight)

1 files changed, 102 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_10_23_02_world.sql b/sql/updates/world/master/2023_10_23_02_world.sql
new file mode 100644
index 00000000000..69ea0da3c44
--- /dev/null
+++ b/sql/updates/world/master/2023_10_23_02_world.sql
@@ -0,0 +1,102 @@
+-- Creature templates
+UPDATE `creature_template` SET `npcflag`=3 WHERE `entry`=53869; -- Orphan Matron Seacole
+UPDATE `creature_template` SET `faction`=35, `npcflag`=268435457, `speed_run`=0.857142865657806396, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=1 WHERE `entry`=205879; -- Ethereal Warpweaver
+
+DELETE FROM `creature_template_addon` WHERE `entry`=205879;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(205879, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 205879 (Ethereal Warpweaver)
+
+-- Equipments
+DELETE FROM `creature_equip_template` WHERE (`CreatureID`=205879 AND `ID`=1);
+INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES
+(205879, 1, 71732, 0, 0, 0, 0, 0, 0, 0, 0, 51754); -- Ethereal Warpweaver
+
+-- Gossips
+DELETE FROM `gossip_menu` WHERE (`MenuID`=31670 AND `TextID`=31799);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(31670, 31799, 51754); -- 205879 (Ethereal Warpweaver)
+
+UPDATE `gossip_menu` SET `VerifiedBuild`=51754 WHERE (`MenuID`=12931 AND `TextID`=18189) OR (`MenuID`=12717 AND `TextID`=17849);
+
+DELETE FROM `gossip_menu_option` WHERE (`MenuID`=31670 AND `OptionID`=0);
+INSERT INTO `gossip_menu_option` (`GossipOptionID`, `MenuID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextId`, `Language`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `Flags`, `OverrideIconID`, `GossipNpcOptionID`, `VerifiedBuild`) VALUES
+(109859, 31670, 0, 34, 'I want to transmogrify my gear.', 130510, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, NULL, 51754);
+
+UPDATE `gossip_menu_option` SET `GossipOptionID`=39655, `VerifiedBuild`=51754 WHERE (`MenuID`=12717 AND `OptionID`=0);
+
+DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=205879 AND `MenuID`=31670);
+INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES
+(205879, 31670, 51754); -- Ethereal Warpweaver
+
+UPDATE `creature_template_gossip` SET `VerifiedBuild`=51754 WHERE (`CreatureID`=53869 AND `MenuID`=12937) OR (`CreatureID`=51934 AND `MenuID`=12931) OR (`CreatureID`=52548 AND `MenuID`=12717);
+
+-- Difficulties
+DELETE FROM `creature_template_difficulty` WHERE (`Entry`=205879 AND `DifficultyID`=0);
+INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`, `VerifiedBuild`) VALUES
+(205879, 0, 0, 0, 864, 9, 1, 1, 235079, 0, 0, 51754); -- Ethereal Warpweaver
+
+UPDATE `creature_template_difficulty` SET `VerifiedBuild`=51754 WHERE (`DifficultyID`=0 AND `Entry` IN (142656,111190,109685,61165,61080,53728,53702,52548,52497,52067,52064,51947,51934,51836,51710,51705,51701,51699,51684,51665,51348,17804,15310,883,68));
+UPDATE `creature_template_difficulty` SET `TypeFlags2`=32768, `VerifiedBuild`=51754 WHERE (`Entry`=53869 AND `DifficultyID`=0); -- Orphan Matron Seacole
+
+-- Models
+UPDATE `creature_template_model` SET `VerifiedBuild`=51754 WHERE (`Idx`=0 AND `CreatureID` IN (51701,53869,205879,109685,52067,17804,51684,51947,61165,51705,51699,52497,53702,51665,308,142656,51836,53728,15310,51934,111190,883,52064,51348,68,52548,51710,18362,61080)) OR (`Idx`=1 AND `CreatureID` IN (52067,51699,111190,51348,68,61080)) OR (`Idx`=3 AND `CreatureID`=68) OR (`Idx`=2 AND `CreatureID`=68);
+
+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 (38804, 87696, 257, 654, 328, 4626, 38529, 38421, 3640, 38523, 37747, 23960, 37652, 38519, 29467, 37111, 37113, 29961, 37310, 37311, 17250, 338, 347, 3167, 5446, 99389);
+
+-- Vendor data
+DELETE FROM `npc_vendor` WHERE (`entry`=53728 AND `item`=204336 AND `ExtendedCost`=5797 AND `type`=1) OR (`entry`=53728 AND `item`=208735 AND `ExtendedCost`=3545 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(53728, 22, 204336, 0, 5797, 1, 0, 0, 51754), -- Awakened Heirloom Armor Casing
+(53728, 1, 208735, 0, 3545, 1, 0, 0, 51754); -- Bucket of Morbid Treats
+
+UPDATE `npc_vendor` SET `VerifiedBuild`=51754 WHERE (`entry`=52497 AND `item`=49216 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=49215 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20573 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20574 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20568 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20567 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20572 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20571 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20570 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20569 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20564 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20563 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20566 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20565 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=49210 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=49212 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20391 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20392 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20561 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=20562 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=34003 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=34001 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=34002 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=34000 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=52497 AND `item`=69195 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=52497 AND `item`=69194 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=52497 AND `item`=69193 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=52497 AND `item`=69192 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=52497 AND `item`=69190 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=52497 AND `item`=69189 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=52497 AND `item`=69188 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=52497 AND `item`=69187 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=53702 AND `item`=139004 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=128644 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=128645 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=128646 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=116854 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=116853 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=116851 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=116850 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=116848 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=20397 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=20398 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=20399 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=20409 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=20410 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=20411 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=20413 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=53702 AND `item`=20414 AND `ExtendedCost`=3404 AND `type`=1) OR (`entry`=109685 AND `item`=139036 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=109685 AND `item`=116812 AND `ExtendedCost`=3547 AND `type`=1) OR (`entry`=109685 AND `item`=116811 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=109685 AND `item`=116810 AND `ExtendedCost`=3403 AND `type`=1) OR (`entry`=109685 AND `item`=151269 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=109685 AND `item`=116801 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=109685 AND `item`=116804 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=109685 AND `item`=70908 AND `ExtendedCost`=3545 AND `type`=1) OR (`entry`=109685 AND `item`=33154 AND `ExtendedCost`=3545 AND `type`=1);
+UPDATE `npc_vendor` SET `slot`=21, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=187997 AND `ExtendedCost`=5797 AND `type`=1); -- Eternal Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=20, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=167731 AND `ExtendedCost`=5797 AND `type`=1); -- Battle-Hardened Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=19, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=151614 AND `ExtendedCost`=5797 AND `type`=1); -- Weathered Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=18, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=122340 AND `ExtendedCost`=5797 AND `type`=1); -- Timeworn Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=17, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=122338 AND `ExtendedCost`=5796 AND `type`=1); -- Ancient Heirloom Armor Casing
+UPDATE `npc_vendor` SET `slot`=16, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=151268 AND `ExtendedCost`=5339 AND `type`=1); -- Exquisite Costume Set: "Xavius"
+UPDATE `npc_vendor` SET `slot`=15, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=138990 AND `ExtendedCost`=5339 AND `type`=1); -- Exquisite Costume Set: "Grommash"
+UPDATE `npc_vendor` SET `slot`=14, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=128643 AND `ExtendedCost`=5339 AND `type`=1); -- Exquisite Costume Set: "Deathwing"
+UPDATE `npc_vendor` SET `slot`=13, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=116828 AND `ExtendedCost`=5339 AND `type`=1); -- Exquisite Costume Set: "The Lich King"
+UPDATE `npc_vendor` SET `slot`=12, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=33292 AND `ExtendedCost`=3546 AND `type`=1); -- Hallowed Helm
+UPDATE `npc_vendor` SET `slot`=11, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=163045 AND `ExtendedCost`=3545 AND `type`=1); -- Headless Horseman's Hearthstone
+UPDATE `npc_vendor` SET `slot`=10, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=151270 AND `ExtendedCost`=3545 AND `type`=1); -- Horse Tail Costume
+UPDATE `npc_vendor` SET `slot`=9, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=151271 AND `ExtendedCost`=3545 AND `type`=1); -- Horse Head Costume
+UPDATE `npc_vendor` SET `slot`=8, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=70722 AND `ExtendedCost`=3546 AND `type`=1); -- Little Wickerman
+UPDATE `npc_vendor` SET `slot`=7, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=37011 AND `ExtendedCost`=3547 AND `type`=1); -- Magic Broom
+UPDATE `npc_vendor` SET `slot`=6, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=37604 AND `ExtendedCost`=3404 AND `type`=1); -- Tooth Pick
+UPDATE `npc_vendor` SET `slot`=5, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=37583 AND `ExtendedCost`=3404 AND `type`=1); -- G.N.E.R.D.S.
+UPDATE `npc_vendor` SET `slot`=4, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=37584 AND `ExtendedCost`=3404 AND `type`=1); -- Soothing Spearmint Candy
+UPDATE `npc_vendor` SET `slot`=3, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=37582 AND `ExtendedCost`=3404 AND `type`=1); -- Pyroblast Cinnamon Ball
+UPDATE `npc_vendor` SET `slot`=2, `VerifiedBuild`=51754 WHERE (`entry`=53728 AND `item`=37585 AND `ExtendedCost`=3404 AND `type`=1); -- Chewy Fel Taffy
+
+-- Gameobject templates
+UPDATE `gameobject_template` SET `VerifiedBuild`=51754 WHERE `entry` IN (207941, 180701, 195164, 208078, 208072, 208212, 208223, 180038, 208210, 208214, 208395, 208220, 180037, 208221, 208218, 208215, 208213, 208186, 195212, 208219, 208069, 208222, 208216, 208211);
+
+-- Quests
+UPDATE `quest_template` SET `VerifiedBuild`=51754 WHERE `ID` IN (29075, 29371, 29054, 60545, 14048, 50599, 56119, 29144, 50600, 53436, 75890, 8311, 29430, 49929);
+
+UPDATE `quest_objectives` SET `VerifiedBuild`=51754 WHERE `ID` IN (256617, 256616, 256615, 256614, 252233, 252281, 393649, 252432, 405017, 406745, 406744, 390274, 254751, 336212, 264862, 336204, 341370);
+
+UPDATE `quest_visual_effect` SET `VerifiedBuild`=51754 WHERE (`Index`=0 AND `ID` IN (393649,252432,405017,406745,406744)) OR (`Index`=1 AND `ID`=406745);
+
+UPDATE `quest_poi` SET `VerifiedBuild`=51754 WHERE (`QuestID`=29075 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=29075 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29075 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=8311 AND `BlobIndex`=0 AND `Idx1`=5) OR (`QuestID`=8311 AND `BlobIndex`=0 AND `Idx1`=4) OR (`QuestID`=8311 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=8311 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=8311 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=8311 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=29371 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=29371 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29371 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=29144 AND `BlobIndex`=0 AND `Idx1`=8) OR (`QuestID`=29144 AND `BlobIndex`=6 AND `Idx1`=7) OR (`QuestID`=29144 AND `BlobIndex`=5 AND `Idx1`=6) OR (`QuestID`=29144 AND `BlobIndex`=4 AND `Idx1`=5) OR (`QuestID`=29144 AND `BlobIndex`=3 AND `Idx1`=4) OR (`QuestID`=29144 AND `BlobIndex`=2 AND `Idx1`=3) OR (`QuestID`=29144 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=29144 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29144 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=29054 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=29054 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=29054 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29054 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=29430 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=29430 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=50599 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=75890 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=75890 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=6) OR (`QuestID`=60545 AND `BlobIndex`=1 AND `Idx1`=5) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=4) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=60545 AND `BlobIndex`=1 AND `Idx1`=1) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=56119 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=56119 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=53436 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=53436 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=50600 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=49929 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=49929 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=49929 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14048 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14048 AND `BlobIndex`=0 AND `Idx1`=0);
+
+UPDATE `quest_poi_points` SET `VerifiedBuild`=51754 WHERE (`QuestID`=29075 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29075 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29075 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=8311 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=8311 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=8311 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=8311 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=8311 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=8311 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=29371 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29371 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29371 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=8 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=11) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=10) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=9) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=8) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=7) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=6) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=5) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=4) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=3) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=2) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=1) OR (`QuestID`=29144 AND `Idx1`=7 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=11) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=10) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=9) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=8) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=7) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=6) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=5) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=4) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=3) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=2) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=1) OR (`QuestID`=29144 AND `Idx1`=6 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=11) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=10) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=9) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=8) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=7) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=6) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=5) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=4) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=3) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=2) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=1) OR (`QuestID`=29144 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=11) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=10) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=9) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=8) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=7) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=6) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=5) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=4) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=3) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=2) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=1) OR (`QuestID`=29144 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=11) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=10) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=9) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=8) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=7) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=6) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=5) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=4) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=3) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=2) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=1) OR (`QuestID`=29144 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=11) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=10) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=9) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=8) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=7) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=6) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=5) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=4) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=3) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=2) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=1) OR (`QuestID`=29144 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=11) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=10) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=9) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=29144 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29144 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=29054 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=29054 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=11) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=10) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=9) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=29054 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29054 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=29430 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=29430 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=50599 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=75890 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=75890 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=6 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=56119 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=56119 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=53436 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=53436 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=50600 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=49929 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=49929 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=49929 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14048 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14048 AND `Idx1`=0 AND `Idx2`=0);
+
+UPDATE `quest_details` SET `VerifiedBuild`=51754 WHERE `ID` IN (8311, 29075, 29371, 29144, 29430, 29054);
+
+UPDATE `quest_request_items` SET `VerifiedBuild`=51754 WHERE `ID` IN (29075, 29371, 29054, 29144);
+
+DELETE FROM `creature_queststarter` WHERE (`id`=53869 AND `quest`=76075);
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(53869, 76075, 51754); -- A Ghostly Message offered Orphan Matron Seacole
+
+UPDATE `creature_queststarter` SET `VerifiedBuild`=51754 WHERE (`id`=15310 AND `quest`=8311) OR (`id`=51665 AND `quest`=29075) OR (`id`=52064 AND `quest`=29371) OR (`id`=51934 AND `quest` IN (29144,29430,29054));
+
+UPDATE `creature_questender` SET `VerifiedBuild`=51754 WHERE (`id`=15310 AND `quest`=8311) OR (`id`=52064 AND `quest`=29371) OR (`id`=51934 AND `quest` IN (29144,29054)) OR (`id`=51665 AND `quest`=29075);