diff options
| author | Warpten <vertozor@gmail.com> | 2015-06-26 01:13:35 +0200 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2015-06-26 01:52:17 +0100 |
| commit | aade16a2f4871607e4a12464835d230ef239b4b2 (patch) | |
| tree | ec051064033303a09621c33ad526b124295ad152 /sql | |
| parent | 33f48a460ced5488b1e782b12a67fab47a4eccf0 (diff) | |
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)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_06_26_01_world_2015_05_15_00.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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)"); |