diff options
| author | Machiavelli <machiaveltman@gmail.com> | 2011-12-16 09:44:31 -0800 |
|---|---|---|
| committer | Machiavelli <machiaveltman@gmail.com> | 2011-12-16 09:44:31 -0800 |
| commit | 5d39dfc7be650236343654650919f9e9d27cf464 (patch) | |
| tree | fb3248ea2789afbd8fc9ef21ed69527c23a66776 /sql/updates | |
| parent | d10b0b74bdb71044372e76ea826119ec99ca1e04 (diff) | |
| parent | eeb5a2d95efdc37a9b814bc653005e71930c2092 (diff) | |
Merge pull request #4354 from elecyb/eletotem2
Core/Spells: Added spells for Fire Elemental Totem and Earth Elemental T...
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2011_12_16_00_world_creature_template.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql | 5 |
2 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2011_12_16_00_world_creature_template.sql b/sql/updates/world/2011_12_16_00_world_creature_template.sql new file mode 100644 index 00000000000..156fd431359 --- /dev/null +++ b/sql/updates/world/2011_12_16_00_world_creature_template.sql @@ -0,0 +1,4 @@ +-- Greater Fire Elemental script +UPDATE `creature_template` SET `ScriptName`='npc_fire_elemental' WHERE `entry`=15438; +-- Greater Earth Elemental script +UPDATE `creature_template` SET `ScriptName`='npc_earth_elemental' WHERE `entry`=15352;
\ No newline at end of file diff --git a/sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql b/sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql new file mode 100644 index 00000000000..3250bda4fdb --- /dev/null +++ b/sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql @@ -0,0 +1,5 @@ +-- Bounus coef for Greater Fire Elemental spells +DELETE FROM `spell_bonus_data` WHERE `entry` IN (13376,57984); +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`,`ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +(13376,0.032,-1,-1,-1,'Greater Fire Elemental - Fire Shield'), +(57984,0.4289,-1,-1,-1,'Greater Fire Elemental - Fire Blast');
\ No newline at end of file |