DB/Waypoints: Rocklance

Closes #20898

1 files changed, 46 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2017_11_17_04_world_335.sql b/sql/updates/world/3.3.5/2017_11_17_04_world_335.sql
new file mode 100644
index 00000000000..44e1e592cd5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_11_17_04_world_335.sql
@@ -0,0 +1,46 @@
+-- Pathing for Rocklance
+UPDATE `creature` SET `position_x`=-1201.63, `position_y`=-3099.24, `position_z`=94.8781, `spawndist`=0, `MovementType`=2 WHERE `guid`=20720;
+UPDATE `creature` SET `position_x`=-1198.92, `position_y`=-3101.53, `position_z`=94.8262, `spawndist`=0, `MovementType`=0 WHERE `guid`=14007;
+UPDATE `creature` SET `position_x`=-1198.8, `position_y`=-3096.75, `position_z`=94.5592, `spawndist`=0, `MovementType`=0 WHERE `guid`=20588;
+
+DELETE FROM `creature_addon` WHERE `guid`=20720;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(20720,207200,0,0,1,0,"");
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=20720;
+INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES
+(20720,20720,0,0,515,0,0),
+(20720,14007,3,330,515,0,0),
+(20720,20588,3,60,515,0,0);
+
+DELETE FROM `waypoint_data` WHERE `id`=207200;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES
+(207200,1,-1201.63,-3099.24,94.8781,0,0,0,0,100,0),
+(207200,2,-1219.21,-3099.76,95.241,0,0,0,0,100,0),
+(207200,3,-1272.76,-3089.53,93.8928,0,0,0,0,100,0),
+(207200,4,-1315.08,-3106.5,91.7995,0,0,0,0,100,0),
+(207200,5,-1330.48,-3095.55,92.4438,0,0,0,0,100,0),
+(207200,6,-1341.49,-3060.61,92.6899,0,0,0,0,100,0),
+(207200,7,-1354.4,-3030.3,93.3309,0,0,0,0,100,0),
+(207200,8,-1386.31,-3005.86,93.1475,0,0,0,0,100,0),
+(207200,9,-1430.19,-2974.08,93.1218,0,0,0,0,100,0),
+(207200,10,-1436.49,-2943.46,91.668,0,0,0,0,100,0),
+(207200,11,-1436.75,-2920.35,92.5429,0,0,0,0,100,0),
+(207200,12,-1410.03,-2893.52,93.1282,0,0,0,0,100,0),
+(207200,13,-1388.5,-2866.72,94.5754,0,0,0,0,100,0),
+(207200,14,-1360.27,-2850.79,94.705,0,0,0,0,100,0),
+(207200,15,-1332.8,-2857.77,93.5965,0,0,0,0,100,0),
+(207200,16,-1288.33,-2870.37,93.0108,0,0,0,0,100,0),
+(207200,17,-1265.32,-2850.79,94.069,0,0,0,0,100,0),
+(207200,18,-1239.87,-2834.24,94.41,0,0,0,0,100,0),
+(207200,19,-1219.09,-2834.03,93.9937,0,0,0,0,100,0),
+(207200,20,-1194.71,-2865.09,93.5771,0,0,0,0,100,0),
+(207200,21,-1170.2,-2886.21,94.3522,0,0,0,0,100,0),
+(207200,22,-1146.43,-2925.68,93.1956,0,0,0,0,100,0),
+(207200,23,-1123.47,-2957.35,92.8819,0,0,0,0,100,0),
+(207200,24,-1114.24,-2966.51,92.4826,0,0,0,0,100,0),
+(207200,25,-1111.46,-3018.12,94.8292,0,0,0,0,100,0),
+(207200,26,-1101.72,-3047.27,93.4784,0,0,0,0,100,0),
+(207200,27,-1123.65,-3070.33,91.8408,0,0,0,0,100,0),
+(207200,28,-1147.38,-3076.85,92.3126,0,0,0,0,100,0),
+(207200,29,-1177.95,-3082.89,92.8266,0,0,0,0,100,0);