From 1447875cac0fefd58ae3ad27e6b3fa2134a714c0 Mon Sep 17 00:00:00 2001 From: Warpten Date: Fri, 15 May 2015 15:48:35 +0200 Subject: Scripts/RubySanctum: Updates to Halion. * Fixed Living Embers not spawning. * Meteor Strike is now randomized. --- sql/updates/world/2015_05_15_00_world.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/2015_05_15_00_world.sql (limited to 'sql') diff --git a/sql/updates/world/2015_05_15_00_world.sql b/sql/updates/world/2015_05_15_00_world.sql new file mode 100644 index 00000000000..3c96f23c970 --- /dev/null +++ b/sql/updates/world/2015_05_15_00_world.sql @@ -0,0 +1,15 @@ +UPDATE `creature_template` SET `ScriptName`="npc_meteor_strike_flame" WHERE `entry`=40055; + +DELETE FROM `spell_script_names` WHERE `spell_id`=75880 OR `ScriptName`="spell_halion_spawn_living_embers"; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(75880, "spell_halion_spawn_living_embers"); + +DELETE FROM `spelleffect_dbc` WHERE `EffectSpellId` IN (75880, 75881); +SET @MaxEffectEntry := (SELECT MAX(Id) + 1 FROM `spelleffect_dbc`); +INSERT INTO `spelleffect_dbc` (`Id`, `EffectSpellId`, `EffectIndex`, `Effect`, `EffectImplicitTargetA`, `EffectImplicitTargetB`, `EffectRadiusIndex`, `EffectRadiusIndexMax`, `EffectMiscValue`, `EffectMiscValueB`) VALUES +(@MaxEffectEntry + 0, 75880, 0, 77, 22, 7, 12, 12, 0, 0), +(@MaxEffectEntry + 1, 75881, 0, 28, 18, 0, 12, 12, 40055, 64); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=75880; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `Comment`) VALUES +(13, 1, 75880, 31, 0, 3, 40055, "Spawn Living Embers can only target Meteor Strike (Flame)"); -- cgit v1.2.3