diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_30_09_world_2019_04_15_03_world.sql | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_30_09_world_2019_04_15_03_world.sql b/sql/updates/world/master/2021_11_30_09_world_2019_04_15_03_world.sql new file mode 100644 index 00000000000..3fc27e48cfa --- /dev/null +++ b/sql/updates/world/master/2021_11_30_09_world_2019_04_15_03_world.sql @@ -0,0 +1,49 @@ +-- +DELETE FROM `creature` WHERE `id`=17398; +DELETE FROM `creature` WHERE `guid` IN (99293, 99294, 99295, 99296, 99297, 99298, 99299, 99300, 99301, 99302, 99303, 99304, 99305, 99347, 99358, 99359, 99424, 99425, 99858, 99859, 99870, 99907, 99908, 100045, 100046, 100050, 100051, 100052, 100053, 100054, 100055, 100063, 100064, 100182, 100202, 100203, 100205, 100212, 100214, 100217, 100218, 100219, 100236, 100237, 100238); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(99293, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 408.8279, 82.40977, 9.743911, 2.635447, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(99294, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 416.6887, 90.8326, 24.68206, 0.05235988, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99295, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 414.6635, 93.36589, 24.48129, 0.01745329, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99296, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 415.1017, 88.18084, 24.47684, 0.1919862, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99297, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 418.2868, 80.22531, 38.57053, 0.296706, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99298, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 419.18, 83.99825, 38.35954, 0.08726646, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99299, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 410.9965, 117.6822, 9.738612, 5.759586, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(99300, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 410.5305, 112.8644, 9.74094, 0.1745329, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(99301, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 417.8123, 88.39768, 38.65628, 5.899213, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99302, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 416.1206, 125.9563, 24.49858, 0.122173, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99303, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 417.9648, 111.2201, 38.60171, 6.161012, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99304, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 419.8577, 114.8938, 38.26726, 6.248279, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99305, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 414.4871, 118.431, 24.60133, 0.2268928, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99347, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 415.4518, 117.5418, 9.729463, 0.122173, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(99358, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 416.4451, 122.0881, 24.68787, 0.03490658, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99359, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 418.5461, 118.5414, 38.51191, 0.1396263, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99424, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 494.5922, 111.4782, 38.67696, 3.071779, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99425, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 496.8652, 118.1183, 24.54488, 3.071779, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99858, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 497.2573, 126.5592, 24.48961, 3.647738, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99859, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 499.6101, 118.6188, 9.735491, 3.700098, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(99870, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 494.196, 118.8684, 38.62325, 3.193953, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99907, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 496.1068, 122.2104, 24.69561, 3.124139, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(99908, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 496.5197, 115.7731, 9.72958, 3.071779, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100045, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 492.4372, 115.3691, 38.29572, 3.211406, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(100046, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 496.0534, 87.96793, 24.31657, 3.333579, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(100050, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 493.0421, 84.16926, 38.36001, 3.246312, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(100051, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 495.5341, 90.99683, 24.68567, 3.176499, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(100052, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 495.096, 88.57997, 38.7952, 3.176499, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(100053, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 496.1001, 94.33677, 24.27757, 3.351032, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(100054, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 493.6279, 80.07557, 38.53217, 2.583087, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(100055, 17429, 542, 3713, 0, '1,2', 0, 0, 0, 442.1639, 55.2048, 9.697337, 1.396263, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17429 (Area: 0 - Difficulty: 0) +(100063, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 410.7916, 87.08148, 9.74017, 4.520403, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100064, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 416.1684, 84.39043, 9.728836, 3.385939, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100182, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 414.598, 112.5374, 9.733525, 0.1396263, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100202, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 314.5811, 195.7484, 11.47551, 5.061455, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) +(100203, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 345.0638, 202.2608, 11.45121, 4.869469, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100205, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 376.4196, 193.6003, 9.676909, 3.961897, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) +(100212, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 405.4595, 190.8113, 9.677215, 5.707227, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100214, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 437.2345, 201.5878, 11.46511, 4.607669, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) +(100217, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 500.6194, 112.281, 9.739496, 2.059489, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100218, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 503.4373, 115.8274, 9.743029, 3.735005, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100219, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 498.672, 87.25279, 9.735205, 3.508112, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100236, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 502.3434, 84.35998, 9.741987, 3.089233, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100237, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 496.5116, 82.27544, 9.730057, 3.054326, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159), -- 17398 (Area: 0 - Difficulty: 0) (possible waypoints or random movement) +(100238, 17398, 542, 3713, 0, '1,2', 0, 0, 0, 470.2018, 58.01126, 9.696453, 1.745329, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 11159); -- 17398 (Area: 0 - Difficulty: 0) |