Trespassers in the Water

/********************************
   Trespassers in the Water
********************************/

-- Script

SET @Guid := xxxxx;

DELETE FROM `creature_template` WHERE  `entry`=46868 LIMIT 1;
INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `mindmg`, `maxdmg`, `attackpower`, `baseattacktime`, `unit_class`, `family`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `skinloot`, `mingold`, `maxgold`, `InhabitType`, `Health_mod`, `WDBVerified`) VALUES
(46868, 36385, 36386, 'Stillwater Slitherer', '', '', 82, 83, 2, 14, 14, 509, 683, 805, 2000, 1, 6, 371, 535, 146, 1, 46868, 46868, 15, 33, 1, 4, 13623);
-- Spawn npc

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