From 180f495c7037dc3be61a33dee5745833fd993d4c Mon Sep 17 00:00:00 2001 From: offl Date: Thu, 10 Jun 2021 19:15:35 +0300 Subject: Scripts/Misc: Remove few more evil flags Ref #25764 --- sql/updates/world/3.3.5/2021_06_10_00_world.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/3.3.5/2021_06_10_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2021_06_10_00_world.sql b/sql/updates/world/3.3.5/2021_06_10_00_world.sql new file mode 100644 index 00000000000..9cccfee7509 --- /dev/null +++ b/sql/updates/world/3.3.5/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); -- cgit v1.2.3