From aade16a2f4871607e4a12464835d230ef239b4b2 Mon Sep 17 00:00:00 2001 From: Warpten Date: Fri, 26 Jun 2015 01:13:35 +0200 Subject: Scripts/RubySanctum: Updates to Halion. * Fixed Living Embers not spawning. * Meteor Strike is now randomized. (cherry picked from 1447875cac0fefd58ae3ad27e6b3fa2134a714c0) Scripts/RubySanctum: Fix a mathematical mistake. SQL: Do not use MAX(Id), hardcode it. (cherry picked from 7a5bc9e1fe457f0c77cdfecefa5bd42525105c3e) Scripts/RubySanctum: Correctly spawn Living Embers. (cherry picked from 7c4b8b0e826fd1cdab8a635225123aebd1b950c6) Scripts/RubySanctum: Remove duplicate code. (cherry picked from 1d29328769d505caf4541b0d712972195dda8b70) Core/Misc: Warning fixes (cherry picked from dc53dad8a44292bcb555db9fdc07eb255a838cac) --- sql/updates/world/2015_06_26_01_world_2015_05_15_00.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/2015_06_26_01_world_2015_05_15_00.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2015_06_26_01_world_2015_05_15_00.sql b/sql/updates/world/2015_06_26_01_world_2015_05_15_00.sql new file mode 100644 index 00000000000..06e2bdda370 --- /dev/null +++ b/sql/updates/world/2015_06_26_01_world_2015_05_15_00.sql @@ -0,0 +1,12 @@ +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"); + +UPDATE `spell_dbc` SET `Effect1`=77, `EffectImplicitTargetA1`=22, `EffectImplicitTargetB1`=7, `EffectRadiusIndex1`=12, `EffectMiscValue1`=0, `EffectMiscValueB1`=0 WHERE `Id`=75880; +UPDATE `spell_dbc` SET `Effect1`=28, `EffectImplicitTargetA1`=18, `EffectImplicitTargetB1`=0, `EffectRadiusIndex1`=12, `EffectMiscValue1`=40683, `EffectMiscValueB1`=64 WHERE `Id`=75881; + +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