diff options
| author | offl <offl@users.noreply.github.com> | 2021-06-10 19:15:35 +0300 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-03-11 01:41:20 +0100 |
| commit | 4bdf5261e6e950aff19a543a7cc103163dd44ac5 (patch) | |
| tree | 90cb616127b474cd9742086b91b7427e4516e8a4 /sql | |
| parent | 0fc126642c90b05bb8e5326fc64c9605cfe8c728 (diff) | |
Scripts/Misc: Remove few more evil flags
Ref #25764
(cherry picked from commit 180f495c7037dc3be61a33dee5745833fd993d4c)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_03_10_34_world_2021_06_10_00_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_10_34_world_2021_06_10_00_world.sql b/sql/updates/world/master/2022_03_10_34_world_2021_06_10_00_world.sql new file mode 100644 index 00000000000..7ba4ef10b1b --- /dev/null +++ b/sql/updates/world/master/2022_03_10_34_world_2021_06_10_00_world.sql @@ -0,0 +1,11 @@ +-- Keristrasza +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ (262144|512|256) WHERE `entry` IN (26723,30540); + +-- Broggok +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ (512|256|2) WHERE `entry` IN (17380,18601); + +-- Spark of Ionar +UPDATE `creature_template` SET `unit_flags` = `unit_flags` &~ (33554432|2), `spell_school_immune_mask` = 127 WHERE `entry` IN (28926,31867); +-- DELETE FROM `spelldifficulty_dbc` WHERE `id` = 52667; +-- INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`, `spellid2`, `spellid3`) VALUES +-- (52667,52667,59833,0,0); |