diff options
| -rw-r--r-- | sql/updates/world/master/2021_11_15_08_world_2018_10_19_01_world_335.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_11_15_08_world_2018_10_19_01_world_335.sql b/sql/updates/world/master/2021_11_15_08_world_2018_10_19_01_world_335.sql new file mode 100644 index 00000000000..adbd65e749b --- /dev/null +++ b/sql/updates/world/master/2021_11_15_08_world_2018_10_19_01_world_335.sql @@ -0,0 +1,21 @@ +-- +DELETE FROM `creature_template_addon` WHERE `entry`=10988; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(10988, 0, 0, 0, 0, 0, "10848"); + +UPDATE `creature_template` SET `flags_extra`=1024 WHERE `entry` IN (10988); +-- DELETE FROM `creature` WHERE `guid` IN (92277,92280,92568,92826,92828,92829,92864,93587,93610,93639,93646,93652,93695); +-- INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`,`spawndist`, `MovementType`) VALUES +-- (92277, 10988, 1, 1, 1, 0, 0, -1247.3, 1825.32, 50.15, 0.189608, 600, 6, 1), +-- (92280, 10988, 1, 1, 1, 0, 0, -1364, 1830.68, 51.281, 1.427, 600, 6, 1), +-- (92568, 10988, 1, 1, 1, 0, 0, -1353, 2059.29, 50.455, 2.322, 600, 7, 1), +-- (92826, 10988, 1, 1, 1, 0, 0, -1339, 2012.71, 50.394, 1.421, 600, 7, 1), +-- (92828, 10988, 1, 1, 1, 0, 0, -1333, 1972.31, 50.144, 5.188, 600, 7, 1), +-- (92829, 10988, 1, 1, 1, 0, 0, -1307, 1813.98, 50.228, 6.213, 600, 7, 1), +-- (92864, 10988, 1, 1, 1, 0, 0, -1255.157, 1965.387, 50.144, 5.822480, 600, 7, 1), +-- (93587, 10988, 1, 1, 1, 0, 0, -1287.059, 1920.125, 50.624, 4.032559, 600, 7, 1), +-- (93610, 10988, 1, 1, 1, 0, 0, -1269.852, 1864.019, 50.298, 5.031582, 600, 7, 1), +-- (93639, 10988, 1, 1, 1, 0, 0, -1354.506, 1890.478, 50.148, 3.497707, 600, 7, 1), +-- (93646, 10988, 1, 1, 1, 0, 0, -1296.158, 1999.375, 51.106, 1.970108, 600, 7, 1), +-- (93652, 10988, 1, 1, 1, 0, 0, -1442.202, 1792.259, 50.144, 0.843056, 600, 7, 1), +-- (93695, 10988, 1, 1, 1, 0, 0, -1384.608, 1797.856, 50.337, 5.842114, 600, 7, 1); |