-- Wellson Supply Boat 48286
SET @CGUID := 26750;

DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM  `creature` WHERE `id` = 48286);

DELETE FROM `creature` WHERE `id` = 48286;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CGUID+0, 48286, 732, 1, 1, 0, 0, -305.02, 2013.7, 0.00240464, 0.884382, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+1, 48286, 732, 1, 1, 0, 0, -274.509, 2041.24, 0.00240464, 3.02198, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+2, 48286, 732, 1, 1, 0, 0, -265.453, 2009.91, -0.0598088, 0.0900559, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+3, 48286, 732, 1, 1, 0, 0, -237.686, 2046.27, -0.0598088, 0.918651, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+4, 48286, 732, 1, 1, 0, 0, -226.113, 2113.7, 0.00121749, 5.24339, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+5, 48286, 732, 1, 1, 0, 0, -210.107, 2078.78, -0.0598088, 0.577776, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+6, 48286, 732, 1, 1, 0, 0, -201.113, 2053.33, -0.0598088, 5.05212, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+7, 48286, 732, 1, 1, 0, 0, -188.153, 2107.33, 0.00240464, 4.91188, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+8, 48286, 732, 1, 1, 0, 0, -164.127, 2084.15, -0.0598088, 0.772555, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+9, 48286, 732, 1, 1, 0, 0, -157.846, 2050.24, -0.0598088, 4.91133, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+10, 48286, 732, 1, 1, 0, 0, -143.333, 2019.08, -0.0404435, 4.97023, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+11, 48286, 732, 1, 1, 0, 0, -121.533, 2092.83, 0.00240464, 5.65888, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+12, 48286, 732, 1, 1, 0, 0, -93.0229, 2130.7, 0.333295, 4.87261, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+13, 48286, 732, 1, 1, 0, 0, -86.0045, 2091.1, 0.00240464, 5.43838, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+14, 48286, 732, 1, 1, 0, 0, -65.3276, 2055.31, 0.00240464, 4.76338, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+15, 48286, 732, 1, 1, 0, 0, -56.0301, 2104.42, 0.00240464, 1.5447, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+16, 48286, 732, 1, 1, 0, 0, -42.396, 2033.35, 0.00240464, 5.51938, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+17, 48286, 732, 1, 1, 0, 0, -34.9532, 2085.1, 0.00240464, 1.7607, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+18, 48286, 732, 1, 1, 0, 0, -29.0716, 2055.86, 0.00240464, 1.0362, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+19, 48286, 732, 1, 1, 0, 0, -19.1981, 2104.79, 0.00240464, 4.64863, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+20, 48286, 732, 1, 1, 0, 0, -3.52562, 2004.79, 0.00240464, 4.08951, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+21, 48286, 732, 1, 1, 0, 0, 9.20782, 2056.84, 0.00240464, 5.32813, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+22, 48286, 732, 1, 1, 0, 0, 19.8772, 1978.63, 0.00240464, 5.32701, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+23, 48286, 732, 1, 1, 0, 0, 42.2354, 2005.17, 0.00240464, 0.167696, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+24, 48286, 732, 1, 1, 0, 0, 53.6281, 2063.52, 0.00240464, 2.5707, 45, 0, 0, 1, 0, 0, 0, 0, 0),
(@CGUID+25, 48286, 732, 1, 1, 0, 0, 61.1358, 2030.98, 0.00240464, 1.61332, 45, 0, 0, 1, 0, 0, 0, 0, 0);

DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+25;

DELETE FROM `creature_template_addon` WHERE `entry` = 48286;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
(48286, 0, 0, 50397184, 1, 0, 0, 0, 0, 4, '84908 72697');

UPDATE `creature_template` SET `modelid2` = 23258, `InhabitType` = 4, `AIName`= 'SmartAI', `ScriptName` = '' WHERE  `entry` = 48286;

DELETE FROM `smart_scripts` WHERE `entryorguid` = 48286 AND `source_type` IN (0, 9);
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(48286, 0, 0, 1, 8, 0, 100, 0, 72755, 0, 0, 0, 0, 11, 20686, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Freed Sha\'tar Warrior - On Spellhit - Cast Spell \'Knock away\''),
(48286, 0, 1, 2, 61, 0, 100, 512, 0, 0, 0, 0, 0, 33, 48286, 0, 0, 0, 0, 0, 18, 50, 0, 0, 0, 0, 0, 0, 0, 'Freed Sha\'tar Warrior - On Spellhit - Quest Credit'),
(48286, 0, 2, 3, 61, 0, 100, 512, 0, 0, 0, 0, 0, 11, 90109, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Freed Sha\'tar Warrior - On Spellhit - Cast Spell \'Explod\''),
(48286, 0, 3, 4, 61, 0, 100, 512, 0, 0, 0, 0, 0, 4, 14884, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Freed Sha\'tar Warrior - On Spellhit - Play sound'),
(48286, 0, 4, 0, 61, 0, 100, 512, 0, 0, 0, 0, 0, 51, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Freed Sha\'tar Warrior - On Spellhit - Die');

DELETE FROM `vehicle_template_accessory` WHERE `entry` = 48286;
INSERT INTO `vehicle_template_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`, `summontype`, `summontimer`) VALUES
(48286, 48285, 0, 1, 'Accursed Supplyman', 6, 30000),
(48286, 48285, 1, 1, 'Accursed Supplyman', 6, 30000),
(48286, 48285, 2, 1, 'Accursed Supplyman', 6, 30000);

DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 48286;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
(48286, 65928, 0, 0);

-- Accursed Supplyman 48285
DELETE FROM `creature` WHERE  `id` = 48285;

DELETE FROM `creature_template_addon` WHERE `entry` = 48285;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
(48285, 0, 0, 0, 1, 0, 0, 0, 0, 4, '10848 84908');