SET @GUID := 3107363;
DELETE FROM `creature` WHERE `guid` BETWEEN @GUID AND @GUID+5;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@GUID, 23623, 230, 1, 1, 0, 0, 847.339, -179.934, -49.7547, 1.97248, 300, 0, 0, 3240, 3155, 0, 0, 0, 0),
(@GUID+1, 23619, 230, 1, 1, 0, 0, 852.487, -176.334, -49.7546, 2.03893, 300, 0, 0, 2835, 7196, 0, 0, 0, 0),
(@GUID+2, 23625, 230, 1, 1, 0, 0, 848.254, -174.755, -49.7546, 2.05962, 300, 0, 0, 4050, 0, 0, 0, 0, 0),
(@GUID+3, 23624, 230, 1, 1, 0, 0, 842.133, -183.924, -49.7546, 2.09497, 300, 0, 0, 3240, 3155, 0, 0, 0, 0),
(@GUID+4, 23626, 230, 1, 1, 0, 0, 842.435, -179.193, -49.7546, 2.08319, 300, 0, 0, 3240, 3155, 0, 0, 0, 0),
(@GUID+5, 23830, 230, 1, 1, 0, 0, 844.317, -175.684, -49.7546, 2.11854, 300, 0, 0, 4120, 0, 0, 0, 0, 0);

DELETE FROM `game_event_creature` WHERE `evententry`=34 AND `guid` BETWEEN @GUID AND @GUID+5;
INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES
(34, @GUID),
(34, @GUID+1),
(34, @GUID+2),
(34, @GUID+3),
(34, @GUID+4),
(34, @GUID+5);

UPDATE `game_event` SET `start_time`='2014-09-18 16:00:00', `occurence`=1440, `length`=10 WHERE  `eventEntry`=32;
UPDATE `game_event` SET `start_time`='2014-09-18 20:00:00', `end_time`='2020-09-18 20:00:00', `occurence`=1440, `length`=10 WHERE  `eventEntry`=34;