diff options
| author | QAston <none@none> | 2009-08-27 22:39:06 +0200 |
|---|---|---|
| committer | QAston <none@none> | 2009-08-27 22:39:06 +0200 |
| commit | 629420b54b983109377c69e1d58363faead709ad (patch) | |
| tree | a9cc6514b880990362f46d6b8a16efe70fd81774 /sql | |
| parent | 685dee559381705e7c79b6cd6b499f23e7e8fc36 (diff) | |
*Fix Crypt Fever and Ebon Plague disease damage mod.
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/FULL/world_spell_full.sql | 5 | ||||
| -rw-r--r-- | sql/updates/5416_world_spell_dbc.sql | 3 | ||||
| -rw-r--r-- | sql/world.sql | 2 |
3 files changed, 7 insertions, 3 deletions
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index fbcf3db0020..54ec11a4c4c 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -1850,8 +1850,9 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` -- -------- TRUNCATE TABLE `spell_dbc`; -INSERT INTO `spell_dbc` (`Id`, `DurationIndex`, `Effect1`, `EffectImplicitTargetA1`, `EffectApplyAuraName1`, `Comment`) VALUES -(62388, 21, 6, 1, 4, 'Demonic Circle: Teleport(48020) - casterAuraSpell'); +INSERT INTO `spell_dbc` (`Id`, `Dispel`, `Mechanic`, `AttributesEx3`, `DurationIndex`, `RangeIndex`, `Effect1`, `EffectImplicitTargetA1`, `EffectApplyAuraName1`, `EffectMiscValue1`, `SpellFamilyName`, `SchoolMask`, `Comment`) VALUES +(62388, 0, 0, 0x00000000, 21, 1, 6, 1, 4, 0, 0, 0, 'Demonic Circle: Teleport(48020) - casterAuraSpell'), +(65142, 3, 22, 0x00000080, 21, 13, 6, 6, 255, 22, 15, 8, 'Crypt Fever - SPELL_AURA_LINKED'); -- -------- -- SPELL ELIXIR diff --git a/sql/updates/5416_world_spell_dbc.sql b/sql/updates/5416_world_spell_dbc.sql new file mode 100644 index 00000000000..0669b9096b3 --- /dev/null +++ b/sql/updates/5416_world_spell_dbc.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_dbc` WHERE `Id` IN(65142); +INSERT INTO `spell_dbc` (`Id`, `Dispel`, `Mechanic`, `AttributesEx3`, `DurationIndex`, `RangeIndex`, `Effect1`, `EffectImplicitTargetA1`, `EffectApplyAuraName1`, `EffectMiscValue1`, `SpellFamilyName`, `SchoolMask`, `Comment`) VALUES +(65142, 3, 22, 0x00000080, 21, 13, 6, 6, 255, 22, 15, 8, 'Crypt Fever - SPELL_AURA_LINKED');
\ No newline at end of file diff --git a/sql/world.sql b/sql/world.sql index 1e9831d856c..e96ffb4388e 100644 --- a/sql/world.sql +++ b/sql/world.sql @@ -2840,7 +2840,7 @@ CREATE TABLE `spell_dbc` ( `AreaGroupId` INT NOT NULL DEFAULT 0, `SchoolMask` INT UNSIGNED NOT NULL DEFAULT 0, `Comment` TEXT NOT NULL, - PRIMARY KEY (`id`) + PRIMARY KEY (`Id`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries'; -- |