aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorQAston <none@none>2009-07-30 11:52:40 +0200
committerQAston <none@none>2009-07-30 11:52:40 +0200
commit2a402ff6c776734f54db44662d34813e95b11c02 (patch)
tree883e83c2499b15bcd027c402c02e033ffd705a6e /sql/updates
parenta07a3417e3eb8e94360fc898d1bacfb823f87278 (diff)
parent9c52a12e08dcbca6234d03f01ef9910320a2c88e (diff)
*Merge required after backout.
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd13
-rw-r--r--sql/updates/8249_02_mangos_spell_chain.sql.tbd31
2 files changed, 0 insertions, 44 deletions
diff --git a/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd b/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd
deleted file mode 100644
index d1502ba40fe..00000000000
--- a/sql/updates/8249_01_mangos_spell_proc_item_enchant.sql.tbd
+++ /dev/null
@@ -1,13 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_8247_01_mangos_spell_bonus_data required_8249_01_mangos_spell_proc_item_enchant bit;
-
-DROP TABLE IF EXISTS `spell_proc_item_enchant`;
-CREATE TABLE `spell_proc_item_enchant` (
- `entry` mediumint unsigned NOT NULL,
- `ppmRate` float NOT NULL default '0',
- PRIMARY KEY (`entry`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
-INSERT INTO `spell_proc_item_enchant` (`entry`, `ppmRate`) VALUES
-(8034, 9), -- Frostbrand Weapon
-(8680, 8.5714), -- Instant Poison
-(13218, 21.4286); -- Wound Poison
diff --git a/sql/updates/8249_02_mangos_spell_chain.sql.tbd b/sql/updates/8249_02_mangos_spell_chain.sql.tbd
deleted file mode 100644
index f3fda91c872..00000000000
--- a/sql/updates/8249_02_mangos_spell_chain.sql.tbd
+++ /dev/null
@@ -1,31 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_8249_01_mangos_spell_proc_item_enchant required_8249_02_mangos_spell_chain bit;
-
-DELETE FROM `spell_chain` WHERE `spell_id` IN
-(8034, 8037, 10458, 16352, 16353, 25501, 58797, 58798, 58799, 8680, 8685, 8689, 11335, 11336, 11337, 26890, 57964, 57965, 13218, 13222, 13223, 13224, 27189, 57974, 57975);
-
-INSERT INTO `spell_chain` (`spell_id`, `prev_spell`, `first_spell`, `rank`, `req_spell`) VALUES
-(8034,0,8034,1,0), -- Frostbrand Attack
-(8037,8034,8034,2,0),
-(10458,8037,8034,3,0),
-(16352,10458,8034,4,0),
-(16353,16352,8034,5,0),
-(25501,16353,8034,6,0),
-(58797,25501,8034,7,0),
-(58798,58797,8034,8,0),
-(58799,58798,8034,9,0),
-(8680,0,8680,1,0), -- Instant Poison
-(8685,8680,8680,2,0),
-(8689,8685,8680,3,0),
-(11335,8689,8680,4,0),
-(11336,11335,8680,5,0),
-(11337,11336,8680,6,0),
-(26890,11337,8680,7,0),
-(57964,26890,8680,8,0),
-(57965,57964,8680,9,0),
-(13218,0,13218,1,0), -- Wound Poison
-(13222,13218,13218,2,0),
-(13223,13222,13218,3,0),
-(13224,13223,13218,4,0),
-(27189,13224,13218,5,0),
-(57974,27189,13218,6,0),
-(57975,57974,13218,7,0);