-- Pathing for Stormwind City Patroller Entry: 1976
SET @NPC := XXXXXX;
SET @LIST := XXXXXX;
SET @PATH := XXXXXX;
UPDATE `creature` SET `position_x`=-8435.28,`position_y`=700.156,`position_z`=115.0977,`orientation`=0.6283185,`ActionList`=@LIST WHERE `guid`=@NPC;;

-- Creature Action List
DELETE FROM `actionlist` WHERE `Id`=@LIST AND `Type`=0;
INSERT INTO `actionlist` (`Id`,`Type`,`PointId`,`MinWait`,`MaxWait`,`Action`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`Target`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(@LIST,0,0,16,24,119,@PATH,1,5,0,0,0,1,0,0,0,0,0,0,0,"Stormwind City Patroller - Move path"),
(@LIST,0,1,1,1,66,0,0,0,0,0,0,8,0,0,0,0,0,0,2.199115,"Stormwind City Patroller - turn to"),
(@LIST,0,2,16,24,119,@PATH,6,10,0,0,0,1,0,0,0,0,0,0,0,"Stormwind City Patroller - Move path"),
(@LIST,0,3,1,1,66,0,0,0,0,0,0,8,0,0,0,0,0,0,0.6283185,"Stormwind City Patroller - turn to"),
(@LIST,0,4,1,1,120,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Stormwind City Patroller - repeat list");

DELETE FROM `waypoints` WHERE `id`=@PATH;
INSERT INTO `waypoints` (`Id`,`Point`,`PointX`,`PointY`,`PointZ`,`Comment`) VALUES
(@PATH,1,-8422.67,710.502,115.0977, 'Stormwind City Patroller'),
(@PATH,2,-8413.84,717.092,114.9219, 'Stormwind City Patroller'),
(@PATH,3,-8405.17,723.368,114.3239, 'Stormwind City Patroller'),
(@PATH,4,-8394.24,732.28,114.4097, 'Stormwind City Patroller'),
(@PATH,5,-8381.44,716.314,114.7478, 'Stormwind City Patroller'),
(@PATH,6,-8389.73,727.092,114.3211, 'Stormwind City Patroller'),
(@PATH,7,-8393.94,731.59,114.3714, 'Stormwind City Patroller'),
(@PATH,8,-8403.7,724.245,114.1387, 'Stormwind City Patroller'),
(@PATH,9,-8417.32,715.094,115.0288, 'Stormwind City Patroller'),
(@PATH,10,-8435.28,700.156,115.0977, 'Stormwind City Patroller');


-- Spell Action list
SET @SPELL := XXXXXX;
DELETE FROM `actionlist` WHERE `Id`=@SPELL AND `Type`=6;
INSERT INTO `actionlist` (`Id`,`Type`,`PointId`,`MinWait`,`MaxWait`,`Action`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`Target`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
SUDO
VICTIM PAUSE MAIN SCRIPTS IF ANY
VICTIM TURN TO CASTER
VICTIM SAY BROADCAST TEXT
VICTIM DO EMOTE
WAIT 4 SEC
VICTIM RESUME MAIN SCRIPT IF ANY