diff options
-rw-r--r-- | sql/FULL/world_spell_full.sql | 40 | ||||
-rw-r--r-- | sql/updates/5445_world.sql | 41 |
2 files changed, 78 insertions, 3 deletions
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index faef453b822..408839af5d6 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -1127,8 +1127,8 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 47535, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00004000, 0x00002000, 0, 0, 12), -- Rapture (Rank 1) ( 47536, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00004000, 0x00002000, 0, 0, 12), -- Rapture (Rank 2) ( 47537, 0x00, 6, 0x00000001, 0x00000000, 0x00000000, 0x00004000, 0x00002000, 0, 0, 12), -- Rapture (Rank 3) -( 47569, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 50, 0), -- Improved Shadowform (Rank 1) -( 47570, 0x00, 6, 0x00004000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0, 100, 0), -- Improved Shadowform (Rank 2) +( 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) ( 47580, 0x00, 6, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0x00010000, 0, 0, 0), -- Pain and Suffering (Rank 1) ( 47581, 0x00, 6, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0x00010000, 0, 0, 0), -- Pain and Suffering (Rank 2) ( 47582, 0x00, 6, 0x00000000, 0x00000000, 0x00000040, 0x00000000, 0x00010000, 0, 0, 0), -- Pain and Suffering (Rank 3) @@ -1569,7 +1569,41 @@ INSERT INTO spell_enchant_proc_data (`entry`, `customChance`, `PPMChance`,`procE (625, 0, 8.53,0), (2641, 0, 8.53,0), (3768, 0, 8.53,0), -(3769, 0, 8.53,0); +(3769, 0, 8.53,0), + -- 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); -- -------- -- SPELL BONUS DATA 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 |