Core/Scripts: implement boss Apothecary Hummel ("Love is in the Air" event boss) (#19076)

Closes #5114

(cherrypicked from 8c6fa411e8118752ddbefe8dc022514602859fb9)

4 files changed, 837 insertions, 1 deletions

diff --git a/sql/updates/world/master/2019_08_08_00_world_2017_03_13_00_world.sql b/sql/updates/world/master/2019_08_08_00_world_2017_03_13_00_world.sql
new file mode 100644
index 00000000000..cbbe1c3cc46
--- /dev/null
+++ b/sql/updates/world/master/2019_08_08_00_world_2017_03_13_00_world.sql
@@ -0,0 +1,246 @@
+SET @CGUID := 146562;
+SET @OGUID := 9743;
+
+UPDATE `creature_template` SET `unit_flags`=33280, `ScriptName`='boss_apothecary_hummel', `mechanic_immune_mask`=617297791 WHERE `entry`=36296;
+UPDATE `creature_template` SET `unit_flags`=33280, `ScriptName`='npc_apothecary_baxter', `mechanic_immune_mask`=617297791 WHERE  `entry`=36565;
+UPDATE `creature_template` SET `unit_flags`=33280, `ScriptName`='npc_apothecary_frye', `mechanic_immune_mask`=617297791 WHERE  `entry`=36272;
+UPDATE `creature_template` SET `unit_flags`=33555200 WHERE  `entry` IN(36710,36530);
+UPDATE `gameobject_loot_template` SET `QuestRequired`=0 WHERE `Entry`=28677 and`Item`=49352;
+UPDATE `gameobject_loot_template` SET `QuestRequired`=0 WHERE `Entry`=28678 and`Item`=49351;
+UPDATE `gameobject_template` SET `size`=2 WHERE `entry` IN(202947,202948);
+UPDATE `creature_model_info` SET `BoundingRadius`=0.4596, `CombatReach`=1.8 WHERE `DisplayID`=31167;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.4596, `CombatReach`=1.8 WHERE `DisplayID`=31166;
+
+DELETE FROM `creature_loot_template` WHERE `Entry`=36296 AND `Item`=50250;
+DELETE FROM `item_loot_template` WHERE `Entry`=54537;
+INSERT INTO `item_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(54537, 1, 50010, 20, 0, 1, 0, 1, 1, NULL), -- Necklaces
+(54537, 49927, 0, 100, 0, 1, 0, 5, 10, NULL), -- Love Token
+(54537, 49715, 0, 6, 0, 1, 0, 1, 1, NULL), -- Forever-Lovely Rose
+(54537, 50446, 0, 6, 0, 1, 0, 1, 1, NULL), -- Toxic Wasteling
+(54537, 50741, 0, 6, 0, 1, 0, 1, 1, NULL), -- Vile Fumigator's Mask
+(54537, 50471, 0, 1.1, 0, 1, 0, 1, 1, NULL), -- The Heartbreaker
+(54537, 50250, 0, 0.03, 0, 1, 0, 1, 1, NULL); -- Big Love Rocket
+
+DELETE FROM `gossip_menu_option` WHERE `MenuId` IN(10847);
+INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `VerifiedBuild`) VALUES 
+(10847, 0, 0, "Begin the battle.", 36652, 1, 1, 0);
+
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN(68644,68614,68798);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
+(13,1,68644,0,0,31,0,3,36530,0,0,0,0,'','Spell [DND] Valentine Boss Validate Area targets [DND] Valentine Boss - Vial Bunny'),
+(13,1,68614 ,0,0,31,0,3,36530,0,0,0,0,'','Spell Concentrated Irresistible Cologne Spill targets [DND] Valentine Boss - Vial Bunny'),
+(13,1,68798,0,0,31,0,3,36530,0,0,0,0,'','Spell Concentrated Alluring Perfume Spill targets [DND] Valentine Boss - Vial Bunny');
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (36565,36272,36296,36710);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(36565, 0, 0, 0, 1, 0, '68946 71869'), -- 36565 (Apothecary Baxter) - Irresistible Cologne
+(36272, 0, 0, 0, 1, 0, 68704), -- 36272 (Apothecary Frye) - Lingering Fumes
+(36296, 0, 0, 0, 1, 0, '68589 71856'), -- 36296 (Apothecary Hummel) - Alluring Perfume
+(36710, 0, 0, 0, 1, 0, 69216);
+
+DELETE FROM `creature_summon_groups` WHERE `summonerId`=36296;
+INSERT INTO `creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`) VALUES
+(36296, 0, 1, 36565, -210.3594, 2214.606, 79.84758, 1.047198, 8, 0),
+(36296, 0, 1, 36272, -205.1962, 2214.549, 79.84695, 2.408554, 8, 0);
+
+DELETE FROM `creature_text` WHERE `CreatureID` IN (36296,36272,36565);
+INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES
+(36296,0,0,"Did they bother to tell you who I am and why I am doing this?",12,0,100,6,0,0,38586,3,'SAY_INTRO_0'),
+(36296,1,0,"...or are they just using you like they do everybody else?",12,0,100,396,0,0,38600,3,'SAY_INTRO_1'),
+(36296,2,0,"But what does it matter.  It is time for this to end.",12,0,100,397,0,0,38591,3,'SAY_INTRO_2'),
+(36296,3,0,"Baxter! Get in here and help! NOW!",12,0,100,0,0,0,38592,3,'SAY_CALL_BAXTER'),
+(36296,4,0,"It is time, Frye!  Attack!",12,0,100,0,0,0,38593,3,'SAY_CALL_FRYE'),
+(36296,5,0,"...please don't think less of me.",12,0,100,0,0,0,38597,3,'SAY_HUMMEL_DEATH'),
+(36272,0,0,"Great. We're not gutless, we're incompetent.",12,0,100,0,0,0,38596,3,'SAY_FRYE_DEATH'),
+(36565,0,0,"It has been the greatest honor of my life to serve with you, Hummel.",12,0,100,0,0,0,38595,3,'SAY_BAXTER_DEATH');
+
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN
+('spell_apothecary_validate_area',
+'spell_apothecary_throw_perfume',
+'spell_apothecary_throw_cologne',
+'spell_apothecary_perfume_spill',
+'spell_apothecary_cologne_spill',
+'spell_apothecary_lingering_fumes');
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(68644,'spell_apothecary_validate_area'),
+(68966,'spell_apothecary_throw_perfume'),
+(69038,'spell_apothecary_throw_cologne'),
+(68798,'spell_apothecary_perfume_spill'),
+(68614,'spell_apothecary_cologne_spill'),
+(68965,'spell_apothecary_lingering_fumes');
+
+DELETE FROM `creature` WHERE `guid` IN(208794,208793,208792);
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+62;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+1, 36530, 33, 0, 0, '1,2', 169, 0, 0, -217.8004, 2183.503, 79.8493, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+2, 36530, 33, 0, 0, '1,2', 169, 0, 0, -215.434, 2198.861, 79.84796, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep) (Auras: )
+(@CGUID+3, 36530, 33, 0, 0, '1,2', 169, 0, 0, -195.1233, 2163.059, 79.83028, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+4, 36530, 33, 0, 0, '1,2', 169, 0, 0, -211.0278, 2163.484, 79.84879, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+5, 36530, 33, 0, 0, '1,2', 169, 0, 0, -221.6858, 2179.219, 79.84988, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+6, 36530, 33, 0, 0, '1,2', 169, 0, 0, -219.0313, 2161.661, 79.84821, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+7, 36530, 33, 0, 0, '1,2', 169, 0, 0, -225.2396, 2164.177, 79.84788, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+8, 36530, 33, 0, 0, '1,2', 169, 0, 0, -222.7795, 2172.851, 79.8497, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+9, 36530, 33, 0, 0, '1,2', 169, 0, 0, -222.434, 2209.076, 79.84451, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+10, 36530, 33, 0, 0, '1,2', 169, 0, 0, -202.6493, 2180.49, 79.84853, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+11, 36530, 33, 0, 0, '1,2', 169, 0, 0, -207.9149, 2195.281, 79.84778, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep) (Auras: )
+(@CGUID+12, 36530, 33, 0, 0, '1,2', 169, 0, 0, -205.6806, 2189.316, 79.84862, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+13, 36530, 33, 0, 0, '1,2', 169, 0, 0, -227.2309, 2177.594, 79.85047, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+14, 36530, 33, 0, 0, '1,2', 169, 0, 0, -202.9149, 2198.993, 79.84741, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+15, 36530, 33, 0, 0, '1,2', 169, 0, 0, -202.809, 2168.38, 79.82594, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+16, 36530, 33, 0, 0, '1,2', 169, 0, 0, -220.2379, 2166.99, 79.8491, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+17, 36530, 33, 0, 0, '1,2', 169, 0, 0, -210.7292, 2184.273, 79.84919, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+18, 36530, 33, 0, 0, '1,2', 169, 0, 0, -229.8142, 2170.894, 79.84966, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+19, 36530, 33, 0, 0, '1,2', 169, 0, 0, -212.1701, 2203.293, 79.84724, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+20, 36530, 33, 0, 0, '1,2', 169, 0, 0, -220.1649, 2190.29, 79.84927, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+21, 36530, 33, 0, 0, '1,2', 169, 0, 0, -233.4618, 2165.745, 79.84706, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+22, 36530, 33, 0, 0, '1,2', 169, 0, 0, -213.8142, 2168.231, 79.85005, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+23, 36530, 33, 0, 0, '1,2', 169, 0, 0, -204.2274, 2162.326, 79.84865, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+24, 36530, 33, 0, 0, '1,2', 169, 0, 0, -220.4219, 2203.752, 79.84645, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+25, 36530, 33, 0, 0, '1,2', 169, 0, 0, -213.8663, 2158.241, 79.84741, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+26, 36530, 33, 0, 0, '1,2', 169, 0, 0, -222.0538, 2196.368, 79.84769, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+27, 36530, 33, 0, 0, '1,2', 169, 0, 0, -224.3004, 2186.681, 79.85001, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+28, 36530, 33, 0, 0, '1,2', 169, 0, 0, -216.4531, 2175.7, 79.84973, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+29, 36530, 33, 0, 0, '1,2', 169, 0, 0, -210.349, 2178.34, 79.85, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+30, 36530, 33, 0, 0, '1,2', 169, 0, 0, -196.5052, 2155.45, 79.84718, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+31, 36530, 33, 0, 0, '1,2', 169, 0, 0, -203.6528, 2155.238, 79.84705, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+32, 36530, 33, 0, 0, '1,2', 169, 0, 0, -205.2465, 2204.854, 79.84711, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep) (Auras: )
+(@CGUID+33, 36530, 33, 0, 0, '1,2', 169, 0, 0, -199.9063, 2211.925, 79.84727, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+34, 36530, 33, 0, 0, '1,2', 169, 0, 0, -207.3108, 2212.943, 79.84712, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep) (Auras: )
+(@CGUID+35, 36530, 33, 0, 0, '1,2', 169, 0, 0, -227.6285, 2191.568, 79.84564, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+36, 36530, 33, 0, 0, '1,2', 169, 0, 0, -230.8125, 2185.498, 79.84583, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+37, 36530, 33, 0, 0, '1,2', 169, 0, 0, -225.7795, 2202.889, 79.84396, 4.520403, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+38, 36530, 33, 0, 0, '1,2', 169, 0, 0, -197.2604, 2196.29, 79.84711, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+39, 36530, 33, 0, 0, '1,2', 169, 0, 0, -220.6354, 2222.007, 79.84279, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+40, 36885, 33, 0, 0, '1,2', 169, 0, 0, -226.0851, 2192.799, 79.84625, 3.193953, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Crown Apothecary (Area: Shadowfang Keep)
+(@CGUID+41, 36530, 33, 0, 0, '1,2', 169, 0, 0, -213.9931, 2209.849, 79.84778, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+42, 36530, 33, 0, 0, '1,2', 169, 0, 0, -212.4826, 2216.82, 79.84779, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep) (Auras: )
+(@CGUID+43, 36530, 33, 0, 0, '1,2', 169, 0, 0, -218.3698, 2217.609, 79.84506, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+44, 36530, 33, 0, 0, '1,2', 169, 0, 0, -197.842, 2203.837, 79.84732, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+45, 36530, 33, 0, 0, '1,2', 169, 0, 0, -209.6354, 2172.125, 79.84968, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+46, 36530, 33, 0, 0, '1,2', 169, 0, 0, -210.8316, 2223.722, 79.84461, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+47, 36885, 33, 0, 0, '1,2', 169, 0, 0, -199.8646, 2191.736, 79.84777, 1.117011, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Crown Apothecary (Area: Shadowfang Keep)
+(@CGUID+48, 36530, 33, 0, 0, '1,2', 169, 0, 0, -216.9497, 2225.153, 79.8432, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+49, 36530, 33, 0, 0, '1,2', 169, 0, 0, -198.4549, 2224.262, 79.84032, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+50, 36530, 33, 0, 0, '1,2', 169, 0, 0, -205.0052, 2219.215, 79.84557, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep) (Auras: )
+(@CGUID+51, 36530, 33, 0, 0, '1,2', 169, 0, 0, -182.7292, 2214.054, 79.81828, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+52, 36530, 33, 0, 0, '1,2', 169, 0, 0, -197.1701, 2217.747, 79.84375, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep) (Auras: )
+(@CGUID+53, 36530, 33, 0, 0, '1,2', 169, 0, 0, -191.8281, 2222.58, 79.84315, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+54, 36530, 33, 0, 0, '1,2', 169, 0, 0, -192.2569, 2210.776, 79.84515, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+55, 36530, 33, 0, 0, '1,2', 169, 0, 0, -189.0816, 2216.911, 79.84314, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+56, 23033, 33, 0, 0, '1,2', 169, 0, 0, -224.4688, 2209.684, 80.92682, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Invisible Stalker (Floating) (Area: Shadowfang Keep) (Auras: 57718 - Harpoon Loot Sparkles)
+(@CGUID+57, 23033, 33, 0, 0, '1,2', 169, 0, 0, -224.3663, 2212.083, 80.92657, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Invisible Stalker (Floating) (Area: Shadowfang Keep) (Auras: 57718 - Harpoon Loot Sparkles)
+(@CGUID+58, 36530, 33, 0, 0, '1,2', 169, 0, 0, -204.5729, 2226.901, 79.84293, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+59, 36885, 33, 0, 0, '1,2', 169, 0, 0, -218.0156, 2216.691, 79.84538, 1.989675, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Crown Apothecary (Area: Shadowfang Keep)
+(@CGUID+60, 36530, 33, 0, 0, '1,2', 169, 0, 0, -182.5885, 2219.731, 79.83677, 0, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- [DND] Valentine Boss - Vial Bunny (Area: Shadowfang Keep)
+(@CGUID+61, 36296, 33, 0, 0, '1,2', 169, 0, 0, -208.0903, 2217.389, 79.84693, 4.817109, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420), -- Apothecary Hummel (Area: Shadowfang Keep) (Auras: 68589 - Alluring Perfume)
+(@CGUID+62, 36885, 33, 0, 0, '1,2', 169, 0, 0, -225.9896, 2235.528, 79.8619, 5.183628, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 23420); -- Crown Apothecary (Area: Shadowfang Keep)
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+94;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(@OGUID+0, 201906, 33, 0, 0, '1,2', 169, -201.7951, 2162.818, 79.76379, 2.042035, 0, 0, 0.8526402, 0.5224986, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+1, 201289, 33, 0, 0, '1,2', 169, -203.3629, 2178.462, 79.76537, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Duskwood Table (Area: Shadowfang Keep)
+(@OGUID+2, 202105, 33, 0, 0, '1,2', 169, -227.7379, 2168.457, 79.76581, 4.049168, 0, 0, -0.8987932, 0.4383728, 7200, 255, 1, 23420), -- Plague Wagon Empty (Area: Shadowfang Keep)
+(@OGUID+3, 200300, 33, 0, 0, '1,2', 169, -228.7326, 2192.905, 79.76138, 4.468043, 0, 0, -0.7880106, 0.6156617, 7200, 255, 1, 23420), -- Generic Cage Top (Area: Shadowfang Keep)
+(@OGUID+4, 200300, 33, 0, 0, '1,2', 169, -228.1163, 2194.755, 82.49375, 4.81711, 0, 0, -0.6691303, 0.743145, 7200, 255, 1, 23420), -- Generic Cage Top (Area: Shadowfang Keep)
+(@OGUID+5, 200332, 33, 0, 0, '1,2', 169, -228.8524, 2192.884, 79.76133, 4.468043, 0, 0, -0.7880106, 0.6156617, 7200, 255, 1, 23420), -- Generic Cage Bottom (Area: Shadowfang Keep)
+(@OGUID+6, 200332, 33, 0, 0, '1,2', 169, -228.2222, 2194.695, 82.49368, 4.834563, 0, 0, -0.6626196, 0.7489561, 7200, 255, 1, 23420), -- Generic Cage Bottom (Area: Shadowfang Keep)
+(@OGUID+7, 200337, 33, 0, 0, '1,2', 169, -218.9306, 2221.089, 80.72054, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+8, 200338, 33, 0, 0, '1,2', 169, -195.7413, 2204.79, 81.76898, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel Empty (Area: Shadowfang Keep)
+(@OGUID+9, 202948, 33, 0, 0, '1,2', 169, -224.0781, 2211.082, 81.02744, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+10, 200337, 33, 0, 0, '1,2', 169, -215.6319, 2219.208, 79.76243, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+11, 200338, 33, 0, 0, '1,2', 169, -195.2205, 2204.566, 80.72088, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel Empty (Area: Shadowfang Keep)
+(@OGUID+12, 181018, 33, 0, 0, '1,2', 169, -159.2257, 2167.594, 132.2321, 0.4014249, 0, 0, 0.1993675, 0.9799248, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+13, 200332, 33, 0, 0, '1,2', 169, -227.8316, 2197.056, 79.7609, 4.485497, 0, 0, -0.782608, 0.6225148, 7200, 255, 1, 23420), -- Generic Cage Bottom (Area: Shadowfang Keep)
+(@OGUID+14, 202948, 33, 0, 0, '1,2', 169, -224.0781, 2211.082, 81.02744, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+15, 202948, 33, 0, 0, '1,2', 169, -224.3629, 2211.849, 81.03157, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+16, 202947, 33, 0, 0, '1,2', 169, -224.7431, 2209.16, 81.01423, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+17, 202948, 33, 0, 0, '1,2', 169, -224.0781, 2211.082, 81.02744, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+18, 202947, 33, 0, 0, '1,2', 169, -224.6076, 2210.144, 81.01418, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+19, 202948, 33, 0, 0, '1,2', 169, -224.0781, 2211.082, 81.02744, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+20, 200334, 33, 0, 0, '1,2', 169, -203.4306, 2178.222, 81.05308, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Holiday - Valentine - Shadowfang Keep - Chemistry Set 03 (Area: Shadowfang Keep)
+(@OGUID+21, 181018, 33, 0, 0, '1,2', 169, -140.8611, 2160.24, 131.9547, 1.867502, 0, 0, 0.8038568, 0.5948228, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+22, 201906, 33, 0, 0, '1,2', 169, -201.8177, 2165.144, 80.67925, 1.378809, 0, 0, 0.6360779, 0.7716249, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+23, 200300, 33, 0, 0, '1,2', 169, -227.7118, 2197.076, 79.76096, 4.468043, 0, 0, -0.7880106, 0.6156617, 7200, 255, 1, 23420), -- Generic Cage Top (Area: Shadowfang Keep)
+(@OGUID+24, 201906, 33, 0, 0, '1,2', 169, -201.0556, 2165.413, 80.67633, 0.6806767, 0, 0, 0.333806, 0.9426418, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+25, 202947, 33, 0, 0, '1,2', 169, -224.7431, 2209.16, 81.01423, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+26, 202948, 33, 0, 0, '1,2', 169, -224.3629, 2211.849, 81.03157, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+27, 202947, 33, 0, 0, '1,2', 169, -224.1024, 2209.566, 81.01447, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+28, 201906, 33, 0, 0, '1,2', 169, -199.1372, 2165.321, 80.66892, 2.042035, 0, 0, 0.8526402, 0.5224986, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+29, 200337, 33, 0, 0, '1,2', 169, -223.2101, 2215.07, 80.9929, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+30, 202948, 33, 0, 0, '1,2', 169, -224.8333, 2210.943, 81.057, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+31, 200338, 33, 0, 0, '1,2', 169, -196.9358, 2191.941, 79.75, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel Empty (Area: Shadowfang Keep)
+(@OGUID+32, 181060, 33, 0, 0, '1,2', 169, -266.908, 2297.325, 77.52528, 5.916668, 0, 0, -0.1822348, 0.983255, 7200, 255, 1, 23420), -- Standing, Interior, Small - Val (Area: Shadowfang Keep)
+(@OGUID+33, 181018, 33, 0, 0, '1,2', 169, -260.8195, 2304.193, 82.19453, 4.380776, 0, 0, -0.8141155, 0.580703, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+34, 201906, 33, 0, 0, '1,2', 169, -199.8524, 2164.865, 80.67292, 3.089183, 0, 0, 0.9996567, 0.02620165, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+35, 202948, 33, 0, 0, '1,2', 169, -224.0781, 2211.082, 81.02744, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+36, 202947, 33, 0, 0, '1,2', 169, -224.6076, 2210.144, 81.01418, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+37, 200336, 33, 0, 0, '1,2', 169, -196.0365, 2203.82, 79.76387, 1.239183, 0, 0, 0.5807028, 0.8141156, 7200, 255, 1, 23420), -- Forsaken Wagon (Area: Shadowfang Keep)
+(@OGUID+38, 200337, 33, 0, 0, '1,2', 169, -218.1319, 2218.642, 80.7216, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+39, 200338, 33, 0, 0, '1,2', 169, -196.0087, 2204.844, 80.7224, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel Empty (Area: Shadowfang Keep)
+(@OGUID+40, 200338, 33, 0, 0, '1,2', 169, -196.8646, 2192.993, 79.75895, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel Empty (Area: Shadowfang Keep)
+(@OGUID+41, 201906, 33, 0, 0, '1,2', 169, -199.467, 2166.151, 80.66539, 0.1745321, 0, 0, 0.08715534, 0.9961947, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+42, 200337, 33, 0, 0, '1,2', 169, -217.4688, 2219.5, 80.72163, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+43, 201906, 33, 0, 0, '1,2', 169, -200.3385, 2165.795, 80.67102, 5.637414, 0, 0, -0.3173046, 0.9483237, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+44, 200338, 33, 0, 0, '1,2', 169, -196.7326, 2202.128, 80.57761, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel Empty (Area: Shadowfang Keep)
+(@OGUID+45, 181060, 33, 0, 0, '1,2', 169, -251.6024, 2289.042, 76.31879, 4.24115, 0, 0, -0.8526402, 0.5224986, 7200, 255, 1, 23420), -- Standing, Interior, Small - Val (Area: Shadowfang Keep)
+(@OGUID+46, 201906, 33, 0, 0, '1,2', 169, -200.5243, 2164.542, 80.67728, 0.1745321, 0, 0, 0.08715534, 0.9961947, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+47, 200338, 33, 0, 0, '1,2', 169, -198.3958, 2201.861, 79.76396, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel Empty (Area: Shadowfang Keep)
+(@OGUID+48, 202947, 33, 0, 0, '1,2', 169, -224.6076, 2210.144, 81.01418, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+49, 202948, 33, 0, 0, '1,2', 169, -224.0781, 2211.082, 81.02744, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+50, 201289, 33, 0, 0, '1,2', 169, -224.6476, 2210.903, 79.75954, 6.108654, 0, 0, -0.08715534, 0.9961947, 7200, 255, 1, 23420), -- Duskwood Table (Area: Shadowfang Keep)
+(@OGUID+51, 201289, 33, 0, 0, '1,2', 169, -223.4531, 2215.885, 79.75977, 6.056293, 0, 0, -0.113203, 0.9935719, 7200, 255, 1, 23420), -- Duskwood Table (Area: Shadowfang Keep)
+(@OGUID+52, 200337, 33, 0, 0, '1,2', 169, -218.7031, 2219.253, 80.72117, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+53, 201906, 33, 0, 0, '1,2', 169, -200.9115, 2162.441, 79.7639, 2.042035, 0, 0, 0.8526402, 0.5224986, 7200, 255, 1, 23420), -- Rocket Delivery System (Area: Shadowfang Keep)
+(@OGUID+54, 200336, 33, 0, 0, '1,2', 169, -218.6736, 2220.03, 79.76088, 2.321287, 0, 0, 0.9170599, 0.3987495, 7200, 255, 1, 23420), -- Forsaken Wagon (Area: Shadowfang Keep)
+(@OGUID+55, 202947, 33, 0, 0, '1,2', 169, -225.3524, 2209.576, 81.01386, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+56, 200335, 33, 0, 0, '1,2', 169, -196.5556, 2195.776, 79.76373, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Holiday - Valentine - Shadowfang Keep - Chemistry Set 04 (Area: Shadowfang Keep)
+(@OGUID+57, 202948, 33, 0, 0, '1,2', 169, -225.1597, 2211.516, 81.02943, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+58, 190678, 33, 0, 0, '1,2', 169, -222.5504, 2206.359, 81.06857, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Apothecary Vials and Bottles (Area: Shadowfang Keep)
+(@OGUID+59, 201289, 33, 0, 0, '1,2', 169, -222.8229, 2206.047, 79.7614, 0.383971, 0, 0, 0.1908083, 0.9816273, 7200, 255, 1, 23420), -- Duskwood Table (Area: Shadowfang Keep)
+(@OGUID+60, 200336, 33, 0, 0, '1,2', 169, -200.2153, 2165.316, 79.74786, 0.4537851, 0, 0, 0.2249508, 0.9743701, 7200, 255, 1, 23420), -- Forsaken Wagon (Area: Shadowfang Keep)
+(@OGUID+61, 202947, 33, 0, 0, '1,2', 169, -225.2222, 2210.189, 81.01381, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+62, 200337, 33, 0, 0, '1,2', 169, -219.0417, 2219.865, 80.72085, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+64, 200337, 33, 0, 0, '1,2', 169, -219.5017, 2219.882, 81.85169, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+65, 202948, 33, 0, 0, '1,2', 169, -223.7014, 2212.127, 81.05749, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+66, 200338, 33, 0, 0, '1,2', 169, -197.9375, 2192.507, 79.76409, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel Empty (Area: Shadowfang Keep)
+(@OGUID+67, 200333, 33, 0, 0, '1,2', 169, -194.8038, 2199.302, 79.76308, 3.281239, 0, 0, -0.9975634, 0.06976615, 7200, 255, 1, 23420), -- Holiday - Valentine - Shadowfang Keep - Chemistry Set 02 (Area: Shadowfang Keep)
+(@OGUID+68, 200337, 33, 0, 0, '1,2', 169, -218.3299, 2220.42, 80.72099, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+70, 200337, 33, 0, 0, '1,2', 169, -219.6823, 2220.344, 80.72044, 0, 0, 0, 0, 1, 7200, 255, 1, 23420), -- Forsaken Plague Barrel (Area: Shadowfang Keep)
+(@OGUID+71, 181018, 33, 0, 0, '1,2', 169, -233.5365, 2268.826, 82.17297, 1.117009, 0, 0, 0.5299187, 0.8480484, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+72, 181018, 33, 0, 0, '1,2', 169, -151.8785, 2185.76, 132.1955, 5.044002, 0, 0, -0.5807028, 0.8141156, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+73, 181018, 33, 0, 0, '1,2', 169, -245.5087, 2273.543, 82.16793, 1.134463, 0, 0, 0.5372992, 0.8433917, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+74, 181018, 33, 0, 0, '1,2', 169, -275.0781, 2302.974, 82.48224, 5.829401, 0, 0, -0.2249508, 0.9743701, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+75, 181018, 33, 0, 0, '1,2', 169, -257.375, 2278.217, 82.14223, 1.291542, 0, 0, 0.6018143, 0.7986361, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+76, 181018, 33, 0, 0, '1,2', 169, -133.6927, 2178.62, 132.1656, 3.403396, 0, 0, -0.9914446, 0.1305283, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+77, 181060, 33, 0, 0, '1,2', 169, -245.2118, 2284.845, 76.36433, 4.24115, 0, 0, -0.8526402, 0.5224986, 7200, 255, 1, 23420), -- Standing, Interior, Small - Val (Area: Shadowfang Keep)
+(@OGUID+78, 181019, 33, 0, 0, '1,2', 169, -244.9879, 2285.457, 76.32001, 5.916668, 0, 0, -0.1822348, 0.983255, 7200, 255, 1, 23420), -- Standing, Interior, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+79, 181060, 33, 0, 0, '1,2', 169, -237.1285, 2281.804, 76.31394, 4.24115, 0, 0, -0.8526402, 0.5224986, 7200, 255, 1, 23420), -- Standing, Interior, Small - Val (Area: Shadowfang Keep)
+(@OGUID+80, 181019, 33, 0, 0, '1,2', 169, -236.8455, 2282.424, 76.27265, 0.6283169, 0, 0, 0.3090162, 0.9510568, 7200, 255, 1, 23420), -- Standing, Interior, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+81, 181060, 33, 0, 0, '1,2', 169, -244.6962, 2286.151, 76.26979, 4.24115, 0, 0, -0.8526402, 0.5224986, 7200, 255, 1, 23420), -- Standing, Interior, Small - Val (Area: Shadowfang Keep)
+(@OGUID+82, 181060, 33, 0, 0, '1,2', 169, -236.6094, 2283.007, 76.26243, 4.24115, 0, 0, -0.8526402, 0.5224986, 7200, 255, 1, 23420), -- Standing, Interior, Small - Val (Area: Shadowfang Keep)
+(@OGUID+83, 181060, 33, 0, 0, '1,2', 169, -252.1007, 2287.615, 76.33432, 4.433136, 0, 0, -0.7986355, 0.601815, 7200, 255, 1, 23420), -- Standing, Interior, Small - Val (Area: Shadowfang Keep)
+(@OGUID+84, 181018, 33, 0, 0, '1,2', 169, -269.25, 2282.983, 82.28855, 1.239183, 0, 0, 0.5807028, 0.8141156, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+85, 202948, 33, 0, 0, '1,2', 169, -224.3629, 2211.849, 81.03157, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+86, 181060, 33, 0, 0, '1,2', 169, -268.9601, 2291.799, 77.44312, 5.899214, 0, 0, -0.1908083, 0.9816273, 7200, 255, 1, 23420), -- Standing, Interior, Small - Val (Area: Shadowfang Keep)
+(@OGUID+87, 202948, 33, 0, 0, '1,2', 169, -224.3629, 2211.849, 81.03157, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Perfume Neutralizer (Area: Shadowfang Keep)
+(@OGUID+88, 181018, 33, 0, 0, '1,2', 169, -237.1163, 2294.856, 82.21571, 4.380776, 0, 0, -0.8141155, 0.580703, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+89, 181018, 33, 0, 0, '1,2', 169, -278.7431, 2293.672, 82.41619, 5.899214, 0, 0, -0.1908083, 0.9816273, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+90, 202947, 33, 0, 0, '1,2', 169, -224.7431, 2209.16, 81.01423, 0, 0, 0, 0, 1, 5, 255, 1, 23420), -- Cologne Neutralizer (Area: Shadowfang Keep)
+(@OGUID+91, 181019, 33, 0, 0, '1,2', 169, -251.8576, 2288.427, 76.32627, 0.6283169, 0, 0, 0.3090162, 0.9510568, 7200, 255, 1, 23420), -- Standing, Interior, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+92, 181018, 33, 0, 0, '1,2', 169, -225.1146, 2290.128, 82.15984, 4.380776, 0, 0, -0.8141155, 0.580703, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+93, 181018, 33, 0, 0, '1,2', 169, -248.9913, 2299.535, 82.2632, 4.380776, 0, 0, -0.8141155, 0.580703, 7200, 255, 1, 23420), -- Hanging, Tall/Thin, Medium - Val (Area: Shadowfang Keep)
+(@OGUID+94, 181019, 33, 0, 0, '1,2', 169, -268.6615, 2295.618, 77.50943, 0.6283169, 0, 0, 0.3090162, 0.9510568, 7200, 255, 1, 23420); -- Standing, Interior, Medium - Val (Area: Shadowfang Keep)
+
+DELETE FROM `game_event_creature` WHERE `guid` IN(208792,208793,208794);
+DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+62 AND `eventEntry`=8;
+INSERT INTO `game_event_creature` SELECT 8, creature.guid FROM `creature` WHERE creature.guid BETWEEN @CGUID+0 AND @CGUID+14;
+
+DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+94 AND `eventEntry`=8;
+INSERT INTO `game_event_gameobject` SELECT 8, creature.guid FROM `creature` WHERE creature.guid BETWEEN @CGUID+0 AND @CGUID+14;
+
+DELETE FROM `creature_addon` WHERE `guid` IN (@CGUID+56,@CGUID+57);
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(@CGUID+56, 0, 0, 0, 1, 0, 57718), -- 23033 (Invisible Stalker (Floating))
+(@CGUID+57, 0, 0, 0, 1, 0, 57718); -- 23033 (Invisible Stalker (Floating))
diff --git a/src/server/scripts/EasternKingdoms/ShadowfangKeep/boss_apothecary_hummel.cpp b/src/server/scripts/EasternKingdoms/ShadowfangKeep/boss_apothecary_hummel.cpp
new file mode 100644
index 00000000000..53fa4f340c0
--- /dev/null
+++ b/src/server/scripts/EasternKingdoms/ShadowfangKeep/boss_apothecary_hummel.cpp
@@ -0,0 +1,587 @@
+/*
+ * Copyright (C) 2008-2017 TrinityCore <http://www.trinitycore.org/>
+ *
+ * This program is free software; you can redistribute it and/or modify it
+ * under the terms of the GNU General Public License as published by the
+ * Free Software Foundation; either version 2 of the License, or (at your
+ * option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful, but WITHOUT
+ * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
+ * FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
+ * more details.
+ *
+ * You should have received a copy of the GNU General Public License along
+ * with this program. If not, see <http://www.gnu.org/licenses/>.
+ */
+
+#include "ScriptMgr.h"
+#include "ScriptedCreature.h"
+#include "ScriptedGossip.h"
+#include "LFGMgr.h"
+#include "Player.h"
+#include "Group.h"
+#include "SpellScript.h"
+#include "SpellAuraEffects.h"
+#include "shadowfang_keep.h"
+#include "GridNotifiersImpl.h"
+
+enum ApothecarySpells
+{
+    SPELL_ALLURING_PERFUME       = 68589,
+    SPELL_PERFUME_SPRAY          = 68607,
+    SPELL_CHAIN_REACTION         = 68821,
+    SPELL_SUMMON_TABLE           = 69218,
+    SPELL_PERMANENT_FEIGN_DEATH  = 29266,
+    SPELL_QUIET_SUICIDE          = 3617,
+    SPELL_COLOGNE_SPRAY          = 68948,
+    SPELL_VALIDATE_AREA          = 68644,
+    SPELL_THROW_COLOGNE          = 68841,
+    SPELL_BUNNY_LOCKDOWN         = 69039,
+    SPELL_THROW_PERFUME          = 68799,
+    SPELL_PERFUME_SPILL          = 68798,
+    SPELL_COLOGNE_SPILL          = 68614,
+    SPELL_PERFUME_SPILL_DAMAGE   = 68927,
+    SPELL_COLOGNE_SPILL_DAMAGE   = 68934
+};
+
+enum ApothecarySays
+{
+    SAY_INTRO_0      = 0,
+    SAY_INTRO_1      = 1,
+    SAY_INTRO_2      = 2,
+    SAY_CALL_BAXTER  = 3,
+    SAY_CALL_FRYE    = 4,
+    SAY_HUMMEL_DEATH = 5,
+    SAY_BAXTER_DEATH = 0,
+    SAY_FRYE_DEATH   = 0
+};
+
+enum ApothecaryEvents
+{
+    EVENT_HUMMEL_SAY_0 = 1,
+    EVENT_HUMMEL_SAY_1,
+    EVENT_HUMMEL_SAY_2,
+    EVENT_START_FIGHT,
+    EVENT_CHAIN_REACTION,
+    EVENT_PERFUME_SPRAY,
+    EVENT_COLOGNE_SPRAY,
+    EVENT_CALL_BAXTER,
+    EVENT_CALL_FRYE
+};
+
+enum ApothecaryMisc
+{
+    ACTION_START_EVENT          = 1,
+    ACTION_START_FIGHT          = 2,
+    FACTION_APOTHECARY_HOSTILE  = 14,
+    FACTION_APOTHECARY_FRIENDLY = 35,
+    GOSSIP_OPTION_START         = 0,
+    GOSSIP_MENU_HUMMEL          = 10847,
+    QUEST_YOUVE_BEEN_SERVED     = 14488,
+    NPC_APOTHECARY_FRYE         = 36272,
+    NPC_APOTHECARY_BAXTER       = 36565,
+    NPC_VIAL_BUNNY              = 36530,
+    NPC_CROWN_APOTHECARY        = 36885,
+    PHASE_ALL                   = 0,
+    PHASE_INTRO                 = 1
+};
+
+Position const BaxterMovePos = { -221.4115f, 2206.825f, 79.93151f, 0.0f };
+Position const FryeMovePos = { -196.2483f, 2197.224f, 79.9315f, 0.0f };
+
+class boss_apothecary_hummel : public CreatureScript
+{
+    public:
+        boss_apothecary_hummel() : CreatureScript("boss_apothecary_hummel") { }
+
+        struct boss_apothecary_hummelAI : public BossAI
+        {
+            boss_apothecary_hummelAI(Creature* creature) : BossAI(creature, DATA_APOTHECARY_HUMMEL), _deadCount(0), _isDead(false) { }
+
+            void sGossipSelect(Player* player, uint32 menuId, uint32 gossipListId) override
+            {
+                if (menuId == GOSSIP_MENU_HUMMEL && gossipListId == GOSSIP_OPTION_START)
+                {
+                    me->RemoveNpcFlag(UNIT_NPC_FLAG_GOSSIP);
+                    CloseGossipMenuFor(player);
+                    DoAction(ACTION_START_EVENT);
+                }
+            }
+
+            void Reset() override
+            {
+                _Reset();
+                _deadCount = 0;
+                _isDead = false;
+                events.SetPhase(PHASE_ALL);
+                me->setFaction(FACTION_APOTHECARY_FRIENDLY);
+                me->SummonCreatureGroup(1);
+            }
+
+            void EnterEvadeMode(EvadeReason /*why*/) override
+            {
+                summons.DespawnAll();
+                _EnterEvadeMode();
+                _DespawnAtEvade(Seconds(10));
+            }
+
+            void DoAction(int32 action) override
+            {
+                if (action == ACTION_START_EVENT && events.IsInPhase(PHASE_ALL))
+                {
+                    events.SetPhase(PHASE_INTRO);
+                    events.ScheduleEvent(EVENT_HUMMEL_SAY_0, Milliseconds(1));
+
+                    me->AddUnitFlag(UNIT_FLAG_IMMUNE_TO_PC);
+                    me->setFaction(FACTION_APOTHECARY_HOSTILE);
+                    DummyEntryCheckPredicate pred;
+                    summons.DoAction(ACTION_START_EVENT, pred);
+                }
+            }
+
+            void DamageTaken(Unit* /*attacker*/, uint32& damage) override
+            {
+                if (damage >= me->GetHealth())
+                    if (_deadCount < 2)
+                    {
+                        damage = me->GetHealth() - 1;
+                        if (!_isDead)
+                        {
+                            _isDead = true;
+                            me->RemoveAurasDueToSpell(SPELL_ALLURING_PERFUME);
+                            DoCastSelf(SPELL_PERMANENT_FEIGN_DEATH, true);
+                            me->AddUnitFlag(UNIT_FLAG_UNK_29);
+                            me->AddUnitFlag(UNIT_FLAG_NOT_SELECTABLE);
+                            Talk(SAY_HUMMEL_DEATH);
+                        }
+                    }
+            }
+
+            void SummonedCreatureDies(Creature* summon, Unit* /*killer*/) override
+            {
+                if (summon->GetEntry() == NPC_APOTHECARY_FRYE || summon->GetEntry() == NPC_APOTHECARY_BAXTER)
+                    _deadCount++;
+
+                if (me->HasAura(SPELL_PERMANENT_FEIGN_DEATH) && _deadCount == 2)
+                    DoCastSelf(SPELL_QUIET_SUICIDE, true);
+            }
+
+            void JustDied(Unit* /*killer*/) override
+            {
+                if (!_isDead)
+                    Talk(SAY_HUMMEL_DEATH);
+
+                events.Reset();
+                me->RemoveUnitFlag(UNIT_FLAG_UNK_29);
+                me->RemoveUnitFlag(UNIT_FLAG_NOT_SELECTABLE);
+                instance->SetBossState(DATA_APOTHECARY_HUMMEL, DONE);
+
+                Map::PlayerList const& players = me->GetMap()->GetPlayers();
+                if (!players.isEmpty())
+                {
+                    if (Group* group = players.begin()->GetSource()->GetGroup())
+                        if (group->isLFGGroup())
+                            sLFGMgr->FinishDungeon(group->GetGUID(), 288, me->GetMap());
+                }
+            }
+
+            void UpdateAI(uint32 diff) override
+            {
+                if (!UpdateVictim() && !events.IsInPhase(PHASE_INTRO))
+                    return;
+
+                events.Update(diff);
+
+                if (me->HasUnitState(UNIT_STATE_CASTING))
+                    return;
+
+                while (uint32 eventId = events.ExecuteEvent())
+                {
+                    switch (eventId)
+                    {
+                        case EVENT_HUMMEL_SAY_0:
+                            Talk(SAY_INTRO_0);
+                            events.ScheduleEvent(EVENT_HUMMEL_SAY_1, Seconds(4));
+                            break;
+                        case EVENT_HUMMEL_SAY_1:
+                            Talk(SAY_INTRO_1);
+                            events.ScheduleEvent(EVENT_HUMMEL_SAY_2, Seconds(4));
+                            break;
+                        case EVENT_HUMMEL_SAY_2:
+                            Talk(SAY_INTRO_2);
+                            events.ScheduleEvent(EVENT_START_FIGHT, Seconds(4));
+                            break;
+                        case EVENT_START_FIGHT:
+                        {
+                            me->RemoveUnitFlag(UNIT_FLAG_IMMUNE_TO_PC);
+                            me->RemoveUnitFlag(UNIT_FLAG_IMMUNE_TO_NPC);
+                            me->SetInCombatWithZone();
+                            events.ScheduleEvent(EVENT_CALL_BAXTER, Seconds(6));
+                            events.ScheduleEvent(EVENT_CALL_FRYE, Seconds(14));
+                            events.ScheduleEvent(EVENT_PERFUME_SPRAY, Milliseconds(3640));
+                            events.ScheduleEvent(EVENT_CHAIN_REACTION, Seconds(15));
+
+                            std::vector<Creature*> trashs;
+                            me->GetCreatureListWithEntryInGrid(trashs, NPC_CROWN_APOTHECARY);
+                            for (Creature* crea : trashs)
+                                crea->DespawnOrUnsummon();
+
+                            break;
+                        }
+                        case EVENT_CALL_BAXTER:
+                        {
+                            Talk(SAY_CALL_BAXTER);
+                            EntryCheckPredicate pred(NPC_APOTHECARY_BAXTER);
+                            summons.DoAction(ACTION_START_FIGHT, pred);
+                            summons.DoZoneInCombat(NPC_APOTHECARY_BAXTER);
+                            break;
+                        }
+                        case EVENT_CALL_FRYE:
+                        {
+                            Talk(SAY_CALL_FRYE);
+                            EntryCheckPredicate pred(NPC_APOTHECARY_FRYE);
+                            summons.DoAction(ACTION_START_FIGHT, pred);
+                            break;
+                        }
+                        case EVENT_PERFUME_SPRAY:
+                            DoCastVictim(SPELL_PERFUME_SPRAY);
+                            events.Repeat(Milliseconds(3640));
+                            break;
+                        case EVENT_CHAIN_REACTION:
+                            DoCastVictim(SPELL_SUMMON_TABLE, true);
+                            DoCastAOE(SPELL_CHAIN_REACTION);
+                            events.Repeat(Seconds(25));
+                            break;
+                        default:
+                            break;
+                    }
+
+                    if (me->HasUnitState(UNIT_STATE_CASTING))
+                        return;
+                }
+
+                DoMeleeAttackIfReady();
+            }
+
+            private:
+                uint8 _deadCount;
+                bool _isDead;
+        };
+
+        bool OnQuestReward(Player* /*player*/, Creature* creature, Quest const* quest, uint32 /*opt*/) override
+        {
+            if (quest->GetQuestId() == QUEST_YOUVE_BEEN_SERVED)
+                creature->AI()->DoAction(ACTION_START_EVENT);
+
+            return true;
+        }
+};
+
+struct npc_apothecary_genericAI : public ScriptedAI
+{
+    npc_apothecary_genericAI(Creature* creature, Position pos) : ScriptedAI(creature), _movePos(pos) { }
+
+    void DoAction(int32 action) override
+    {
+        if (action == ACTION_START_EVENT)
+        {
+            me->AddUnitFlag(UNIT_FLAG_IMMUNE_TO_PC);
+            me->setFaction(FACTION_APOTHECARY_HOSTILE);
+            me->GetMotionMaster()->MovePoint(1, _movePos);
+        }
+        else if (action == ACTION_START_FIGHT)
+        {
+            me->RemoveUnitFlag(UNIT_FLAG_IMMUNE_TO_PC);
+            me->RemoveUnitFlag(UNIT_FLAG_IMMUNE_TO_NPC);
+            me->SetInCombatWithZone();
+        }
+    }
+
+    void MovementInform(uint32 type, uint32 pointId) override
+    {
+        if (type == POINT_MOTION_TYPE && pointId == 1)
+            me->SetEmoteState(EMOTE_STATE_USE_STANDING);
+    }
+
+protected:
+    Position _movePos;
+};
+
+class npc_apothecary_frye : public CreatureScript
+{
+    public:
+        npc_apothecary_frye() : CreatureScript("npc_apothecary_frye") { }
+
+        struct npc_apothecary_fryeAI : public npc_apothecary_genericAI
+        {
+            npc_apothecary_fryeAI(Creature* creature) : npc_apothecary_genericAI(creature, FryeMovePos) { }
+
+            void JustDied(Unit* /*who*/) override
+            {
+                Talk(SAY_FRYE_DEATH);
+            }
+        };
+};
+
+class npc_apothecary_baxter : public CreatureScript
+{
+    public:
+        npc_apothecary_baxter() : CreatureScript("npc_apothecary_baxter") { }
+
+        struct npc_apothecary_baxterAI : public npc_apothecary_genericAI
+        {
+            npc_apothecary_baxterAI(Creature* creature) : npc_apothecary_genericAI(creature, BaxterMovePos) { }
+
+            void Reset() override
+            {
+                _events.Reset();
+                _events.ScheduleEvent(EVENT_COLOGNE_SPRAY, Seconds(7));
+                _events.ScheduleEvent(EVENT_CHAIN_REACTION, Seconds(12));
+            }
+
+            void JustDied(Unit* /*who*/) override
+            {
+                _events.Reset();
+                Talk(SAY_BAXTER_DEATH);
+            }
+
+            void UpdateAI(uint32 diff) override
+            {
+                if (!UpdateVictim())
+                    return;
+
+                _events.Update(diff);
+
+                if (me->HasUnitState(UNIT_STATE_CASTING))
+                    return;
+
+                while (uint32 eventId = _events.ExecuteEvent())
+                {
+                    switch (eventId)
+                    {
+                        case EVENT_COLOGNE_SPRAY:
+                            DoCastVictim(SPELL_COLOGNE_SPRAY);
+                            _events.Repeat(Seconds(4));
+                            break;
+                        case EVENT_CHAIN_REACTION:
+                            DoCastVictim(SPELL_SUMMON_TABLE);
+                            DoCastVictim(SPELL_CHAIN_REACTION);
+                            _events.Repeat(Seconds(25));
+                            break;
+                        default:
+                            break;
+                    }
+                }
+
+                DoMeleeAttackIfReady();
+            }
+
+        private:
+            EventMap _events;
+        };
+};
+
+// 68965 -[DND] Lingering Fumes Targetting (starter)
+class spell_apothecary_lingering_fumes : public SpellScriptLoader
+{
+    public:
+        spell_apothecary_lingering_fumes() : SpellScriptLoader("spell_apothecary_lingering_fumes") { }
+
+        class spell_apothecary_lingering_fumes_SpellScript : public SpellScript
+        {
+            PrepareSpellScript(spell_apothecary_lingering_fumes_SpellScript);
+
+            void HandleAfterCast()
+            {
+                Unit* caster = GetCaster();
+                if (!caster->IsInCombat() || roll_chance_i(50))
+                    return;
+
+                std::list<Creature*> triggers;
+                caster->GetCreatureListWithEntryInGrid(triggers, NPC_VIAL_BUNNY, 100.0f);
+                Creature* trigger = Trinity::Containers::SelectRandomContainerElement(triggers);
+                caster->GetMotionMaster()->MovePoint(0, trigger->GetPosition());
+
+            }
+
+            void HandleScript(SpellEffIndex /*effindex*/)
+            {
+                Unit* caster = GetCaster();
+                caster->CastSpell(GetHitUnit(), SPELL_VALIDATE_AREA, true);
+            }
+
+            void Register() override
+            {
+                AfterCast += SpellCastFn(spell_apothecary_lingering_fumes_SpellScript::HandleAfterCast);
+                OnEffectHitTarget += SpellEffectFn(spell_apothecary_lingering_fumes_SpellScript::HandleScript, EFFECT_0, SPELL_EFFECT_DUMMY);
+            }
+        };
+
+        SpellScript* GetSpellScript() const override
+        {
+            return new spell_apothecary_lingering_fumes_SpellScript();
+        }
+};
+
+// 68644 - [DND] Valentine Boss Validate Area
+class spell_apothecary_validate_area : public SpellScriptLoader
+{
+    public:
+        spell_apothecary_validate_area() : SpellScriptLoader("spell_apothecary_validate_area") { }
+
+        class spell_apothecary_validate_area_SpellScript : public SpellScript
+        {
+            PrepareSpellScript(spell_apothecary_validate_area_SpellScript);
+
+            void FilterTargets(std::list<WorldObject*>& targets)
+            {
+                targets.remove_if(Trinity::UnitAuraCheck(true, SPELL_BUNNY_LOCKDOWN));
+                if (targets.empty())
+                    return;
+
+                WorldObject* target = Trinity::Containers::SelectRandomContainerElement(targets);
+                targets.clear();
+                targets.push_back(target);
+            }
+
+
+            void HandleScript(SpellEffIndex /*effindex*/)
+            {
+                GetHitUnit()->CastSpell(GetHitUnit(), SPELL_BUNNY_LOCKDOWN, true);
+                GetCaster()->CastSpell(GetHitUnit(), RAND(SPELL_THROW_COLOGNE, SPELL_THROW_PERFUME), true);
+            }
+
+            void Register() override
+            {
+                OnObjectAreaTargetSelect += SpellObjectAreaTargetSelectFn(spell_apothecary_validate_area_SpellScript::FilterTargets, EFFECT_0, TARGET_UNIT_DEST_AREA_ENTRY);
+                OnEffectHitTarget += SpellEffectFn(spell_apothecary_validate_area_SpellScript::HandleScript, EFFECT_0, SPELL_EFFECT_DUMMY);
+            }
+        };
+
+        SpellScript* GetSpellScript() const override
+        {
+            return new spell_apothecary_validate_area_SpellScript();
+        }
+};
+
+// 69038 - Throw Cologne
+class spell_apothecary_throw_cologne : public SpellScriptLoader
+{
+    public:
+        spell_apothecary_throw_cologne() : SpellScriptLoader("spell_apothecary_throw_cologne") { }
+
+        class spell_apothecary_throw_cologne_SpellScript : public SpellScript
+        {
+            PrepareSpellScript(spell_apothecary_throw_cologne_SpellScript);
+
+            void HandleScript(SpellEffIndex /*effindex*/)
+            {
+                GetHitUnit()->CastSpell(GetHitUnit(), SPELL_COLOGNE_SPILL, true);
+            }
+
+            void Register() override
+            {
+                OnEffectHitTarget += SpellEffectFn(spell_apothecary_throw_cologne_SpellScript::HandleScript, EFFECT_0, SPELL_EFFECT_DUMMY);
+            }
+        };
+
+        SpellScript* GetSpellScript() const override
+        {
+            return new spell_apothecary_throw_cologne_SpellScript();
+        }
+};
+
+// 68966 - Throw Perfume
+class spell_apothecary_throw_perfume : public SpellScriptLoader
+{
+    public:
+        spell_apothecary_throw_perfume() : SpellScriptLoader("spell_apothecary_throw_perfume") { }
+
+        class spell_apothecary_throw_perfume_SpellScript : public SpellScript
+        {
+            PrepareSpellScript(spell_apothecary_throw_perfume_SpellScript);
+
+            void HandleScript(SpellEffIndex /*effindex*/)
+            {
+                GetHitUnit()->CastSpell(GetHitUnit(), SPELL_PERFUME_SPILL, true);
+            }
+
+            void Register() override
+            {
+                OnEffectHitTarget += SpellEffectFn(spell_apothecary_throw_perfume_SpellScript::HandleScript, EFFECT_0, SPELL_EFFECT_DUMMY);
+            }
+        };
+
+        SpellScript* GetSpellScript() const override
+        {
+            return new spell_apothecary_throw_perfume_SpellScript();
+        }
+};
+
+// 68798 - Concentrated Alluring Perfume Spill
+class spell_apothecary_perfume_spill : public SpellScriptLoader
+{
+    public:
+        spell_apothecary_perfume_spill() : SpellScriptLoader("spell_apothecary_perfume_spill") { }
+
+        class spell_apothecary_perfume_spill_AuraScript : public AuraScript
+        {
+            PrepareAuraScript(spell_apothecary_perfume_spill_AuraScript);
+
+            void OnPeriodic(AuraEffect const* /*aurEff*/)
+            {
+                GetTarget()->CastSpell(GetTarget(), SPELL_PERFUME_SPILL_DAMAGE, true);
+            }
+
+            void Register() override
+            {
+                OnEffectPeriodic += AuraEffectPeriodicFn(spell_apothecary_perfume_spill_AuraScript::OnPeriodic, EFFECT_0, SPELL_AURA_PERIODIC_DUMMY);
+            }
+        };
+
+        AuraScript* GetAuraScript() const override
+        {
+            return new spell_apothecary_perfume_spill_AuraScript();
+        }
+};
+
+// 68614 - Concentrated Irresistible Cologne Spill
+class spell_apothecary_cologne_spill : public SpellScriptLoader
+{
+    public:
+        spell_apothecary_cologne_spill() : SpellScriptLoader("spell_apothecary_cologne_spill") { }
+
+        class spell_apothecary_cologne_spill_AuraScript : public AuraScript
+        {
+            PrepareAuraScript(spell_apothecary_cologne_spill_AuraScript);
+
+            void OnPeriodic(AuraEffect const* /*aurEff*/)
+            {
+                GetTarget()->CastSpell(GetTarget(), SPELL_COLOGNE_SPILL_DAMAGE, true);
+            }
+
+            void Register() override
+            {
+                OnEffectPeriodic += AuraEffectPeriodicFn(spell_apothecary_cologne_spill_AuraScript::OnPeriodic, EFFECT_0, SPELL_AURA_PERIODIC_DUMMY);
+            }
+        };
+
+        AuraScript* GetAuraScript() const override
+        {
+            return new spell_apothecary_cologne_spill_AuraScript();
+        }
+};
+
+void AddSC_boss_apothecary_hummel()
+{
+    new boss_apothecary_hummel();
+    new npc_apothecary_baxter();
+    new npc_apothecary_frye();
+    new spell_apothecary_lingering_fumes();
+    new spell_apothecary_validate_area();
+    new spell_apothecary_throw_cologne();
+    new spell_apothecary_throw_perfume();
+    new spell_apothecary_perfume_spill();
+    new spell_apothecary_cologne_spill();
+}
diff --git a/src/server/scripts/EasternKingdoms/ShadowfangKeep/shadowfang_keep.h b/src/server/scripts/EasternKingdoms/ShadowfangKeep/shadowfang_keep.h
index bf9e8606fcb..37d2905a8fb 100644
--- a/src/server/scripts/EasternKingdoms/ShadowfangKeep/shadowfang_keep.h
+++ b/src/server/scripts/EasternKingdoms/ShadowfangKeep/shadowfang_keep.h
@@ -30,7 +30,8 @@ enum SKDataTypes
     TYPE_RETHILGORE             = 2,
     TYPE_FENRUS                 = 3,
     TYPE_NANDOS                 = 4,
-    BOSS_ARUGAL                 = 5
+    BOSS_ARUGAL                 = 5,
+    DATA_APOTHECARY_HUMMEL      = 6
 };
 
 template<typename AI>
diff --git a/src/server/scripts/EasternKingdoms/eastern_kingdoms_script_loader.cpp b/src/server/scripts/EasternKingdoms/eastern_kingdoms_script_loader.cpp
index 68e7a2130f0..3d724c33928 100644
--- a/src/server/scripts/EasternKingdoms/eastern_kingdoms_script_loader.cpp
+++ b/src/server/scripts/EasternKingdoms/eastern_kingdoms_script_loader.cpp
@@ -132,6 +132,7 @@ void AddSC_boss_kirtonos_the_herald();
 void AddSC_instance_scholomance();
 void AddSC_shadowfang_keep();                //Shadowfang keep
 void AddSC_instance_shadowfang_keep();
+void AddSC_boss_apothecary_hummel();
 void AddSC_boss_magistrate_barthilas();      //Stratholme
 void AddSC_boss_maleki_the_pallid();
 void AddSC_boss_nerubenkan();
@@ -323,6 +324,7 @@ void AddEasternKingdomsScripts()
     AddSC_instance_scholomance();
     AddSC_shadowfang_keep();                //Shadowfang keep
     AddSC_instance_shadowfang_keep();
+    AddSC_boss_apothecary_hummel();
     AddSC_boss_magistrate_barthilas();      //Stratholme
     AddSC_boss_maleki_the_pallid();
     AddSC_boss_nerubenkan();