From 01069e62d53df2e5d345461941587377c9178676 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 21 Aug 2016 16:35:14 +0200 Subject: DB: Fix more DB errors (cherry picked from commit 755add6fd202a50e43074c98315f74eaee1fa662) --- .../world/master/2017_02_18_00_world_2016_08_21_03_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/master/2017_02_18_00_world_2016_08_21_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2017_02_18_00_world_2016_08_21_03_world.sql b/sql/updates/world/master/2017_02_18_00_world_2016_08_21_03_world.sql new file mode 100644 index 00000000000..37a59cff386 --- /dev/null +++ b/sql/updates/world/master/2017_02_18_00_world_2016_08_21_03_world.sql @@ -0,0 +1,6 @@ +-- +-- DELETE FROM `spell_ranks` WHERE `first_spell_id` = 34453 AND `rank` IN (1,2); +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|2 WHERE `entry` IN (32117,37440,32113,37436,32116,37439,32115,37438,32114,37437,32118,37441); +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry` IN (22582); +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|130 WHERE `entry` IN (30780,30782,30784,30786); +UPDATE `creature_template` SET `mechanic_immune_mask`=`mechanic_immune_mask`|80358666 WHERE `entry` IN (37283,37444); -- cgit v1.2.3