From c243bf96d436aaaaf12f4a42cf8e439defe198ea Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sun, 21 Sep 2014 04:18:31 +0200 Subject: DB/Spells: - Added EffectItemType columns to spell_dbc table - Fix "Create Bundle of Bloodthistle" --- sql/updates/world/2014_09_21_00_world_spell_dbc.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2014_09_21_00_world_spell_dbc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_09_21_00_world_spell_dbc.sql b/sql/updates/world/2014_09_21_00_world_spell_dbc.sql new file mode 100644 index 00000000000..d762bf92107 --- /dev/null +++ b/sql/updates/world/2014_09_21_00_world_spell_dbc.sql @@ -0,0 +1,5 @@ +ALTER TABLE `spell_dbc` ADD `EffectItemType1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectMultipleValue3`; +ALTER TABLE `spell_dbc` ADD `EffectItemType2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectItemType1`; +ALTER TABLE `spell_dbc` ADD `EffectItemType3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `EffectItemType2`; + +UPDATE `spell_dbc` SET `EffectItemType1`=30616 WHERE `Id`=37064; -- cgit v1.2.3