diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2017_02_04_05_world.sql | 964 |
1 files changed, 964 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_02_04_05_world.sql b/sql/updates/world/3.3.5/2017_02_04_05_world.sql new file mode 100644 index 00000000000..cb7860360e6 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_02_04_05_world.sql @@ -0,0 +1,964 @@ +-- [NPC][WotlK] Stormrider and Snowdrift Jormungar, missing paths +-- 1 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115280; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8483.389,`position_y`=120.0789,`position_z`=785.0029 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,8483.389,120.0789,785.0029,0,0,0,0,100,0), +(@PATH,2,8477.139,135.5789,785.5029,0,0,0,0,100,0), +(@PATH,3,8475.889,138.3289,786.2529,0,0,0,0,100,0), +(@PATH,4,8475.762,138.6024,786.4821,0,0,0,0,100,0), +(@PATH,5,8475.012,140.3524,786.9821,0,0,0,0,100,0), +(@PATH,6,8474.512,148.1024,787.9821,0,0,0,0,100,0), +(@PATH,7,8474.288,150.5778,788.3462,0,0,0,0,100,0), +(@PATH,8,8475.001,140.6742,786.8529,0,0,0,0,100,0), +(@PATH,9,8476.501,136.9242,785.8529,0,0,0,0,100,0), +(@PATH,10,8477.251,135.1742,785.1029,0,0,0,0,100,0), +(@PATH,11,8478.501,132.1742,784.6029,0,0,0,0,100,0), +(@PATH,12,8480.501,126.9242,785.1029,0,0,0,0,100,0), +(@PATH,13,8483.457,120.1221,784.6454,0,0,0,0,100,0), +(@PATH,14,8483.457,116.1221,784.1454,0,0,0,0,100,0), +(@PATH,15,8483.457,105.3721,784.6454,0,0,0,0,100,0), +(@PATH,16,8483.559,102.9274,784.8464,0,0,0,0,100,0), +(@PATH,17,8478.059,92.67744,784.3464,0,0,0,0,100,0), +(@PATH,18,8475.809,88.17744,784.8464,0,0,0,0,100,0), +(@PATH,19,8477.074,90.60742,784.7319,0,0,0,0,100,0), +(@PATH,20,8481.074,98.35742,785.2319,0,0,0,0,100,0), +(@PATH,21,8483.517,103.0361,784.6637,0,0,0,0,100,0), +(@PATH,22,8483.517,110.0361,784.4137,0,0,0,0,100,0); +-- 0x203CD047601CB380000C1D0000090C3C .go 8483.389 120.0789 785.0029 + +-- 2 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115279; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8338.393,`position_y`=140.3292,`position_z`=821.1263 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,8338.393,140.3292,821.1263,0,0,0,0,100,0), +(@PATH,2,8336.643,139.0792,821.3763,0,0,0,0,100,0), +(@PATH,3,8332.393,136.8292,822.1263,0,0,0,0,100,0), +(@PATH,4,8324.393,133.0792,822.6263,0,0,0,0,100,0), +(@PATH,5,8319.893,131.0792,823.6263,0,0,0,0,100,0), +(@PATH,6,8317.143,129.5792,824.6263,0,0,0,0,100,0), +(@PATH,7,8310.533,127.8266,827.4747,0,0,0,0,100,0), +(@PATH,8,8308.783,127.5766,828.2247,0,0,0,0,100,0), +(@PATH,9,8306.783,127.0766,828.9747,0,0,0,0,100,0), +(@PATH,10,8298.843,125.6751,830.6709,0,0,0,0,100,0), +(@PATH,11,8282.29,128.9023,831.7688,0,0,0,0,100,0), +(@PATH,12,8280.29,126.4023,832.5188,0,0,0,0,100,0), +(@PATH,13,8279.79,125.6523,833.2688,0,0,0,0,100,0), +(@PATH,14,8269.282,112.9607,837.5331,0,0,0,0,100,0), +(@PATH,15,8268.032,108.4607,838.0331,0,0,0,0,100,0), +(@PATH,16,8264.186,101.3011,838.7614,0,0,0,0,100,0), +(@PATH,17,8267.936,109.0511,838.0114,0,0,0,0,100,0), +(@PATH,18,8269.764,113.308,837.4911,0,0,0,0,100,0), +(@PATH,19,8273.514,117.808,835.9911,0,0,0,0,100,0), +(@PATH,20,8280.975,127.048,832.282,0,0,0,0,100,0), +(@PATH,21,8288.475,127.548,830.532,0,0,0,0,100,0), +(@PATH,22,8302.979,126.4604,830.1434,0,0,0,0,100,0), +(@PATH,23,8311.479,127.9604,827.3934,0,0,0,0,100,0), +(@PATH,24,8314.479,128.4604,826.3934,0,0,0,0,100,0), +(@PATH,25,8319.242,130.7043,823.8026,0,0,0,0,100,0), +(@PATH,26,8324.742,133.2043,822.5526,0,0,0,0,100,0); +-- 0x203CD047601CB380000C1D000308E709 .go 8338.393 140.3292 821.1263 + +-- 3 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113395; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8260.436,`position_y`=-16.78813,`position_z`=836.5507 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,8260.436,-16.78813,836.5507,0,0,0,0,100,0), +(@PATH,2,8252.936,-12.53813,836.0507,0,0,0,0,100,0), +(@PATH,3,8249.051,-9.981455,836.0782,0,0,0,0,100,0), +(@PATH,4,8243.801,-8.231455,836.8282,0,0,0,0,100,0), +(@PATH,5,8240.801,-7.231455,837.3282,0,0,0,0,100,0), +(@PATH,6,8218.997,-20.00337,843.4836,0,0,0,0,100,0), +(@PATH,7,8219.747,-24.75337,843.7336,0,0,0,0,100,0), +(@PATH,8,8221.284,-35.93419,844.4065,0,0,0,0,100,0), +(@PATH,9,8225.534,-40.93419,843.9065,0,0,0,0,100,0), +(@PATH,10,8229.64,-46.10286,844.2892,0,0,0,0,100,0), +(@PATH,11,8238.89,-49.60286,841.2892,0,0,0,0,100,0), +(@PATH,12,8239.042,-49.55084,840.9866,0,0,0,0,100,0), +(@PATH,13,8243.042,-51.05084,840.7366,0,0,0,0,100,0), +(@PATH,14,8246.042,-50.55084,840.2366,0,0,0,0,100,0), +(@PATH,15,8253.542,-49.30084,839.7366,0,0,0,0,100,0), +(@PATH,16,8259.944,-43.7584,837.2139,0,0,0,0,100,0), +(@PATH,17,8261.694,-38.5084,835.9639,0,0,0,0,100,0), +(@PATH,18,8263.78,-29.49244,835.9905,0,0,0,0,100,0), +(@PATH,19,8262.53,-24.99244,836.7405,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D00000902BD .go 8260.436 -16.78813 836.5507 + +-- 4 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113370; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8423.055,`position_y`=147.5028,`position_z`=799.3521 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,8423.055,147.5028,799.3521,0,0,0,0,100,0), +(@PATH,2,8425.178,152.7048,798.3853,0,0,0,0,100,0), +(@PATH,3,8426.178,155.4548,797.8853,0,0,0,0,100,0), +(@PATH,4,8427.928,160.2048,797.1353,0,0,0,0,100,0), +(@PATH,5,8427.748,164.3534,797.9297,0,0,0,0,100,0), +(@PATH,6,8426.998,167.1034,798.4297,0,0,0,0,100,0), +(@PATH,7,8424.701,176.3006,798.8204,0,0,0,0,100,0), +(@PATH,8,8420.701,176.8006,799.5704,0,0,0,0,100,0), +(@PATH,9,8417.951,177.0506,800.3204,0,0,0,0,100,0), +(@PATH,10,8409.748,177.6317,803.272,0,0,0,0,100,0), +(@PATH,11,8405.748,175.1317,803.772,0,0,0,0,100,0), +(@PATH,12,8397.998,170.6317,807.522,0,0,0,0,100,0), +(@PATH,13,8395.102,165.9627,809.2842,0,0,0,0,100,0), +(@PATH,14,8392.602,160.7127,810.0342,0,0,0,0,100,0), +(@PATH,15,8391.555,157.5859,810.3688,0,0,0,0,100,0), +(@PATH,16,8391.805,154.5859,809.6188,0,0,0,0,100,0), +(@PATH,17,8392.055,152.8359,808.8688,0,0,0,0,100,0), +(@PATH,18,8392.412,148.687,808.0127,0,0,0,0,100,0), +(@PATH,19,8394.162,147.687,806.7627,0,0,0,0,100,0), +(@PATH,20,8396.412,146.187,805.7627,0,0,0,0,100,0), +(@PATH,21,8398.143,144.8019,804.6888,0,0,0,0,100,0), +(@PATH,22,8400.643,143.3019,803.4388,0,0,0,0,100,0), +(@PATH,23,8410.621,141.8891,800.1554,0,0,0,0,100,0), +(@PATH,24,8414.371,141.3891,799.9054,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000090C6F .go 8423.055 147.5028 799.3521 + +-- 5 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113392; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8303.739,`position_y`=-117.4471,`position_z`=834.6846 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,8303.739,-117.4471,834.6846,0,0,0,0,100,0), +(@PATH,2,8314.489,-116.6971,831.4346,0,0,0,0,100,0), +(@PATH,3,8318.199,-116.0559,829.6553,0,0,0,0,100,0), +(@PATH,4,8323.199,-109.0559,827.9053,0,0,0,0,100,0), +(@PATH,5,8327.883,-102.1588,827.2328,0,0,0,0,100,0), +(@PATH,6,8324.883,-92.90875,828.2328,0,0,0,0,100,0), +(@PATH,7,8322.745,-86.58333,829.4406,0,0,0,0,100,0), +(@PATH,8,8319.995,-83.83333,829.9406,0,0,0,0,100,0), +(@PATH,9,8313.152,-77.69038,829.7444,0,0,0,0,100,0), +(@PATH,10,8302.611,-75.62973,830.1938,0,0,0,0,100,0), +(@PATH,11,8290.111,-77.62973,832.9438,0,0,0,0,100,0), +(@PATH,12,8282.793,-82.42642,835.05,0,0,0,0,100,0), +(@PATH,13,8274.236,-92.59892,837.8594,0,0,0,0,100,0), +(@PATH,14,8272.242,-95.86304,838.2373,0,0,0,0,100,0), +(@PATH,15,8272.242,-99.86304,838.9873,0,0,0,0,100,0), +(@PATH,16,8271.873,-108.3001,840.4122,0,0,0,0,100,0), +(@PATH,17,8284.216,-116.4625,840.5463,0,0,0,0,100,0), +(@PATH,18,8298.966,-117.7125,836.2963,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000090F81 .go 8303.739 -117.4471 834.6846 + +-- 6 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113391; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8163.82,`position_y`=-27.84444,`position_z`=855.3219 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,8163.82,-27.84444,855.3219,0,0,0,0,100,0), +(@PATH,2,8165.07,-38.09444,854.5719,0,0,0,0,100,0), +(@PATH,3,8166.879,-47.57221,853.7852,0,0,0,0,100,0), +(@PATH,4,8175.793,-55.48145,853.0232,0,0,0,0,100,0), +(@PATH,5,8178.293,-57.48145,852.5232,0,0,0,0,100,0), +(@PATH,6,8188.16,-58.32919,850.5991,0,0,0,0,100,0), +(@PATH,7,8196.483,-50.9135,848.6631,0,0,0,0,100,0), +(@PATH,8,8203.26,-40.62049,848.3727,0,0,0,0,100,0), +(@PATH,9,8200.849,-24.73827,848.7682,0,0,0,0,100,0), +(@PATH,10,8196.599,-16.23827,848.5182,0,0,0,0,100,0), +(@PATH,11,8188.089,-12.84765,851.0456,0,0,0,0,100,0), +(@PATH,12,8178.111,-14.61565,854.0222,0,0,0,0,100,0), +(@PATH,13,8173.207,-16.45553,854.7506,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D00000970AB .go 8163.82 -27.84444 855.3219 + +-- 7 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113374; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8337.599,`position_y`=-42.12108,`position_z`=819.649 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,8337.599,-42.12108,819.649,0,0,0,0,100,0), +(@PATH,2,8342.849,-38.12108,818.149,0,0,0,0,100,0), +(@PATH,3,8349.309,-32.48808,815.6023,0,0,0,0,100,0), +(@PATH,4,8349.059,-29.48808,814.8523,0,0,0,0,100,0), +(@PATH,5,8345.402,-19.32711,814.7479,0,0,0,0,100,0), +(@PATH,6,8340.152,-15.32711,815.2479,0,0,0,0,100,0), +(@PATH,7,8330.824,-13.28823,818.6204,0,0,0,0,100,0), +(@PATH,8,8325.129,-12.56654,820.0824,0,0,0,0,100,0), +(@PATH,9,8316.629,-14.06654,823.0824,0,0,0,0,100,0), +(@PATH,10,8312.491,-14.59283,824.088,0,0,0,0,100,0), +(@PATH,11,8309.741,-17.09283,824.588,0,0,0,0,100,0), +(@PATH,12,8304.241,-21.34283,825.338,0,0,0,0,100,0), +(@PATH,13,8299.967,-29.3581,828.0966,0,0,0,0,100,0), +(@PATH,14,8324.586,-43.57063,824.2495,0,0,0,0,100,0), +(@PATH,15,8335.336,-42.82063,820.7495,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D00000998EF .go 8337.599 -42.12108 819.649 + +-- 8 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113376; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8361.24,`position_y`=72.00473,`position_z`=806.7928 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,8361.24,72.00473,806.7928,0,0,0,0,100,0), +(@PATH,2,8352.74,69.25473,809.5428,0,0,0,0,100,0), +(@PATH,3,8344.121,66.37489,812.7969,0,0,0,0,100,0), +(@PATH,4,8338.371,63.3749,814.7969,0,0,0,0,100,0), +(@PATH,5,8335.121,60.1249,815.5469,0,0,0,0,100,0), +(@PATH,6,8332.121,57.3749,816.0469,0,0,0,0,100,0), +(@PATH,7,8329.713,55.21807,816.5285,0,0,0,0,100,0), +(@PATH,8,8326.279,45.32442,817.1024,0,0,0,0,100,0), +(@PATH,9,8329.762,37.57087,815.1774,0,0,0,0,100,0), +(@PATH,10,8334.012,33.82087,814.9274,0,0,0,0,100,0), +(@PATH,11,8336.279,31.98418,814.7461,0,0,0,0,100,0), +(@PATH,12,8345.324,30.90188,813.2716,0,0,0,0,100,0), +(@PATH,13,8353.824,32.40188,811.0216,0,0,0,0,100,0), +(@PATH,14,8356.446,33.32373,810.2869,0,0,0,0,100,0), +(@PATH,15,8365.696,41.82373,807.7869,0,0,0,0,100,0), +(@PATH,16,8368.84,45.11391,807.4647,0,0,0,0,100,0), +(@PATH,17,8367.701,57.84833,807.3383,0,0,0,0,100,0), +(@PATH,18,8364.951,64.09833,806.8383,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009995C .go 8361.24 72.00473 806.7928 + +-- 9 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113369; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8284.329,`position_y`=121.4438,`position_z`=833.2343 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,8284.329,121.4438,833.2343,0,0,0,0,100,0), +(@PATH,2,8280.329,113.1938,834.9843,0,0,0,0,100,0), +(@PATH,3,8278.172,107.1636,835.4257,0,0,0,0,100,0), +(@PATH,4,8280.672,97.66364,832.9257,0,0,0,0,100,0), +(@PATH,5,8292.196,85.89703,831.514,0,0,0,0,100,0), +(@PATH,6,8302.768,84.16976,828.753,0,0,0,0,100,0), +(@PATH,7,8315.018,87.41976,824.753,0,0,0,0,100,0), +(@PATH,8,8323.037,95.84097,822.5682,0,0,0,0,100,0), +(@PATH,9,8326.287,99.59097,821.8182,0,0,0,0,100,0), +(@PATH,10,8328.787,102.591,821.3182,0,0,0,0,100,0), +(@PATH,11,8329.604,121.7692,820.901,0,0,0,0,100,0), +(@PATH,12,8321.604,127.2692,823.901,0,0,0,0,100,0), +(@PATH,13,8311.825,130.3843,827.8814,0,0,0,0,100,0), +(@PATH,14,8301.5,130.3336,831.0457,0,0,0,0,100,0), +(@PATH,15,8295.75,129.3336,831.5457,0,0,0,0,100,0), +(@PATH,16,8292.822,128.321,831.7411,0,0,0,0,100,0), +(@PATH,17,8286.822,123.571,832.2411,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000688E70A .go 8284.329 121.4438 833.2343 + +-- 10 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113388; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8261.218,`position_y`=-54.82065,`position_z`=838.364 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,8261.218,-54.82065,838.364,0,0,0,0,100,0), +(@PATH,2,8259.968,-54.07065,838.614,0,0,0,0,100,0), +(@PATH,3,8220.468,-57.32065,843.864,0,0,0,0,100,0), +(@PATH,4,8208.107,-63.9275,845.6727,0,0,0,0,100,0), +(@PATH,5,8184.943,-83.72288,849.8229,0,0,0,0,100,0), +(@PATH,6,8174.943,-90.22288,850.3229,0,0,0,0,100,0), +(@PATH,7,8160.901,-121.3754,852.5476,0,0,0,0,100,0), +(@PATH,8,8166.575,-135.1128,851.502,0,0,0,0,100,0), +(@PATH,9,8185.575,-143.1128,850.752,0,0,0,0,100,0), +(@PATH,10,8221.051,-150.4958,852.1077,0,0,0,0,100,0), +(@PATH,11,8232.375,-161.3204,854.3168,0,0,0,0,100,0), +(@PATH,12,8242.125,-154.5704,853.8168,0,0,0,0,100,0), +(@PATH,13,8258.375,-143.3204,849.0668,0,0,0,0,100,0), +(@PATH,14,8264.131,-137.7563,846.2808,0,0,0,0,100,0), +(@PATH,15,8284.385,-110.9104,838.467,0,0,0,0,100,0), +(@PATH,16,8293.885,-92.66043,831.217,0,0,0,0,100,0); +-- 0x203CD047601CB380000C1D000008E709 .go 8261.218 -54.82065 838.364 + +-- 11 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115289; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8113.045,`position_y`=-145.7162,`position_z`=859.8527 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,8113.045,-145.7162,859.8527,0,0,0,0,100,0), +(@PATH,2,8121.045,-144.4662,858.8527,0,0,0,0,100,0), +(@PATH,3,8124.795,-144.2162,858.1027,0,0,0,0,100,0), +(@PATH,4,8129.795,-143.4662,857.1027,0,0,0,0,100,0), +(@PATH,5,8138.312,-142.2911,856.4733,0,0,0,0,100,0), +(@PATH,6,8155.812,-145.5411,855.2233,0,0,0,0,100,0), +(@PATH,7,8159.812,-146.0411,854.7233,0,0,0,0,100,0), +(@PATH,8,8163.562,-146.7911,854.2233,0,0,0,0,100,0), +(@PATH,9,8168.545,-147.6485,853.438,0,0,0,0,100,0), +(@PATH,10,8165.545,-147.1485,854.188,0,0,0,0,100,0), +(@PATH,11,8160.795,-146.1485,854.438,0,0,0,0,100,0), +(@PATH,12,8156.795,-145.3985,855.188,0,0,0,0,100,0), +(@PATH,13,8151.045,-144.6485,856.438,0,0,0,0,100,0), +(@PATH,14,8138,-142.2222,856.7609,0,0,0,0,100,0), +(@PATH,15,8128.25,-143.7222,857.2609,0,0,0,0,100,0), +(@PATH,16,8123.5,-144.4722,858.2609,0,0,0,0,100,0), +(@PATH,17,8113.034,-146.0319,859.786,0,0,0,0,100,0), +(@PATH,18,8101.534,-148.2819,858.786,0,0,0,0,100,0), +(@PATH,19,8096.668,-149.2531,858.3553,0,0,0,0,100,0), +(@PATH,20,8086.918,-148.7531,857.1053,0,0,0,0,100,0), +(@PATH,21,8094.245,-149.1685,857.9631,0,0,0,0,100,0), +(@PATH,22,8107.382,-147.1342,859.3724,0,0,0,0,100,0); +-- 0x203CD047601CB380000C1D000008E70A .go 8113.045 -145.7162 859.8527 + +-- 12 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113387; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8170.149,`position_y`=-133.9764,`position_z`=852.0671 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,8170.149,-133.9764,852.0671,0,0,0,0,100,0), +(@PATH,2,8163.399,-126.9764,853.3171,0,0,0,0,100,0), +(@PATH,3,8157.419,-121.2402,853.9956,0,0,0,0,100,0), +(@PATH,4,8152.419,-121.2402,854.2456,0,0,0,0,100,0), +(@PATH,5,8147.669,-121.2402,854.9956,0,0,0,0,100,0), +(@PATH,6,8141.832,-121.1382,855.4686,0,0,0,0,100,0), +(@PATH,7,8136.582,-127.1382,857.4686,0,0,0,0,100,0), +(@PATH,8,8129.55,-135.0644,857.4929,0,0,0,0,100,0), +(@PATH,9,8129.05,-142.8144,857.9929,0,0,0,0,100,0), +(@PATH,10,8128.589,-149.8953,859.0665,0,0,0,0,100,0), +(@PATH,11,8134.625,-161.6889,858.8472,0,0,0,0,100,0), +(@PATH,12,8139.875,-163.9389,857.8472,0,0,0,0,100,0), +(@PATH,13,8145.5,-166.7278,857.3265,0,0,0,0,100,0), +(@PATH,14,8151.5,-167.2278,856.5765,0,0,0,0,100,0), +(@PATH,15,8159.863,-166.7916,855.6296,0,0,0,0,100,0), +(@PATH,16,8169.827,-158.6342,854.9665,0,0,0,0,100,0), +(@PATH,17,8171.077,-154.8842,854.2165,0,0,0,0,100,0), +(@PATH,18,8173.96,-147.1916,853.1615,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000090B16 .go 8170.149 -133.9764 852.0671 + +-- 13 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113393; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8224.797,`position_y`=-57.28389,`position_z`=844.0118 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,8224.797,-57.28389,844.0118,0,0,0,0,100,0), +(@PATH,2,8221.297,-51.53389,845.2618,0,0,0,0,100,0), +(@PATH,3,8216.066,-42.17661,846.0341,0,0,0,0,100,0), +(@PATH,4,8210.066,-38.92661,847.5341,0,0,0,0,100,0), +(@PATH,5,8201.566,-33.92661,848.2841,0,0,0,0,100,0), +(@PATH,6,8198.287,-31.94426,849.2422,0,0,0,0,100,0), +(@PATH,7,8185.307,-34.69743,851.4602,0,0,0,0,100,0), +(@PATH,8,8171.356,-45.90803,853.3741,0,0,0,0,100,0), +(@PATH,9,8167.435,-62.14374,852.7194,0,0,0,0,100,0), +(@PATH,10,8169.935,-66.39374,852.4694,0,0,0,0,100,0), +(@PATH,11,8175.568,-76.82973,852.3575,0,0,0,0,100,0), +(@PATH,12,8189.388,-85.52091,849.8093,0,0,0,0,100,0), +(@PATH,13,8203.619,-87.87728,847.043,0,0,0,0,100,0), +(@PATH,14,8217.857,-82.13977,846.7528,0,0,0,0,100,0), +(@PATH,15,8223.357,-71.88977,846.2528,0,0,0,0,100,0), +(@PATH,16,8224.282,-64.98611,844.8251,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000090EE0 .go 8224.797 -57.28389 844.0118 + +-- 14 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113394; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8092.041,`position_y`=-125.5589,`position_z`=860.9391 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,8092.041,-125.5589,860.9391,0,0,0,0,100,0), +(@PATH,2,8092.291,-117.8089,860.1891,0,0,0,0,100,0), +(@PATH,3,8089.837,-110.99,860.6083,0,0,0,0,100,0), +(@PATH,4,8087.372,-106.6422,860.7501,0,0,0,0,100,0), +(@PATH,5,8083.122,-102.3922,860.2501,0,0,0,0,100,0), +(@PATH,6,8074.622,-93.14217,860.5001,0,0,0,0,100,0), +(@PATH,7,8070.13,-90.92207,861.4481,0,0,0,0,100,0), +(@PATH,8,8067.38,-90.17207,861.9481,0,0,0,0,100,0), +(@PATH,9,8059.083,-87.19926,862.3928,0,0,0,0,100,0), +(@PATH,10,8053.083,-90.69926,862.8928,0,0,0,0,100,0), +(@PATH,11,8048.083,-93.44926,863.3928,0,0,0,0,100,0), +(@PATH,12,8045.337,-95.49344,863.9271,0,0,0,0,100,0), +(@PATH,13,8047.837,-100.7434,864.4271,0,0,0,0,100,0), +(@PATH,14,8053.272,-111.2964,864.1976,0,0,0,0,100,0), +(@PATH,15,8056.14,-123.6121,861.4926,0,0,0,0,100,0), +(@PATH,16,8064.39,-126.6121,859.7426,0,0,0,0,100,0), +(@PATH,17,8069.186,-128.5212,859.0728,0,0,0,0,100,0), +(@PATH,18,8085.84,-128.5559,860.9337,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000090EE8 .go 8092.041 -125.5589 860.9391 + +-- 15 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113390; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8239.28,`position_y`=-118.3995,`position_z`=847.8878 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,8239.28,-118.3995,847.8878,0,0,0,0,100,0), +(@PATH,2,8236.78,-116.3995,848.3878,0,0,0,0,100,0), +(@PATH,3,8229.722,-110.955,849.0916,0,0,0,0,100,0), +(@PATH,4,8220.815,-110.3566,849.0093,0,0,0,0,100,0), +(@PATH,5,8216.315,-113.8566,848.7593,0,0,0,0,100,0), +(@PATH,6,8210.815,-117.8566,849.2593,0,0,0,0,100,0), +(@PATH,7,8203.953,-128.8316,851.0131,0,0,0,0,100,0), +(@PATH,8,8200.203,-145.0816,850.0131,0,0,0,0,100,0), +(@PATH,9,8202.623,-151.9364,850.6365,0,0,0,0,100,0), +(@PATH,10,8205.279,-157.3342,852.0366,0,0,0,0,100,0), +(@PATH,11,8207.029,-157.8342,852.5366,0,0,0,0,100,0), +(@PATH,12,8210.779,-158.8342,853.7866,0,0,0,0,100,0), +(@PATH,13,8215.529,-160.3342,854.5366,0,0,0,0,100,0), +(@PATH,14,8227.006,-160.7807,854.4167,0,0,0,0,100,0), +(@PATH,15,8239.143,-151.2999,854.6742,0,0,0,0,100,0), +(@PATH,16,8244.271,-140.1049,852.0412,0,0,0,0,100,0), +(@PATH,17,8242.991,-129.3054,848.2133,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000090F5C .go 8239.28 -118.3995 847.8878 + +-- 16 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113383; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8011.053,`position_y`=-95.82051,`position_z`=868.8751 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,8011.053,-95.82051,868.8751,0,0,0,0,100,0), +(@PATH,2,8009.053,-98.07051,868.1251,0,0,0,0,100,0), +(@PATH,3,8002.777,-105.2258,867.3148,0,0,0,0,100,0), +(@PATH,4,8002.527,-110.9758,867.5648,0,0,0,0,100,0), +(@PATH,5,8002.309,-116.2535,867.8479,0,0,0,0,100,0), +(@PATH,6,8007.059,-124.5035,867.0979,0,0,0,0,100,0), +(@PATH,7,8019.524,-129.6734,866.1702,0,0,0,0,100,0), +(@PATH,8,8025.563,-124.448,865.4678,0,0,0,0,100,0), +(@PATH,9,8028.063,-121.948,864.9678,0,0,0,0,100,0), +(@PATH,10,8030.313,-112.448,864.4678,0,0,0,0,100,0), +(@PATH,11,8028.987,-106.4559,865.0516,0,0,0,0,100,0), +(@PATH,12,8027.906,-102.6449,866.0817,0,0,0,0,100,0), +(@PATH,13,8025.906,-100.6449,866.8317,0,0,0,0,100,0), +(@PATH,14,8024.156,-98.39489,867.5817,0,0,0,0,100,0), +(@PATH,15,8022.333,-96.49437,868.2311,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009B815 .go 8011.053 -95.82051 868.8751 + +-- 17 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113389; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=8137.981,`position_y`=-25.96372,`position_z`=861.1268 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,8137.981,-25.96372,861.1268,0,0,0,0,100,0), +(@PATH,2,8124.158,-21.75461,864.9316,0,0,0,0,100,0), +(@PATH,3,8117.658,-23.25461,865.9316,0,0,0,0,100,0), +(@PATH,4,8110.664,-24.86094,866.3862,0,0,0,0,100,0), +(@PATH,5,8106.414,-27.11094,865.8862,0,0,0,0,100,0), +(@PATH,6,8100.164,-29.86094,866.3862,0,0,0,0,100,0), +(@PATH,7,8092.958,-39.87451,863.9676,0,0,0,0,100,0), +(@PATH,8,8089.466,-45.70385,863.3384,0,0,0,0,100,0), +(@PATH,9,8092.216,-46.95385,862.8384,0,0,0,0,100,0), +(@PATH,10,8102.716,-51.95385,863.0884,0,0,0,0,100,0), +(@PATH,11,8110.197,-55.45034,863.1456,0,0,0,0,100,0), +(@PATH,12,8115.947,-55.20034,862.3956,0,0,0,0,100,0), +(@PATH,13,8127.869,-52.50022,859.0458,0,0,0,0,100,0), +(@PATH,14,8136.268,-49.04823,858.8497,0,0,0,0,100,0), +(@PATH,15,8138.018,-45.54823,859.3497,0,0,0,0,100,0), +(@PATH,16,8142.212,-38.46772,860.2988,0,0,0,0,100,0), +(@PATH,17,8140.962,-34.96772,860.7988,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000608E709 .go 8137.981 -25.96372 861.1268 + +-- 18 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115288; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7729.775,`position_y`=-162.0579,`position_z`=875.1993 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,7729.775,-162.0579,875.1993,0,0,0,0,100,0), +(@PATH,2,7718.775,-150.0579,866.9493,0,0,0,0,100,0), +(@PATH,3,7714.09,-144.8307,864.7841,0,0,0,0,100,0), +(@PATH,4,7681.938,-126.7039,858.0164,0,0,0,0,100,0), +(@PATH,5,7601.672,-99.42115,852.6929,0,0,0,0,100,0), +(@PATH,6,7601.326,-99.12383,852.9333,0,0,0,0,100,0), +(@PATH,7,7591.576,-95.37383,856.1833,0,0,0,0,100,0), +(@PATH,8,7587.109,-93.54893,856.2277,0,0,0,0,100,0), +(@PATH,9,7633.792,-112.5126,851.726,0,0,0,0,100,0), +(@PATH,10,7641.292,-115.0126,851.226,0,0,0,0,100,0), +(@PATH,11,7668.157,-120.7587,853.6274,0,0,0,0,100,0), +(@PATH,12,7672.907,-122.7587,854.3774,0,0,0,0,100,0), +(@PATH,13,7684.657,-127.5087,859.1274,0,0,0,0,100,0), +(@PATH,14,7690.157,-129.7587,860.3774,0,0,0,0,100,0), +(@PATH,15,7703.922,-137.9652,861.9536,0,0,0,0,100,0); +-- 0x203CD047601CB380000C1D000009A15E .go 7729.775 -162.0579 875.1993 + +-- 19 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115284; +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`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 1, 8287.09, -109.358, 836.91, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 8303.23, -86.5026, 829.131, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 8301.78, -63.4542, 828.74, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 8287.95, -54.9459, 831.378, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 8263.13, -62.1064, 837.124, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 8255.9, -91.615, 840.24, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 8250.24, -114.158, 846.065, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 8258.48, -133.333, 845.805, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 8276.5, -128.463, 844.769, 0, 0, 0, 0, 100, 0); +-- 0x203CD047601CB380000C1D000009A15E .go 7729.775 -162.0579 875.1993 + +-- 20 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115287; +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`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 1, 8146.4, -33.0818, 858.977, 0, 0, 0, 0, 100, 0), +(@PATH, 2, 8131.03, -50.6079, 857.581, 0, 0, 0, 0, 100, 0), +(@PATH, 3, 8129.46, -73.9332, 856.529, 0, 0, 0, 0, 100, 0), +(@PATH, 4, 8140.89, -109.386, 854.486, 0, 0, 0, 0, 100, 0), +(@PATH, 5, 8170.77, -117.146, 852.526, 0, 0, 0, 0, 100, 0), +(@PATH, 6, 8193.43, -113.071, 848.526, 0, 0, 0, 0, 100, 0), +(@PATH, 7, 8203.92, -97.3843, 847.322, 0, 0, 0, 0, 100, 0), +(@PATH, 8, 8210.68, -77.5012, 845.115, 0, 0, 0, 0, 100, 0), +(@PATH, 9, 8208.03, -56.9516, 845.03, 0, 0, 0, 0, 100, 0), +(@PATH, 10, 8195.88, -37.2008, 847.441, 0, 0, 0, 0, 100, 0), +(@PATH, 11, 8174.54, -23.2762, 852.409, 0, 0, 0, 0, 100, 0); +-- 0x203CD047601CB380000C1D000009A15E .go 7729.775 -162.0579 875.1993 + +-- 21 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115290; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7962.478,`position_y`=-104.978,`position_z`=876.2352 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,7962.478,-104.978,876.2352,0,0,0,0,100,0), +(@PATH,2,7958.728,-106.728,876.9852,0,0,0,0,100,0), +(@PATH,3,7956.978,-107.728,877.4852,0,0,0,0,100,0), +(@PATH,4,7954.728,-108.728,878.2352,0,0,0,0,100,0), +(@PATH,5,7951.978,-110.228,878.7352,0,0,0,0,100,0), +(@PATH,6,7950.228,-111.228,879.4852,0,0,0,0,100,0), +(@PATH,7,7951.728,-110.228,878.7352,0,0,0,0,100,0), +(@PATH,8,7954.478,-108.978,878.2352,0,0,0,0,100,0), +(@PATH,9,7967.349,-103.0375,874.6534,0,0,0,0,100,0), +(@PATH,10,7978.582,-100.8995,873.8323,0,0,0,0,100,0), +(@PATH,11,7984.332,-100.6495,873.0823,0,0,0,0,100,0), +(@PATH,12,7986.332,-100.6495,872.5823,0,0,0,0,100,0), +(@PATH,13,7995.295,-101.795,868.124,0,0,0,0,100,0), +(@PATH,14,7999.713,-102.601,866.489,0,0,0,0,100,0), +(@PATH,15,7995.963,-101.851,867.489,0,0,0,0,100,0), +(@PATH,16,7981.404,-100.8894,873.796,0,0,0,0,100,0), +(@PATH,17,7978.154,-100.8894,874.046,0,0,0,0,100,0), +(@PATH,18,7966.654,-102.8894,874.546,0,0,0,0,100,0), +(@PATH,19,7957.309,-107.5281,877.4311,0,0,0,0,100,0), +(@PATH,20,7954.559,-108.7781,878.1811,0,0,0,0,100,0), +(@PATH,21,7952.059,-110.2781,878.6811,0,0,0,0,100,0), +(@PATH,22,7956.978,-107.728,877.4852,0,0,0,0,100,0), +(@PATH,23,7958.728,-106.728,876.9852,0,0,0,0,100,0), +(@PATH,24,7960.478,-105.978,876.4852,0,0,0,0,100,0), +(@PATH,25,7962.978,-104.478,875.7352,0,0,0,0,100,0), +(@PATH,26,7954.605,-113.4985,877.3135,0,0,0,0,100,0), +(@PATH,27,7957.355,-125.9985,872.8135,0,0,0,0,100,0), +(@PATH,28,7953.318,-109.6559,878.1667,0,0,0,0,100,0); +-- 0x203CD047601CB380000C1D0000091D3A .go 7962.478 -104.978 876.2352 + +-- 22 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115291; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7931.346,`position_y`=-237.1364,`position_z`=871.7883 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,7931.346,-237.1364,871.7883,0,0,0,0,100,0), +(@PATH,2,7952.126,-205.6467,868.6334,0,0,0,0,100,0), +(@PATH,3,7956.538,-180.1704,867.7823,0,0,0,0,100,0), +(@PATH,4,7932.038,-155.6704,868.2823,0,0,0,0,100,0), +(@PATH,5,7891.03,-139.0742,871.8517,0,0,0,0,100,0), +(@PATH,6,7862.28,-139.8242,876.1017,0,0,0,0,100,0), +(@PATH,7,7862.11,-139.8329,876.4797,0,0,0,0,100,0), +(@PATH,8,7836.143,-159.29,877.4626,0,0,0,0,100,0), +(@PATH,9,7817.548,-188.1205,880.426,0,0,0,0,100,0), +(@PATH,10,7845.881,-234.2336,880.1614,0,0,0,0,100,0), +(@PATH,11,7857.998,-268.1895,883.2256,0,0,0,0,100,0), +(@PATH,12,7905.861,-270.3058,875.3668,0,0,0,0,100,0), +(@PATH,13,7926.361,-243.5558,873.1168,0,0,0,0,100,0); +-- 0x203CD047601CB380000C1D000009B7E3 .go 7931.346 -237.1364 871.7883 + +-- 23 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 115283; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7826.088,`position_y`=-342.1893,`position_z`=896.4302 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,7826.088,-342.1893,896.4302,0,0,0,0,100,0), +(@PATH,2,7826.088,-337.1893,895.6802,0,0,0,0,100,0), +(@PATH,3,7826.088,-334.4393,895.4302,0,0,0,0,100,0), +(@PATH,4,7826.088,-329.4393,894.6802,0,0,0,0,100,0), +(@PATH,5,7825.917,-324.7986,894.2247,0,0,0,0,100,0), +(@PATH,6,7824.917,-317.7986,895.2247,0,0,0,0,100,0), +(@PATH,7,7824.417,-314.7986,895.4747,0,0,0,0,100,0), +(@PATH,8,7824.167,-312.0486,896.2247,0,0,0,0,100,0), +(@PATH,9,7823.917,-309.2986,896.9747,0,0,0,0,100,0), +(@PATH,10,7821.913,-296.525,897.121,0,0,0,0,100,0), +(@PATH,11,7816.413,-286.275,896.371,0,0,0,0,100,0), +(@PATH,12,7815.163,-283.525,895.621,0,0,0,0,100,0), +(@PATH,13,7814.163,-281.775,894.621,0,0,0,0,100,0), +(@PATH,14,7813.413,-280.025,893.871,0,0,0,0,100,0), +(@PATH,15,7811.913,-277.275,893.371,0,0,0,0,100,0), +(@PATH,16,7801.908,-260.5068,892.2883,0,0,0,0,100,0), +(@PATH,17,7825.939,-325.0502,894.215,0,0,0,0,100,0), +(@PATH,18,7826.189,-333.0502,894.965,0,0,0,0,100,0), +(@PATH,19,7826.189,-335.0502,895.465,0,0,0,0,100,0), +(@PATH,20,7826.189,-337.8002,895.965,0,0,0,0,100,0), +(@PATH,21,7826.189,-342.8002,896.715,0,0,0,0,100,0), +(@PATH,22,7826.318,-348.9898,897.3843,0,0,0,0,100,0), +(@PATH,23,7824.818,-354.9898,898.1343,0,0,0,0,100,0), +(@PATH,24,7821.818,-367.2398,898.6343,0,0,0,0,100,0), +(@PATH,25,7821.318,-369.2398,899.3843,0,0,0,0,100,0), +(@PATH,26,7821.068,-370.2398,899.8843,0,0,0,0,100,0), +(@PATH,27,7820.318,-372.9898,900.6343,0,0,0,0,100,0), +(@PATH,28,7819.818,-374.9898,901.3843,0,0,0,0,100,0), +(@PATH,29,7819.068,-377.9898,902.1343,0,0,0,0,100,0); +-- 0x203CD047601CB380000C1D000088E70A .go 7826.088 -342.1893 896.4302 + +-- 24 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113371; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7964.534,`position_y`=-496.7162,`position_z`=911.4208 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,7964.534,-496.7162,911.4208,0,0,0,0,100,0), +(@PATH,2,7964.034,-488.9662,910.6708,0,0,0,0,100,0), +(@PATH,3,7963.784,-484.9662,909.9208,0,0,0,0,100,0), +(@PATH,4,7961.325,-475.3741,904.6919,0,0,0,0,100,0), +(@PATH,5,7950.872,-469.3599,902.6947,0,0,0,0,100,0), +(@PATH,6,7941.893,-469.2499,901.594,0,0,0,0,100,0), +(@PATH,7,7933.553,-476.817,901.6441,0,0,0,0,100,0), +(@PATH,8,7930.099,-486.2301,905.3557,0,0,0,0,100,0), +(@PATH,9,7932.197,-495.9886,908.0842,0,0,0,0,100,0), +(@PATH,10,7932.697,-497.9886,908.8342,0,0,0,0,100,0), +(@PATH,11,7934.447,-499.2386,909.0842,0,0,0,0,100,0), +(@PATH,12,7936.447,-500.9886,910.0842,0,0,0,0,100,0), +(@PATH,13,7941.47,-504.9008,910.8705,0,0,0,0,100,0), +(@PATH,14,7952.649,-507.087,911.3226,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000090730 .go 7964.534 -496.7162 911.4208 + +-- 25 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113372; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7936.481,`position_y`=-515.3499,`position_z`=913.5527 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,7936.481,-515.3499,913.5527,0,0,0,0,100,0), +(@PATH,2,7925.203,-524.214,913.3343,0,0,0,0,100,0), +(@PATH,3,7923.953,-531.964,914.0843,0,0,0,0,100,0), +(@PATH,4,7923.271,-535.9978,915.5811,0,0,0,0,100,0), +(@PATH,5,7928.549,-544.8326,920.0537,0,0,0,0,100,0), +(@PATH,6,7931.549,-547.0826,920.5537,0,0,0,0,100,0), +(@PATH,7,7937.795,-551.6417,921.2117,0,0,0,0,100,0), +(@PATH,8,7941.795,-552.1417,921.7117,0,0,0,0,100,0), +(@PATH,9,7946.295,-552.8917,922.4617,0,0,0,0,100,0), +(@PATH,10,7951.295,-553.6417,921.7117,0,0,0,0,100,0), +(@PATH,11,7958.813,-552.6586,919.6346,0,0,0,0,100,0), +(@PATH,12,7964.313,-549.6586,918.6346,0,0,0,0,100,0), +(@PATH,13,7964.813,-545.6586,918.1346,0,0,0,0,100,0), +(@PATH,14,7965.692,-538.2499,917.9045,0,0,0,0,100,0), +(@PATH,15,7960.692,-527.7499,917.1545,0,0,0,0,100,0), +(@PATH,16,7950.671,-518.781,913.1788,0,0,0,0,100,0), +(@PATH,17,7948.671,-517.531,912.9288,0,0,0,0,100,0), +(@PATH,18,7942.171,-516.281,913.1788,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009074A .go 7936.481 -515.3499 913.5527 + +-- 26 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113378; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7882.668,`position_y`=-335.8647,`position_z`=884.3019 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,7882.668,-335.8647,884.3019,0,0,0,0,100,0), +(@PATH,2,7879.918,-330.1147,883.5519,0,0,0,0,100,0), +(@PATH,3,7878.918,-320.6147,884.0519,0,0,0,0,100,0), +(@PATH,4,7878.583,-315.2315,883.4753,0,0,0,0,100,0), +(@PATH,5,7882.398,-307.8708,881.4282,0,0,0,0,100,0), +(@PATH,6,7892.883,-304.4643,880.4242,0,0,0,0,100,0), +(@PATH,7,7900.926,-308.514,878.4785,0,0,0,0,100,0), +(@PATH,8,7904.426,-310.264,877.9785,0,0,0,0,100,0), +(@PATH,9,7911.176,-315.764,877.4785,0,0,0,0,100,0), +(@PATH,10,7916.583,-320.2761,877.1124,0,0,0,0,100,0), +(@PATH,11,7922.944,-332.6617,880.4846,0,0,0,0,100,0), +(@PATH,12,7919.944,-337.4117,881.2346,0,0,0,0,100,0), +(@PATH,13,7917.849,-341.5013,881.5995,0,0,0,0,100,0), +(@PATH,14,7906.154,-348.1179,883.4591,0,0,0,0,100,0), +(@PATH,15,7899.404,-348.8679,884.2091,0,0,0,0,100,0), +(@PATH,16,7895.163,-349.1321,884.8114,0,0,0,0,100,0), +(@PATH,17,7890.663,-345.6321,885.3114,0,0,0,0,100,0), +(@PATH,18,7886.087,-341.9172,885.6866,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000091D44 .go 7882.668 -335.8647 884.3019 + +-- 27 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113381; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7806.673,`position_y`=-264.247,`position_z`=893.3229 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,7806.673,-264.247,893.3229,0,0,0,0,100,0), +(@PATH,2,7804.923,-266.997,894.3229,0,0,0,0,100,0), +(@PATH,3,7804.173,-270.997,894.8229,0,0,0,0,100,0), +(@PATH,4,7802.673,-275.497,895.3229,0,0,0,0,100,0), +(@PATH,5,7801.131,-281.4723,897.5118,0,0,0,0,100,0), +(@PATH,6,7808.131,-289.4723,898.2618,0,0,0,0,100,0), +(@PATH,7,7820.355,-287.2386,897.2406,0,0,0,0,100,0), +(@PATH,8,7820.494,-287.2525,897.3724,0,0,0,0,100,0), +(@PATH,9,7830.744,-281.5025,894.6224,0,0,0,0,100,0), +(@PATH,10,7831.391,-271.0396,891.8566,0,0,0,0,100,0), +(@PATH,11,7831.145,-265.8995,891.6976,0,0,0,0,100,0), +(@PATH,12,7828.956,-259.3557,891.9122,0,0,0,0,100,0), +(@PATH,13,7825.122,-255.9064,891.7454,0,0,0,0,100,0), +(@PATH,14,7818.013,-256.4042,890.922,0,0,0,0,100,0), +(@PATH,15,7811.013,-261.1542,891.922,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000091D79 .go 7806.673 -264.247 893.3229 + +-- 28 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113386; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7907.299,`position_y`=-116.1205,`position_z`=877.2152 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,7907.299,-116.1205,877.2152,0,0,0,0,100,0), +(@PATH,2,7906.916,-110.1426,877.9662,0,0,0,0,100,0), +(@PATH,3,7906.88,-107.0582,878.896,0,0,0,0,100,0), +(@PATH,4,7903.778,-100.1047,881.9014,0,0,0,0,100,0), +(@PATH,5,7895.384,-95.24154,884.3519,0,0,0,0,100,0), +(@PATH,6,7889.634,-96.49154,885.1019,0,0,0,0,100,0), +(@PATH,7,7887.759,-96.79578,885.2578,0,0,0,0,100,0), +(@PATH,8,7879.157,-105.284,883.3859,0,0,0,0,100,0), +(@PATH,9,7877.484,-108.0048,882.6,0,0,0,0,100,0), +(@PATH,10,7876.484,-109.2548,882.1,0,0,0,0,100,0), +(@PATH,11,7878.839,-119.2038,878.769,0,0,0,0,100,0), +(@PATH,12,7881.339,-121.9538,878.019,0,0,0,0,100,0), +(@PATH,13,7883.839,-124.9538,877.519,0,0,0,0,100,0), +(@PATH,14,7886.191,-127.1403,876.7408,0,0,0,0,100,0), +(@PATH,15,7887.441,-128.6403,875.9908,0,0,0,0,100,0), +(@PATH,16,7895.941,-126.1403,876.7408,0,0,0,0,100,0), +(@PATH,17,7901.846,-124.529,876.8298,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D0000091DB3 .go 7907.299 -116.1205 877.2152 + +-- 29 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113382; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7939.051,`position_y`=-212.0869,`position_z`=868.8726 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,7939.051,-212.0869,868.8726,0,0,0,0,100,0), +(@PATH,2,7937.074,-200.4377,868.8435,0,0,0,0,100,0), +(@PATH,3,7934.574,-196.4377,868.3435,0,0,0,0,100,0), +(@PATH,4,7932.289,-192.9474,867.9701,0,0,0,0,100,0), +(@PATH,5,7924.047,-189.5213,868.165,0,0,0,0,100,0), +(@PATH,6,7914.271,-187.7899,871.269,0,0,0,0,100,0), +(@PATH,7,7907.263,-193.7007,871.2343,0,0,0,0,100,0), +(@PATH,8,7903.763,-200.4507,871.4843,0,0,0,0,100,0), +(@PATH,9,7903.536,-200.702,871.7118,0,0,0,0,100,0), +(@PATH,10,7902.036,-203.702,871.7118,0,0,0,0,100,0), +(@PATH,11,7902.286,-208.452,871.2118,0,0,0,0,100,0), +(@PATH,12,7902.237,-216.3445,871.2385,0,0,0,0,100,0), +(@PATH,13,7910.793,-223.7857,871.1857,0,0,0,0,100,0), +(@PATH,14,7923.444,-227.3098,870.9725,0,0,0,0,100,0), +(@PATH,15,7926.694,-225.3098,870.4725,0,0,0,0,100,0), +(@PATH,16,7934.415,-220.85,870.1981,0,0,0,0,100,0), +(@PATH,17,7936.165,-217.6,869.6981,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009B789 .go 7939.051 -212.0869 868.8726 + +-- 30 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113380; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7856.291,`position_y`=-377.0292,`position_z`=893.7392 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,7856.291,-377.0292,893.7392,0,0,0,0,100,0), +(@PATH,2,7844.067,-380.9856,897.8703,0,0,0,0,100,0), +(@PATH,3,7842.817,-383.7356,898.6203,0,0,0,0,100,0), +(@PATH,4,7837.246,-396.3517,900.8141,0,0,0,0,100,0), +(@PATH,5,7840.746,-409.6017,900.3141,0,0,0,0,100,0), +(@PATH,6,7843.023,-411.2653,899.7865,0,0,0,0,100,0), +(@PATH,7,7851.767,-416.7169,898.8773,0,0,0,0,100,0), +(@PATH,8,7862.026,-418.29,896.3708,0,0,0,0,100,0), +(@PATH,9,7870.276,-413.29,894.6208,0,0,0,0,100,0), +(@PATH,10,7874.109,-410.3698,893.6812,0,0,0,0,100,0), +(@PATH,11,7873.602,-395.0012,891.5162,0,0,0,0,100,0), +(@PATH,12,7871.365,-385.4788,891.3826,0,0,0,0,100,0), +(@PATH,13,7869.115,-383.7288,892.1326,0,0,0,0,100,0), +(@PATH,14,7866.365,-380.9788,892.6326,0,0,0,0,100,0), +(@PATH,15,7863.131,-378.1737,892.8054,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009B78A .go 7856.291 -377.0292 893.7392 + +-- 31 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113373; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7932.32,`position_y`=-415.053,`position_z`=891.8268 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,7932.32,-415.053,891.8268,0,0,0,0,100,0), +(@PATH,2,7928.82,-414.553,891.0768,0,0,0,0,100,0), +(@PATH,3,7926.07,-414.303,890.8268,0,0,0,0,100,0), +(@PATH,4,7920.668,-413.7732,890.6802,0,0,0,0,100,0), +(@PATH,5,7912.178,-417.5264,890.9336,0,0,0,0,100,0), +(@PATH,6,7906.428,-424.0264,891.1836,0,0,0,0,100,0), +(@PATH,7,7901.829,-438.0031,895.7061,0,0,0,0,100,0), +(@PATH,8,7904.829,-441.7531,896.7061,0,0,0,0,100,0), +(@PATH,9,7908.936,-447.2642,897.145,0,0,0,0,100,0), +(@PATH,10,7915.436,-448.7642,897.645,0,0,0,0,100,0), +(@PATH,11,7924.153,-451.3075,897.8478,0,0,0,0,100,0), +(@PATH,12,7928.153,-450.0575,897.3478,0,0,0,0,100,0), +(@PATH,13,7941.832,-445.3867,898.3464,0,0,0,0,100,0), +(@PATH,14,7946.148,-433.0703,896.0321,0,0,0,0,100,0), +(@PATH,15,7942.648,-425.0703,895.0321,0,0,0,0,100,0), +(@PATH,16,7941.398,-421.3203,894.7821,0,0,0,0,100,0), +(@PATH,17,7936.718,-417.7,893.3426,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009B79F .go 7932.32 -415.053 891.8268 + +-- 32 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113384; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7921.565,`position_y`=-235.566,`position_z`=873.1581 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,7921.565,-235.566,873.1581,0,0,0,0,100,0), +(@PATH,2,7912.748,-231.0216,872.7734,0,0,0,0,100,0), +(@PATH,3,7907.748,-230.7716,872.2734,0,0,0,0,100,0), +(@PATH,4,7900.154,-230.6973,872.1544,0,0,0,0,100,0), +(@PATH,5,7892.55,-233.0851,873.8065,0,0,0,0,100,0), +(@PATH,6,7888.3,-239.5851,874.3065,0,0,0,0,100,0), +(@PATH,7,7885.4,-243.9487,875.5348,0,0,0,0,100,0), +(@PATH,8,7885.975,-255.0505,877.9758,0,0,0,0,100,0), +(@PATH,9,7891.241,-261.0245,877.8999,0,0,0,0,100,0), +(@PATH,10,7900.34,-270.3193,877.1683,0,0,0,0,100,0), +(@PATH,11,7904.34,-271.0693,876.6683,0,0,0,0,100,0), +(@PATH,12,7912.338,-273.0228,876.3547,0,0,0,0,100,0), +(@PATH,13,7925.873,-270.48,875.6802,0,0,0,0,100,0), +(@PATH,14,7930.354,-258.4549,875.5649,0,0,0,0,100,0), +(@PATH,15,7930.229,-245.6155,873.9316,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009B7E1 .go 7921.565 -235.566 873.1581 + +-- 33 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113385; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7967.27,`position_y`=-150.0064,`position_z`=867.3828 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,7967.27,-150.0064,867.3828,0,0,0,0,100,0), +(@PATH,2,7965.02,-147.7564,868.3828,0,0,0,0,100,0), +(@PATH,3,7960.52,-150.0064,869.3828,0,0,0,0,100,0), +(@PATH,4,7957.325,-151.4551,869.3378,0,0,0,0,100,0), +(@PATH,5,7949.724,-158.8941,869.6543,0,0,0,0,100,0), +(@PATH,6,7948.474,-165.6441,869.1543,0,0,0,0,100,0), +(@PATH,7,7947.817,-169.516,868.6296,0,0,0,0,100,0), +(@PATH,8,7952.93,-178.4099,868.7637,0,0,0,0,100,0), +(@PATH,9,7962.082,-184.3365,868.1664,0,0,0,0,100,0), +(@PATH,10,7965.582,-183.3365,867.9164,0,0,0,0,100,0), +(@PATH,11,7975.864,-177.8723,868.5774,0,0,0,0,100,0), +(@PATH,12,7977.614,-176.1223,868.8274,0,0,0,0,100,0), +(@PATH,13,7981.194,-170.4183,868.9552,0,0,0,0,100,0), +(@PATH,14,7979.694,-163.6683,868.2052,0,0,0,0,100,0), +(@PATH,15,7975.829,-157.9865,867.3531,0,0,0,0,100,0), +(@PATH,16,7971.586,-153.7018,866.812,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009B7EB .go 7967.27 -150.0064 867.3828 + +-- 34 +-- Pathing for Entry: Entry: 'TDB FORMAT' +SET @NPC := 113379; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=7828.894,`position_y`=-189.2058,`position_z`=879.6809 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,7828.894,-189.2058,879.6809,0,0,0,0,100,0), +(@PATH,2,7828.957,-189.0395,879.7325,0,0,0,0,100,0), +(@PATH,3,7829.961,-177.5152,878.3817,0,0,0,0,100,0), +(@PATH,4,7825.768,-165.7655,878.844,0,0,0,0,100,0), +(@PATH,5,7822.268,-164.2655,879.594,0,0,0,0,100,0), +(@PATH,6,7820.018,-163.2655,879.594,0,0,0,0,100,0), +(@PATH,7,7811.728,-162.7168,880.9461,0,0,0,0,100,0), +(@PATH,8,7802.697,-166.7544,881.1599,0,0,0,0,100,0), +(@PATH,9,7799.375,-177.3094,881.318,0,0,0,0,100,0), +(@PATH,10,7801.785,-189.0911,881.4005,0,0,0,0,100,0), +(@PATH,11,7811.168,-198.4076,880.4467,0,0,0,0,100,0), +(@PATH,12,7823.17,-196.6632,880.1226,0,0,0,0,100,0); +-- 0x203CD047601CEE00000C1D000009B85E .go 7828.894 -189.2058 879.6809 |