From c9591eb97eef136c00034dc1e5e621901a05e6a6 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 9 Apr 2025 10:22:41 +0200 Subject: DB/Creature: Add missing AnimTier Hover for Zidormi closes #30816 by CraftedRO --- sql/updates/world/3.3.5/2025_04_08_02_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/3.3.5/2025_04_08_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2025_04_08_02_world.sql b/sql/updates/world/3.3.5/2025_04_08_02_world.sql new file mode 100644 index 00000000000..8dd0a3a84be --- /dev/null +++ b/sql/updates/world/3.3.5/2025_04_08_02_world.sql @@ -0,0 +1,6 @@ +-- Add AnimTier Hover +UPDATE `creature_addon` SET `AnimTier`=2 WHERE `guid`=105234; + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=31848; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(31848, 0, 0, 1, 0, 0, 0, NULL); -- cgit v1.2.3