aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2016-08-21 16:35:14 +0200
committerKillyana <morphone1@gmail.com>2016-08-21 16:35:14 +0200
commit755add6fd202a50e43074c98315f74eaee1fa662 (patch)
tree8ec6b2f3cdb190f8224c832f468cfb5d49271f90
parent0a53d0b1fadb0861e57ef6332d1afeb75babf836 (diff)
DB: Fix more DB errors
-rw-r--r--sql/updates/world/3.3.5/2016_08_21_03_world.sql6
1 files changed, 6 insertions, 0 deletions
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);