aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorVincent-Michael <Vincent_Michael@gmx.de>2013-07-18 18:20:01 +0200
committerVincent-Michael <Vincent_Michael@gmx.de>2013-07-18 18:20:01 +0200
commitde673fc4b072f71595ca24072d8c2c3db98aa518 (patch)
tree4c61d30a6ec535324be1b92444bec50d527e47be /sql/updates
parent0b94293dba4a3fa202ec1fe24f16f76d0aef7496 (diff)
Core/Spells: Convert/Update more spells for 4.3.4
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2013_07_18_02_world_spell_script_misc_434.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2013_07_18_02_world_spell_script_misc_434.sql b/sql/updates/world/2013_07_18_02_world_spell_script_misc_434.sql
new file mode 100644
index 00000000000..5bc7bffadb1
--- /dev/null
+++ b/sql/updates/world/2013_07_18_02_world_spell_script_misc_434.sql
@@ -0,0 +1,12 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (-31571,-51664);
+INSERT INTO `spell_script_names`(`spell_id`, `ScriptName`) VALUES
+(-31571,'spell_mage_arcane_potency'),
+(-51664,'spell_rog_cut_to_the_chase');
+
+DELETE FROM `spell_ranks` WHERE `first_spell_id` IN (31571,51664);
+INSERT INTO `spell_ranks` (`first_spell_id`, `spell_id`, `rank`) VALUES
+(31571, 31571, 1),
+(31571, 31572, 2),
+(51664, 51664, 1),
+(51664, 51665, 2),
+(51664, 51667, 3);