qsdgeth

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

-- Script

SET @Guid := 4567950;

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`) VALUES
(@Guid, 36385, 36386, 'Stillwater Slitherer', '', '', 82, 83, 2, 14, 14, 509, 683, 805, 2000, 1, 6, 371, 535, 146, 1, 46868, 46868, 15, 33, 1, 9);


-- 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);