DB/Thaldraszus: Implement Quest "Keeper of the Ossuary"

1 files changed, 175 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_03_25_00_world.sql b/sql/updates/world/master/2024_03_25_00_world.sql
new file mode 100644
index 00000000000..eace60f85cb
--- /dev/null
+++ b/sql/updates/world/master/2024_03_25_00_world.sql
@@ -0,0 +1,175 @@
+SET @CGUID := 9004159;
+
+SET @NPCTEXTID := 590111;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 200099, 2444, 13647, 13794, '0', 20026, 0, 0, 0, 2999.44091796875, -3180.33154296875, 337.3531494140625, 0.027856664732098579, 120, 0, 0, 112919, 3155, 0, NULL, NULL, NULL, NULL, 53584), -- Stellagosa (Area: Veiled Ossuary - Difficulty: 0) CreateObject1
+(@CGUID+1, 199923, 2444, 13647, 13794, '0', 20026, 0, 0, 0, 2998.450439453125, -3182.236083984375, 337.3531494140625, 6.041118144989013671, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53584), -- Senegos (Area: Veiled Ossuary - Difficulty: 0) CreateObject1
+(@CGUID+2, 189277, 2444, 13647, 13794, '0', 0, 0, 0, 0, 2969.81787109375, -3145.427734375, 337.349090576171875, 1.608183741569519042, 120, 0, 0, 90335, 7196, 0, NULL, NULL, NULL, NULL, 53877), -- Medic Malorthas (Area: Veiled Ossuary - Difficulty: 0) CreateObject1 (Auras: 384599 - [DNT] Dragonspawn Casting - Crate Hold)
+(@CGUID+3, 189255, 2444, 13647, 13794, '0', 0, 0, 0, 1, 2977.35498046875, -3187.729248046875, 337.39727783203125, 0.541858494281768798, 120, 0, 0, 1693785, 0, 0, NULL, NULL, NULL, NULL, 53877), -- Ossuary Guard (Area: Veiled Ossuary - Difficulty: 0) CreateObject1
+(@CGUID+4, 189253, 2444, 13647, 13794, '0', 0, 0, 0, 0, 2967.032958984375, -3213.413330078125, 337.3531494140625, 1.997595548629760742, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53877), -- Supplier Sukinoth (Area: Veiled Ossuary - Difficulty: 0) CreateObject1
+(@CGUID+5, 189255, 2444, 13647, 13794, '0', 0, 0, 0, 1, 2982.194580078125, -3169.100830078125, 337.39727783203125, 5.783255577087402343, 120, 0, 0, 1693785, 0, 0, NULL, NULL, NULL, NULL, 53877), -- Ossuary Guard (Area: Veiled Ossuary - Difficulty: 0) CreateObject1
+(@CGUID+6, 189237, 2444, 13647, 13794, '0', 0, 0, 0, 0, 2928.2353515625, -3165.757080078125, 338.643310546875, 0.028303543105721473, 120, 0, 0, 112919, 0, 0, NULL, NULL, NULL, NULL, 53877); -- Officer Obernax (Area: Veiled Ossuary - Difficulty: 0) CreateObject1
+
+-- Template
+UPDATE `creature_template` SET `faction`=35, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=199923; -- Senegos
+UPDATE `creature_template` SET `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=200099; -- Stellagosa
+UPDATE `creature_template` SET `faction`=3277, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry`=189255; -- Ossuary Guard
+UPDATE `creature_template` SET `faction`=35, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=189277; -- Medic Malorthas
+UPDATE `creature_template` SET `faction`=35, `npcflag`=4224, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=189253; -- Supplier Sukinoth
+UPDATE `creature_template` SET `faction`=35, `npcflag`=8193, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=189237; -- Officer Obernax
+
+-- Template Addon
+DELETE FROM `creature_template_addon` WHERE `entry` IN (189253 /*189253 (Supplier Sukinoth)*/, 189255 /*189255 (Ossuary Guard)*/);
+INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(189253, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 189253 (Supplier Sukinoth)
+(189255, 0, 0, 0, 0, 0, 1, 1, 716, 0, 0, 0, 0, ''); -- 189255 (Ossuary Guard)
+
+-- Difficulty & Model
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2588, `StaticFlags1`=268435456, `VerifiedBuild`=53584 WHERE (`Entry`=200099 AND `DifficultyID`=0); -- Stellagosa
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2588, `VerifiedBuild`=53584 WHERE (`Entry`=199923 AND `DifficultyID`=0); -- Senegos
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=53877 WHERE (`Entry`=189255 AND `DifficultyID`=0); -- Ossuary Guard
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=53877 WHERE (`Entry`=189277 AND `DifficultyID`=0); -- Medic Malorthas
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=53877 WHERE (`Entry`=189253 AND `DifficultyID`=0); -- Supplier Sukinoth
+
+UPDATE `creature_model_info` SET `VerifiedBuild`=53584 WHERE `DisplayID` IN (76763, 110040, 109639, 104516, 103558, 105560, 105703, 61799, 106855, 109990, 106868, 64062, 103530);
+UPDATE `creature_model_info` SET `BoundingRadius`=0.44829609990119934, `CombatReach`=0.300000011920928955, `VerifiedBuild`=53584 WHERE `DisplayID`=102067;
+UPDATE `creature_model_info` SET `CombatReach`=2.529999971389770507, `VerifiedBuild`=53584 WHERE `DisplayID`=105442;
+UPDATE `creature_model_info` SET `CombatReach`=3, `VerifiedBuild`=53584 WHERE `DisplayID` IN (106873, 106844);
+UPDATE `creature_model_info` SET `BoundingRadius`=1.441807508468627929, `CombatReach`=0.625, `VerifiedBuild`=53584 WHERE `DisplayID`=103531;
+
+-- Gossip & Text
+DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=199923 AND `MenuID` IN (30316)) OR (`CreatureID`=200099 AND `MenuID`=30317);
+INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES
+(199923, 30316, 53584), -- Senegos
+(200099, 30317, 53584); -- Stellagosa
+
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+2;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 238799, 0, 0, 0, 0, 0, 0, 0, 53584), -- 199923 (Senegos)
+(@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 233649, 0, 0, 0, 0, 0, 0, 0, 53584), -- 199923 (Senegos)
+(@NPCTEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 233652, 0, 0, 0, 0, 0, 0, 0, 53584); -- 200099 (Stellagosa)
+
+DELETE FROM `gossip_menu` WHERE (`MenuID`=31093 AND `TextID`=@NPCTEXTID+0) OR (`MenuID`=30316 AND `TextID`=@NPCTEXTID+1) OR (`MenuID`=30317 AND `TextID`=@NPCTEXTID+2);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(31093, @NPCTEXTID+0, 53584), -- 199923 (Senegos)
+(30316, @NPCTEXTID+1, 53584), -- 199923 (Senegos)
+(30317, @NPCTEXTID+2, 53584); -- 200099 (Stellagosa)
+
+DELETE FROM `gossip_menu_option` WHERE (`MenuID`=30316 AND `OptionID`=1) OR (`MenuID`=31093 AND `OptionID`=0);
+INSERT INTO `gossip_menu_option` (`MenuID`, `GossipOptionID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextID`, `Language`, `Flags`, `ActionMenuID`, `ActionPoiID`, `GossipNpcOptionID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `OverrideIconID`, `VerifiedBuild`) VALUES
+(30316, 108981, 1, 0, 'I\'m here to help you, Senegos. Can you tell me more of this place?', 0, 0, 1, 31093, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 53584),
+(31093, 108980, 0, 0, 'I\'m ready to begin helping you clean the Veiled Ossuary.', 0, 0, 1, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 53584);
+
+-- Creature Equip
+DELETE FROM `creature_equip_template` WHERE (`CreatureID`=189255 AND `ID`=1);
+INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES
+(189255, 1, 191692, 0, 0, 193845, 0, 0, 0, 0, 0, 53877); -- Ossuary Guard
+
+-- Phasing
+DELETE FROM `phase_name` WHERE `ID` = 20026;
+INSERT INTO `phase_name` (`ID`, `Name`) VALUES
+(20026, 'Cosmetic - See Senegos and Stellagosa in Veiled Ossuary');
+
+DELETE FROM `phase_area` WHERE `PhaseId` = 20026;
+INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
+(13647, 20026, 'See Senegos and Stellagosa in Veiled Ossuary');
+
+DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId`=26 AND `SourceGroup` = 20026 AND `SourceEntry` = 0);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUE
+(26, 20026, 0, 0, 0, 47, 0, 72900, 2|8|64, 0, 0, 'Apply Phase 20026 if Quest 72900 is in Progress | complete | rewarded');
+
+-- Quest stuff
+DELETE FROM `creature_questender` WHERE (`id`=199923 AND `quest`=72900);
+INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES
+(199923, 72900, 53584); -- Keeper of the Ossuary ended by Senegos
+
+DELETE FROM `quest_request_items` WHERE `ID`=72900;
+INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES
+(72900, 0, 0, 0, 0, 'Ah, here to help are we?', 53584); -- Keeper of the Ossuary
+
+DELETE FROM `quest_offer_reward` WHERE `ID`=72900;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(72900, 6, 0, 0, 0, 0, 0, 0, 0, 'Shall we begin?', 53584); -- Keeper of the Ossuary
+
+DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 15) AND (`SourceGroup` IN (30316));
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES 
+(15, 30316, 1, 0, 0, 9, 0, 72900, 0, 0, '', 0, 'Player for which gossip text is shown has quest Keeper of the Ossuary (72900) active');
+
+-- Senegos smart ai
+SET @ENTRY := 199923;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 0, 0, 1, '', 62, 0, 100, 0, 31093, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 0 from menu 31093 selected - Gossip player: Close gossip'),
+(@ENTRY, 0, 1, 0, '', 61, 0, 100, 0, 0, 0, 0, 0, 85, 405456, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip action 0 from menu 31093 selected - Gossip player: Cast spell 405456 on self');
+
+-- Medic Malorthas smart ai
+SET @ENTRY := 189277;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 0, 0, 0, '', 34, 0, 100, 0, 2, 9, 0, 0, 80, 18927700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 9 - Self: Start timed action list id #Medic Malorthas #0 (18927700) (update out of combat)'),
+(@ENTRY, 0, 1, 0, '', 34, 0, 100, 0, 2, 5, 0, 0, 80, 18927701, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 5 - Self: Start timed action list id #Medic Malorthas #1 (18927701) (update out of combat)');
+
+-- Timed list 18927700 smart ai
+SET @ENTRY := 18927700;
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 9, 0, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 17, 569, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Set emote state to 569'),
+(@ENTRY, 9, 1, 0, '', 0, 0, 100, 0, 19000, 19000, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 19 seconds - Self: Set emote state to 0');
+
+-- Timed list 18927701 smart ai
+SET @ENTRY := 18927701;
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
+(@ENTRY, 9, 0, 0, '', 0, 0, 100, 0, 1000, 1000, 0, 0, 85, 384599, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 1 seconds - Self: Cast spell 384599 on self'),
+(@ENTRY, 9, 1, 0, '', 0, 0, 100, 0, 18000, 18000, 0, 0, 28, 384599, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 18 seconds - Self: Remove aura due to spell  384599');
+
+-- Path for CGUID+2
+SET @ENTRY := 189277;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Comment`) VALUES
+(@PATH, 0, 0, 'Medic Malorthas - Scripted Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, 2970.196, -3146.978, 337.3491, NULL, 0),
+(@PATH, 1, 2970.244, -3150.445, 337.3491, NULL, 0),
+(@PATH, 2, 2971.34, -3153.259, 337.3491, NULL, 0),
+(@PATH, 3, 2974.313, -3154.503, 337.3491, NULL, 0),
+(@PATH, 4, 2976.226, -3154.316, 337.3491, NULL, 0),
+(@PATH, 5, 2977.806, -3149.455, 337.3491, NULL, 20476),
+(@PATH, 6, 2971.992, -3149.818, 337.3491, NULL, 0),
+(@PATH, 7, 2970.576, -3148.351, 337.3491, NULL, 0),
+(@PATH, 8, 2969.841, -3146.045, 337.3491, NULL, 0),
+(@PATH, 9, 2970.019, -3141.945, 337.3491, NULL, 21902);
+
+UPDATE `creature` SET `position_x`= 2970.196, `position_y`= -3146.978, `position_z`= 337.3491, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+2;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+2;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@CGUID+2, @PATH, 1);
+
+-- Vendor data
+DELETE FROM `npc_vendor` WHERE (`entry`=189277 AND `item`=2324 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=2325 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=2604 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=2605 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=4340 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=4341 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=4342 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=6260 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=6261 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=10290 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189277 AND `item`=166422 AND `ExtendedCost`=6418 AND `type`=1) OR (`entry`=189253 AND `item`=173762 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189253 AND `item`=173761 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189253 AND `item`=173760 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=189253 AND `item`=173759 AND `ExtendedCost`=0 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(189277, 23, 2324, 0, 0, 1, 0, 0, 53877), -- Bleach
+(189277, 22, 2325, 0, 0, 1, 0, 0, 53877), -- Black Dye
+(189277, 21, 2604, 0, 0, 1, 0, 0, 53877), -- Red Dye
+(189277, 20, 2605, 0, 0, 1, 0, 0, 53877), -- Green Dye
+(189277, 19, 4340, 0, 0, 1, 0, 0, 53877), -- Gray Dye
+(189277, 18, 4341, 0, 0, 1, 0, 0, 53877), -- Yellow Dye
+(189277, 17, 4342, 0, 0, 1, 0, 0, 53877), -- Purple Dye
+(189277, 16, 6260, 0, 0, 1, 0, 0, 53877), -- Blue Dye
+(189277, 15, 6261, 0, 0, 1, 0, 0, 53877), -- Orange Dye
+(189277, 14, 10290, 0, 0, 1, 0, 0, 53877), -- Pink Dye
+(189277, 13, 7005, 0, 0, 1, 0, 0, 53877), -- Skinning Knife
+(189277, 1, 166422, 0, 6418, 1, 0, 0, 53877), -- Recipe: Silas' Sphere of Transmutation
+(189253, 4, 173762, 0, 0, 1, 0, 0, 53877), -- Flask of Ardendew
+(189253, 3, 173761, 0, 0, 1, 0, 0, 53877), -- Glazed Glowberries
+(189253, 2, 173760, 0, 0, 1, 0, 0, 53877), -- Sylberry Snowcake
+(189253, 1, 173759, 0, 0, 1, 0, 0, 53877); -- Candied Brightbark