diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_03_23_00_world_2021_12_01_01_world.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_23_00_world_2021_12_01_01_world.sql b/sql/updates/world/master/2022_03_23_00_world_2021_12_01_01_world.sql new file mode 100644 index 00000000000..110a284581d --- /dev/null +++ b/sql/updates/world/master/2022_03_23_00_world_2021_12_01_01_world.sql @@ -0,0 +1,19 @@ +-- +DELETE FROM `spell_script_names` WHERE `spell_id` IN (35268,39346) AND `ScriptName` = 'spell_nethermancer_sepethrea_inferno'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(35268,'spell_nethermancer_sepethrea_inferno'), +(39346,'spell_nethermancer_sepethrea_inferno'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 13 AND `SourceEntry` = 35277; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,35277,0,0,31,0,3,20481,0,0,0,0,"","Group 0: Spell 'Quell Raging Flames' (Effect 0) targets creature 'Raging Flames'"); + +-- They're not immune even to fire, only to all mechanics +UPDATE `creature_template` SET `ScriptName` = 'npc_raging_flames' WHERE `entry` = 20481; +UPDATE `creature_template` SET `mechanic_immune_mask` = 617299803, `spell_school_immune_mask` = 0 WHERE `entry` IN (20481,21538); + +UPDATE `serverside_spell` SET `ProcFlags` = 20, `ProcChance` = 100, `BaseLevel` = 70, `SpellLevel` = 70, `DmgClass` = 1, `PreventionType` = 1 WHERE `Id` = 45196; + +DELETE FROM `serverside_spell_effect` WHERE `SpellID`=45196; +INSERT INTO `serverside_spell_effect` (`SpellID`,`Effect`,`EffectAura`,`EffectChainAmplitude`,`EffectTriggerSpell`,`ImplicitTarget1`) VALUES +(45196,6,42,1,45195,1); |