Engineering NPC

-- Liliam Sparkspindle Engineering npc

SET @GUID := xxxxx;

DELETE FROM `creature` WHERE  `id`=5518;
INSERT INTO `creature` (`guid`, `id`, `map`, `modelid`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
(@GUID, 5518, 0, 3314, -8332.527344, 628.162537, 95.649300, 2.425658, 300);

DELETE FROM `creature_template` WHERE  `entry`=5518;
INSERT INTO `creature_template` (`entry`, `modelid1`, `name`, `subname`, `minlevel`, `maxlevel`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `mindmg`, `maxdmg`, `attackpower`, `baseattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `trainer_type`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `Health_mod`, `equipment_id`, `flags_extra`, `WDBVerified`) VALUES
(5518, 3314, 'Lilliam Sparkspindle', 'Engineering Trainer', 35, 35, 875, 875, 83, 1.28, 49, 64, 118, 2000, 1, 512, 8, 2, 33, 49, 11, 7, 1.1, 88, 2, 12340);