From ea1c783b84d4fa489436531667f3c121631b25d4 Mon Sep 17 00:00:00 2001 From: treeston Date: Fri, 25 Sep 2015 13:01:36 +0200 Subject: Scripts/Naxxramas: Adjustments to the Loatheb encounter - Adjusted doom cast timings as per boss mod timers. - Add Deathbloom's final tick using spellscript - Move Spores' Fungal Creep cast handling to Loatheb's cpp instead of handling it in SmartAI - Fungal Creep should also be cast if the spore expires (important for Spore Loser achievement) - Remove Fungal Creep from players on reset to avoid cheesy strats --- sql/updates/world/2015_09_25_15596_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/2015_09_25_15596_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_09_25_15596_world.sql b/sql/updates/world/2015_09_25_15596_world.sql new file mode 100644 index 00000000000..068255d4e0c --- /dev/null +++ b/sql/updates/world/2015_09_25_15596_world.sql @@ -0,0 +1,12 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=16286 AND `source_type`=0; +UPDATE `creature_template` SET `AIName`="" WHERE `entry`=16286; + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (29865,55053); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(29865,"spell_loatheb_deathbloom"), +(55053,"spell_loatheb_deathbloom"); + +DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (55594); +INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`) VALUES +(55594,55594,55601); -- cgit v1.2.3 From ba100a0cb9e88394fd5582cc5e4bcf54f013d7d0 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sat, 10 Oct 2015 11:56:31 +0200 Subject: Rename sql --- sql/updates/world/2015_09_25_15596_world.sql | 12 ------------ sql/updates/world/2015_10_10_02_world.sql | 12 ++++++++++++ 2 files changed, 12 insertions(+), 12 deletions(-) delete mode 100644 sql/updates/world/2015_09_25_15596_world.sql create mode 100644 sql/updates/world/2015_10_10_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_09_25_15596_world.sql b/sql/updates/world/2015_09_25_15596_world.sql deleted file mode 100644 index 068255d4e0c..00000000000 --- a/sql/updates/world/2015_09_25_15596_world.sql +++ /dev/null @@ -1,12 +0,0 @@ --- -DELETE FROM `smart_scripts` WHERE `entryorguid`=16286 AND `source_type`=0; -UPDATE `creature_template` SET `AIName`="" WHERE `entry`=16286; - -DELETE FROM `spell_script_names` WHERE `spell_id` IN (29865,55053); -INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES -(29865,"spell_loatheb_deathbloom"), -(55053,"spell_loatheb_deathbloom"); - -DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (55594); -INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`) VALUES -(55594,55594,55601); diff --git a/sql/updates/world/2015_10_10_02_world.sql b/sql/updates/world/2015_10_10_02_world.sql new file mode 100644 index 00000000000..068255d4e0c --- /dev/null +++ b/sql/updates/world/2015_10_10_02_world.sql @@ -0,0 +1,12 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid`=16286 AND `source_type`=0; +UPDATE `creature_template` SET `AIName`="" WHERE `entry`=16286; + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (29865,55053); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(29865,"spell_loatheb_deathbloom"), +(55053,"spell_loatheb_deathbloom"); + +DELETE FROM `spelldifficulty_dbc` WHERE `id` IN (55594); +INSERT INTO `spelldifficulty_dbc` (`id`,`spellid0`,`spellid1`) VALUES +(55594,55594,55601); -- cgit v1.2.3