DELETE FROM `creature_addon` WHERE `guid` BETWEEN 155488 AND 155499;
DELETE FROM `creature_addon` WHERE `guid`= 104386;
DELETE FROM `creature` WHERE `id` IN (24177,24250,24226,24253,24254,24255,24270);
UPDATE `creature` SET `modelid`=0, `curhealth`=1 WHERE `id` IN (24216,24249,24250);
UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (24221,24258,24260);

-- Spawn Devoring maggot
SET @CGUID := 86498;
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+12;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID+0, 24270, 571, 0, 0, 1, 1, 0, 0, 920.3727, -4820.956, -116.1583, 1.39876, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+1, 24270, 571, 0, 0, 1, 1, 0, 0, 867.1586, -4866.869, -115.7611, 1.117435, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+2, 24270, 571, 0, 0, 1, 1, 0, 0, 868.3704, -4858.826, -115.9888, 5.194222, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+3, 24270, 571, 0, 0, 1, 1, 0, 0, 847.1349, -4847.13, -115.7101, 3.256897, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+4, 24270, 571, 0, 0, 1, 1, 0, 0, 845.8868, -4842.255, -114.9933, 4.433831, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+5, 24270, 571, 0, 0, 1, 1, 0, 0, 846.8536, -4815.939, -115.8419, 5.850776, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+6, 24270, 571, 0, 0, 1, 1, 0, 0, 847.973, -4870.388, -115.7377, 4.820714, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+7, 24270, 571, 0, 0, 1, 1, 0, 0, 838.5492, -4853.339, -115.7324, 3.754435, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+8, 24270, 571, 0, 0, 1, 1, 0, 0, 919.4053, -4845.84, -116.1583, 3.593357, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+9, 24270, 571, 0, 0, 1, 1, 0, 0, 833.8646, -4824.632, -115.9204, 6.045882, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+10, 24270, 571, 0, 0, 1, 1, 0, 0, 828.0585, -4858.886, -115.74, 6.0632, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+11, 24270, 571, 0, 0, 1, 1, 0, 0, 826.5804, -4799.911, -115.99, 5.823083, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594),
(@CGUID+12, 24270, 571, 0, 0, 1, 1, 0, 0, 806.4168, -4802.574, -115.8733, 3.316379, 120, 5, 0, 0, 0, 1, 0, 0, 0, 22594);

-- Spawn Dragonflayer Fleshripper
SET @CGUID := 87530;
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+13;
INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
(@CGUID+0, 24250, 571, 0, 0, 1, 1, 0, 0, 894.2793 ,-4853.812 ,-72.35857, 1.09911, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+1, 24250, 571, 0, 0, 1, 1, 0, 0, 835.082 ,-4852.535 ,-72.34498, 5.131268, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+2, 24250, 571, 0, 0, 1, 1, 0, 0, 889.3472 ,-4931.63 ,-72.35851, 3.438299, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+3, 24250, 571, 0, 0, 1, 1, 0, 0, 843.719 ,-4788.988 ,-94.0441, 3.351032, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+4, 24250, 571, 0, 0, 1, 1, 0, 0, 832.092 ,-4885.617 ,-72.35873, 1.727876, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+5, 24250, 571, 0, 0, 1, 1, 0, 0, 802.9092 ,-4796.535 ,-94.0372, 4.991642, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+6, 24250, 571, 0, 0, 1, 1, 0, 0, 854.3528 ,-4928.178 ,-72.35851, 0.9545009, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+7, 24250, 571, 0, 0, 1, 1, 0, 0, 845.1808 ,-4946.441 ,-72.35851, 0.3141593, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+8, 24250, 571, 0, 0, 1, 1, 0, 0, 1012.705 ,-4799.854 ,-70.8481, 6.213372, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+9, 24250, 571, 0, 0, 1, 1, 0, 0 ,982.7759 ,-4805.024 ,-72.35856, 5.113815, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+10, 24250, 571, 0, 0, 1, 1, 0, 0 ,880.2073, -4949.447, -72.3585, 2.570883, 120, 0, 0, 0, 0, 0, 0, 0, 0, 22594),
(@CGUID+11, 24250, 571, 0, 0, 1, 1, 0, 0 ,919.5702, -4815.712, -72.44168, 1.53589, 120, 0, 0, 0, 0, 2, 0, 0, 0, 22594),
(@CGUID+12, 24250, 571, 0, 0, 1, 1, 0, 0 ,909.7383 ,-4820.702 ,-72.4417, 2.408554, 120, 0, 0, 0, 0, 2, 0, 0, 0, 22594),
(@CGUID+13, 24250, 571, 0, 0, 1, 1, 0, 0 ,830.6761 ,-4871.174 ,-72.42693, 3.996804, 120, 0, 0, 0, 0, 2, 0, 0, 0, 22594);

-- Pathing for Dragonflayer Fleshripper Entry: 24250 'TDB FORMAT' 
SET @NPC := @CGUID+11;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,929.5845,-4854.908,-72.44169,0,0,0,0,100,0),
(@PATH,2,929.5845,-4854.908,-72.44169,5.916666,46000,0,0,100,0),
(@PATH,3,921.6194,-4826.802,-72.4417,0,0,0,0,100,0),
(@PATH,4,919.5702,-4815.712,-72.44168,0,0,0,0,100,0),
(@PATH,5,919.5702,-4815.712,-72.44168,1.53589,33000,0,0,100,0);
-- 0x203108476017AE80000023000062C82A

-- Pathing for Dragonflayer Fleshripper Entry: 24250 'TDB FORMAT' 
SET @NPC := @CGUID+12;
SET @PATH := @NPC * 10;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,916.5015,-4834.056,-72.44172,0,0,0,0,100,0),
(@PATH,2,917.287,-4848.597,-72.4417,0,0,0,0,100,0),
(@PATH,3,917.287,-4848.597,-72.4417,4.29351,47000,0,0,100,0),
(@PATH,4,909.7383,-4820.702,-72.4417,0,0,0,0,100,0),
(@PATH,5,909.7383,-4820.702,-72.4417,2.408554,180000,0,0,100,0);
-- 0x203108476017AE80000023000162C4F5

-- Pathing for Dragonflayer Fleshripper Entry: 24250 'TDB FORMAT' 
SET @NPC := @CGUID+13;
SET @PATH := @NPC * 10;
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=830.6761,`position_y`=-4871.174,`position_z`=-72.42693 WHERE `guid`=@NPC;
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,830.6761,-4871.174,-72.42693,0,0,0,0,100,0),
(@PATH,2,829.3475,-4878.425,-72.43112,0,0,0,0,100,0),
(@PATH,3,829.3475,-4878.425,-72.43112,3.996804,44000,0,0,100,0),
(@PATH,4,829.4708,-4857.084,-72.4222,0,0,0,0,100,0),
(@PATH,5,829.4708,-4857.084,-72.4222,2.164208,39000,0,0,100,0),
(@PATH,6,821.4581,-4857.853,-72.42,0,0,0,0,100,0),
(@PATH,7,821.4581,-4857.853,-72.42,3.089233,37000,0,0,100,0);
-- 0x203108476017AE80000023000062C79F