Frozo

-- FROZO THE RENOWNED
DELETE FROM `creature` WHERE `id`='40160';
INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
VALUES
('40160', '571', '1', '1', '0', '0', '5910.08', '720.278', '643.425', '3.26377', '600', '0', '0', '8508', '7981', '0', '0');

UPDATE creature_template SET `modelid3` = "0", `armor` = "6588", `npcflag` = "128", `speed_run` = "2.28571", `mindmg` = "248", `maxdmg` = "372", `attackpower` = "93", `dmg_multiplier` = "1.4", `unit_flags` = "32768", `minrangedmg` = "198", `maxrangedmg` = "298", `rangedattackpower` = "74", `equipment_id` = "2286", `InhabitType` = "4" WHERE entry=40160;
-- KIS KOZMETIKA
DELETE FROM `creature_equip_template` WHERE `entry`='2286';
INSERT INTO `creature_equip_template` (`entry`, `equipentry1`, `equipentry2`, `equipentry3`)
VALUES
('2286', '0', '36459', '0');
DELETE FROM `creature_template_addon` WHERE `entry`='40160';
INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `b2_0_sheath`, `b2_1_pvp_state`, `emote`, `moveflags`, `auras`)
VALUES
('40160', '31837', '0', '1', '1', '0', '0', '75387');

-- VENDOR PART
DELETE FROM `npc_vendor` WHERE `entry`='40160';
INSERT INTO `npc_vendor` (`entry`, `item`, `maxcount`, `incrtime`, `ExtendedCost`)
VALUES
('40160', '35622', '0', '0', '2985'),
('40160', '35623', '0', '0', '2985'),
('40160', '35624', '0', '0', '2985'),
('40160', '35625', '0', '0', '2985'),
('40160', '35627', '0', '0', '2985'),
('40160', '36860', '0', '0', '2985'),
('40160', '36908', '0', '0', '2985'),
('40160', '45087', '0', '0', '2987'),
('40160', '47556', '0', '0', '2986'),
('40160', '54798', '0', '0', '2986');