Foxtails By The Handful

/***************************
     Fluffy Fox Tail
***************************/

-- Script

SET @GUID := xxxxx;

DELETE FROM `creature_template` WHERE  `entry`=44635 LIMIT 1;
INSERT INTO `creature_template` (`entry`, `modelid1`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `faction_A`, `faction_H`, `speed_run`, `mindmg`,
`maxdmg`, `attackpower`, `baseattacktime`, `unit_class`, `dynamicflags`, `family`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`,
`lootid`, `skinloot`, `InhabitType`, `questItem1`, `equipment_id`, `WDBVerified`) VALUES
(44635, 30301, 'Hill Fox', '', '', 16, 16, 2200, 2200, 1, 43.7, 58.9, 106, 2000, 1, 2048, 50, 30.4, 43.7, 3, 1, 1, 44635, 44635, 1, 60755, 44635, 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, 44635, 0, -5186.763672, -3987.615479, 332.908875, 4.03570, 100),
(@GUID+1, 44635, 0, -5171.630371, -4029.276367, 329.414368, 4.03570, 100),
(@GUID+2, 44635, 0, -5140.209473, -4061.532227, 322.283478, 4.03570, 100),
(@GUID+3, 44635, 0, -5164.602539, -4139.211914, 322.650360, 4.03570, 100),
(@GUID+4, 44635, 0, -5214.417480, -4095.427246, 323.809631, 4.03570, 100),
(@GUID+5, 44635, 0, -5221.785156, -4041.881592, 329.575409, 4.03570, 100),
(@GUID+6, 44635, 0, -5257.636230, -4073.832764, 323.787140, 4.03570, 100),
(@GUID+7, 44635, 0, -5285.915527, -4113.302246, 330.827637, 4.03570, 100),
(@GUID+8, 44635, 0, -5320.578613, -4162.186035, 335.056122, 4.03570, 100),
(@GUID+9, 44635, 0, -5360.395020, -4125.103027, 335.757690, 4.03570, 100),
(@GUID+10, 44635, 0, -5329.208008, -4061.650879, 332.283356, 4.03570, 100),
(@GUID+11, 44635, 0, -5278.190430, -4034.732422, 328.067078, 4.03570, 100);

-- Assign

UPDATE `creature_questrelation` SET `id`=44635, `quest`=27030;