diff options
| author | Machiavelli <none@none> | 2009-08-28 01:57:29 +0200 |
|---|---|---|
| committer | Machiavelli <none@none> | 2009-08-28 01:57:29 +0200 |
| commit | 5ce0b50fc628a82b3df70f6b640638b785d996d7 (patch) | |
| tree | d2eb84e16b572e097b12a40ef71ea1dfa618d8fb /sql | |
| parent | 1c45055482d5af9a2c7e374ae782b3a107c87d37 (diff) | |
| parent | 562f661ac3bc64fecf4a847b506651a5d7306e0b (diff) | |
Merge
--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'; -- |