From eeb5a2d95efdc37a9b814bc653005e71930c2092 Mon Sep 17 00:00:00 2001 From: elecyb Date: Fri, 16 Dec 2011 12:11:26 -0300 Subject: Core/Spells: Added spells for Fire Elemental Totem and Earth Elemental Totem --- sql/updates/world/2011_12_16_00_world_creature_template.sql | 4 ++++ sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql | 5 +++++ 2 files changed, 9 insertions(+) create mode 100644 sql/updates/world/2011_12_16_00_world_creature_template.sql create mode 100644 sql/updates/world/2011_12_16_00_world_spell_bonus_data.sql (limited to 'sql') 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 -- cgit v1.2.3