diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_11_17_04_world_335.sql | 46 |
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); |