DB/Pathing: Howling Ford - Baleheim

(cherry picked from commit 601c46f63d1035340cda06d97ed6c1fd493b33cd)

1 files changed, 441 insertions, 0 deletions

diff --git a/sql/updates/world/2015_07_13_01_world_2015_07_13_01.sql b/sql/updates/world/2015_07_13_01_world_2015_07_13_01.sql
new file mode 100644
index 00000000000..f2d691b3b82
--- /dev/null
+++ b/sql/updates/world/2015_07_13_01_world_2015_07_13_01.sql
@@ -0,0 +1,441 @@
+-- Howling Ford - Baleheim
+
+-- 1.
+SET @NPC := 105427;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1561.077,`position_y`=-5299.635,`position_z`=201.7604 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,1561.077,-5299.635,201.7604,0,0,0,0,100,0),
+(@PATH,2,1571.522,-5299.381,201.9658,0.04711876,0,0,0,100,0),
+(@PATH,3,1556.678,-5299.724,201.5954,0,0,0,0,100,0),
+(@PATH,4,1555.473,-5293.783,202.0718,0,0,0,0,100,0),
+(@PATH,5,1554.473,-5287.783,201.8218,0,0,0,0,100,0),
+(@PATH,6,1553.723,-5283.283,202.0718,0,0,0,0,100,0),
+(@PATH,7,1552.223,-5277.033,201.5718,0,0,0,0,100,0),
+(@PATH,8,1552.223,-5275.033,201.3218,0,0,0,0,100,0),
+(@PATH,9,1551.973,-5272.033,200.5718,0,0,0,0,100,0),
+(@PATH,10,1551.258,-5267.803,200.185,0,0,0,0,100,0),
+(@PATH,11,1554.758,-5257.553,199.435,0,0,0,0,100,0),
+(@PATH,12,1555.758,-5253.803,198.685,0,0,0,0,100,0),
+(@PATH,13,1556.758,-5251.053,198.185,0,0,0,0,100,0),
+(@PATH,14,1557.758,-5248.053,197.435,0,0,0,0,100,0),
+(@PATH,15,1558.88,-5245.146,196.3539,0,0,0,0,100,0),
+(@PATH,16,1558.88,-5242.146,195.6039,0,0,0,0,100,0),
+(@PATH,17,1559.63,-5237.396,195.1039,0,0,0,0,100,0),
+(@PATH,18,1559.86,-5233.974,194.6031,0,0,0,0,100,0),
+(@PATH,19,1559.11,-5231.224,193.8531,0,0,0,0,100,0),
+(@PATH,20,1557.86,-5227.224,193.1031,0,0,0,0,100,0),
+(@PATH,21,1557.11,-5224.474,192.3531,0,0,0,0,100,0),
+(@PATH,22,1556.61,-5222.474,191.8531,0,0,0,0,100,0),
+(@PATH,23,1555.36,-5218.724,191.1031,0,0,0,0,100,0),
+(@PATH,24,1554.86,-5215.974,190.3531,0,0,0,0,100,0),
+(@PATH,25,1551.61,-5204.474,189.8531,0,0,0,0,100,0),
+(@PATH,26,1550.081,-5199.936,189.4463,0,0,0,0,100,0),
+(@PATH,27,1543.581,-5195.186,190.1963,0,0,0,0,100,0),
+(@PATH,28,1539.081,-5191.686,190.6963,0,0,0,0,100,0),
+(@PATH,29,1532.888,-5186.81,191.1922,0,0,0,0,100,0),
+(@PATH,30,1519.388,-5181.31,190.4422,0,0,0,0,100,0),
+(@PATH,31,1511.437,-5178.014,190.0339,0,0,0,0,100,0),
+(@PATH,32,1501.937,-5179.514,189.7839,0,0,0,0,100,0),
+(@PATH,33,1490.024,-5181.557,189.5792,0,0,0,0,100,0),
+(@PATH,34,1469.024,-5187.307,189.0792,0,0,0,0,100,0),
+(@PATH,35,1459.077,-5186.193,189.7157,0,0,0,0,100,0),
+(@PATH,36,1457.077,-5185.943,189.9657,0,0,0,0,100,0),
+(@PATH,37,1456.577,-5185.943,190.2157,0,0,0,0,100,0),
+(@PATH,38,1453.577,-5186.443,191.4657,0,0,0,0,100,0),
+(@PATH,39,1453.481,-5186.764,191.6214,0,0,0,0,100,0),
+(@PATH,40,1456.481,-5186.514,190.1214,0,0,0,0,100,0),
+(@PATH,41,1457.481,-5186.514,190.1214,0,0,0,0,100,0),
+(@PATH,42,1458.481,-5186.514,189.8714,0,0,0,0,100,0),
+(@PATH,43,1461.231,-5187.514,189.3714,0,0,0,0,100,0),
+(@PATH,44,1465.014,-5188.682,188.9621,0,0,0,0,100,0),
+(@PATH,45,1459.388,-5198.137,189.6352,0,0,0,0,100,0),
+(@PATH,46,1446.638,-5207.387,190.1352,0,0,0,0,100,0),
+(@PATH,47,1443.388,-5209.887,190.6352,0,0,0,0,100,0),
+(@PATH,48,1440.138,-5212.137,191.3852,0,0,0,0,100,0),
+(@PATH,49,1439.874,-5212.509,191.4967,0,0,0,0,100,0),
+(@PATH,50,1438.374,-5213.509,192.2467,0,0,0,0,100,0),
+(@PATH,51,1437.624,-5216.759,192.9967,0,0,0,0,100,0),
+(@PATH,52,1436.624,-5220.509,193.4967,0,0,0,0,100,0),
+(@PATH,53,1435.874,-5223.509,194.2467,0,0,0,0,100,0),
+(@PATH,54,1435.624,-5224.759,194.7467,0,0,0,0,100,0),
+(@PATH,55,1433.624,-5226.759,195.4967,0,0,0,0,100,0),
+(@PATH,56,1432.624,-5229.009,196.4967,0,0,0,0,100,0),
+(@PATH,57,1432.124,-5231.009,197.2467,0,0,0,0,100,0),
+(@PATH,58,1432.124,-5233.009,197.7467,0,0,0,0,100,0),
+(@PATH,59,1432.156,-5233.357,198.068,0,0,0,0,100,0),
+(@PATH,60,1431.406,-5235.107,198.818,0,0,0,0,100,0),
+(@PATH,61,1430.906,-5242.107,201.568,0,0,0,0,100,0),
+(@PATH,62,1430.906,-5243.107,201.568,0,0,0,0,100,0),
+(@PATH,63,1434.406,-5243.857,202.818,0,0,0,0,100,0),
+(@PATH,64,1433.817,-5253.724,205.7995,0,0,0,0,100,0),
+(@PATH,65,1434.067,-5254.724,205.7995,0,0,0,0,100,0),
+(@PATH,66,1434.567,-5255.224,206.2995,0,0,0,0,100,0),
+(@PATH,67,1435.067,-5256.724,206.2995,0,0,0,0,100,0),
+(@PATH,68,1435.817,-5257.724,206.5495,0,0,0,0,100,0),
+(@PATH,69,1439.067,-5265.974,207.0495,0,0,0,0,100,0),
+(@PATH,70,1439.567,-5266.974,206.7995,0,0,0,0,100,0),
+(@PATH,71,1440.317,-5267.474,207.0495,0,0,0,0,100,0),
+(@PATH,72,1441.067,-5267.974,206.7995,0,0,0,0,100,0),
+(@PATH,73,1443.456,-5270.874,206.9769,0,0,0,0,100,0),
+(@PATH,74,1466.157,-5273.644,206.4446,0,0,0,0,100,0),
+(@PATH,75,1481.157,-5273.894,206.1946,0,0,0,0,100,0),
+(@PATH,76,1487.907,-5273.894,206.4446,0,0,0,0,100,0),
+(@PATH,77,1499.916,-5274.196,206.7411,0,0,0,0,100,0),
+(@PATH,78,1510.666,-5269.196,205.9911,0,0,0,0,100,0),
+(@PATH,79,1516.916,-5266.696,205.4911,0,0,0,0,100,0),
+(@PATH,80,1521.416,-5264.446,204.9911,0,0,0,0,100,0),
+(@PATH,81,1526.284,-5264.774,203.6901,0,0,0,0,100,0),
+(@PATH,82,1528.034,-5265.024,203.1901,0,0,0,0,100,0),
+(@PATH,83,1530.034,-5266.274,202.4401,0,0,0,0,100,0),
+(@PATH,84,1539.034,-5267.024,201.1901,0,0,0,0,100,0),
+(@PATH,85,1541.784,-5267.524,200.9401,0,0,0,0,100,0),
+(@PATH,86,1545.871,-5267.189,200.2871,0,0,0,0,100,0),
+(@PATH,87,1550.121,-5270.939,200.2871,0,0,0,0,100,0),
+(@PATH,88,1551.371,-5273.439,201.0371,0,0,0,0,100,0),
+(@PATH,89,1552.121,-5274.689,201.2871,0,0,0,0,100,0),
+(@PATH,90,1551.774,-5279.828,201.8945,0,0,0,0,100,0),
+(@PATH,91,1549.524,-5288.328,201.1445,0,0,0,0,100,0),
+(@PATH,92,1551.274,-5292.578,201.1445,0,0,0,0,100,0),
+(@PATH,93,1551.409,-5292.688,201.2267,0,0,0,0,100,0),
+(@PATH,94,1551.409,-5293.688,201.2267,0,0,0,0,100,0),
+(@PATH,95,1555.409,-5296.188,201.7267,0,0,0,0,100,0),
+(@PATH,96,1561.142,-5299.583,201.7539,0,0,0,0,100,0),
+(@PATH,97,1571.522,-5299.381,201.9658,0.04711876,0,0,0,100,0);
+
+-- 2.
+SET @NPC := 114753;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1601.395,`position_y`=-4968.979,`position_z`=144.1384 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,1601.395,-4968.979,144.1384,0,0,0,0,100,0),
+(@PATH,2,1600.757,-4963.54,144.4538,0,0,0,0,100,0),
+(@PATH,3,1602.757,-4961.29,144.7038,0,0,0,0,100,0),
+(@PATH,4,1605.507,-4958.54,145.4538,0,0,0,0,100,0),
+(@PATH,5,1611.448,-4952.011,145.7336,0,0,0,0,100,0),
+(@PATH,6,1622.198,-4951.261,144.9836,0,0,0,0,100,0),
+(@PATH,7,1626.198,-4951.011,144.4836,0,0,0,0,100,0),
+(@PATH,8,1623.184,-4951.196,144.7398,0,0,0,0,100,0),
+(@PATH,9,1614.434,-4951.446,145.4898,0,0,0,0,100,0),
+(@PATH,10,1611.246,-4952.017,145.6747,0,0,0,0,100,0),
+(@PATH,11,1603.246,-4960.517,144.9247,0,0,0,0,100,0),
+(@PATH,12,1600.839,-4963.714,144.0903,0,0,0,0,100,0),
+(@PATH,13,1602.839,-4977.214,143.8403,0,0,0,0,100,0),
+(@PATH,14,1601.395,-4968.979,144.1384,0,0,0,0,100,0);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=114753;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES 
+(114753, 114753, 0, 0, 2, 0, 0),
+(114753, 100322, 2, 90, 0, 0, 0);
+
+-- 3.
+SET @NPC := 114761;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1499.107,`position_y`=-4958.632,`position_z`=121.1436 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,1499.107,-4958.632,121.1436,0,0,0,0,100,0),
+(@PATH,2,1505.996,-4954.564,121.3016,0,0,0,0,100,0),
+(@PATH,3,1496.012,-4960.557,120.816,0,0,0,0,100,0),
+(@PATH,4,1495.029,-4961.049,120.3304,0.3665192,0,0,0,100,0),
+(@PATH,5,1499.107,-4958.632,121.1436,0,0,0,0,100,0);
+
+-- 4.
+SET @NPC := 114759;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1511.549,`position_y`=-4924.131,`position_z`=124.3161 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,1511.549,-4924.131,124.3161,0,0,0,0,100,0),
+(@PATH,2,1512.337,-4927.372,126.3721,0,0,0,0,100,0),
+(@PATH,3,1512.587,-4928.872,127.6221,0,0,0,0,100,0),
+(@PATH,4,1513.087,-4930.872,128.1221,0,0,0,0,100,0),
+(@PATH,5,1513.479,-4932.331,128.9914,0,0,0,0,100,0),
+(@PATH,6,1512.951,-4930.13,128.2168,0,0,0,0,100,0),
+(@PATH,7,1512.701,-4929.13,127.7168,0,0,0,0,100,0),
+(@PATH,8,1512.451,-4928.13,126.4668,0,0,0,0,100,0),
+(@PATH,9,1512.201,-4926.63,125.9668,0,0,0,0,100,0),
+(@PATH,10,1511.451,-4923.63,124.2168,0,0,0,0,100,0),
+(@PATH,11,1510.923,-4922.429,123.4422,5.044002,0,0,0,100,0),
+(@PATH,12,1511.549,-4924.131,124.3161,0,0,0,0,100,0);
+
+-- 5.
+SET @NPC := 114748;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1649.139,`position_y`=-4848.134,`position_z`=127.4596 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,1649.139,-4848.134,127.4596,0,0,0,0,100,0),
+(@PATH,2,1649.104,-4847.937,127.5568,0,0,0,0,100,0),
+(@PATH,3,1641.558,-4840.375,127.2656,0,0,0,0,100,0),
+(@PATH,4,1634.903,-4838.598,126.964,0,0,0,0,100,0),
+(@PATH,5,1635.027,-4838.845,126.7835,0,0,0,0,100,0),
+(@PATH,6,1635.286,-4838.562,126.933,0,0,0,0,100,0),
+(@PATH,7,1641.655,-4840.305,127.2741,0,0,0,0,100,0),
+(@PATH,8,1649.497,-4847.935,127.6258,0,0,0,0,100,0);
+
+-- 6.
+SET @NPC := 114942;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1718.106,`position_y`=-4883.712,`position_z`=125.9529 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,1718.106,-4883.712,125.9529,0,0,0,0,100,0),
+(@PATH,2,1720.21,-4882.47,127.2277,0,0,0,0,100,0),
+(@PATH,3,1723.46,-4882.72,128.9778,0,0,0,0,100,0),
+(@PATH,4,1728.71,-4882.72,130.2278,0,0,0,0,100,0),
+(@PATH,5,1731.24,-4882.965,130.3452,0,0,0,0,100,0),
+(@PATH,6,1740.042,-4883.115,130.3452,0,0,0,0,100,0),
+(@PATH,7,1742.042,-4883.115,130.3452,0,0,0,0,100,0),
+(@PATH,8,1745.486,-4883.223,130.3452,0,0,0,0,100,0),
+(@PATH,9,1751.762,-4883.266,130.3452,0,0,0,0,100,0),
+(@PATH,10,1754.512,-4883.266,130.3452,0,0,0,0,100,0),
+(@PATH,11,1757.878,-4883.357,130.3452,0,0,0,0,100,0),
+(@PATH,12,1764.046,-4883.471,130.3452,0,0,0,0,100,0),
+(@PATH,13,1767.296,-4883.471,130.3452,0,0,0,0,100,0),
+(@PATH,14,1768.796,-4883.471,130.3452,0,0,0,0,100,0),
+(@PATH,15,1770.296,-4883.471,130.3452,0,0,0,0,100,0),
+(@PATH,16,1770.667,-4883.514,130.3452,0,0,0,0,100,0),
+(@PATH,17,1771.917,-4883.514,130.3452,0,0,0,0,100,0),
+(@PATH,18,1778.08,-4883.535,130.2061,0,0,0,0,100,0),
+(@PATH,19,1779.58,-4883.535,130.2061,0,0,0,0,100,0),
+(@PATH,20,1780.83,-4883.535,130.2061,0,0,0,0,100,0),
+(@PATH,21,1784.352,-4883.44,129.4088,0,0,0,0,100,0),
+(@PATH,22,1785.852,-4883.44,129.1588,0,0,0,0,100,0),
+(@PATH,23,1789.852,-4883.44,126.9088,0,0,0,0,100,0),
+(@PATH,24,1789.939,-4883.641,126.5849,0,0,0,0,100,0),
+(@PATH,25,1791.439,-4883.641,126.3349,0,0,0,0,100,0),
+(@PATH,26,1791.059,-4883.561,125.9662,0,0,0,0,100,0),
+(@PATH,27,1790.803,-4883.574,126.1703,0,0,0,0,100,0),
+(@PATH,28,1789.803,-4883.574,126.9203,0,0,0,0,100,0),
+(@PATH,29,1785.803,-4883.574,129.1703,0,0,0,0,100,0),
+(@PATH,30,1785.512,-4883.579,129.3584,0,0,0,0,100,0),
+(@PATH,31,1784.012,-4883.579,129.6084,0,0,0,0,100,0),
+(@PATH,32,1781.012,-4883.579,130.1084,0,0,0,0,100,0),
+(@PATH,33,1779.762,-4883.579,130.3584,0,0,0,0,100,0),
+(@PATH,34,1779.507,-4883.542,130.3221,0,0,0,0,100,0),
+(@PATH,35,1777.757,-4883.542,130.3221,0,0,0,0,100,0),
+(@PATH,36,1771.58,-4883.485,130.3452,0,0,0,0,100,0),
+(@PATH,37,1770.33,-4883.485,130.3452,0,0,0,0,100,0),
+(@PATH,38,1769.08,-4883.485,130.3452,0,0,0,0,100,0),
+(@PATH,39,1767.58,-4883.485,130.3452,0,0,0,0,100,0),
+(@PATH,40,1763.704,-4883.377,130.3452,0,0,0,0,100,0),
+(@PATH,41,1757.67,-4883.315,130.3452,0,0,0,0,100,0),
+(@PATH,42,1754.92,-4883.315,130.3452,0,0,0,0,100,0),
+(@PATH,43,1751.469,-4883.236,130.3452,0,0,0,0,100,0),
+(@PATH,44,1745.172,-4883.166,130.3452,0,0,0,0,100,0),
+(@PATH,45,1742.672,-4883.166,130.3452,0,0,0,0,100,0),
+(@PATH,46,1739.547,-4883.013,130.3452,0,0,0,0,100,0),
+(@PATH,47,1732.047,-4883.013,130.3452,0,0,0,0,100,0),
+(@PATH,48,1730.942,-4882.714,130.2043,0,0,0,0,100,0),
+(@PATH,49,1729.192,-4882.714,130.2043,0,0,0,0,100,0),
+(@PATH,50,1723.942,-4882.714,129.2043,0,0,0,0,100,0),
+(@PATH,51,1719.913,-4882.498,127.0959,0,0,0,0,100,0),
+(@PATH,52,1717.163,-4882.748,126.3459,0,0,0,0,100,0),
+(@PATH,53,1712.663,-4883.248,126.8459,0,0,0,0,100,0),
+(@PATH,54,1718.106,-4883.712,125.9529,0,0,0,0,100,0);
+
+-- 7.
+SET @NPC := 114944;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=1905.927,`position_y`=-4879.938,`position_z`=172.084 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,1905.927,-4879.938,172.084,0,0,0,0,100,0),
+(@PATH,2,1899.677,-4882.188,171.334,0,0,0,0,100,0),
+(@PATH,3,1896.927,-4883.188,170.834,0,0,0,0,100,0),
+(@PATH,4,1896.593,-4883.376,170.5366,0,0,0,0,100,0),
+(@PATH,5,1896.093,-4883.376,170.2866,0,0,0,0,100,0),
+(@PATH,6,1893.093,-4883.626,169.7866,0,0,0,0,100,0),
+(@PATH,7,1890.093,-4883.876,169.0366,0,0,0,0,100,0),
+(@PATH,8,1888.093,-4883.876,168.2866,0,0,0,0,100,0),
+(@PATH,9,1886.093,-4883.876,167.7866,0,0,0,0,100,0),
+(@PATH,10,1884.093,-4884.126,167.0366,0,0,0,0,100,0),
+(@PATH,11,1882.093,-4884.126,166.0366,0,0,0,0,100,0),
+(@PATH,12,1880.093,-4884.126,165.0366,0,0,0,0,100,0),
+(@PATH,13,1878.093,-4884.126,164.0366,0,0,0,0,100,0),
+(@PATH,14,1876.343,-4884.126,163.2866,0,0,0,0,100,0),
+(@PATH,15,1874.343,-4884.126,162.2866,0,0,0,0,100,0),
+(@PATH,16,1872.343,-4884.376,161.5366,0,0,0,0,100,0),
+(@PATH,17,1871.343,-4884.376,161.0366,0,0,0,0,100,0),
+(@PATH,18,1869.343,-4884.376,160.0366,0,0,0,0,100,0),
+(@PATH,19,1867.343,-4884.626,159.0366,0,0,0,0,100,0),
+(@PATH,20,1866.343,-4884.626,158.5366,0,0,0,0,100,0),
+(@PATH,21,1864.343,-4884.626,157.2866,0,0,0,0,100,0),
+(@PATH,22,1862.343,-4884.876,156.2866,0,0,0,0,100,0),
+(@PATH,23,1860.343,-4884.876,155.2866,0,0,0,0,100,0),
+(@PATH,24,1858.343,-4884.876,154.2866,0,0,0,0,100,0),
+(@PATH,25,1858.171,-4884.888,153.8452,0,0,0,0,100,0),
+(@PATH,26,1857.171,-4884.888,153.5952,0,0,0,0,100,0),
+(@PATH,27,1855.171,-4884.638,152.3452,0,0,0,0,100,0),
+(@PATH,28,1852.171,-4884.388,151.3452,0,0,0,0,100,0),
+(@PATH,29,1850.421,-4884.138,150.5952,0,0,0,0,100,0),
+(@PATH,30,1848.421,-4883.888,149.5952,0,0,0,0,100,0),
+(@PATH,31,1846.421,-4883.638,148.5952,0,0,0,0,100,0),
+(@PATH,32,1846.197,-4883.707,148.4949,0,0,0,0,100,0),
+(@PATH,33,1845.447,-4883.707,148.2449,0,0,0,0,100,0),
+(@PATH,34,1843.697,-4883.957,146.9949,0,0,0,0,100,0),
+(@PATH,35,1842.697,-4883.957,146.2449,0,0,0,0,100,0),
+(@PATH,36,1840.697,-4884.207,145.2449,0,0,0,0,100,0),
+(@PATH,37,1837.697,-4884.457,143.9949,0,0,0,0,100,0),
+(@PATH,38,1835.947,-4884.707,143.2449,0,0,0,0,100,0),
+(@PATH,39,1833.947,-4884.957,142.2449,0,0,0,0,100,0),
+(@PATH,40,1832.947,-4884.957,141.7449,0,0,0,0,100,0),
+(@PATH,41,1830.947,-4885.207,140.4949,0,0,0,0,100,0),
+(@PATH,42,1828.947,-4885.457,139.4949,0,0,0,0,100,0),
+(@PATH,43,1826.947,-4885.707,138.4949,0,0,0,0,100,0),
+(@PATH,44,1826.772,-4885.628,138.2459,0,0,0,0,100,0),
+(@PATH,45,1826.022,-4885.628,137.9959,0,0,0,0,100,0),
+(@PATH,46,1823.022,-4885.378,136.7459,0,0,0,0,100,0),
+(@PATH,47,1821.272,-4885.378,136.2459,0,0,0,0,100,0),
+(@PATH,48,1819.272,-4885.128,135.4959,0,0,0,0,100,0),
+(@PATH,49,1819.344,-4885.267,135.4447,0,0,0,0,100,0),
+(@PATH,50,1821.344,-4885.517,135.9447,0,0,0,0,100,0),
+(@PATH,51,1823.094,-4885.517,136.6947,0,0,0,0,100,0),
+(@PATH,52,1825.094,-4885.767,137.6947,0,0,0,0,100,0),
+(@PATH,53,1825.52,-4885.686,138.0349,0,0,0,0,100,0),
+(@PATH,54,1826.27,-4885.686,138.2849,0,0,0,0,100,0),
+(@PATH,55,1828.27,-4885.436,139.0349,0,0,0,0,100,0),
+(@PATH,56,1830.27,-4885.186,140.0349,0,0,0,0,100,0),
+(@PATH,57,1832.27,-4884.936,141.2849,0,0,0,0,100,0),
+(@PATH,58,1834.27,-4884.686,142.2849,0,0,0,0,100,0),
+(@PATH,59,1836.02,-4884.686,143.0349,0,0,0,0,100,0),
+(@PATH,60,1837.02,-4884.686,143.5349,0,0,0,0,100,0),
+(@PATH,61,1838.77,-4884.436,144.7849,0,0,0,0,100,0),
+(@PATH,62,1840.77,-4884.186,145.7849,0,0,0,0,100,0),
+(@PATH,63,1842.77,-4883.936,147.0349,0,0,0,0,100,0),
+(@PATH,64,1844.77,-4883.686,148.0349,0,0,0,0,100,0),
+(@PATH,65,1845.081,-4883.799,148.281,0,0,0,0,100,0),
+(@PATH,66,1845.831,-4883.549,148.531,0,0,0,0,100,0),
+(@PATH,67,1847.831,-4883.799,149.281,0,0,0,0,100,0),
+(@PATH,68,1849.831,-4884.049,150.281,0,0,0,0,100,0),
+(@PATH,69,1851.581,-4884.549,151.031,0,0,0,0,100,0),
+(@PATH,70,1853.581,-4884.549,152.031,0,0,0,0,100,0),
+(@PATH,71,1855.581,-4884.799,153.031,0,0,0,0,100,0),
+(@PATH,72,1857.403,-4885.068,153.9602,0,0,0,0,100,0),
+(@PATH,73,1859.403,-4884.818,154.7102,0,0,0,0,100,0),
+(@PATH,74,1861.403,-4884.818,155.7102,0,0,0,0,100,0),
+(@PATH,75,1863.403,-4884.818,156.7102,0,0,0,0,100,0),
+(@PATH,76,1865.403,-4884.568,157.9602,0,0,0,0,100,0),
+(@PATH,77,1867.403,-4884.568,158.9602,0,0,0,0,100,0),
+(@PATH,78,1869.403,-4884.568,159.9602,0,0,0,0,100,0),
+(@PATH,79,1871.403,-4884.318,160.9602,0,0,0,0,100,0),
+(@PATH,80,1872.403,-4884.318,161.7102,0,0,0,0,100,0),
+(@PATH,81,1874.403,-4884.318,162.4602,0,0,0,0,100,0),
+(@PATH,82,1876.153,-4884.318,163.4602,0,0,0,0,100,0),
+(@PATH,83,1877.153,-4884.318,163.9602,0,0,0,0,100,0),
+(@PATH,84,1880.153,-4884.318,164.9602,0,0,0,0,100,0),
+(@PATH,85,1882.153,-4884.068,165.9602,0,0,0,0,100,0),
+(@PATH,86,1884.153,-4884.068,166.9602,0,0,0,0,100,0),
+(@PATH,87,1886.153,-4884.068,167.7102,0,0,0,0,100,0),
+(@PATH,88,1888.153,-4883.818,168.4602,0,0,0,0,100,0),
+(@PATH,89,1890.153,-4883.818,168.9602,0,0,0,0,100,0),
+(@PATH,90,1893.153,-4883.568,169.7102,0,0,0,0,100,0),
+(@PATH,91,1896.27,-4883.222,170.7779,0,0,0,0,100,0),
+(@PATH,92,1898.27,-4882.722,171.2779,0,0,0,0,100,0),
+(@PATH,93,1902.02,-4881.222,171.7779,0,0,0,0,100,0),
+(@PATH,94,1907.52,-4879.472,172.2779,0,0,0,0,100,0),
+(@PATH,95,1905.927,-4879.938,172.084,0,0,0,0,100,0),
+(@PATH,96,1899.677,-4882.188,171.334,0,0,0,0,100,0),
+(@PATH,97,1896.927,-4883.188,170.834,0,0,0,0,100,0);
+
+-- visuals
+-- Cyclothar SAI
+SET @ENTRY := 24235;
+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,25,0,100,0,0,0,0,0,11,43312,0,0,0,0,0,1,0,0,0,0,0,0,0,"Cyclothar - On Reset - Cast 'Elemental Prison (Cosmetic)'");
+
+-- Wind Tamer SAI
+SET @ENTRY := 24236;
+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,25,0,100,0,0,0,0,0,11,43320,0,0,0,0,0,1,0,0,0,0,0,0,0,"Wind Tamer - On Reset - Cast 'Windwarden Channeling'");
+
+-- Camp Winterhoof Wind Rider SAI
+SET @GUID := -102741;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=24142;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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
+(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Camp Winterhoof Wind Rider - Out of Combat - Play Emote 1");
+
+-- Camp Winterhoof Wind Rider SAI
+SET @GUID := -102745;
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=24142;
+DELETE FROM `smart_scripts` WHERE `entryorguid`=@GUID 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
+(@GUID,0,0,0,1,0,100,0,3000,5000,3000,5000,5,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Camp Winterhoof Wind Rider - Out of Combat - Play Emote 1");
+
+-- 8.
+SET @NPC := 100710;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2535.262,`position_y`=-3926.417,`position_z`=272.4942 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,2535.262,-3926.417,272.4942,0,0,0,0,100,0),
+(@PATH,2,2536.262,-3924.667,272.9942,0,0,0,0,100,0),
+(@PATH,3,2537.512,-3921.917,273.7442,0,0,0,0,100,0),
+(@PATH,4,2538.012,-3920.417,274.2442,0,0,0,0,100,0),
+(@PATH,5,2539.012,-3918.667,274.9942,0,0,0,0,100,0),
+(@PATH,6,2540.262,-3915.917,275.7442,0,0,0,0,100,0),
+(@PATH,7,2541.262,-3914.167,276.4942,0,0,0,0,100,0),
+(@PATH,8,2540.505,-3915.667,275.8498,0,0,0,0,100,0),
+(@PATH,9,2541.505,-3913.917,276.5998,0,0,0,0,100,0),
+(@PATH,10,2541.505,-3913.667,276.8498,0,0,0,0,100,0),
+(@PATH,11,2543.005,-3911.917,277.3498,0,0,0,0,100,0),
+(@PATH,12,2544.255,-3910.417,278.3498,0,0,0,0,100,0),
+(@PATH,13,2545.255,-3909.167,278.8498,0,0,0,0,100,0),
+(@PATH,14,2546.505,-3907.667,279.5998,0,0,0,0,100,0),
+(@PATH,15,2547.005,-3906.917,280.0998,0,0,0,0,100,0),
+(@PATH,16,2548.255,-3905.417,280.8498,0,0,0,0,100,0),
+(@PATH,17,2549.005,-3904.667,281.5998,0,0,0,0,100,0),
+(@PATH,18,2549.203,-3904.302,281.7696,0,0,0,0,100,0),
+(@PATH,19,2550.203,-3903.302,282.2696,0,0,0,0,100,0),
+(@PATH,20,2550.953,-3902.802,282.7696,0,0,0,0,100,0),
+(@PATH,21,2552.953,-3902.302,283.5196,0,0,0,0,100,0),
+(@PATH,22,2555.203,-3901.052,285.5196,0,0,0,0,100,0),
+(@PATH,23,2555.605,-3900.629,285.9603,0,0,0,0,100,0),
+(@PATH,24,2557.605,-3899.879,286.7103,0,0,0,0,100,0),
+(@PATH,25,2559.355,-3899.879,287.7103,0,0,0,0,100,0),
+(@PATH,26,2562.355,-3899.629,288.7103,0,0,0,0,100,0),
+(@PATH,27,2561.653,-3899.828,288.6268,0,0,0,0,100,0),
+(@PATH,28,2559.903,-3899.828,287.8768,0,0,0,0,100,0),
+(@PATH,29,2559.016,-3899.898,287.2452,3.176786,0,0,0,100,0),
+(@PATH,30,2557.399,-3899.966,286.1906,0,0,0,0,100,0),
+(@PATH,31,2554.774,-3901.154,284.9332,0,0,0,0,100,0),
+(@PATH,32,2553.024,-3901.904,284.1832,0,0,0,0,100,0),
+(@PATH,33,2550.035,-3903.224,282.2341,0,0,0,0,100,0),
+(@PATH,34,2548.785,-3904.974,281.2341,0,0,0,0,100,0),
+(@PATH,35,2547.535,-3906.474,280.2341,0,0,0,0,100,0),
+(@PATH,36,2546.535,-3907.974,279.7341,0,0,0,0,100,0),
+(@PATH,37,2545.785,-3908.474,279.2341,0,0,0,0,100,0),
+(@PATH,38,2544.035,-3910.724,277.9841,0,0,0,0,100,0),
+(@PATH,39,2542.785,-3912.224,277.2341,0,0,0,0,100,0),
+(@PATH,40,2541.275,-3913.808,276.6663,0,0,0,0,100,0),
+(@PATH,41,2540.525,-3915.558,275.9163,0,0,0,0,100,0),
+(@PATH,42,2539.275,-3918.308,274.9163,0,0,0,0,100,0),
+(@PATH,43,2538.275,-3920.058,274.1663,0,0,0,0,100,0),
+(@PATH,44,2537.775,-3921.558,273.6663,0,0,0,0,100,0),
+(@PATH,45,2536.275,-3924.308,273.1663,0,0,0,0,100,0),
+(@PATH,46,2535.525,-3926.058,272.4163,0,0,0,0,100,0),
+(@PATH,47,2534.525,-3927.808,271.9163,0,0,0,0,100,0);