Dragonmaw Skyclaw

/****************************
   Last Stand at Thundermar
****************************/

-- Script Dragonmaw Skyclaw

DELETE FROM `creature_template` WHERE  `entry`=48194 LIMIT 1;
INSERT INTO `creature_template` (`entry`, `modelid1`, `modelid2`, `modelid3`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `mindmg`, `maxdmg`, `attackpower`, `baseattacktime`, `unit_class`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `lootid`, `mingold`, `maxgold`, `InhabitType`, `Health_mod`, `movementId`) VALUES
(48194, 36040, 36041, 36042, 'Dragonmaw Skyclaw', '', '', 84, 84, 2, 85, 85, 519, 693, 815, 2000, 1, 384, 546, 157, 7, 48194, 15, 33, 1, 6, 875);

-- NPC Spawn

SET @Guid := 212123;

DELETE FROM `creature` WHERE  `guid`=@Guid LIMIT 1;
INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `position_x`, `position_y`,  `position_z`,  `orientation`,  `spawntimesecs`) VALUES
(@Guid+0, 48194, 0, 36040, -3202.886963, -4961.883301, 122.967590, 4.451533, 120),
(@Guid+1, 48194, 0, 36040, -3217.696289, -4996.700684, 120.527618, 4.531644, 120),
(@Guid+2, 48194, 0, 36040, -3172.630859, -5004.904297, 122.488594, 3.691267, 120),
(@Guid+3, 48194, 0, 36040, -3173.218750, -5042.251953, 120.970032, 2.638048, 120),
(@Guid+4, 48194, 0, 36040, -3223.430420, -5056.562988, 131.368179, 0.917242, 120),
(@Guid+5, 48194, 0, 36040, -3234.444580, -5028.253418, 124.770805, 0.749953, 120),
(@Guid+6, 48194, 0, 36040, -3245.809082, -4987.615234, 123.000603, 2.063925, 120),
(@Guid+7, 48194, 0, 36040, -3273.432617, -4956.326660, 126.733406, 4.885862, 120),
(@Guid+8, 48194, 0, 36040, -3255.596924, -4913.134277, 123.974442, 1.040554, 120),
(@Guid+9, 48194, 0, 36040, -3208.270752, -4909.887207, 129.510269, 5.344538, 120);