DB/SAI: Onslaught Warhorse fix & pathing

1 files changed, 296 insertions, 0 deletions

diff --git a/sql/updates/world/2011_05_24_04_sai.sql b/sql/updates/world/2011_05_24_04_sai.sql
new file mode 100644
index 00000000000..a03325f546d
--- /dev/null
+++ b/sql/updates/world/2011_05_24_04_sai.sql
@@ -0,0 +1,296 @@
+-- Onslaught Warhorse SAI
+UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN (27213,27206);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (27213,27206);
+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
+(27213,0,0,0,11,0,100,0,0,0,0,0,12,27206,8,0,0,0,0,1,0,0,0,0,0,0,0,'Onslaught Warhorse - On Spawn - Summon Onslaught Knight'),
+(27206,0,0,0,1,0,100,1,500,500,500,500,11,43671,3,0,0,0,0,19,27213,0,0,0,0,0,0,'Onslaught Knight - OOC once - Cast Ride Vehicle on Onslaught Warhorse');
+
+-- Remove spawned Onslaught Knights
+DELETE FROM `creature_addon` WHERE `guid` IN (Select `guid` FROM `creature` WHERE `id`=27206);
+DELETE FROM `creature` WHERE `id`=27206;
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102716;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2508.58,`position_y`=-290.6462,`position_z`=-0.1427202 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2519.424,-279.186,-0.7677202,0,0,0,100,0),
+(@PATH,2,2530.539,-279.0238,-0.7677202,0,0,0,100,0),
+(@PATH,3,2539.442,-270.758,-0.3258755,0,0,0,100,0),
+(@PATH,4,2540.027,-251.3916,-0.06487894,0,0,0,100,0),
+(@PATH,5,2539.442,-270.758,-0.3258755,0,0,0,100,0),
+(@PATH,6,2530.539,-279.0238,-0.7677202,0,0,0,100,0),
+(@PATH,7,2519.424,-279.186,-0.7677202,0,0,0,100,0),
+(@PATH,8,2508.58,-290.6462,-0.1427202,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102717;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2587.305,`position_y`=-291.1189,`position_z`=3.032966 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2601.257,-273.5315,1.532966,0,0,0,100,0),
+(@PATH,2,2618.792,-253.0176,2.282767,0,0,0,100,0),
+(@PATH,3,2633.199,-245.2131,4.532767,0,0,0,100,0),
+(@PATH,4,2618.873,-252.9083,2.282767,0,0,0,100,0),
+(@PATH,5,2601.339,-273.4219,1.532966,0,0,0,100,0),
+(@PATH,6,2587.305,-291.1189,3.032966,0,0,0,100,0),
+(@PATH,7,2575.844,-304.2566,3.642326,0,0,0,100,0),
+(@PATH,8,2570.643,-318.0563,3.767326,0,0,0,100,0),
+(@PATH,9,2571.61,-332.3442,3.767326,0,0,0,100,0),
+(@PATH,10,2570.399,-357.3963,3.884323,0,0,0,100,0),
+(@PATH,11,2571.61,-332.3442,3.767326,0,0,0,100,0),
+(@PATH,12,2570.643,-318.0563,3.767326,0,0,0,100,0),
+(@PATH,13,2575.844,-304.2566,3.642326,0,0,0,100,0),
+(@PATH,14,2587.305,-291.1189,3.032966,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102719;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2538.552,`position_y`=-475.1394,`position_z`=0.6403183 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2515.825,-450.3543,0.282984,0,0,0,100,0),
+(@PATH,2,2538.552,-475.1394,0.6403183,0,0,0,100,0),
+(@PATH,3,2562.629,-487.9083,0.7653183,0,0,0,100,0),
+(@PATH,4,2569.465,-510.7032,0.8169425,0,0,0,100,0),
+(@PATH,5,2575.739,-523.7434,1.191942,0,0,0,100,0),
+(@PATH,6,2601.065,-534.6965,0.9285774,0,0,0,100,0),
+(@PATH,7,2575.739,-523.7434,1.191942,0,0,0,100,0),
+(@PATH,8,2569.465,-510.7032,0.8169425,0,0,0,100,0),
+(@PATH,9,2562.629,-487.9083,0.7653183,0,0,0,100,0),
+(@PATH,10,2538.552,-475.1394,0.6403183,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102721;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2582.436,`position_y`=-222.4737,`position_z`=-0.4052925 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2579.515,-214.4551,-0.5302925,0,0,0,100,0),
+(@PATH,2,2580.979,-202.8364,0.3447075,0,0,0,100,0),
+(@PATH,3,2579.515,-214.4551,-0.5302925,0,0,0,100,0),
+(@PATH,4,2582.436,-222.4737,-0.4052925,0,0,0,100,0),
+(@PATH,5,2561.902,-230.8203,-0.3034239,0,0,0,100,0),
+(@PATH,6,2582.436,-222.4737,-0.4052925,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102723;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2838.992,`position_y`=-178.4683,`position_z`=137.0378 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2837.595,-191.9704,137.9128,0,0,0,100,0),
+(@PATH,2,2842.86,-215.9774,136.6075,0,0,0,100,0),
+(@PATH,3,2837.595,-191.9704,137.9128,0,0,0,100,0),
+(@PATH,4,2838.992,-178.4683,137.0378,0,0,0,100,0),
+(@PATH,5,2836.44,-170.251,138.1628,0,0,0,100,0),
+(@PATH,6,2829.992,-167.1136,138.761,0,0,0,100,0),
+(@PATH,7,2820.281,-166.5459,138.6697,0,0,0,100,0),
+(@PATH,8,2829.992,-167.1136,138.761,0,0,0,100,0),
+(@PATH,9,2836.44,-170.251,138.1628,0,0,0,100,0),
+(@PATH,10,2838.992,-178.4683,137.0378,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102724;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2712.161,`position_y`=-564.5253,`position_z`=9.693825 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2693.882,-580.2343,7.060011,0,0,0,100,0),
+(@PATH,2,2672.807,-596.9056,9.185011,0,0,0,100,0),
+(@PATH,3,2662.762,-603.8812,9.776094,0,0,0,100,0),
+(@PATH,4,2648.289,-604.2076,10.40109,0,0,0,100,0),
+(@PATH,5,2662.762,-603.8812,9.776094,0,0,0,100,0),
+(@PATH,6,2672.807,-596.9056,9.185011,0,0,0,100,0),
+(@PATH,7,2693.882,-580.2343,7.060011,0,0,0,100,0),
+(@PATH,8,2712.161,-564.5253,9.693825,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102725;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2688.144,`position_y`=-181.5894,`position_z`=138.8123 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2690.253,-211.2009,138.7873,0,0,0,100,0),
+(@PATH,2,2711.088,-233.0926,141.4496,0,0,0,100,0),
+(@PATH,3,2691.518,-247.295,142.4064,0,0,0,100,0),
+(@PATH,4,2690.253,-211.2009,138.7873,0,0,0,100,0),
+(@PATH,5,2688.144,-181.5894,138.8123,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102726;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2832.563,`position_y`=-258.2318,`position_z`=133.0783 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2823.757,-269.6722,132.6919,0,0,0,100,0),
+(@PATH,2,2810.606,-274.9349,132.6919,0,0,0,100,0),
+(@PATH,3,2798.263,-267.8378,132.7004,0,0,0,100,0),
+(@PATH,4,2795.204,-255.2375,132.6619,0,0,0,100,0),
+(@PATH,5,2815.456,-249.9233,133.0783,0,0,0,100,0),
+(@PATH,6,2841.983,-244.2453,135.4677,0,0,0,100,0),
+(@PATH,7,2815.456,-249.9233,133.0783,0,0,0,100,0),
+(@PATH,8,2795.204,-255.2375,132.6619,0,0,0,100,0),
+(@PATH,9,2798.263,-267.8378,132.7004,0,0,0,100,0),
+(@PATH,10,2810.606,-274.9349,132.6919,0,0,0,100,0),
+(@PATH,11,2823.757,-269.6722,132.6919,0,0,0,100,0),
+(@PATH,12,2832.563,-258.2318,133.0783,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102727;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2655.115,`position_y`=-139.6238,`position_z`=73.46788 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2656.776,-155.0757,66.71788,0,0,0,100,0),
+(@PATH,2,2655.572,-172.0843,62.16366,0,0,0,100,0),
+(@PATH,3,2650.678,-180.1066,63.41366,0,0,0,100,0),
+(@PATH,4,2656.032,-164.1928,64.71788,0,0,0,100,0),
+(@PATH,5,2656.646,-150.7192,68.46788,0,0,0,100,0),
+(@PATH,6,2654.885,-130.6351,77.12984,0,0,0,100,0),
+(@PATH,7,2659.214,-115.5115,82.62984,0,0,0,100,0),
+(@PATH,8,2659.958,-93.19423,87.00713,0,0,0,100,0),
+(@PATH,9,2666.549,-83.81207,89.50713,0,0,0,100,0),
+(@PATH,10,2681.103,-87.36887,92.43093,0,0,0,100,0),
+(@PATH,11,2700.115,-95.54926,101.8188,0,0,0,100,0),
+(@PATH,12,2718.652,-104.436,110.9657,0,0,0,100,0),
+(@PATH,13,2731.385,-117.8694,116.5907,0,0,0,100,0),
+(@PATH,14,2726.709,-128.2827,120.8407,0,0,0,100,0),
+(@PATH,15,2714.232,-134.095,125.4612,0,0,0,100,0),
+(@PATH,16,2684.606,-134.3662,125.9815,0,0,0,100,0),
+(@PATH,17,2705.027,-135.4983,127.8362,0,0,0,100,0),
+(@PATH,18,2719.343,-131.1707,122.8407,0,0,0,100,0),
+(@PATH,19,2731.655,-119.8017,117.2157,0,0,0,100,0),
+(@PATH,20,2725.038,-106.6583,113.3407,0,0,0,100,0),
+(@PATH,21,2703.98,-99.18321,103.9438,0,0,0,100,0),
+(@PATH,22,2680.189,-88.67188,92.05593,0,0,0,100,0),
+(@PATH,23,2665.09,-83.62039,89.38213,0,0,0,100,0),
+(@PATH,24,2660.516,-94.05186,87.00713,0,0,0,100,0),
+(@PATH,25,2659.939,-112.8213,83.37984,0,0,0,100,0),
+(@PATH,26,2658.327,-126.0295,79.12984,0,0,0,100,0),
+(@PATH,27,2655.115,-139.6238,73.46788,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102728;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2809.652,`position_y`=-404.1015,`position_z`=118.2837 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2820.063,-404.6535,118.2837,0,0,0,100,0),
+(@PATH,2,2808.515,-405.1523,118.2837,0,0,0,100,0),
+(@PATH,3,2793.463,-420.3747,118.3209,0,0,0,100,0),
+(@PATH,4,2779.776,-437.7538,118.6404,0,0,0,100,0),
+(@PATH,5,2775.378,-463.4759,116.1404,0,0,0,100,0),
+(@PATH,6,2767.986,-472.3566,116.8041,0,0,0,100,0),
+(@PATH,7,2755.093,-477.2342,121.6782,0,0,0,100,0),
+(@PATH,8,2773.319,-467.1881,116.1791,0,0,0,100,0),
+(@PATH,9,2778.031,-447.918,118.3904,0,0,0,100,0),
+(@PATH,10,2785.59,-429.4701,118.3209,0,0,0,100,0),
+(@PATH,11,2800.177,-413.79,118.2837,0,0,0,100,0),
+(@PATH,12,2809.652,-404.1015,118.2837,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102729;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2750.5,`position_y`=-154.7686,`position_z`=139.4088 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2741.167,-164.7871,139.1588,0,0,0,100,0),
+(@PATH,2,2750.5,-154.7686,139.4088,0,0,0,100,0),
+(@PATH,3,2759.093,-161.0407,138.9088,0,0,0,100,0),
+(@PATH,4,2771.567,-152.4166,139.9017,0,0,0,100,0),
+(@PATH,5,2781.019,-154.3085,140.5267,0,0,0,100,0),
+(@PATH,6,2791.13,-161.2096,139.1517,0,0,0,100,0),
+(@PATH,7,2802.436,-164.2816,137.4197,0,0,0,100,0),
+(@PATH,8,2791.13,-161.2096,139.1517,0,0,0,100,0),
+(@PATH,9,2781.019,-154.3085,140.5267,0,0,0,100,0),
+(@PATH,10,2771.567,-152.4166,139.9017,0,0,0,100,0),
+(@PATH,11,2759.093,-161.0407,138.9088,0,0,0,100,0),
+(@PATH,12,2750.5,-154.7686,139.4088,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102730;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2712.018,`position_y`=-465.3528,`position_z`=85.87247 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2722.812,-487.2094,91.62904,0,0,0,100,0),
+(@PATH,2,2726.125,-504.7564,94.96687,0,0,0,100,0),
+(@PATH,3,2720.495,-521.4435,91.71687,0,0,0,100,0),
+(@PATH,4,2727.937,-503.8876,95.59187,0,0,0,100,0),
+(@PATH,5,2725.637,-491.6325,93.62904,0,0,0,100,0),
+(@PATH,6,2715.711,-476.3229,88.62904,0,0,0,100,0),
+(@PATH,7,2704.701,-454.9398,81.12247,0,0,0,100,0),
+(@PATH,8,2692.514,-431.9863,72.42125,0,0,0,100,0),
+(@PATH,9,2672.562,-431.7496,64.54625,0,0,0,100,0),
+(@PATH,10,2649.395,-432.2932,52.79884,0,0,0,100,0),
+(@PATH,11,2643.88,-442.8751,50.55303,0,0,0,100,0),
+(@PATH,12,2652.563,-431.4375,54.42384,0,0,0,100,0),
+(@PATH,13,2682.649,-431.7939,69.17125,0,0,0,100,0),
+(@PATH,14,2693.424,-434.0273,73.17553,0,0,0,100,0),
+(@PATH,15,2703.067,-449.0695,79.62247,0,0,0,100,0),
+(@PATH,16,2712.018,-465.3528,85.87247,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102731;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2534.057,`position_y`=-419.9908,`position_z`=3.277672 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2543.743,-400.441,2.027672,0,0,0,100,0),
+(@PATH,2,2555.679,-395.5271,2.825949,0,0,0,100,0),
+(@PATH,3,2543.743,-400.441,2.027672,0,0,0,100,0),
+(@PATH,4,2534.057,-419.9908,3.277672,0,0,0,100,0),
+(@PATH,5,2532.219,-440.2344,3.032984,0,0,0,100,0),
+(@PATH,6,2532.378,-470.4768,0.8200397,0,0,0,100,0),
+(@PATH,7,2548.762,-479.3864,0.5153183,0,0,0,100,0),
+(@PATH,8,2532.378,-470.4768,0.8200397,0,0,0,100,0),
+(@PATH,9,2532.219,-440.2344,3.032984,0,0,0,100,0),
+(@PATH,10,2534.057,-419.9908,3.277672,0,0,0,100,0);
+
+-- Pathing for Onslaught Warhorse Entry: 27213
+SET @NPC := 102734;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2684.26,`position_y`=-287.8797,`position_z`=127.2792 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_flag`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,2728.101,-295.6697,132.1564,0,0,0,100,0),
+(@PATH,2,2698.353,-312.0914,133.1807,0,0,0,100,0),
+(@PATH,3,2689.288,-321.3154,132.3057,0,0,0,100,0),
+(@PATH,4,2675.345,-320.4376,131.9307,0,0,0,100,0),
+(@PATH,5,2654.261,-324.0862,132.1816,0,0,0,100,0),
+(@PATH,6,2675.345,-320.4376,131.9307,0,0,0,100,0),
+(@PATH,7,2689.288,-321.3154,132.3057,0,0,0,100,0),
+(@PATH,8,2698.353,-312.0914,133.1807,0,0,0,100,0),
+(@PATH,9,2728.101,-295.6697,132.1564,0,0,0,100,0),
+(@PATH,10,2684.26,-287.8797,127.2792,0,0,0,100,0);