diff options
| author | CraftedRO <CraftedRO@users.noreply.github.com> | 2021-11-10 21:04:01 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2021-11-10 21:04:01 +0200 |
| commit | d1201b963fffe12751bc57d3d830fef119ee1b6f (patch) | |
| tree | def51422fa35cc911763944635658bef4fa569ea | |
| parent | 164a32e4848c454db45bdb954d4f7e37d191fc4a (diff) | |
DB/Creature: Updates for Winterspring dragons
Closes #27253
| -rw-r--r-- | sql/updates/world/3.3.5/2021_11_10_02_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_11_10_02_world.sql b/sql/updates/world/3.3.5/2021_11_10_02_world.sql new file mode 100644 index 00000000000..89cdfe9ff94 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_11_10_02_world.sql @@ -0,0 +1,19 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (10202,10662,10663,10664) AND `source_type` = 0 AND `id` = 0; + +-- Credit: vmangos +-- Azurous: Immune to Fear. +UPDATE `creature_template` SET `mechanic_immune_mask`=16 WHERE `entry`=10202; + +-- Spellmaw: Immune to Fear, Silence, Snare, Stun. +UPDATE `creature_template` SET `mechanic_immune_mask`=16+256+1024+2048 WHERE `entry`=10662; + +-- Manaclaw: Immune to Root, Snare, Freeze. +UPDATE `creature_template` SET `mechanic_immune_mask`=64+1024+4096 WHERE `entry`=10663; +UPDATE `creature_template_addon` SET `auras` = '17010' WHERE `entry` = 10663; + +-- Scryer +DELETE FROM `creature_template_addon` WHERE `entry` = 10664; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `bytes1`, `bytes2`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(10664, 0, 0, 0, 0, 1, 0, 0, '8279 18943'); +UPDATE `creature_addon` SET `auras` = '8279 18943' WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 10664); |