From cec4522c9917c15555e58d8f1d0086fdca80661a Mon Sep 17 00:00:00 2001 From: QAston Date: Fri, 28 Aug 2009 17:27:42 +0200 Subject: *Add some spell_enchant_proc_event data. --HG-- branch : trunk --- sql/updates/5445_world.sql | 41 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 sql/updates/5445_world.sql (limited to 'sql/updates') diff --git a/sql/updates/5445_world.sql b/sql/updates/5445_world.sql new file mode 100644 index 00000000000..f2e0fb79fd1 --- /dev/null +++ b/sql/updates/5445_world.sql @@ -0,0 +1,41 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN(47569, 47570); +INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES +( 47569, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0), -- Improved Shadowform (Rank 1) +( 47570, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 0, 0); -- Improved Shadowform (Rank 2) + +DELETE FROM `spell_enchant_proc_data` WHERE `entry` IN(803, 912, 1894, 1898, 1899, 1900, 2673, 2675, 3225, 3239, 3241, 3273, 3368, 3369, 3789, 3869); +INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procEx`) VALUES + -- Fiery Weapon +(803, 0, 6.0,0), + -- Demonslaying +(912, 0, 6.0,0), + -- Icy Weapon +(1894, 0, 3.0,0), + -- Lifestealing +(1898, 0, 6.0,0), + -- Unholy Weapon +(1899, 0, 1.0,0), + -- Crusader +(1900, 0, 1.0,0), + -- Mongoose +(2673, 0, 1.0,0), + -- Battlemaster +(2675, 0, 1.0,0), + -- Executioner +(3225, 0, 1.0,0), + -- Icebreaker Weapon +(3239, 0, 3.0,0), + -- Lifeward +(3241, 0, 3.0,0), + -- Giantslaying +(3251, 0, 3.0,0), + -- Deathfrost +(3273, 0, 3.0,0), + -- Rune of the Fallen Crusader +(3368, 0, 1.0,0), + -- Rune of Cinderglacier +(3369, 0, 1.0,0), + -- Berserking +(3789, 0, 1.0,0), + -- Blade Ward +(3869, 0, 1.0,0); \ No newline at end of file -- cgit v1.2.3