diff options
| author | Gustavo <sirikfoll@hotmail.com> | 2017-09-25 17:21:15 -0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-09-25 17:21:15 -0300 |
| commit | 0b766db6a41a4db0d631e36fcc753c658b746328 (patch) | |
| tree | 3f35503aaf7288cf24cd31c1172d5381b800c997 /sql | |
| parent | f1ff7e642f8feb027d668a53adc39ecaa7488cc2 (diff) | |
Core/Scripts: Boss Amanitar rewrite (#20283)
* Core/Scripts: Boss Amanitar rewrite
Fixes mushrooms behavior, correct and script his spell, size, spawn positions, despawn and respawn, and everything else
Fixes Mini spell cast(only re-cast if there is at least one person without the debuff)
Corrects boss initial position
Updates script register model
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2017_09_25_01_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_09_25_01_world.sql b/sql/updates/world/3.3.5/2017_09_25_01_world.sql new file mode 100644 index 00000000000..68262d8a94a --- /dev/null +++ b/sql/updates/world/3.3.5/2017_09_25_01_world.sql @@ -0,0 +1,7 @@ +UPDATE `creature` SET `position_x`=340.1726, `position_y`=-878.5924, `position_z`=-74.86385, `orientation`=0.3316126 WHERE `id`=30258; +UPDATE `creature_template` SET `InhabitType`=12, `flags_extra`=0 WHERE `entry` IN(30391,31461,30435,31462); +UPDATE `spell_dbc` SET `StackAmount`=3 ,`Effect1`=6, `EffectBasePoints1`=100, `EffectImplicitTargetA1`=1, `EffectApplyAuraName1`=61 WHERE `Id`=57059; + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_amanitar_potent_fungus'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(56648,'spell_amanitar_potent_fungus'); |