diff options
| author | Killyana <morphone1@gmail.com> | 2016-08-21 16:35:14 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-18 13:53:19 +0100 |
| commit | 01069e62d53df2e5d345461941587377c9178676 (patch) | |
| tree | 6e17f2e74d86eeaec54ddefcb56835cd10b009d7 /sql | |
| parent | c6632dc3ee9538c05a7086a1bd8c8ada9a3c72e4 (diff) | |
DB: Fix more DB errors
(cherry picked from commit 755add6fd202a50e43074c98315f74eaee1fa662)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_02_18_00_world_2016_08_21_03_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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); |