diff options
| author | megamage <none@none> | 2009-06-07 20:50:35 -0500 |
|---|---|---|
| committer | megamage <none@none> | 2009-06-07 20:50:35 -0500 |
| commit | 9ef844d23d183c951d53e21c8cbe091f1133386b (patch) | |
| tree | 1d611f3d690c17b2d91d4ec68c4de2a0d459b1b8 | |
| parent | 2e7d1d1ffcd61974533faeac409b87aa9877c9e7 (diff) | |
*Fix some spell script target. By Drahy.
*Fix a typo in 3810 spell bonus sql.
--HG--
branch : trunk
| -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 |