aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorJohn Holiver <none@none>2010-05-22 01:29:01 -0300
committerJohn Holiver <none@none>2010-05-22 01:29:01 -0300
commit70a44e8d0ed2a7f8186f3c274d384d703bc89dc3 (patch)
treecc93835bef279b3714c3a2a85f01f2ee090ab172 /sql
parentb902d7f9ad6679a0d8be025cd11f6953b01eb621 (diff)
- Fix Warlock Decimation not procing for Soul Fire
Thanks Karolis.Rudzevicius Fixes 2259 - Also, applies sql mods from rb178306035 to world.sql --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/8259_world_spell_proc_event.sql1
-rw-r--r--sql/world.sql6
2 files changed, 4 insertions, 3 deletions
diff --git a/sql/updates/8259_world_spell_proc_event.sql b/sql/updates/8259_world_spell_proc_event.sql
new file mode 100644
index 00000000000..a1b8b3eabb7
--- /dev/null
+++ b/sql/updates/8259_world_spell_proc_event.sql
@@ -0,0 +1 @@
+UPDATE `spell_proc_event` SET `SpellFamilyMask1`=192 WHERE `entry` in (63156,63158);
diff --git a/sql/world.sql b/sql/world.sql
index 06edef2bd3f..1771349b6a2 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -2756,7 +2756,7 @@ CREATE TABLE `item_template` (
`displayid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`Quality` tinyint(3) unsigned NOT NULL DEFAULT '0',
`Flags` bigint(20) signed NOT NULL DEFAULT '0',
- `Faction` int(11) unsigned NOT NULL DEFAULT '0',
+ `FlagsExtra` int(10) unsigned NOT NULL DEFAULT '0',
`BuyCount` tinyint(3) unsigned NOT NULL DEFAULT '1',
`BuyPrice` bigint(20) signed NOT NULL DEFAULT '0',
`SellPrice` int(10) unsigned NOT NULL DEFAULT '0',
@@ -7035,8 +7035,8 @@ INSERT INTO `spell_proc_event` (`entry`,`SchoolMask`,`SpellFamilyName`,`SpellFam
( 62147, 0x00, 15, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Icy Touch Defense Increase
( 62459, 0x00, 15, 0x00000004, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Chains of Ice Frost Rune Refresh (Rank 3)
( 63108, 0x00, 5, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Siphon Life
-( 63158, 0x00, 5, 0x00000001, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Decimation
-( 63156, 0x00, 5, 0x00000001, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Decimation
+( 63158, 0x00, 5, 0x00000001, 0x000000C0, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Decimation
+( 63156, 0x00, 5, 0x00000001, 0x000000C0, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Decimation
( 64343, 0x00, 3, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Impact
( 64976, 0x00, 4, 0x00000001, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Juggernaut
( 64914, 0x00, 8, 0x00010000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Item - Rogue T8 2P Bonus