From 755add6fd202a50e43074c98315f74eaee1fa662 Mon Sep 17 00:00:00 2001 From: Killyana Date: Sun, 21 Aug 2016 16:35:14 +0200 Subject: DB: Fix more DB errors --- sql/updates/world/3.3.5/2016_08_21_03_world.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_08_21_03_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2016_08_21_03_world.sql b/sql/updates/world/3.3.5/2016_08_21_03_world.sql new file mode 100644 index 00000000000..c8b1f0f1c2e --- /dev/null +++ b/sql/updates/world/3.3.5/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