Mathias's Command

/*******************
  Mathias's Command
*******************/

-- NPC Script

DELETE FROM `creature_template` WHERE  `entry`=47592 LIMIT 1;
INSERT INTO `creature_template` (`entry`, `modelid1`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `rank`, `mindmg`, `maxdmg`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `unit_class`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `mingold`, `maxgold`, `InhabitType`, `Health_mod`) VALUES
(47592, 34974, 'Master Mathias Shaw', 'Leader of SI:7', '', 85, 85, 3, 11, 11, 7, 1, 530, 713, 827, 4.6, 2000, 1, 399, 559, 169, 7, 15, 33, 1, 11.9803);

-- NPC Mathias Shaw spawn

SET @Guid := xxxxx;

DELETE FROM `creature` WHERE  `guid`=@Guid LIMIT 1;
INSERT INTO `creature` (`guid`, `id`, `modelid`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`) VALUES
(@Guid, 47592, 34974, -3523.974121, -3812.373535, 91.380028, 0.962582, 300);