diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-02-07 21:52:14 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-02-07 21:52:14 +0000 |
| commit | f81cfca7bd5583cef0254920e3fae234d0789e69 (patch) | |
| tree | d8bb223cbe576383b995e1044ee30e10dc02162b /sql/old | |
| parent | 774f8e86505ab8ca371c8c4d1acfcfaceedec4a9 (diff) | |
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
Diffstat (limited to 'sql/old')
| -rw-r--r-- | sql/old/3.3.5a/09551_world_spell_bonus_data.sql | 1 | ||||
| -rw-r--r-- | sql/old/3.3.5a/09700_world_spell_script_names.sql | 2 | ||||
| -rw-r--r-- | sql/old/3.3.5a/10284_world_spell_script_names.sql | 4 | ||||
| -rw-r--r-- | sql/old/3.3.5a/2011_01_31_0_world_spell_bonus_data.sql (renamed from sql/old/3.3.5a/2011_01_31_0_spell_bonus_data.sql) | 0 |
4 files changed, 4 insertions, 3 deletions
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_world_spell_bonus_data.sql index a908e227a1d..a908e227a1d 100644 --- a/sql/old/3.3.5a/2011_01_31_0_spell_bonus_data.sql +++ b/sql/old/3.3.5a/2011_01_31_0_world_spell_bonus_data.sql |