diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-09 04:19:29 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-02-28 23:51:27 +0100 |
| commit | fb2181715906604a6bb46a23d99e12682347da38 (patch) | |
| tree | 745cf48e3c85554c0a28f72e458c76e777faca96 | |
| parent | c267c015ed43c007e28518f77f63ad4f94bdc3db (diff) | |
DB/Creature: Correctly handle Sapphiron's Wing Buffet
Add CREATURE_FLAG_EXTRA_NO_COMBAT & periodic aura
(cherry picked from commit d798430d3fd747bdf3b9efc58de255ec022bf4b7)
| -rw-r--r-- | sql/updates/world/master/2022_02_28_64_world_2020_11_09_01_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_28_64_world_2020_11_09_01_world.sql b/sql/updates/world/master/2022_02_28_64_world_2020_11_09_01_world.sql new file mode 100644 index 00000000000..d790674a6fe --- /dev/null +++ b/sql/updates/world/master/2022_02_28_64_world_2020_11_09_01_world.sql @@ -0,0 +1,6 @@ +-- +UPDATE `creature_template` SET `flags_extra` = `flags_extra` | 0x00002000, `ScriptName` = "" WHERE `entry` = 17025; +DELETE FROM `creature_template_addon` WHERE `entry` = 17025; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(17025,0,0,0,1,0,0,"29327"); +DELETE FROM `creature_template_spell` WHERE `CreatureID` = 17025; |