DB/Pathing: Howling Fjord - Wyrmskol

1 files changed, 398 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_13_00_world.sql b/sql/updates/world/2015_07_13_00_world.sql
new file mode 100644
index 00000000000..384699449f4
--- /dev/null
+++ b/sql/updates/world/2015_07_13_00_world.sql
@@ -0,0 +1,398 @@
+-- Howling Fjord - Wyrmskol
+-- 1.
+SET @NPC := 104907;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=832.9526,`position_y`=-4900.833,`position_z`=2.292943 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,832.9526,-4900.833,2.292943,0,0,0,0,100,0),
+(@PATH,2,833.7026,-4894.833,2.042943,0,0,0,0,100,0),
+(@PATH,3,834.7026,-4887.833,1.292943,0,0,0,0,100,0),
+(@PATH,4,836.7026,-4871.333,2.042943,0,0,0,0,100,0),
+(@PATH,5,837.6712,-4864.411,2.218289,0,0,0,0,100,0),
+(@PATH,6,834.9212,-4855.161,2.718289,0,0,0,0,100,0),
+(@PATH,7,833.6712,-4849.161,3.218289,0,0,0,0,100,0),
+(@PATH,8,832.6712,-4845.411,3.718289,0,0,0,0,100,0),
+(@PATH,9,833.3871,-4848.325,3.284828,0,0,0,0,100,0),
+(@PATH,10,834.6371,-4853.075,2.784828,0,0,0,0,100,0),
+(@PATH,11,836.6371,-4860.575,2.284828,0,0,0,0,100,0),
+(@PATH,12,837.5208,-4864.751,2.011053,0,0,0,0,100,0),
+(@PATH,13,836.0208,-4876.501,1.511053,0,0,0,0,100,0),
+(@PATH,14,833.2708,-4897.251,2.011053,0,0,0,0,100,0),
+(@PATH,15,832.8204,-4900.963,2.558359,0,0,0,0,100,0),
+(@PATH,16,837.8204,-4908.463,3.058359,0,0,0,0,100,0),
+(@PATH,17,840.5704,-4912.713,3.308359,0,0,0,0,100,0),
+(@PATH,18,842.8204,-4915.713,4.058359,0,0,0,0,100,0),
+(@PATH,19,845.3204,-4919.963,4.558359,0,0,0,0,100,0),
+(@PATH,20,852.834,-4931.051,4.537304,0,0,0,0,100,0),
+(@PATH,21,865.834,-4948.301,4.037304,0,0,0,0,100,0),
+(@PATH,22,869.4553,-4953.051,3.750921,0,0,0,0,100,0),
+(@PATH,23,875.4553,-4956.801,3.250921,0,0,0,0,100,0),
+(@PATH,24,878.4553,-4958.551,2.750921,0,0,0,0,100,0),
+(@PATH,25,882.7053,-4961.301,2.000921,0,0,0,0,100,0),
+(@PATH,26,878.4462,-4958.602,2.705121,0,0,0,0,100,0),
+(@PATH,27,876.1962,-4957.352,3.205121,0,0,0,0,100,0),
+(@PATH,28,869.2432,-4952.792,3.942354,0,0,0,0,100,0),
+(@PATH,29,859.7432,-4940.292,4.442354,0,0,0,0,100,0),
+(@PATH,30,852.5776,-4930.71,4.488802,0,0,0,0,100,0),
+(@PATH,31,842.3276,-4915.21,3.988802,0,0,0,0,100,0),
+(@PATH,32,840.0776,-4911.96,3.238802,0,0,0,0,100,0),
+(@PATH,33,837.3276,-4907.71,2.988802,0,0,0,0,100,0);
+
+-- 2.
+SET @NPC := 105806;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=991.1062,`position_y`=-4830.96,`position_z`=17.1903 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,991.1062,-4830.96,17.1903,0,0,0,0,100,0),
+(@PATH,2,992.1062,-4829.71,17.1903,0,0,0,0,100,0),
+(@PATH,3,999.1062,-4822.46,17.1903,0,0,0,0,100,0),
+(@PATH,4,999.361,-4822.228,17.19029,0,0,0,0,100,0),
+(@PATH,5,1001.111,-4820.478,17.19029,0,0,0,0,100,0),
+(@PATH,6,1005.111,-4815.728,17.19029,0,0,0,0,100,0),
+(@PATH,7,1006.861,-4813.978,17.19029,0,0,0,0,100,0),
+(@PATH,8,1007.611,-4812.978,17.19029,0,0,0,0,100,0),
+(@PATH,9,1000.811,-4820.833,17.1903,0,0,0,0,100,0),
+(@PATH,10,999.0606,-4822.333,17.1903,0,0,0,0,100,0),
+(@PATH,11,991.9886,-4830.128,17.1903,0,0,0,0,100,0),
+(@PATH,12,990.9886,-4831.128,17.1903,0,0,0,0,100,0),
+(@PATH,13,989.9886,-4832.128,17.1903,0,0,0,0,100,0),
+(@PATH,14,989.2386,-4832.878,17.1903,0,0,0,0,100,0);
+
+-- 3.
+SET @NPC := 105798;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=924.4086,`position_y`=-4838.904,`position_z`=6.411173 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,924.4086,-4838.904,6.411173,0,0,0,0,100,0),
+(@PATH,2,924.1586,-4840.654,6.411173,0,0,0,0,100,0),
+(@PATH,3,911.9665,-4838.748,6.289279,0,0,0,0,100,0),
+(@PATH,4,907.4665,-4828.998,6.789279,0,0,0,0,100,0),
+(@PATH,5,907.2181,-4828.92,6.567353,0,0,0,0,100,0),
+(@PATH,6,906.4681,-4827.67,6.817353,0,0,0,0,100,0),
+(@PATH,7,906.7062,-4827.532,6.844745,0,0,0,0,100,0),
+(@PATH,8,903.7062,-4827.532,6.844745,0,0,0,0,100,0),
+(@PATH,9,905.2062,-4831.282,6.344745,0,0,0,0,100,0),
+(@PATH,10,908.2062,-4839.532,6.094745,0,0,0,0,100,0),
+(@PATH,11,908.4603,-4839.719,5.910981,0,0,0,0,100,0),
+(@PATH,12,908.9603,-4840.719,5.910981,0,0,0,0,100,0),
+(@PATH,13,924.6008,-4838.925,6.675292,0,0,0,0,100,0),
+(@PATH,14,924.8508,-4836.925,7.425292,0,0,0,0,100,0),
+(@PATH,15,925.1008,-4833.925,8.675291,0,0,0,0,100,0),
+(@PATH,16,925.3508,-4832.675,8.925291,0,0,0,0,100,0),
+(@PATH,17,925.3508,-4832.175,9.175291,0,0,0,0,100,0),
+(@PATH,18,925.1008,-4831.175,9.175291,0,0,0,0,100,0),
+(@PATH,19,925.3508,-4830.675,8.925291,0,0,0,0,100,0),
+(@PATH,20,925.8508,-4827.425,8.925291,0,0,0,0,100,0),
+(@PATH,21,925.8508,-4826.925,8.925291,0,0,0,0,100,0),
+(@PATH,22,926.1008,-4826.175,8.925291,0,0,0,0,100,0),
+(@PATH,23,926.6008,-4822.175,8.925291,0,0,0,0,100,0),
+(@PATH,24,927.5,-4816.937,9.10537,0,0,0,0,100,0),
+(@PATH,25,924.0263,-4816.295,9.076832,0,0,0,0,100,0),
+(@PATH,26,924.0263,-4820.545,9.076832,0,0,0,0,100,0),
+(@PATH,27,924.2763,-4824.295,9.076832,0,0,0,0,100,0),
+(@PATH,28,924.2763,-4826.045,9.076832,0,0,0,0,100,0),
+(@PATH,29,924.2763,-4827.045,9.076832,0,0,0,0,100,0),
+(@PATH,30,924.5263,-4829.795,9.076832,0,0,0,0,100,0),
+(@PATH,31,924.5263,-4831.545,9.326832,0,0,0,0,100,0),
+(@PATH,32,924.5263,-4833.295,9.076832,0,0,0,0,100,0),
+(@PATH,33,924.5263,-4836.545,7.576832,0,0,0,0,100,0),
+(@PATH,34,924.7763,-4838.795,6.576832,0,0,0,0,100,0);
+
+DELETE FROM `creature_addon` WHERE `guid`=104797;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES 
+(104797,0,0,0,1,27, '');
+
+-- 4.
+SET @NPC := 105510;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=928.6401,`position_y`=-4950.189,`position_z`=2.880867 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,928.6401,-4950.189,2.880867,0,0,0,0,100,0),
+(@PATH,2,926.8901,-4949.689,2.880867,0,0,0,0,100,0),
+(@PATH,3,926.1401,-4950.939,2.380867,0,0,0,0,100,0),
+(@PATH,4,924.8901,-4951.439,2.380867,0,0,0,0,100,0),
+(@PATH,5,923.3901,-4953.689,2.130867,0,0,0,0,100,0),
+(@PATH,6,923.3901,-4953.939,1.630867,0,0,0,0,100,0),
+(@PATH,7,923.1401,-4957.189,3.130867,0,0,0,0,100,0),
+(@PATH,8,923.1401,-4958.439,3.380867,0,0,0,0,100,0),
+(@PATH,9,923.6401,-4959.689,3.630867,0,0,0,0,100,0),
+(@PATH,10,923.1401,-4960.689,3.380867,0,0,0,0,100,0),
+(@PATH,11,921.8901,-4963.689,3.380867,0,0,0,0,100,0),
+(@PATH,12,920.8901,-4966.189,3.380867,0,0,0,0,100,0),
+(@PATH,13,919.8901,-4968.439,3.380867,0,0,0,0,100,0),
+(@PATH,14,917.8901,-4973.689,3.380867,0,0,0,0,100,0),
+(@PATH,15,917.8533,-4973.872,3.371433,0,0,0,0,100,0),
+(@PATH,16,917.3533,-4975.122,3.621433,0,0,0,0,100,0),
+(@PATH,17,917.6033,-4974.122,3.621433,0,0,0,0,100,0),
+(@PATH,18,920.1033,-4968.372,3.371433,0,0,0,0,100,0),
+(@PATH,19,921.1033,-4966.122,3.371433,0,0,0,0,100,0),
+(@PATH,20,921.8533,-4963.872,3.371433,0,0,0,0,100,0),
+(@PATH,21,922.8533,-4960.622,3.371433,0,0,0,0,100,0),
+(@PATH,22,923.6033,-4959.622,3.621433,0,0,0,0,100,0),
+(@PATH,23,924.3533,-4957.872,3.371433,0,0,0,0,100,0),
+(@PATH,24,925.3533,-4955.372,2.121433,0,0,0,0,100,0),
+(@PATH,25,926.0581,-4950.71,2.163225,0,0,0,0,100,0),
+(@PATH,26,922.1503,-4948.315,2.218931,0,0,0,0,100,0),
+(@PATH,27,926.5681,-4950.268,2.852909,0,0,0,0,100,0);
+
+-- 5.
+SET @NPC := 105803;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1020.718,`position_y`=-4964.679,`position_z`=8.971722 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,1020.718,-4964.679,8.971722,0,0,0,0,100,0),
+(@PATH,2,1015.468,-4973.929,8.471722,0,0,0,0,100,0),
+(@PATH,3,1015.241,-4974.018,8.366907,0,0,0,0,100,0),
+(@PATH,4,1013.741,-4976.268,8.116907,0,0,0,0,100,0),
+(@PATH,5,1012.491,-4975.768,7.866907,0,0,0,0,100,0),
+(@PATH,6,1010.491,-4975.268,7.616907,0,0,0,0,100,0),
+(@PATH,7,1009.491,-4975.268,7.366907,0,0,0,0,100,0),
+(@PATH,8,1008.241,-4975.268,7.116907,0,0,0,0,100,0),
+(@PATH,9,1001.241,-4974.768,6.616907,0,0,0,0,100,0),
+(@PATH,10,1000.241,-4975.768,6.616907,0,0,0,0,100,0),
+(@PATH,11,995.9764,-4972.892,6.077339,0,0,0,0,100,0),
+(@PATH,12,986.4764,-4962.892,5.577339,0,0,0,0,100,0),
+(@PATH,13,982.9764,-4959.142,5.077339,0,0,0,0,100,0),
+(@PATH,14,978.9764,-4954.892,4.577339,0,0,0,0,100,0),
+(@PATH,15,979.0667,-4954.604,4.314516,0,0,0,0,100,0),
+(@PATH,16,978.0667,-4953.604,4.314516,0,0,0,0,100,0),
+(@PATH,17,981.6317,-4935.452,4.541917,0,0,0,0,100,0),
+(@PATH,18,992.8817,-4931.952,5.041917,0,0,0,0,100,0),
+(@PATH,19,999.0505,-4930.004,5.220732,0,0,0,0,100,0),
+(@PATH,20,1004.551,-4931.504,5.720732,0,0,0,0,100,0),
+(@PATH,21,1009.301,-4932.504,6.220732,0,0,0,0,100,0),
+(@PATH,22,1009.646,-4932.741,6.460849,0,0,0,0,100,0),
+(@PATH,23,1012.396,-4933.491,6.960849,0,0,0,0,100,0),
+(@PATH,24,1015.146,-4938.741,7.710849,0,0,0,0,100,0),
+(@PATH,25,1017.646,-4943.741,7.960849,0,0,0,0,100,0),
+(@PATH,26,1019.896,-4948.241,8.710849,0,0,0,0,100,0),
+(@PATH,27,1022.146,-4952.741,9.460849,0,0,0,0,100,0),
+(@PATH,28,1022.264,-4952.971,9.396458,0,0,0,0,100,0),
+(@PATH,29,1023.264,-4954.971,9.646458,0,0,0,0,100,0);
+
+-- visualspells
+-- Dragonflayer Death Weaver SAI
+SET @ENTRY := 23658;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;
+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
+(@ENTRY,0,0,0,1,0,100,0,1000,1000,1000,1000,11,43159,0,0,0,0,0,19,24158,30,0,0,0,0,0,"Dragonflayer Death Weaver - Out of Combat - Cast 'Soul Infusion'");
+-- remove rndmmovement
+UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE  `guid`=104386;
+
+-- 6.
+SET @NPC := 105801;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1033.632,`position_y`=-5027.26,`position_z`=10.98902 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,1033.632,-5027.26,10.98902,0,0,0,0,100,0),
+(@PATH,2,1040.969,-5052.146,10.95943,0,0,0,0,100,0),
+(@PATH,3,1041.719,-5055.146,10.95943,0,0,0,0,100,0),
+(@PATH,4,1044.219,-5064.146,10.95943,0,0,0,0,100,0),
+(@PATH,5,1046.595,-5071.466,10.83414,0,0,0,0,100,0),
+(@PATH,6,1051.095,-5071.216,10.83414,0,0,0,0,100,0),
+(@PATH,7,1053.345,-5071.216,10.83414,0,0,0,0,100,0),
+(@PATH,8,1055.595,-5070.966,10.58414,0,0,0,0,100,0),
+(@PATH,9,1057.095,-5070.966,10.58414,0,0,0,0,100,0),
+(@PATH,10,1059.345,-5070.716,10.58414,0,0,0,0,100,0),
+(@PATH,11,1059.584,-5070.768,10.60721,0,0,0,0,100,0),
+(@PATH,12,1062.334,-5070.768,10.60721,0,0,0,0,100,0),
+(@PATH,13,1066.834,-5072.018,11.10721,0,0,0,0,100,0),
+(@PATH,14,1077.334,-5069.018,11.35721,0,0,0,0,100,0),
+(@PATH,15,1077.834,-5068.768,10.60721,0,0,0,0,100,0),
+(@PATH,16,1087.084,-5064.268,10.60721,0,0,0,0,100,0),
+(@PATH,17,1093.334,-5060.768,10.35721,0,0,0,0,100,0),
+(@PATH,18,1083.835,-5057.688,10.86776,0,0,0,0,100,0),
+(@PATH,19,1080.085,-5057.438,10.36776,0,0,0,0,100,0),
+(@PATH,20,1066.835,-5060.938,10.36776,0,0,0,0,100,0),
+(@PATH,21,1062.081,-5070.768,10.56456,0,0,0,0,100,0),
+(@PATH,22,1059.331,-5070.768,10.56456,0,0,0,0,100,0),
+(@PATH,23,1057.081,-5071.018,10.56456,0,0,0,0,100,0),
+(@PATH,24,1055.581,-5071.018,10.56456,0,0,0,0,100,0),
+(@PATH,25,1053.331,-5071.018,10.81456,0,0,0,0,100,0),
+(@PATH,26,1051.331,-5071.268,10.81456,0,0,0,0,100,0),
+(@PATH,27,1046.227,-5071.43,10.92623,0,0,0,0,100,0),
+(@PATH,28,1044.227,-5064.18,10.92623,0,0,0,0,100,0),
+(@PATH,29,1041.727,-5055.18,10.92623,0,0,0,0,100,0),
+(@PATH,30,1041.615,-5054.926,11.01639,0,0,0,0,100,0),
+(@PATH,31,1040.615,-5051.926,10.76639,0,0,0,0,100,0),
+(@PATH,32,1033.615,-5027.426,11.01639,0,0,0,0,100,0),
+(@PATH,33,1033.632,-5027.26,10.98902,0,0,0,0,100,0);
+
+-- 7.
+SET @NPC := 101388;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=953.4445,`position_y`=-5022.563,`position_z`=6.194824 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,953.4445,-5022.563,6.194824,0,0,0,0,100,0),
+(@PATH,2,952.6945,-5023.813,6.194824,0,0,0,0,100,0),
+(@PATH,3,960.9445,-5029.063,5.944824,0,0,0,0,100,0),
+(@PATH,4,962.4445,-5029.813,6.194824,0,0,0,0,100,0),
+(@PATH,5,966.4445,-5032.313,6.194824,0,0,0,0,100,0),
+(@PATH,6,971.4445,-5035.563,6.194824,0,0,0,0,100,0),
+(@PATH,7,981.3123,-5041.753,6.079709,0,0,0,0,100,0),
+(@PATH,8,984.0623,-5037.503,6.079709,0,0,0,0,100,0),
+(@PATH,9,985.8123,-5035.003,5.579709,0,0,0,0,100,0),
+(@PATH,10,988.8123,-5030.003,5.079709,0,0,0,0,100,0),
+(@PATH,11,995.8123,-5019.753,4.079709,0,0,0,0,100,0),
+(@PATH,12,996.3123,-5017.253,3.829709,0,0,0,0,100,0),
+(@PATH,13,959.4459,-5012.519,6.297375,0,0,0,0,100,0),
+(@PATH,14,953.4459,-5022.269,6.047375,0,0,0,0,100,0);
+
+-- 8.
+SET @NPC := 113647;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=655.2243,`position_y`=-4943.861,`position_z`=6.125971 WHERE `guid`=@NPC;
+DELETE FROM `creature_addon` WHERE `guid`=@NPC;
+INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,8469,0,1,0, '');
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,655.2243,-4943.861,6.125971,0,0,0,0,100,0),
+(@PATH,2,651.4743,-4931.361,6.625971,0,0,0,0,100,0),
+(@PATH,3,650.2243,-4927.861,7.375971,0,0,0,0,100,0),
+(@PATH,4,649.9743,-4926.111,8.125971,0,0,0,0,100,0),
+(@PATH,5,648.9743,-4923.111,8.625971,0,0,0,0,100,0),
+(@PATH,6,648.4743,-4921.111,9.125971,0,0,0,0,100,0),
+(@PATH,7,647.9743,-4919.361,9.875971,0,0,0,0,100,0),
+(@PATH,8,647.2243,-4917.361,10.62597,0,0,0,0,100,0),
+(@PATH,9,646.2314,-4914.236,12.35588,0,0,0,0,100,0),
+(@PATH,10,645.2314,-4912.486,13.10588,0,0,0,0,100,0),
+(@PATH,11,644.2314,-4910.736,14.35588,0,0,0,0,100,0),
+(@PATH,12,642.4814,-4907.486,16.60588,0,0,0,0,100,0),
+(@PATH,13,641.4814,-4905.736,18.10588,0,0,0,0,100,0),
+(@PATH,14,640.4814,-4903.986,19.60588,0,0,0,0,100,0),
+(@PATH,15,639.3942,-4902.131,20.73806,0,0,0,0,100,0),
+(@PATH,16,639.1442,-4901.131,21.23806,0,0,0,0,100,0),
+(@PATH,17,638.8942,-4900.131,21.98806,0,0,0,0,100,0),
+(@PATH,18,638.6442,-4899.131,22.48806,0,0,0,0,100,0),
+(@PATH,19,638.3942,-4898.131,23.23806,0,0,0,0,100,0),
+(@PATH,20,637.6442,-4896.381,24.48806,0,0,0,0,100,0),
+(@PATH,21,637.6442,-4895.381,24.98806,0,0,0,0,100,0),
+(@PATH,22,637.3942,-4894.631,25.73806,0,0,0,0,100,0),
+(@PATH,23,637.1442,-4893.631,26.23806,0,0,0,0,100,0),
+(@PATH,24,636.8942,-4892.631,26.98806,0,0,0,0,100,0),
+(@PATH,25,636.3942,-4890.631,27.73806,0,0,0,0,100,0),
+(@PATH,26,636.1442,-4889.881,28.48806,0,0,0,0,100,0),
+(@PATH,27,635.8942,-4888.881,29.23806,0,0,0,0,100,0),
+(@PATH,28,635.6442,-4887.881,29.98806,0,0,0,0,100,0),
+(@PATH,29,635.6986,-4888.498,29.41977,0,0,0,0,100,0),
+(@PATH,30,635.4486,-4887.748,29.91977,0,0,0,0,100,0),
+(@PATH,31,635.1986,-4886.998,30.66977,0,0,0,0,100,0),
+(@PATH,32,631.4691,-4887.98,30.75117,0,0,0,0,100,0),
+(@PATH,33,632.4691,-4889.73,29.50117,0,0,0,0,100,0),
+(@PATH,34,633.4691,-4891.48,28.75117,0,0,0,0,100,0),
+(@PATH,35,634.4691,-4893.23,27.00117,0,0,0,0,100,0),
+(@PATH,36,635.4691,-4894.98,25.50117,0,0,0,0,100,0),
+(@PATH,37,636.4691,-4896.48,25.00117,0,0,0,0,100,0),
+(@PATH,38,637.2191,-4898.23,23.50117,0,0,0,0,100,0),
+(@PATH,39,637.9691,-4899.98,22.25117,0,0,0,0,100,0),
+(@PATH,40,638.9691,-4901.73,21.25117,0,0,0,0,100,0),
+(@PATH,41,639.2169,-4901.832,21.10294,0,0,0,0,100,0),
+(@PATH,42,640.2169,-4903.582,19.60294,0,0,0,0,100,0),
+(@PATH,43,641.2169,-4905.332,18.10294,0,0,0,0,100,0),
+(@PATH,44,641.9669,-4907.082,17.10294,0,0,0,0,100,0),
+(@PATH,45,642.9669,-4908.832,15.85294,0,0,0,0,100,0),
+(@PATH,46,643.7169,-4910.332,14.60294,0,0,0,0,100,0),
+(@PATH,47,644.9669,-4913.082,13.10294,0,0,0,0,100,0),
+(@PATH,48,645.9669,-4914.832,11.85294,0,0,0,0,100,0),
+(@PATH,49,646.9669,-4916.582,10.85294,0,0,0,0,100,0),
+(@PATH,50,647.8633,-4917.849,10.43143,0,0,0,0,100,0),
+(@PATH,51,648.3633,-4919.849,9.431431,0,0,0,0,100,0),
+(@PATH,52,649.1133,-4922.849,8.931431,0,0,0,0,100,0),
+(@PATH,53,649.3633,-4924.849,8.181431,0,0,0,0,100,0),
+(@PATH,54,650.1133,-4927.599,7.681431,0,0,0,0,100,0),
+(@PATH,55,650.6133,-4930.349,6.931431,0,0,0,0,100,0),
+(@PATH,56,651.8633,-4935.099,6.431431,0,0,0,0,100,0),
+(@PATH,57,653.776,-4943.458,5.970608,0,0,0,0,100,0),
+(@PATH,58,644.6491,-4957.902,5.843118,0,0,0,0,100,0),
+(@PATH,59,634.1491,-4968.652,5.093118,0,0,0,0,100,0),
+(@PATH,60,619.8991,-4983.652,4.843118,0,0,0,0,100,0),
+(@PATH,61,616.7938,-4986.155,4.304571,0,0,0,0,100,0),
+(@PATH,62,596.7675,-4983.58,4.695544,0,0,0,0,100,0),
+(@PATH,63,576.0175,-4976.83,4.945544,0,0,0,0,100,0),
+(@PATH,64,572.2675,-4975.58,5.695544,0,0,0,0,100,0),
+(@PATH,65,572.0885,-4975.668,5.86325,0,0,0,0,100,0),
+(@PATH,66,571.5885,-4975.418,6.11325,0,0,0,0,100,0),
+(@PATH,67,567.5885,-4976.668,6.86325,0,0,0,0,100,0),
+(@PATH,68,564.0885,-4977.918,7.36325,0,0,0,0,100,0),
+(@PATH,69,561.3385,-4978.668,7.86325,0,0,0,0,100,0),
+(@PATH,70,559.3385,-4979.168,8.61325,0,0,0,0,100,0),
+(@PATH,71,557.3385,-4979.918,9.11325,0,0,0,0,100,0),
+(@PATH,72,555.0521,-4980.638,10.00597,0,0,0,0,100,0),
+(@PATH,73,551.3021,-4981.138,10.50597,0,0,0,0,100,0),
+(@PATH,74,548.5521,-4981.388,11.25597,0,0,0,0,100,0),
+(@PATH,75,545.3079,-4981.789,11.84596,0,0,0,0,100,0),
+(@PATH,76,543.8079,-4979.289,12.84596,0,0,0,0,100,0),
+(@PATH,77,542.3079,-4976.539,14.84596,0,0,0,0,100,0),
+(@PATH,78,541.3079,-4974.789,15.59596,0,0,0,0,100,0),
+(@PATH,79,540.5579,-4973.039,16.59596,0,0,0,0,100,0),
+(@PATH,80,539.5579,-4971.539,17.34596,0,0,0,0,100,0),
+(@PATH,81,538.5579,-4970.039,17.84596,0,0,0,0,100,0),
+(@PATH,82,537.5579,-4968.289,18.84596,0,0,0,0,100,0),
+(@PATH,83,536.5579,-4966.539,19.84596,0,0,0,0,100,0),
+(@PATH,84,535.0579,-4963.789,21.09596,0,0,0,0,100,0),
+(@PATH,85,534.0579,-4962.039,22.09596,0,0,0,0,100,0),
+(@PATH,86,534.0902,-4962.266,21.93852,0,0,0,0,100,0),
+(@PATH,87,533.3402,-4960.766,22.93852,0,0,0,0,100,0),
+(@PATH,88,532.0902,-4961.516,22.93852,0,0,0,0,100,0),
+(@PATH,89,533.8402,-4964.016,21.18852,0,0,0,0,100,0),
+(@PATH,90,534.8402,-4965.766,20.18852,0,0,0,0,100,0),
+(@PATH,91,535.8402,-4967.516,19.43852,0,0,0,0,100,0),
+(@PATH,92,536.8402,-4968.766,18.68852,0,0,0,0,100,0),
+(@PATH,93,537.5902,-4970.516,18.18852,0,0,0,0,100,0),
+(@PATH,94,538.5902,-4972.266,17.18852,0,0,0,0,100,0),
+(@PATH,95,539.606,-4973.961,16.58982,0,0,0,0,100,0),
+(@PATH,96,540.356,-4974.461,16.08982,0,0,0,0,100,0),
+(@PATH,97,542.606,-4976.711,14.58982,0,0,0,0,100,0),
+(@PATH,98,544.356,-4978.461,13.33982,0,0,0,0,100,0),
+(@PATH,99,547.356,-4981.461,11.58982,0,0,0,0,100,0),
+(@PATH,100,547.6256,-4981.252,11.30922,0,0,0,0,100,0),
+(@PATH,101,548.6256,-4982.502,11.05922,0,0,0,0,100,0),
+(@PATH,102,551.6256,-4981.752,10.30922,0,0,0,0,100,0),
+(@PATH,103,554.3756,-4981.002,9.809217,0,0,0,0,100,0),
+(@PATH,104,558.1256,-4980.002,9.059217,0,0,0,0,100,0),
+(@PATH,105,560.1256,-4979.502,8.559217,0,0,0,0,100,0),
+(@PATH,106,558.3359,-4979.884,8.813904,0,0,0,0,100,0),
+(@PATH,107,560.3359,-4979.384,8.313904,0,0,0,0,100,0),
+(@PATH,108,560.8359,-4979.134,8.063904,0,0,0,0,100,0),
+(@PATH,109,564.3359,-4978.134,7.313903,0,0,0,0,100,0),
+(@PATH,110,567.0859,-4977.134,6.813903,0,0,0,0,100,0),
+(@PATH,111,569.8359,-4976.134,6.063903,0,0,0,0,100,0),
+(@PATH,112,570.0482,-4976.134,5.998487,0,0,0,0,100,0),
+(@PATH,113,571.0482,-4975.884,5.748487,0,0,0,0,100,0),
+(@PATH,114,573.7982,-4976.884,5.498487,0,0,0,0,100,0),
+(@PATH,115,576.5482,-4978.134,4.998487,0,0,0,0,100,0),
+(@PATH,116,580.0482,-4979.384,4.498487,0,0,0,0,100,0),
+(@PATH,117,590.3996,-4983.531,3.958145,0,0,0,0,100,0),
+(@PATH,118,599.1496,-4984.781,4.458145,0,0,0,0,100,0),
+(@PATH,119,619.5626,-4987.873,4.363738,0,0,0,0,100,0),
+(@PATH,120,624.5626,-4981.873,4.863738,0,0,0,0,100,0),
+(@PATH,121,630.5004,-4975.25,5.408068,0,0,0,0,100,0),
+(@PATH,122,644.4115,-4961.025,5.549562,0,0,0,0,100,0),
+(@PATH,123,655.3062,-4943.986,6.128833,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=113647;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(113647, 113647, 0, 0, 2, 0, 0),
+(113647, 113648, 4, 0, 2, 0, 0);