From 8c6a25ee9442eac5a4d7ad5ec5de59d17bcc2626 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 19 Apr 2020 22:05:34 +0200 Subject: DB/Creature: Servant of Hodir Closes #24406 (cherry picked from commit 1b897d33c76984f3600f51eeb6650599c859e780) --- .../world/master/2022_01_01_31_world_2020_04_19_04_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/master/2022_01_01_31_world_2020_04_19_04_world.sql (limited to 'sql/updates') 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; -- cgit v1.2.3