diff options
| -rw-r--r-- | sql/updates/3810_world_spell_bonus_data.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3851_characters_aura.sql | 1 | ||||
| -rw-r--r-- | sql/updates/3851_world_spell.sql | 8 |
3 files changed, 10 insertions, 1 deletions
diff --git a/sql/updates/3810_world_spell_bonus_data.sql b/sql/updates/3810_world_spell_bonus_data.sql index 777a3c2213d..1803687d6a4 100644 --- a/sql/updates/3810_world_spell_bonus_data.sql +++ b/sql/updates/3810_world_spell_bonus_data.sql @@ -1,5 +1,5 @@ -- by Drahy -UPDATE `spell_bonus_data` SET `direct_bonus` = '0,6453' WHERE `entry`=33763; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `entry`=33763; UPDATE `spell_bonus_data` SET `direct_bonus` = '0.67305' WHERE `entry`=50464; UPDATE `spell_bonus_data` SET `dot_bonus` = '0.2' WHERE `entry`=5570; UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7143' WHERE `entry`=44425; diff --git a/sql/updates/3851_characters_aura.sql b/sql/updates/3851_characters_aura.sql new file mode 100644 index 00000000000..966665ac776 --- /dev/null +++ b/sql/updates/3851_characters_aura.sql @@ -0,0 +1 @@ +DELETE FROM `character_aura` WHERE `spell` IN (48714,57806);
\ No newline at end of file diff --git a/sql/updates/3851_world_spell.sql b/sql/updates/3851_world_spell.sql new file mode 100644 index 00000000000..4475c24f0e8 --- /dev/null +++ b/sql/updates/3851_world_spell.sql @@ -0,0 +1,8 @@ +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `entry`=33763; +DELETE FROM `spell_script_target` WHERE `entry` IN (48714,57806); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +('48714', '2', '27237'), +('48714', '2', '27235'), +('48714', '2', '27234'), +('48714', '2', '27236'), +('57806', '2', '31043');
\ No newline at end of file |