qwerty

/*******************
  Uther's Blessing
*******************/

-- NPC Spawn

SET @guid := 15455380;

DELETE FROM `creature` WHERE  `id`=1854 LIMIT 1;
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
(@Guid+0, 1854, 0, 1, 1, 11395, 330, 986.847290, -1819.901611, 80.487434, 3.479811, 300, 0, 0, 3101, 0, 0, 3, 4096, 8);

-- NPC smart script

DELETE FROM `smart_scripts` WHERE  `entryorguid`=1854 AND `source_type`=0 AND `id`=0 AND `link`=0 LIMIT 1;
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`,  `action_type`,
`action_param1`,  `action_param2`,  `action_param3`,  `action_param4`,  `action_param5`,  `action_param6`,  `target_type`,
`target_param1`,  `target_param2`,  `target_param3`,  `target_x`,  `target_y`,  `target_z`,  `target_o`,  `comment`) VALUES
(1854, 0, 2, 0, 8, 0, 100, 0, 61920, 0, 0, 0, 12, 1854, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 986.847290, -1819.901611, 80.487434, 'On cast - summon npc');

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=1854;