diff options
| author | Rushor <Rushor@users.noreply.github.com> | 2020-03-15 14:24:35 +0100 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2020-03-15 14:24:35 +0100 |
| commit | 8102fae3d5970072398a1e72d44ab14f9aaab7d3 (patch) | |
| tree | 7a8c9d3a3e8c424c147563accddad00f3e51dd68 | |
| parent | 480c16a038be83a814bce8b9336d8b471b144caf (diff) | |
DB/Creature: Decaying Colossus
Closes #24303
| -rw-r--r-- | sql/updates/world/3.3.5/2020_03_15_01_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_03_15_01_world.sql b/sql/updates/world/3.3.5/2020_03_15_01_world.sql new file mode 100644 index 00000000000..5efe02c8208 --- /dev/null +++ b/sql/updates/world/3.3.5/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); |