From bf81c39bbd9e54ff397da9cdce15da92e69037ae Mon Sep 17 00:00:00 2001 From: Rushor Date: Sun, 15 Mar 2020 14:24:35 +0100 Subject: DB/Creature: Decaying Colossus Closes #24303 (cherry picked from commit 8102fae3d5970072398a1e72d44ab14f9aaab7d3) --- .../world/master/2021_12_23_05_world_2020_03_15_01_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/master/2021_12_23_05_world_2020_03_15_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_12_23_05_world_2020_03_15_01_world.sql b/sql/updates/world/master/2021_12_23_05_world_2020_03_15_01_world.sql new file mode 100644 index 00000000000..5efe02c8208 --- /dev/null +++ b/sql/updates/world/master/2021_12_23_05_world_2020_03_15_01_world.sql @@ -0,0 +1,10 @@ +-- +UPDATE `creature` SET `MovementType`=2 WHERE `guid`=201253; +DELETE FROM `creature_addon` WHERE `guid` IN (201253); +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES +(201253, 2012530, 0, 0, 0, 0, ''); +DELETE FROM `waypoint_data` WHERE `id`=2012530; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(2012530, 1, 4356.641, 3033.731, 360.52, 0, 0, 0, 0, 100, 0), +(2012530, 2, 4356.061, 2986.438, 360.51, 4.75, 7000, 0, 0, 100, 0), +(2012530, 3, 4357.132, 3055.515, 360.52, 4.75, 7000, 0, 0, 100, 0); -- cgit v1.2.3