diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_01_31_world_2020_04_19_04_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_31_world_2020_04_19_04_world.sql b/sql/updates/world/master/2022_01_01_31_world_2020_04_19_04_world.sql new file mode 100644 index 00000000000..1b880b1c7f1 --- /dev/null +++ b/sql/updates/world/master/2022_01_01_31_world_2020_04_19_04_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (130746, 130748, 130750, 130751); +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 +(130746, 30881, 571, 67, 4446, '0', 0, 0, 0, 7506.01, -1923.566, 1473.698, 1.256637, 120, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 30881 (Area: 4446 - Difficulty: 0) (Auras: 29266 - 29266) +(130748, 30881, 571, 67, 4446, '0', 0, 0, 0, 7458.983, -1928.875, 1474.344, 4.468043, 120, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 30881 (Area: 4446 - Difficulty: 0) (Auras: 29266 - 29266) +(130750, 30881, 571, 67, 4446, '0', 0, 0, 0, 7483.364, -1855.742, 1474.344, 4.363323, 120, 0, 0, 0, 0, 0, 0, 0, 0, 15595), -- 30881 (Area: 4446 - Difficulty: 0) (Auras: 29266 - 29266) +(130751, 30881, 571, 67, 4446, '0', 0, 0, 0, 7501.811, -1849.362, 1474.344, 4.834562, 120, 0, 0, 0, 0, 0, 0, 0, 0, 15595); -- 30881 (Area: 4446 - Difficulty: 0) (Auras: 29266 - 29266) + +UPDATE `creature_template` SET `unit_flags`=768 WHERE `entry`=30881; +UPDATE `creature_template_addon` SET `bytes2`=1, `auras`='29266' WHERE `entry`=30881; |