From 3a3429602a3f16708610ea80cd296fb01483efdb Mon Sep 17 00:00:00 2001 From: megamage Date: Thu, 5 Feb 2009 22:59:49 -0600 Subject: [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 --- sql/updates/7230_02_mangos_spell_bonus_data.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/7230_02_mangos_spell_bonus_data.sql (limited to 'sql/updates') 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'); -- cgit v1.2.3