diff options
| author | megamage <none@none> | 2009-02-05 22:59:49 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-02-05 22:59:49 -0600 |
| commit | 3a3429602a3f16708610ea80cd296fb01483efdb (patch) | |
| tree | ec48ab2c975cf7f0f1bf0f43748b09c743891826 /sql/updates | |
| parent | 944a1cec7315f482ee6de93c0ea18f97dc776042 (diff) | |
[7230] Add spell_bonus_data for 18220 and ranks. Author: Dietrich
[7232] Use constant name that hide client dependent value. Author: VladimirMangos
Skip: [7231] Some info to sql updates commiters in slq/update/README and spell chain update of [7230]
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/7230_02_mangos_spell_bonus_data.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/7230_02_mangos_spell_bonus_data.sql b/sql/updates/7230_02_mangos_spell_bonus_data.sql new file mode 100644 index 00000000000..85333ee2a88 --- /dev/null +++ b/sql/updates/7230_02_mangos_spell_bonus_data.sql @@ -0,0 +1,9 @@ +ALTER TABLE db_version CHANGE COLUMN required_7230_01_mangos_spell_chain required_7230_02_mangos_spell_bonus_data bit; + +DELETE FROM `spell_bonus_data` WHERE `entry` IN (18220,18937,18938,27265,59092); +INSERT INTO `spell_bonus_data` VALUES +('18220', '0.96', '0', '0', 'Warlock - Dark Pact Rank 1'), +('18937', '0.96', '0', '0', 'Warlock - Dark Pact Rank 2'), +('18938', '0.96', '0', '0', 'Warlock - Dark Pact Rank 3'), +('27265', '0.96', '0', '0', 'Warlock - Dark Pact Rank 4'), +('59092', '0.96', '0', '0', 'Warlock - Dark Pact Rank 5'); |