From f81cfca7bd5583cef0254920e3fae234d0789e69 Mon Sep 17 00:00:00 2001 From: Nay Date: Mon, 7 Feb 2011 21:52:14 +0000 Subject: SQL: Any content SQL should be able to be re-imported without errors; Fix an import error in world_scripts_full; P.S Full DB will be available soon Closes #586 --- sql/old/3.3.5a/09551_world_spell_bonus_data.sql | 1 + sql/old/3.3.5a/09700_world_spell_script_names.sql | 2 +- sql/old/3.3.5a/10284_world_spell_script_names.sql | 4 ++-- sql/old/3.3.5a/2011_01_31_0_spell_bonus_data.sql | 3 --- sql/old/3.3.5a/2011_01_31_0_world_spell_bonus_data.sql | 3 +++ 5 files changed, 7 insertions(+), 6 deletions(-) delete mode 100644 sql/old/3.3.5a/2011_01_31_0_spell_bonus_data.sql create mode 100644 sql/old/3.3.5a/2011_01_31_0_world_spell_bonus_data.sql (limited to 'sql/old') diff --git a/sql/old/3.3.5a/09551_world_spell_bonus_data.sql b/sql/old/3.3.5a/09551_world_spell_bonus_data.sql index ae040a7e03c..95af16980d2 100644 --- a/sql/old/3.3.5a/09551_world_spell_bonus_data.sql +++ b/sql/old/3.3.5a/09551_world_spell_bonus_data.sql @@ -1 +1,2 @@ +DELETE FROM `spell_bonus_data` WHERE `entry`=70809; INSERT INTO `spell_bonus_data` VALUES (70809, 0, 0, 0, 0, 'Item - Shaman T10 Restoration 4P Bonus'); diff --git a/sql/old/3.3.5a/09700_world_spell_script_names.sql b/sql/old/3.3.5a/09700_world_spell_script_names.sql index 24e3a8a3e89..fa0bcb81e60 100644 --- a/sql/old/3.3.5a/09700_world_spell_script_names.sql +++ b/sql/old/3.3.5a/09700_world_spell_script_names.sql @@ -1,4 +1,4 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=73032 AND `ScriptName`='spell_stinky_precious_decimate'; +DELETE FROM `spell_script_names` WHERE `spell_id`=71123 AND `ScriptName`='spell_stinky_precious_decimate'; DELETE FROM `spell_script_names` WHERE `spell_id` IN (73032,73031,71219,69195) AND `ScriptName`='spell_festergut_pungent_blight'; DELETE FROM `spell_script_names` WHERE `spell_id` IN (72219,72551,72552,72553) AND `ScriptName`='spell_festergut_gastric_bloat'; DELETE FROM `spell_script_names` WHERE `spell_id` IN (69290,71222,73033,73034) AND `ScriptName`='spell_festergut_blighted_spores'; diff --git a/sql/old/3.3.5a/10284_world_spell_script_names.sql b/sql/old/3.3.5a/10284_world_spell_script_names.sql index 571fb59d3a5..71d7696396b 100644 --- a/sql/old/3.3.5a/10284_world_spell_script_names.sql +++ b/sql/old/3.3.5a/10284_world_spell_script_names.sql @@ -2,7 +2,7 @@ DELETE FROM `spell_script_names` WHERE `spell_id`=71598 AND `ScriptName`='spell_ DELETE FROM `spell_script_names` WHERE `spell_id`=71806 AND `ScriptName`='spell_taldaram_glittering_sparks'; DELETE FROM `spell_script_names` WHERE `spell_id` IN (71718,72040) AND `ScriptName`='spell_taldaram_summon_flame_ball'; DELETE FROM `spell_script_names` WHERE `spell_id` IN (55891,55947) AND `ScriptName`='spell_taldaram_flame_ball_visual'; -DELETE FROM `spell_script_names` WHERE `spell_id` IN (71756,72782,72783,72783) AND `ScriptName`='spell_taldaram_ball_of_inferno_flame'; +DELETE FROM `spell_script_names` WHERE `spell_id` IN (71756,72782,72783,72784) AND `ScriptName`='spell_taldaram_ball_of_inferno_flame'; DELETE FROM `spell_script_names` WHERE `spell_id`=72080 AND `ScriptName`='spell_valanar_kinetic_bomb'; DELETE FROM `spell_script_names` WHERE `spell_id`=72087 AND `ScriptName`='spell_valanar_kinetic_bomb_knockback'; DELETE FROM `spell_script_names` WHERE `spell_id`=73001 AND `ScriptName`='spell_blood_council_shadow_prison'; @@ -21,4 +21,4 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (72080,'spell_valanar_kinetic_bomb'), (72087,'spell_valanar_kinetic_bomb_knockback'), (73001,'spell_blood_council_shadow_prison'), -(72999,'spell_blood_council_shadow_prison_damage'); +(72999,'spell_blood_council_shadow_prison_damage'); \ No newline at end of file diff --git a/sql/old/3.3.5a/2011_01_31_0_spell_bonus_data.sql b/sql/old/3.3.5a/2011_01_31_0_spell_bonus_data.sql deleted file mode 100644 index a908e227a1d..00000000000 --- a/sql/old/3.3.5a/2011_01_31_0_spell_bonus_data.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_bonus_data` WHERE `entry`=70691; -INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES -(70691,0,0,0,0, 'Druid - Rejuvenation T10 4P proc'); diff --git a/sql/old/3.3.5a/2011_01_31_0_world_spell_bonus_data.sql b/sql/old/3.3.5a/2011_01_31_0_world_spell_bonus_data.sql new file mode 100644 index 00000000000..a908e227a1d --- /dev/null +++ b/sql/old/3.3.5a/2011_01_31_0_world_spell_bonus_data.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_bonus_data` WHERE `entry`=70691; +INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`ap_dot_bonus`,`comments`) VALUES +(70691,0,0,0,0, 'Druid - Rejuvenation T10 4P proc'); -- cgit v1.2.3