/********************************
    Tresspassers in the Water
********************************/

SET @Guid := xxxxx;

-- Spawn npc

DELETE FROM `creature` WHERE  `guid`=@Guid LIMIT 1;
INSERT INTO `creature` (`guid`,  `id`,  `map`,  `modelid`,  `equipment_id`,  `position_x`,  `position_y`,  `position_z`,
`orientation`,  `spawntimesecs`) VALUES
(@Guid+0, 46868, 1, 36385, 0, -9572.615234, -954.506775, 95.397865, 5.599866, 100),
(@Guid+1, 46868, 1, 36385, 0, -9590.443359, -986.574646, 98.248528, 4.300032, 100),
(@Guid+2, 46868, 1, 36385, 0, -9615.254492, -1018.995911, 75.530235, 4.174367, 100),
(@Guid+3, 46868, 1, 36385, 0, -9638.652344, -973.499451, 66.062775, 1.123875, 100),
(@Guid+4, 46868, 1, 36385, 0, -9625.760742, -935.184814, 74.333282, 2.582364, 100),
(@Guid+5, 46868, 1, 36385, 0, -9662.057617, -932.829834, 61.588886, 2.582364, 100),
(@Guid+6, 46868, 1, 36385, 0, -9636.456055, -883.977722, 69.701294, 0.642431, 100),
(@Guid+7, 46868, 1, 36385, 0, -9591.530273, -883.344788, 75.508575, 6.170848, 100),
(@Guid+8, 46868, 1, 36385, 0, -9560.581055, -853.524536, 81.527946, 2.000385, 100),
(@Guid+9, 46868, 1, 36385, 0, -9548.017578, -812.676331, 80.923653, 3.370120, 100),
(@Guid+10, 46868, 1, 36385, 0, -9519.665039, -778.673828, 82.698929, 0.433515, 100),
(@Guid+11, 46868, 1, 36385, 0, -9589.807617, -822.883911, 75.842155, 1.732563, 100);