diff options
| -rw-r--r-- | sql/updates/world/2015_03_23_00_world.sql | 469 |
1 files changed, 469 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_23_00_world.sql b/sql/updates/world/2015_03_23_00_world.sql new file mode 100644 index 00000000000..a8c152d1985 --- /dev/null +++ b/sql/updates/world/2015_03_23_00_world.sql @@ -0,0 +1,469 @@ +-- The Vortex Pinnacle spawns +SET @CGUID := 368176; +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+121; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 49943, 657, 3, 1, 0, -324.8004, 7.833333, 627.0626, 2.86234, 7200, 0, 0), -- questgiver +(@CGUID+1, 53488, 657, 3, 1, 0, -338.7639, 13.66146, 627.0626, 0, 7200, 0, 0), -- summon enabler +(@CGUID+2, 21252, 657, 3, 1, 0, -356.958, 26.1406, 627.0623, 0, 7200, 0, 0), -- worldtrigger +-- Wild Vortex +(@CGUID+3, 45912, 657, 3, 1, 0, -418.019, -37.6424, 634.5143, 6.195919, 7200, 0, 0), +(@CGUID+4, 45912, 657, 3, 1, 0, -404.377, -70.6997, 634.5143, 1.204277, 7200, 0, 0), +(@CGUID+5, 45912, 657, 3, 1, 0, -502.7083, -185.8125, 638.5676, 0, 7200, 5, 1), +(@CGUID+6, 45912, 657, 3, 1, 0, -528.9051, -222.5104, 632.3754, 5.473792, 7200, 5, 1), +(@CGUID+7, 45912, 657, 3, 1, 0, -542.3109, -215.308, 630.7964, 0.7233705, 7200, 5, 1), +(@CGUID+8, 45912, 657, 3, 1, 0, -565.0833, -191.2153, 625.6744, 4.391624, 7200, 5, 1), +(@CGUID+9, 45912, 657, 3, 1, 0, -541.5673, -226.7534, 630.9402, 2.528159, 7200, 5, 1), +-- Gust Soldier +(@CGUID+10, 45477, 657, 3, 1, 0, -390.436, -64.9878, 634.5143, 1.64061, 7200, 0, 0), +(@CGUID+11, 45477, 657, 3, 1, 0, -423.58, -51.2708, 634.5143, 0.3490658, 7200, 0, 0), +(@CGUID+12, 45477, 657, 3, 1, 0, -503.1545, -194.2049, 637.6876, 0, 7200, 5, 1), +(@CGUID+13, 45477, 657, 3, 1, 0, -492.5903, -194.5208, 637.9598, 0, 7200, 5, 1), +(@CGUID+14, 45477, 657, 3, 1, 0, -492.7083, -185.1736, 638.7111, 0, 7200, 5, 1), +(@CGUID+15, 45477, 657, 3, 1, 0, -568.1024, -179.5122, 624.2385, 3.255483, 7200, 5, 1), +(@CGUID+16, 45477, 657, 3, 1, 0, -525.7846, -217.7267, 632.8151, 1.705291, 7200, 5, 1), +(@CGUID+17, 45477, 657, 3, 1, 0, -582.3148, -181.2325, 624.1856, 3.493456, 7200, 5, 1), +(@CGUID+18, 45477, 657, 3, 1, 0, -576.9833, -193.912, 625.4399, 0.177531, 7200, 5, 1), +(@CGUID+19, 45477, 657, 3, 1, 0, -599.738, -132.148, 619.8263, 5.88176, 7200, 0, 0), +(@CGUID+20, 45477, 657, 3, 1, 0, -584.417, -115.842, 619.8263, 5.113815, 7200, 0, 0), +-- Armored Mistral +(@CGUID+21, 45915, 657, 3, 1, 0, -418.155, -65.0139, 634.5143, 0.715585, 7200, 0, 0), +(@CGUID+22, 45915, 657, 3, 1, 0, -488.8311, -135.5369, 638.8159, 3.909716, 7200, 0, 0), +(@CGUID+23, 45915, 657, 3, 1, 0, -481.639, -128.589, 638.8203, 3.90972, 7200, 0, 0), +-- Lurking Tempest +(@CGUID+24, 45704, 657, 3, 1, 0, -519.0938, -152.8194, 639.0195, 0.4712389, 7200, 0, 0), +(@CGUID+25, 45704, 657, 3, 1, 0, -561.8281, -139.776, 623.7429, 4.537856, 7200, 0, 0), +(@CGUID+26, 45704, 657, 3, 1, 0, -650.0104, -65.13368, 619.8268, 5.497787, 7200, 0, 0), +-- Cloud Prince +(@CGUID+27, 45917, 657, 3, 1, 0, -592.736, -123.337, 619.8263, 5.497787, 7200, 0, 0), +(@CGUID+28, 45917, 657, 3, 1, 0, -668.6233, -63.64931, 619.8224, 5.550147, 7200, 0, 0), +(@CGUID+29, 45917, 657, 3, 1, 0, -652.717, -47.63889, 619.8234, 5.410521, 7200, 0, 0), +-- Grand Vizier Ertan +(@CGUID+30, 43878, 657, 3, 1, 0, -719.587, 4.32986, 635.7563, 5.480334, 7200, 0, 0), +-- Slipstream +(@CGUID+34, 45455, 657, 3, 1, 0, -310.4583, -29.74479, 625.0833, 0, 7200, 0, 0), +(@CGUID+35, 45455, 657, 3, 1, 0, -382.441, 42.31597, 625.0833, 0, 7200, 0, 0), +-- Turbulent Squall +(@CGUID+44, 45924, 657, 3, 1, 0, -966.16, -169.941, 670.1903, 5.759586, 7200, 0, 0), +(@CGUID+45, 45924, 657, 3, 1, 0, -975.819, -173.043, 672.6453, 5.986479, 7200, 0, 0), +(@CGUID+46, 45924, 657, 3, 1, 0, -984.875, -174.967, 676.3273, 6.091199, 7200, 0, 0), +(@CGUID+47, 45924, 657, 3, 1, 0, -996.002, -174.469, 680.3823, 6.108652, 7200, 0, 0), +(@CGUID+48, 45924, 657, 3, 1, 0, -939.155, -143.243, 670.2243, 5.201081, 7200, 0, 0), +(@CGUID+49, 45924, 657, 3, 1, 0, -936.123, -131.561, 673.4803, 4.974188, 7200, 0, 0), +(@CGUID+50, 45924, 657, 3, 1, 0, -934.01, -120.943, 677.5303, 4.869469, 7200, 0, 0), +(@CGUID+51, 45924, 657, 3, 1, 0, -935.212, -109.497, 682.0773, 4.852015, 7200, 0, 0), +(@CGUID+52, 45924, 657, 3, 1, 0, -1184.93, 25.7483, 710.1263, 6.143559, 7200, 0, 0), +(@CGUID+53, 45924, 657, 3, 1, 0, -1167.22, 52.3872, 707.8033, 5.969026, 7200, 0, 0), +(@CGUID+54, 45924, 657, 3, 1, 0, -1171.89, 37.6997, 707.8133, 5.742133, 7200, 0, 0), +(@CGUID+55, 45924, 657, 3, 1, 0, -1166.52, 69.7483, 710.2673, 5.602507, 7200, 0, 0), +-- Empyrean Assassin +(@CGUID+56, 45922, 657, 3, 1, 0, -948.167, -83.4965, 693.5547, 2.43775, 7200, 5, 1), +(@CGUID+57, 45922, 657, 3, 1, 0, -945.3143, -79.35951, 693.7779, 5.579355, 7200, 5, 1), +(@CGUID+58, 45922, 657, 3, 1, 0, -1039.177, -151.2265, 694.9168, 2.345539, 7200, 5, 1), +(@CGUID+59, 45922, 657, 3, 1, 0, -1035.218, -147.9758, 694.9168, 2.160594, 7200, 5, 1), +(@CGUID+60, 45922, 657, 3, 1, 0, -1134.513, 5.665045, 704.7355, 3.65594, 7200, 5, 1), +(@CGUID+61, 45922, 657, 3, 1, 0, -1129.21, 3.206383, 704.7364, 3.600507, 7200, 5, 1), +(@CGUID+62, 45922, 657, 3, 1, 0, -1123.238, -2.846611, 704.7382, 0.5232236, 7200, 5, 1), +(@CGUID+63, 45922, 657, 3, 1, 0, -1125.692, 1.504206, 704.7371, 0.5248207, 7200, 5, 1), +(@CGUID+64, 45922, 657, 3, 1, 0, -1195.59, 19.184, 714.4073, 6.230825, 7200, 5, 1), +(@CGUID+65, 45922, 657, 3, 1, 0, -1167.51, 80.5122, 713.8813, 5.532694, 7200, 5, 1), +-- Young Storm Dragon +(@CGUID+66, 45919, 657, 3, 1, 0, -989.747, -119.878, 695.0003, 5.462881, 7200, 0, 0), +(@CGUID+67, 45919, 657, 3, 1, 0, -1134.43, 27.9358, 704.8183, 5.462881, 7200, 0, 0), +-- Howling Gale +(@CGUID+68, 45572, 657, 3, 1, 0, -1052.99, -56.23958, 700.5693, 0, 7200, 0, 0), +(@CGUID+69, 45572, 657, 3, 1, 0, -1073.375, -35.96354, 700.5583, 0, 7200, 0, 0), +-- Air Current +(@CGUID+70, 47305, 657, 3, 1, 0, -1192.89, 119.983, 740.0833, 1.117011, 7200, 0, 0), +(@CGUID+71, 47305, 657, 3, 1, 0, -1159.61, 40.6719, 740.0833, 5.916666, 7200, 0, 0), +(@CGUID+72, 47305, 657, 3, 1, 0, -1271.69, 87.2951, 740.0833, 2.75762, 7200, 0, 0), +(@CGUID+73, 47305, 657, 3, 1, 0, -1239.14, 8.40625, 740.0833, 4.310963, 7200, 0, 0), +-- Altairus +(@CGUID+74, 43873, 657, 3, 1, 0, -1192.2, 54.16493, 734.2574, 5.899213, 7200, 0, 0), +-- Servant of Asaad +(@CGUID+84, 45926, 657, 3, 1, 0, -1106.401, 485.3993, 644.9298, 2.6529, 7200, 0, 0), +(@CGUID+85, 45926, 657, 3, 1, 0, -854.8455, 503.7344, 700.1058, 2.321288, 7200, 0, 0), +(@CGUID+86, 45926, 657, 3, 1, 0, -835.7986, 473.7205, 700.0827, 2.303835, 7200, 0, 0), +-- Executor of the Caliph +(@CGUID+87, 45928, 657, 3, 1, 0, -1122.646, 476.8399, 644.8428, 4.32006, 7200, 0, 0), +(@CGUID+88, 45928, 657, 3, 1, 0, -1000.596, 483.256, 700.0039, 0.8164106, 7200, 0, 0), +(@CGUID+89, 45928, 657, 3, 1, 0, -984.3547, 500.5497, 699.9448, 0.8168104, 7200, 0, 0), +(@CGUID+90, 45928, 657, 3, 1, 0, -857.3542, 495.3455, 700.0806, 2.286381, 7200, 0, 0), +(@CGUID+91, 45928, 657, 3, 1, 0, -847.1198, 504.7379, 700.0857, 2.268928, 7200, 0, 0), +(@CGUID+92, 45928, 657, 3, 1, 0, -824.0278, 472.4254, 700.106, 2.338741, 7200, 0, 0), +-- Temple Adept +(@CGUID+93, 45935, 657, 3, 1, 0, -1111.547, 479.0851, 644.9398, 2.670354, 7200, 0, 0), +(@CGUID+94, 45935, 657, 3, 1, 0, -845.6059, 512.1962, 700.0641, 2.286381, 7200, 0, 0), +(@CGUID+95, 45935, 657, 3, 1, 0, -995.2896, 510.8176, 699.9313, 0.8168046, 7200, 0, 0), +(@CGUID+96, 45935, 657, 3, 1, 0, -973.4213, 490.2802, 699.9539, 0.8167999, 7200, 0, 0), +(@CGUID+97, 45935, 657, 3, 1, 0, -865.4219, 494.9219, 700.0602, 2.268928, 7200, 0, 0), +(@CGUID+98, 45935, 657, 3, 1, 0, -822.25, 496.0504, 700.0477, 2.373648, 7200, 0, 0), +(@CGUID+99, 45935, 657, 3, 1, 0, -825.2014, 484.0781, 700.0819, 2.373648, 7200, 0, 0), +-- Minister of Air +(@CGUID+100, 45930, 657, 3, 1, 0, -846.8299, 470.3351, 700.0483, 2.303835, 7200, 0, 0), +(@CGUID+101, 45930, 657, 3, 1, 0, -1112.144, 470.8629, 644.9246, 2.6529, 7200, 0, 0), +(@CGUID+102, 45930, 657, 3, 1, 0, -973.1523, 512.4789, 699.9983, 3.95841, 7200, 0, 0), +-- Skyfall Star +(@CGUID+103, 45932, 657, 3, 1, 0, -924.444, 565.505, 716.6143, 0, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+104, 45932, 657, 3, 1, 0, -919.589, 557.378, 716.6143, 0, 7200, 0, 0), +(@CGUID+105, 45932, 657, 3, 1, 0, -922.568, 572.76, 716.6143, 0, 7200, 0, 0), +(@CGUID+106, 45932, 657, 3, 1, 0, -917.411, 562.898, 716.6143, 0, 7200, 0, 0), +(@CGUID+107, 45932, 657, 3, 1, 0, -910.854, 565.316, 716.6143, 0, 7200, 0, 0), +(@CGUID+108, 45932, 657, 3, 1, 0, -918.365, 575.523, 716.6143, 0, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+109, 45932, 657, 3, 1, 0, -911.5, 559.076, 716.6143, 0, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+110, 45932, 657, 3, 1, 0, -911.905, 572.38, 716.6143, 0, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+111, 45932, 657, 3, 1, 0, -697.596, 500.194, 648.0363, 2.897247, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+112, 45932, 657, 3, 1, 0, -699.214, 507.453, 648.0363, 2.897247, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+113, 45932, 657, 3, 1, 0, -698.644, 503.625, 648.0363, 2.897247, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+114, 45932, 657, 3, 1, 0, -693.46, 498.672, 648.0363, 2.897247, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+115, 45932, 657, 3, 1, 0, -692.582, 509.233, 648.0363, 2.897247, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+116, 45932, 657, 3, 1, 0, -696.323, 507.385, 648.0363, 2.897247, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+117, 45932, 657, 3, 1, 0, -690.71, 505.573, 648.0363, 2.897247, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +(@CGUID+118, 45932, 657, 3, 1, 0, -690.545, 500.667, 648.0363, 2.897247, 7200, 0, 0), -- 45932 (Area: 0) (Auras: 87845 - 87845) (possible waypoints or random movement) +-- Skyfall +(@CGUID+119, 45981, 657, 3, 1, 0, -917.865, 567.325, 717.1413, 3.909538, 7200, 0, 0), -- 45981 (Area: 0) (Auras: 85719 - 85719) +(@CGUID+120, 45981, 657, 3, 1, 0, -695.193, 503.347, 648.4973, 3.106686, 7200, 0, 0), -- 45981 (Area: 0) (Auras: 85719 - 85719) +-- Asaad +(@CGUID+121, 43875, 657, 3, 1, 0, -622.729, 503.509, 646.7143, 3.141593, 7200, 0, 0); + +SET @OGUID := 224757; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+2; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +-- entrance portal visual +(@OGUID+0, 207372, 657, 3, 1, 0, -325.592, 27.35414, 628.5861, 3.926996, 0, 0, 0.9238795, -0.3826835, 7200, 255, 1), +(@OGUID+1, 207373, 657, 3, 1, 0, -325.592, 27.35414, 628.5861, 3.926996, 0, 0, 0.9238795, -0.3826835, 7200, 255, 1), +-- Magical Brazier +(@OGUID+2, 207408, 657, 3, 1, 0, -533.6979, -142.658, 623.1421, 3.141593, 0, 0, 0, 1, 7200, 255, 1); + +-- The Vortex Pinnacle Movement +-- Pathing for Entry: 45915 'TDB FORMAT' +SET @NPC := 368199; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-461.4295,`position_y`=-108.6605,`position_z`=639.0703 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,-461.4295,-108.6605,639.0703,0,0,0,0,100,0), +(@PATH,2,-468.6795,-116.1605,639.0703,0,0,0,0,100,0), +(@PATH,3,-471.4298,-118.5493,639.0703,0,0,0,0,100,0), +(@PATH,4,-476.4298,-123.5493,639.0703,0,0,0,0,100,0), +(@PATH,5,-476.5,-123.6245,639.0703,0,0,0,0,100,0), +(@PATH,6,-471.0612,-118.5038,639.0703,0,0,0,0,100,0), +(@PATH,7,-468.8112,-116.0038,639.0703,0,0,0,0,100,0), +(@PATH,8,-461.5612,-108.7538,639.0703,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=368199; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(368199, 368199, 0, 0, 2, 0, 0), +(368199, 368198, 3, 0, 2, 0, 0); + +-- Pathing for Entry: 45922 'TDB FORMAT' +SET @NPC := 368235; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1020.567,`position_y`=-163.0906,`position_z`=691.8421 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,-1020.567,-163.0906,691.8421,0,0,0,0,100,0), +(@PATH,2,-1020.397,-163.2647,691.7646,0,0,0,0,100,0), +(@PATH,3,-1023.195,-160.4057,693.0373,0,0,0,0,100,0), +(@PATH,4,-1023.882,-159.7041,693.3497,0,0,0,0,100,0), +(@PATH,5,-1024.543,-158.779,693.8544,0,0,0,0,100,0), +(@PATH,6,-1027.976,-155.5214,694.9077,0,0,0,0,100,0), +(@PATH,7,-1027.938,-155.2948,695.0358,0,0,0,0,100,0), +(@PATH,8,-1032.238,-151.1678,694.9168,0,0,0,0,100,0), +(@PATH,9,-1034.379,-148.9811,694.9168,0,0,0,0,100,0), +(@PATH,10,-1035.429,-148.2066,694.9168,0,0,0,0,100,0), +(@PATH,11,-1036.682,-145.4446,694.9168,0,0,0,0,100,0), +(@PATH,12,-1036.826,-144.741,695.1667,0,0,0,0,100,0), +(@PATH,13,-1039.191,-139.9155,694.9167,0,0,0,0,100,0), +(@PATH,14,-1039.588,-138.5355,695.1667,0,0,0,0,100,0), +(@PATH,15,-1041.693,-134.4045,694.9168,0,0,0,0,100,0), +(@PATH,16,-1042.497,-133.1839,694.9168,0,0,0,0,100,0), +(@PATH,17,-1042.855,-130.1601,694.9168,0,0,0,0,100,0), +(@PATH,18,-1043.213,-127.1363,694.9168,0,0,0,0,100,0), +(@PATH,19,-1043.569,-124.1275,694.9168,0,0,0,0,100,0), +(@PATH,20,-1043.925,-121.1137,694.9168,0,0,0,0,100,0), +(@PATH,21,-1044.037,-118.412,695.1668,0,0,0,0,100,0), +(@PATH,22,-1044.605,-115.3696,694.9168,0,0,0,0,100,0), +(@PATH,23,-1044.605,-115.3696,694.9168,0,0,0,0,100,0), +(@PATH,24,-1044.332,-118.172,695.1668,0,0,0,0,100,0), +(@PATH,25,-1043.882,-121.4811,694.9168,0,0,0,0,100,0), +(@PATH,26,-1043.526,-124.4873,694.9168,0,0,0,0,100,0), +(@PATH,27,-1043.167,-127.5256,694.9168,0,0,0,0,100,0), +(@PATH,28,-1042.812,-130.5243,694.9168,0,0,0,0,100,0), +(@PATH,29,-1042.79,-131.9866,694.9168,0,0,0,0,100,0), +(@PATH,30,-1041.54,-134.7402,694.9168,0,0,0,0,100,0), +(@PATH,31,-1040.286,-137.5029,694.9168,0,0,0,0,100,0), +(@PATH,32,-1039.877,-138.3825,695.1667,0,0,0,0,100,0), +(@PATH,33,-1037.779,-143.0287,694.9167,0,0,0,0,100,0), +(@PATH,34,-1036.869,-144.6801,695.1667,0,0,0,0,100,0), +(@PATH,35,-1036.136,-147.1862,694.9168,0,0,0,0,100,0), +(@PATH,36,-1033.922,-149.447,694.9168,0,0,0,0,100,0), +(@PATH,37,-1031.724,-151.6929,694.9168,0,0,0,0,100,0), +(@PATH,38,-1029.526,-153.9389,694.9168,0,0,0,0,100,0), +(@PATH,39,-1028.084,-155.1418,695.0518,0,0,0,0,100,0), +(@PATH,40,-1025.216,-158.3411,693.938,0,0,0,0,100,0), +(@PATH,41,-1024.537,-158.7843,693.8418,0,0,0,0,100,0), +(@PATH,42,-1020.936,-162.7132,692.0101,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=368235; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(368235, 368235, 0, 0, 2, 0, 0), +(368235, 368234, 4, 90, 2, 0, 0); + + +-- Pathing for Entry: 45922 'TDB FORMAT' +SET @NPC := 368232; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-954.8532,`position_y`=-71.26212,`position_z`=694.9168 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,-954.8532,-71.26212,694.9168,0,0,0,0,100,0), +(@PATH,2,-957.1711,-69.29456,694.9168,0,0,0,0,100,0), +(@PATH,3,-961.0368,-67.11697,694.9168,0,0,0,0,100,0), +(@PATH,4,-961.2958,-66.89389,695.1668,0,0,0,0,100,0), +(@PATH,5,-964.6377,-65.5666,695.1668,0,0,0,0,100,0), +(@PATH,6,-969.3343,-63.47558,694.9168,0,0,0,0,100,0), +(@PATH,7,-972.1071,-62.2587,694.9168,0,0,0,0,100,0), +(@PATH,8,-974.8754,-61.04382,694.9168,0,0,0,0,100,0), +(@PATH,9,-978.6987,-60.16025,694.9168,0,0,0,0,100,0), +(@PATH,10,-981.7899,-59.74974,694.9168,0,0,0,0,100,0), +(@PATH,11,-984.8863,-59.33855,694.9168,0,0,0,0,100,0), +(@PATH,12,-987.9955,-58.92566,694.9168,0,0,0,0,100,0), +(@PATH,13,-991.079,-58.51617,694.9168,0,0,0,0,100,0), +(@PATH,14,-994.0758,-58.11821,694.9168,0,0,0,0,100,0), +(@PATH,15,-994.0758,-58.11821,694.9168,0,0,0,0,100,0), +(@PATH,16,-989.9869,-58.66121,694.9168,0,0,0,0,100,0), +(@PATH,17,-987.9772,-58.9281,694.9168,0,0,0,0,100,0), +(@PATH,18,-984.9415,-59.33123,694.9168,0,0,0,0,100,0), +(@PATH,19,-981.933,-59.73074,694.9168,0,0,0,0,100,0), +(@PATH,20,-978.9543,-60.1263,694.9168,0,0,0,0,100,0), +(@PATH,21,-974.6758,-61.13142,694.9168,0,0,0,0,100,0), +(@PATH,22,-971.892,-62.3531,694.9168,0,0,0,0,100,0), +(@PATH,23,-969.1174,-63.57076,694.9168,0,0,0,0,100,0), +(@PATH,24,-966.3402,-64.78954,694.9168,0,0,0,0,100,0), +(@PATH,25,-964.4506,-65.43292,695.1668,0,0,0,0,100,0), +(@PATH,26,-961.1824,-66.6456,695.1668,0,0,0,0,100,0), +(@PATH,27,-956.9669,-69.46789,694.9168,0,0,0,0,100,0), +(@PATH,28,-954.6504,-71.43433,694.9168,0,0,0,0,100,0), +(@PATH,29,-952.3281,-73.40562,694.9168,0,0,0,0,100,0), +(@PATH,30,-950.0269,-75.35908,694.9168,0,0,0,0,100,0), +(@PATH,31,-948.8146,-76.21729,694.9896,0,0,0,0,100,0), +(@PATH,32,-945.5163,-79.18809,693.8428,0,0,0,0,100,0), +(@PATH,33,-944.9313,-79.68468,693.6548,0,0,0,0,100,0), +(@PATH,34,-947.9789,-77.09758,694.6339,0,0,0,0,100,0), +(@PATH,35,-948.7214,-76.46726,694.8724,0,0,0,0,100,0), +(@PATH,36,-948.7795,-76.0313,695.0355,0,0,0,0,100,0), +(@PATH,37,-953.3309,-72.55439,694.9168,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=368232; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(368232, 368232, 0, 0, 2, 0, 0), +(368232, 368233, 4, 270, 2, 0, 0); + +-- Pathing for Entry: 45922 'TDB FORMAT' +SET @NPC := 368237; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1141.952,`position_y`=0.1362936,`position_z`=704.9866 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,-1141.952,0.1362936,704.9866,0,0,0,0,100,0), +(@PATH,2,-1146.67,0.02607536,704.7366,0,0,0,0,100,0), +(@PATH,3,-1147.038,0.02259642,704.9866,0,0,0,0,100,0), +(@PATH,4,-1149.834,-0.003255367,704.7373,0,0,0,0,100,0), +(@PATH,5,-1147.159,0.01711412,704.9869,0,0,0,0,100,0), +(@PATH,6,-1146.924,0.02619778,704.9868,0,0,0,0,100,0), +(@PATH,7,-1142.202,0.0536294,704.9865,0,0,0,0,100,0), +(@PATH,8,-1138.62,0.1007004,704.7366,0,0,0,0,100,0), +(@PATH,9,-1135.57,0.1289759,704.7367,0,0,0,0,100,0), +(@PATH,10,-1130.542,2.166062,704.7365,0,0,0,0,100,0), +(@PATH,11,-1130.4,2.601685,704.9865,0,0,0,0,100,0), +(@PATH,12,-1126.193,4.615932,704.9863,0,0,0,0,100,0), +(@PATH,13,-1122.64,6.631642,704.7365,0,0,0,0,100,0), +(@PATH,14,-1119.99,8.129199,704.7366,0,0,0,0,100,0), +(@PATH,15,-1117.338,9.628002,704.7368,0,0,0,0,100,0), +(@PATH,16,-1114.711,11.11202,704.7369,0,0,0,0,100,0), +(@PATH,17,-1114.536,12.09257,705.0007,0,0,0,0,100,0), +(@PATH,18,-1112.286,15.34257,705.0007,0,0,0,0,100,0), +(@PATH,19,-1112.236,15.66,704.9948,0,0,0,0,100,0), +(@PATH,20,-1110.005,23.10597,704.7404,0,0,0,0,100,0), +(@PATH,21,-1109.542,26.09011,704.7285,0,0,0,0,100,0), +(@PATH,22,-1109.161,28.04013,704.9596,0,0,0,0,100,0), +(@PATH,23,-1108.683,32.67579,704.9204,0,0,0,0,100,0), +(@PATH,24,-1108.914,36.36856,704.6313,0,0,0,0,100,0), +(@PATH,25,-1109.215,39.39096,704.6422,0,0,0,0,100,0), +(@PATH,26,-1109.515,42.40091,704.653,0,0,0,0,100,0), +(@PATH,27,-1109.815,45.41621,704.6638,0,0,0,0,100,0), +(@PATH,28,-1110.438,46.32099,704.9484,0,0,0,0,100,0), +(@PATH,29,-1111.938,50.07099,704.9484,0,0,0,0,100,0), +(@PATH,30,-1112.663,50.20761,704.9731,0,0,0,0,100,0), +(@PATH,31,-1116.874,55.20683,704.7368,0,0,0,0,100,0), +(@PATH,32,-1118.976,57.39814,704.7368,0,0,0,0,100,0), +(@PATH,33,-1121.073,59.58406,704.7367,0,0,0,0,100,0), +(@PATH,34,-1121.497,60.28359,704.9868,0,0,0,0,100,0), +(@PATH,35,-1123.912,62.54309,704.737,0,0,0,0,100,0), +(@PATH,36,-1121.293,60.10541,704.9868,0,0,0,0,100,0), +(@PATH,37,-1118.949,57.37017,704.7368,0,0,0,0,100,0), +(@PATH,38,-1116.854,55.18592,704.7368,0,0,0,0,100,0), +(@PATH,39,-1114.75,52.99265,704.7368,0,0,0,0,100,0), +(@PATH,40,-1112.649,50.80296,704.7368,0,0,0,0,100,0), +(@PATH,41,-1112.108,49.99615,704.9503,0,0,0,0,100,0), +(@PATH,42,-1110.358,46.49615,704.9503,0,0,0,0,100,0), +(@PATH,43,-1110.305,45.75431,704.9316,0,0,0,0,100,0), +(@PATH,44,-1109.188,39.33895,704.6419,0,0,0,0,100,0), +(@PATH,45,-1108.878,36.32722,704.631,0,0,0,0,100,0), +(@PATH,46,-1108.566,32.9744,704.8962,0,0,0,0,100,0), +(@PATH,47,-1109.087,29.02698,704.6871,0,0,0,0,100,0), +(@PATH,48,-1109.272,28.10846,704.9492,0,0,0,0,100,0), +(@PATH,49,-1110.016,23.03103,704.7407,0,0,0,0,100,0), +(@PATH,50,-1110.479,20.04577,704.7527,0,0,0,0,100,0), +(@PATH,51,-1110.942,17.05803,704.7646,0,0,0,0,100,0), +(@PATH,52,-1112.207,15.40365,704.9985,0,0,0,0,100,0), +(@PATH,53,-1114.207,11.90365,704.9985,0,0,0,0,100,0), +(@PATH,54,-1115.119,11.92619,704.9988,0,0,0,0,100,0), +(@PATH,55,-1119.924,8.166574,704.7366,0,0,0,0,100,0), +(@PATH,56,-1122.573,6.669635,704.7365,0,0,0,0,100,0), +(@PATH,57,-1125.228,5.168983,704.7363,0,0,0,0,100,0), +(@PATH,58,-1126.054,4.707599,704.9864,0,0,0,0,100,0), +(@PATH,59,-1130.37,2.263834,704.7365,0,0,0,0,100,0), +(@PATH,60,-1135.498,0.1296411,704.7367,0,0,0,0,100,0), +(@PATH,61,-1138.536,0.1014838,704.7366,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=368237; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(368237, 368237, 0, 0, 2, 0, 0), +(368237, 368236, 4, 270, 2, 0, 0); + +-- Pathing for Entry: 45922 'TDB FORMAT' +SET @NPC := 368238; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1148.17,`position_y`=5.06337,`position_z`=704.9856 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,-1148.17,5.06337,704.9856,0,0,0,0,100,0), +(@PATH,2,-1142.42,5.06337,704.9856,0,0,0,0,100,0), +(@PATH,3,-1135.203,5.313489,704.9858,0,0,0,0,100,0), +(@PATH,4,-1133.703,6.313489,704.9858,0,0,0,0,100,0), +(@PATH,5,-1128.453,9.313489,704.9858,0,0,0,0,100,0), +(@PATH,6,-1120.703,13.56349,704.9858,0,0,0,0,100,0), +(@PATH,7,-1115.835,16.32874,704.9491,0,0,0,0,100,0), +(@PATH,8,-1115.835,17.82874,704.9491,0,0,0,0,100,0), +(@PATH,9,-1114.585,26.57874,704.9491,0,0,0,0,100,0), +(@PATH,10,-1113.537,32.85158,704.7101,0,0,0,0,100,0), +(@PATH,11,-1114.537,42.10158,704.9601,0,0,0,0,100,0), +(@PATH,12,-1114.851,46.20461,704.9625,0,0,0,0,100,0), +(@PATH,13,-1116.601,47.95461,704.9625,0,0,0,0,100,0), +(@PATH,14,-1122.851,54.45461,704.9625,0,0,0,0,100,0), +(@PATH,15,-1122.705,54.24915,704.9748,0,0,0,0,100,0), +(@PATH,16,-1116.455,47.74915,704.9748,0,0,0,0,100,0), +(@PATH,17,-1116.281,47.50231,704.9354,0,0,0,0,100,0), +(@PATH,18,-1114.781,46.00231,704.9354,0,0,0,0,100,0), +(@PATH,19,-1114.531,42.00231,704.9354,0,0,0,0,100,0), +(@PATH,20,-1113.561,32.96235,704.6952,0,0,0,0,100,0), +(@PATH,21,-1114.561,26.71235,704.9452,0,0,0,0,100,0), +(@PATH,22,-1115.561,17.71235,704.9452,0,0,0,0,100,0), +(@PATH,23,-1115.837,17.5244,704.9978,0,0,0,0,100,0), +(@PATH,24,-1116.087,16.0244,704.9978,0,0,0,0,100,0), +(@PATH,25,-1120.837,13.5244,704.9978,0,0,0,0,100,0), +(@PATH,26,-1128.337,9.274401,704.9978,0,0,0,0,100,0), +(@PATH,27,-1133.587,6.274401,704.9978,0,0,0,0,100,0), +(@PATH,28,-1133.94,6.040699,704.9855,0,0,0,0,100,0), +(@PATH,29,-1135.44,5.290699,704.9855,0,0,0,0,100,0), +(@PATH,30,-1141.94,5.290699,704.9855,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=368238; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(368238, 368238, 0, 0, 2, 0, 0), +(368238, 368239, 4, 270, 2, 0, 0); + +-- Pathing for Entry: 45928 'TDB FORMAT' +SET @NPC := 368263; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1123.944,`position_y`=473.7014,`position_z`=644.8436 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,-1123.944,473.7014,644.8436,0,0,0,0,100,0), +(@PATH,2,-1117.012,490.4549,644.8395,0,0,0,0,100,0); + +-- Pathing for Entry: 45928 'TDB FORMAT' +SET @NPC := 368265; +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1013.499,`position_y`=469.9056,`position_z`=700.2697 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,-1013.499,469.9056,700.2697,0,0,0,0,100,0), +(@PATH,2,-1013.463,470.0063,700.2694,0,0,0,0,100,0), +(@PATH,3,-1013.207,470.0758,700.2692,0,0,0,0,100,0), +(@PATH,4,-1008.742,474.9245,700.0145,0,0,0,0,100,0), +(@PATH,5,-1007.346,476.3719,700.0128,0,0,0,0,100,0), +(@PATH,6,-1007.007,476.4276,700.0117,0,0,0,0,100,0), +(@PATH,7,-1005.51,478.0214,700.0099,0,0,0,0,100,0), +(@PATH,8,-1004.006,479.6232,700.0081,0,0,0,0,100,0), +(@PATH,9,-1002.512,481.2144,700.0062,0,0,0,0,100,0), +(@PATH,10,-1001.002,482.8228,700.0044,0,0,0,0,100,0), +(@PATH,11,-999.4986,484.4232,700.0026,0,0,0,0,100,0), +(@PATH,12,-998.0031,486.0157,700.0007,0,0,0,0,100,0), +(@PATH,13,-996.7684,487.2819,700.2106,0,0,0,0,100,0), +(@PATH,14,-994.9923,489.2219,699.9229,0,0,0,0,100,0), +(@PATH,15,-993.4943,490.8171,699.926,0,0,0,0,100,0), +(@PATH,16,-991.9926,492.4162,699.9291,0,0,0,0,100,0), +(@PATH,17,-991.8552,492.5625,699.9294,0,0,0,0,100,0), +(@PATH,18,-993.7377,490.5579,699.9255,0,0,0,0,100,0), +(@PATH,19,-994.2009,490.0647,699.9246,0,0,0,0,100,0), +(@PATH,20,-995.5779,488.5983,699.9217,0,0,0,0,100,0), +(@PATH,21,-996.8477,487.2461,699.9191,0,0,0,0,100,0), +(@PATH,22,-998.3343,485.6631,700.0012,0,0,0,0,100,0), +(@PATH,23,-999.7216,484.1857,700.0028,0,0,0,0,100,0), +(@PATH,24,-1001.102,482.7157,700.0045,0,0,0,0,100,0), +(@PATH,25,-1002.486,481.242,700.0062,0,0,0,0,100,0), +(@PATH,26,-1003.866,479.772,700.0079,0,0,0,0,100,0), +(@PATH,27,-1005.256,478.2922,700.0096,0,0,0,0,100,0), +(@PATH,28,-1006.647,476.8112,700.0113,0,0,0,0,100,0), +(@PATH,29,-1007.382,476.334,700.0128,0,0,0,0,100,0), +(@PATH,30,-1008.871,474.7909,700.0147,0,0,0,0,100,0), +(@PATH,31,-1010.363,473.2453,700.0166,0,0,0,0,100,0), +(@PATH,32,-1011.857,471.6971,700.0185,0,0,0,0,100,0), +(@PATH,33,-1013.354,470.1463,700.0204,0,0,0,0,100,0), +(@PATH,34,-1013.587,469.8955,700.2709,0,0,0,0,100,0), +(@PATH,35,-1016.34,467.0525,700.0211,0,0,0,0,100,0), +(@PATH,36,-1017.834,465.5042,700.0201,0,0,0,0,100,0), +(@PATH,37,-1019.325,463.9599,700.0192,0,0,0,0,100,0), +(@PATH,38,-1020.811,462.4193,700.0182,0,0,0,0,100,0), +(@PATH,39,-1020.944,462.2815,700.0181,0,0,0,0,100,0), +(@PATH,40,-1019.035,464.2601,700.0193,0,0,0,0,100,0), +(@PATH,41,-1018.572,464.7398,700.0197,0,0,0,0,100,0), +(@PATH,42,-1017.161,466.2016,700.0205,0,0,0,0,100,0), +(@PATH,43,-1015.762,467.6514,700.0214,0,0,0,0,100,0), +(@PATH,44,-1014.359,469.1049,700.0223,0,0,0,0,100,0); + +DELETE FROM `creature_formations` WHERE `leaderGUID`=368265; +INSERT INTO `creature_formations` (`leaderGUID`, `memberGUID`, `dist`, `angle`, `groupAI`, `point_1`, `point_2`) VALUES +(368265, 368265, 0, 0, 2, 0, 0), +(368265, 368272, 16, 90, 2, 0, 0), +(368265, 368278, 16, 180, 2, 0, 0), +(368265, 368271, 16, 270, 2, 0, 0), +(368265, 368264, 16, 0, 2, 0, 0); + +-- randommovement +UPDATE `creature` SET `spawndist`=5, `MovementType`=1 WHERE `guid` IN (368192); + +-- addons +DELETE FROM `creature_addon` WHERE `guid` IN (368270, 368267, 368261, 368266, 368273); +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(368270,0,0,0,1,27, ''), +(368267,0,0,0,1,27, ''), +(368261,0,0,0,1,27, ''), +(368266,0,0,0,1,27, ''), +(368273,0,0,0,1,27, ''); |