diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 1 | ||||
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 1 | ||||
| -rw-r--r-- | sql/updates/2011_01_24_0_world_scriptname.sql (renamed from sql/updates/2011_01_24_0_world_script_names.sql) | 2 | ||||
| -rw-r--r-- | sql/updates/2011_01_26_0_world_scriptname.sql | 1 | ||||
| -rw-r--r-- | sql/updates/2011_01_26_0_world_spell_script_names.sql | 3 | ||||
| -rw-r--r-- | sql/updates/2011_01_26_world_scriptname.sql | 4 | ||||
| -rw-r--r-- | sql/updates/2011_01_28_0_world_spell_linked_spell.sql | 1 | ||||
| -rw-r--r-- | sql/updates/2011_01_28_0_world_spell_script_names.sql | 3 |
8 files changed, 10 insertions, 6 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 6e8cc6c2621..04fc64555bc 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -18178,7 +18178,6 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment ( 71479, 71482, 1, 'Blood-Queen: Bloodbolt Splash'), ( 71480, 71483, 1, 'Blood-Queen: Bloodbolt Splash'), ( 71952, 70995, 1, 'Blood-Queen: Presence of the Darkfallen'), -( 71390, 71341, 0, 'Blood-Queen: Pact of the Darkfallen'), -- Isle of Conquest ( 66548, 66550, 0, 'Isle of Conquest (IN>OUT)'), ( 66549, 66551, 0, 'Isle of Conquest (OUT>IN)'), diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index 8eb2e1e0ace..0dacb2d7bf8 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -1970,6 +1970,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES ( 71901, 'spell_blood_queen_bloodbolt'), ( 71902, 'spell_blood_queen_bloodbolt'), ( 71390, 'spell_blood_queen_pact_of_the_darkfallen'), +( 71340, 'spell_blood_queen_pact_of_the_darkfallen_dmg'), -- Isle of Conquest ( 66630, 'spell_gen_gunship_portal'), ( 66637, 'spell_gen_gunship_portal'), diff --git a/sql/updates/2011_01_24_0_world_script_names.sql b/sql/updates/2011_01_24_0_world_scriptname.sql index 7716fb79039..6e4233c5431 100644 --- a/sql/updates/2011_01_24_0_world_script_names.sql +++ b/sql/updates/2011_01_24_0_world_scriptname.sql @@ -8,4 +8,4 @@ INSERT INTO `spell_script_names` (spell_id,ScriptName) VALUES (54069,'spell_varos_energize_core_area_entry'), (56251,'spell_varos_energize_core_area_entry'), (50785,'spell_varos_energize_core_area_enemy'), -(59372,'spell_varos_energize_core_area_enemy');
\ No newline at end of file +(59372,'spell_varos_energize_core_area_enemy'); diff --git a/sql/updates/2011_01_26_0_world_scriptname.sql b/sql/updates/2011_01_26_0_world_scriptname.sql new file mode 100644 index 00000000000..810fe263f76 --- /dev/null +++ b/sql/updates/2011_01_26_0_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='boss_eregos' WHERE `entry`=27656; diff --git a/sql/updates/2011_01_26_0_world_spell_script_names.sql b/sql/updates/2011_01_26_0_world_spell_script_names.sql new file mode 100644 index 00000000000..1244adf63c8 --- /dev/null +++ b/sql/updates/2011_01_26_0_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=51162 AND `ScriptName`='spell_eregos_planar_shift'; +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(51162,'spell_eregos_planar_shift'); diff --git a/sql/updates/2011_01_26_world_scriptname.sql b/sql/updates/2011_01_26_world_scriptname.sql deleted file mode 100644 index 98c74106866..00000000000 --- a/sql/updates/2011_01_26_world_scriptname.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `spell_id`=51162; -INSERT INTO `spell_script_names`(spell_id, ScriptName) VALUES (51162,'spell_eregos_planar_shift'); - -UPDATE `creature_template` SET `ScriptName`='boss_eregos' WHERE `entry`=27656;
\ No newline at end of file diff --git a/sql/updates/2011_01_28_0_world_spell_linked_spell.sql b/sql/updates/2011_01_28_0_world_spell_linked_spell.sql new file mode 100644 index 00000000000..2357ff914d3 --- /dev/null +++ b/sql/updates/2011_01_28_0_world_spell_linked_spell.sql @@ -0,0 +1 @@ +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=71390; diff --git a/sql/updates/2011_01_28_0_world_spell_script_names.sql b/sql/updates/2011_01_28_0_world_spell_script_names.sql new file mode 100644 index 00000000000..aa0a291f526 --- /dev/null +++ b/sql/updates/2011_01_28_0_world_spell_script_names.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=71340 AND `ScriptName`='spell_blood_queen_pact_of_the_darkfallen_dmg'; +INSERT INTO `spell_script_names`(`spell_id`,`ScriptName`) VALUES +(71340,'spell_blood_queen_pact_of_the_darkfallen_dmg'); |