diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_23_08_world.sql | 111 |
1 files changed, 111 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_23_08_world.sql b/sql/updates/world/master/2017_05_23_08_world.sql new file mode 100644 index 00000000000..da177c2fc85 --- /dev/null +++ b/sql/updates/world/master/2017_05_23_08_world.sql @@ -0,0 +1,111 @@ +-- Pathing for Ix'lar the Underlord Entry: 45744 'TDB FORMAT' +SET @NPC := 319950; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=2845.473,`position_y`=-4767.625,`position_z`=84.60523 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,2845.473,-4767.625,84.60523,0,0,0,0,100,0), +(@PATH,2,2854.41,-4778.39,91.96474,0,0,0,0,100,0), +(@PATH,3,2862.23,-4789.15,95.09084,0,0,0,0,100,0), +(@PATH,4,2856.74,-4803.69,94.67984,0,0,0,0,100,0), +(@PATH,5,2842.84,-4805.25,97.01968,0,0,0,0,100,0), +(@PATH,6,2833.87,-4790.56,96.84133,0,0,0,0,100,0), +(@PATH,7,2825.65,-4788.4,99.6292,0,0,0,0,100,0), +(@PATH,8,2812.69,-4791.82,95.80302,0,0,0,0,100,0), +(@PATH,9,2805.72,-4798.94,90.90422,0,0,0,0,100,0), +(@PATH,10,2795.53,-4802.25,85.21287,0,0,0,0,100,0), +(@PATH,11,2783.56,-4801.21,83.14036,0,0,0,0,100,0), +(@PATH,12,2768.65,-4800.15,79.33762,0,0,0,0,100,0), +(@PATH,13,2755.91,-4794.9,76.57204,0,0,0,0,100,0), +(@PATH,14,2747,-4777.48,76.48952,0,0,0,0,100,0), +(@PATH,15,2748.14,-4746.14,76.97128,0,0,0,0,100,0), +(@PATH,16,2747.03,-4722.73,74.83576,0,0,0,0,100,0), +(@PATH,17,2750.93,-4698.12,78.95863,0,0,0,0,100,0), +(@PATH,18,2760.24,-4670.02,80.02687,0,0,0,0,100,0), +(@PATH,19,2770.4,-4660.86,86.92216,0,0,0,0,100,0), +(@PATH,20,2783.42,-4664.73,92.67192,0,0,0,0,100,0), +(@PATH,21,2797.51,-4678.94,95.49097,0,0,0,0,100,0), +(@PATH,22,2809.22,-4682.13,95.92142,0,0,0,0,100,0), +(@PATH,23,2826.65,-4680.09,90.41763,0,0,0,0,100,0), +(@PATH,24,2838.29,-4692.48,93.17684,0,0,0,0,100,0), +(@PATH,25,2853.44,-4706.6,89.93577,0,0,0,0,100,0), +(@PATH,26,2861.5,-4729.15,82.22752,0,0,0,0,100,0), +(@PATH,27,2855.89,-4746.56,81.98978,0,0,0,0,100,0); + +-- Pathing for Yetimus the Yeti Lord Entry: 47484 'TDB FORMAT' +SET @NPC := 323060; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-151.922,`position_y`=-171.311,`position_z`=104.9993 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,-151.922,-171.311,104.9993,0,0,0,0,100,0), +(@PATH,2,-197.392,-164.851,92.99743,0,0,0,0,100,0), +(@PATH,3,-240.981,-167.431,80.67632,0,0,0,0,100,0), +(@PATH,4,-279.948,-174.962,74.14382,0,0,0,0,100,0), +(@PATH,5,-301.554,-187.203,68.3701,0,0,0,0,100,0), +(@PATH,6,-319.957,-198.203,64.63304,0,0,0,0,100,0), +(@PATH,7,-348.99,-235.068,62.78932,0,0,0,0,100,0), +(@PATH,8,-368.51,-265.285,60.20347,0,0,0,0,100,0), +(@PATH,9,-381.052,-305.778,59.71421,0,0,0,0,100,0), +(@PATH,10,-383.299,-340.087,59.16272,0,0,0,0,100,0), +(@PATH,11,-370.479,-366.644,58.37293,0,0,0,0,100,0), +(@PATH,12,-349.299,-399.33,58.9684,0,0,0,0,100,0), +(@PATH,13,-324.72,-430.033,59.33606,0,0,0,0,100,0), +(@PATH,14,-297.215,-456.95,60.7625,0,0,0,0,100,0), +(@PATH,15,-268.215,-460.696,64.35992,0,0,0,0,100,0), +(@PATH,16,-247.248,-462.217,65.86039,0,0,0,0,100,0), +(@PATH,17,-222.099,-464.127,67.62333,0,0,0,0,100,0), +(@PATH,18,-195.962,-466.226,71.86466,0,0,0,0,100,0), +(@PATH,19,-160.519,-459.127,76.6852,0,0,0,0,100,0), +(@PATH,20,-141.003,-451.144,76.6852,0,0,0,0,100,0), +(@PATH,21,-160.519,-459.127,76.6852,0,0,0,0,100,0), +(@PATH,22,-195.962,-466.226,71.86466,0,0,0,0,100,0), +(@PATH,23,-222.099,-464.127,67.62333,0,0,0,0,100,0), +(@PATH,24,-247.248,-462.217,65.86039,0,0,0,0,100,0), +(@PATH,25,-268.215,-460.696,64.35992,0,0,0,0,100,0), +(@PATH,26,-297.215,-456.95,60.7625,0,0,0,0,100,0), +(@PATH,27,-324.72,-430.033,59.33606,0,0,0,0,100,0), +(@PATH,28,-349.299,-399.33,58.9684,0,0,0,0,100,0), +(@PATH,29,-370.479,-366.644,58.37293,0,0,0,0,100,0), +(@PATH,30,-383.299,-340.087,59.16272,0,0,0,0,100,0), +(@PATH,31,-381.052,-305.778,59.71421,0,0,0,0,100,0), +(@PATH,32,-368.51,-265.285,60.20347,0,0,0,0,100,0), +(@PATH,33,-348.99,-235.068,62.78932,0,0,0,0,100,0), +(@PATH,34,-319.957,-198.203,64.63304,0,0,0,0,100,0), +(@PATH,35,-301.554,-187.203,68.3701,0,0,0,0,100,0), +(@PATH,36,-279.948,-174.962,74.14382,0,0,0,0,100,0), +(@PATH,37,-240.981,-167.431,80.67632,0,0,0,0,100,0), +(@PATH,38,-197.392,-164.851,92.99743,0,0,0,0,100,0); + +-- Pathing for Infernus Entry: 49266 'TDB FORMAT' +SET @NPC := 322294; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-573.0382,`position_y`=-1449.427,`position_z`=53.92358 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,-573.0382,-1449.427,53.92358,0,0,0,0,100,0), +(@PATH,2,-561.0801,-1444.299,52.56591,0,0,0,0,100,0), +(@PATH,3,-554.1354,-1448.941,52.56591,0,0,0,0,100,0), +(@PATH,4,-552.0695,-1463.915,52.56591,0,0,0,0,100,0), +(@PATH,5,-553.8038,-1475.297,52.56591,0,0,0,0,100,0), +(@PATH,6,-565.9965,-1476.443,52.67285,0,0,0,0,100,0), +(@PATH,7,-573.3889,-1463.563,52.94677,0,0,0,0,100,0); + +-- Pathing for Teracula Entry: 49265 'TDB FORMAT' +SET @NPC := 322435; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-462.533,`position_y`=-1424.408,`position_z`=90.77872 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,-462.533,-1424.408,90.77872,0,0,0,0,100,0), +(@PATH,2,-449.6858,-1420.599,96.06876,0,0,0,0,100,0), +(@PATH,3,-462.533,-1424.408,90.77872,0,0,0,0,100,0), +(@PATH,4,-477.5868,-1429.043,88.90503,0,0,0,0,100,0); |