From 9ef844d23d183c951d53e21c8cbe091f1133386b Mon Sep 17 00:00:00 2001 From: megamage Date: Sun, 7 Jun 2009 20:50:35 -0500 Subject: *Fix some spell script target. By Drahy. *Fix a typo in 3810 spell bonus sql. --HG-- branch : trunk --- sql/updates/3810_world_spell_bonus_data.sql | 2 +- sql/updates/3851_characters_aura.sql | 1 + sql/updates/3851_world_spell.sql | 8 ++++++++ 3 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 sql/updates/3851_characters_aura.sql create mode 100644 sql/updates/3851_world_spell.sql (limited to 'sql') 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 -- cgit v1.2.3