Code:
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+820; INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (@CGUID+0, 99656, 1481, 7705, 7705, '0', 0, 895, 0, 0, 1181.866, 3218.76, 55.44142, 1.794285, 120, 10, 0, 0, 0, 1, 0, 0, 0, 27843), -- Red Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) (possible waypoints or random movement) (@CGUID+1, 99656, 1481, 7705, 7705, '0', 5837, 0, 0, 0, 1181.866, 3218.76, 55.44142, 1.794285, 120, 10, 0, 0, 0, 1, 0, 0, 0, 27843), -- Red Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) (possible waypoints or random movement) (@CGUID+2, 99656, 1481, 7705, 7705, '0', 5324, 0, 0, 0, 1181.866, 3218.76, 55.44142, 1.794285, 120, 10, 0, 0, 0, 1, 0, 0, 0, 27843), -- Red Broodling (Area: Mardum, the Shattered Abyss - Difficulty: 0) (possible waypoints or random movement) (@CGUID+3, 94655, 1481, 7705, 7705, '0', 0, 895, 0, 0, 1173.173, 3288.728, 69.17558, 0.4322493, 120, 0, 0, 0, 0, 0, 0, 0, 0, 27843), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) (@CGUID+4, 94655, 1481, 7705, 7705, '0', 5837, 0, 0, 0, 1173.173, 3288.728, 69.17558, 0.4322493, 120, 0, 0, 0, 0, 0, 0, 0, 0, 27843), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) (@CGUID+5, 94655, 1481, 7705, 7705, '0', 5324, 0, 0, 0, 1173.173, 3288.728, 69.17558, 0.4322493, 120, 0, 0, 0, 0, 0, 0, 0, 0, 27843), -- Soul Leech (Area: Mardum, the Shattered Abyss - Difficulty: 0) (@CGUID+6, 98191, 1481, 7705, 7705, '0', 0, 895, 0, 0, 1276.815, 2301.269, 243.1888, 3.666962, 120, 10, 0, 0, 0, 1, 0, 0, 0, 27843), -- Leg
parsing phase and phasegroup