diff options
| -rw-r--r-- | sql/updates/world/master/2021_12_21_23_world_2020_02_17_00_world.sql | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_21_23_world_2020_02_17_00_world.sql b/sql/updates/world/master/2021_12_21_23_world_2020_02_17_00_world.sql new file mode 100644 index 00000000000..5cc07c3a9e7 --- /dev/null +++ b/sql/updates/world/master/2021_12_21_23_world_2020_02_17_00_world.sql @@ -0,0 +1,33 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (127351, 127352, 127353, 127354, 127355, 127356, 127358, 127359, 127360, 127361, 127362, 127363, 127364, 127365, 127366, 127367, 127368, 127369, 127370, 127371, 127372, 127373, 127374, 127375, 127376, 127377, 127378, 127379, 127380, 127402); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(127351, 20155, 560, 2367, 2370, '1,2', 0, 0, 0, 2102.716, 95.3138, 53.06873, 3.316126, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 20155 (Area: 2370 - Difficulty: 0) +(127352, 20156, 560, 2367, 2368, '1,2', 0, 0, 0, 2621.884, 684.1758, 55.37511, 3.752458, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 20156 (Area: 2368 - Difficulty: 0) +(127353, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 267.997, -84.13632, 3.174591, 5.864306, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127354, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 260.1482, -83.79867, 4.184245, 2.6529, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127355, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 249.6018, -69.3923, 5.022202, 1.396263, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127356, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 242.7067, -90.59, 5.023407, 5.113815, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127358, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 235.9178, -83.92481, 5.023408, 1.815142, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127359, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 243.1962, -104.702, 5.022936, 5.148721, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127360, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 249.9625, -98.26886, 5.022704, 3.612832, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127361, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 243.4501, -77.29634, 5.0234, 4.555309, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127362, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 235.6373, -99.74619, 5.023408, 5.340707, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127363, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 242.3749, -63.77849, 5.022943, 3.054326, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127364, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 251.6234, -84.12178, 5.021717, 5.253441, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127365, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 236.2814, -68.86074, 5.023407, 5.148721, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127366, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 222.929, -99.31724, 5.023414, 0.3665192, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127367, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 229.2128, -91.27964, 5.023414, 0.2443461, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127368, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 223.4857, -68.38847, 5.023414, 0.9424778, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127369, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 229.3703, -63.33781, 5.023414, 2.75762, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127370, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 229.5742, -76.44375, 5.023414, 2.146755, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127371, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 229.3575, -104.7927, 5.023414, 3.438299, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127372, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 223.1584, -83.87238, 5.023413, 6.108652, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127373, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 207.5476, -84.2186, 5.021762, 0.122173, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127374, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 209.3706, -97.99586, 5.022563, 5.253441, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127375, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 210.2564, -70.4671, 5.022758, 0.9250245, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127376, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 216.0915, -104.1881, 5.022802, 1.48353, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127377, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 216.2818, -64.6925, 5.02281, 3.752458, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127378, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 215.4207, -89.05723, 5.023415, 5.218534, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127379, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 216.0998, -78.2583, 5.023416, 5.096361, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127380, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 198.5645, -84.26196, 3.918597, 4.014257, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545), -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) +(127402, 20709, 540, 3714, 0, '1,2', 0, 0, 0, 190.9118, -84.5878, 2.684293, 5.759586, 7200, 0, 0, 0, 0, 0, 0, 0, 0, 14545); -- 20709 (Area: 0 - Difficulty: 0) (Auras: ) |