DB/Waypoints: Mazzranache

Closes #18732
By Rushor

1 files changed, 72 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_01_04_02_world_335.sql b/sql/updates/world/3.3.5/2017_01_04_02_world_335.sql
new file mode 100644
index 00000000000..e0c9484fa0b
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_01_04_02_world_335.sql
@@ -0,0 +1,72 @@
+-- 
+SET @NPC := 26908;
+SET @PATH := @NPC * 10;
+UPDATE `creature` SET `spawndist`=0,`MovementType`=2 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`, `delay`) VALUES
+(@PATH, 1, -1722.14, -550.386, -14.7598, 0),
+(@PATH, 2, -1705.61, -569.055, -19.4067, 0),
+(@PATH, 3, -1682.04, -591.91, -25.4708, 0),
+(@PATH, 4, -1662.63, -603.838, -30.1185, 0),
+(@PATH, 5, -1639.97, -607.133, -35.8754, 0),
+(@PATH, 6, -1616.22, -613.15, -42.4359, 0),
+(@PATH, 7, -1595.86, -618.308, -47.3956, 0),
+(@PATH, 8, -1574.93, -616.712, -51.7647, 0),
+(@PATH, 9, -1550.95, -605.914, -55.6474, 0),
+(@PATH, 10, -1537.55, -596.276, -56.3861, 0),
+(@PATH, 11, -1532.89, -586.289, -56.2095, 0),
+(@PATH, 12, -1532.3, -566.583, -55.7341, 0),
+(@PATH, 13, -1536.28, -539.553, -55.2342, 0),
+(@PATH, 14, -1533.07, -522.97, -54.4489, 0),
+(@PATH, 15, -1522.68, -506.3, -54.3973, 0),
+(@PATH, 16, -1519.62, -488.083, -52.5074, 0),
+(@PATH, 17, -1524.13, -467.337, -48.9335, 0),
+(@PATH, 18, -1526.95, -424.435, -45.2492, 0),
+(@PATH, 19, -1531.14, -398.722, -43.8176, 0),
+(@PATH, 20, -1538.91, -374.683, -42.8131, 0),
+(@PATH, 21, -1545.47, -354.239, -39.0446, 0),
+(@PATH, 22, -1552.81, -335.938, -35.917, 0),
+(@PATH, 23, -1566.63, -312.613, -31.0947, 0),
+(@PATH, 24, -1584.27, -296.213, -27.3011, 0),
+(@PATH, 25, -1597.27, -278.386, -23.4966, 0),
+(@PATH, 26, -1610.64, -257.862, -19.3983, 0),
+(@PATH, 27, -1621, -236.845, -18.9327, 0),
+(@PATH, 28, -1636.78, -206.561, -16.684, 0),
+(@PATH, 29, -1648.04, -178.252, -12.0433, 0),
+(@PATH, 30, -1656.17, -153.199, -9.43765, 0),
+(@PATH, 31, -1657.82, -126.837, -8.72994, 0),
+(@PATH, 32, -1668.55, -97.9253, -8.34947, 0),
+(@PATH, 33, -1681.95, -76.5867, -9.11107, 0),
+(@PATH, 34, -1700.51, -57.342, -5.64828, 0),
+(@PATH, 35, -1719.51, -47.7012, -2.54774, 0),
+(@PATH, 36, -1747.72, -46.3402, -5.4005, 0),
+(@PATH, 37, -1772.79, -50.129, -7.08613, 0),
+(@PATH, 38, -1798.4, -58.4037, -5.76034, 0),
+(@PATH, 39, -1811.88, -70.5313, -7.68982, 0),
+(@PATH, 40, -1820.73, -93.7355, -9.2501, 0),
+(@PATH, 41, -1822.1, -112.172, -8.20732, 0),
+(@PATH, 42, -1834.29, -123.408, -9.03176, 0),
+(@PATH, 43, -1851.19, -129.656, -8.52712, 0),
+(@PATH, 44, -1867.92, -137.048, -6.59658, 0),
+(@PATH, 45, -1878.32, -150.986, -5.8911, 0),
+(@PATH, 46, -1887.57, -173.195, -6.12971, 0),
+(@PATH, 47, -1889.37, -196.466, -8.58793, 0),
+(@PATH, 48, -1883.97, -217.889, -9.40669, 0),
+(@PATH, 49, -1876.46, -244.283, -9.555, 0),
+(@PATH, 50, -1864.45, -266.181, -7.23699, 0),
+(@PATH, 51, -1850.99, -284.616, -4.7108, 0),
+(@PATH, 52, -1830.57, -303.767, -6.94358, 0),
+(@PATH, 53, -1815.14, -318.23, -9.07484, 0),
+(@PATH, 54, -1800.89, -336.331, -9.26187, 0),
+(@PATH, 55, -1782.61, -356.073, -9.42632, 0),
+(@PATH, 56, -1756.99, -378.227, -12.8384, 0),
+(@PATH, 57, -1745.2, -402.325, -16.7898, 0),
+(@PATH, 58, -1740.74, -423.93, -14.3259, 0),
+(@PATH, 59, -1723.81, -452.481, -10.9682, 0),
+(@PATH, 60, -1706.64, -461.978, -10.5846, 0),
+(@PATH, 61, -1701.38, -480.422, -10.4956, 0),
+(@PATH, 62, -1709.83, -507.869, -12.8309, 0),
+(@PATH, 63, -1729.44, -528.724, -13.8673, 0),
+(@PATH, 64, -1731.65, -542.165, -13.1692, 0);