1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
-- Update Proc Rate
INSERT INTO `spell_proc_event` VALUES ('60442', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45');
INSERT INTO `spell_proc_event` VALUES ('57345', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45');
INSERT INTO `spell_proc_event` VALUES ('61356', '0', '0', '0', '0', '0', '0', '0', '0', '0', '45');
INSERT INTO `spell_proc_event` VALUES ('54707', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60');
INSERT INTO `spell_proc_event` VALUES ('54808', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60');
-- Update Spell Coefficients
DELETE FROM `spell_bonus_data` WHERE `entry` IN ('689', '18790', '172', '42223', '42224', '42225', '42226', '42218', '47817', '47818', '1949', '5857', '11681', '11682', '27214', '47822', '27243', '30108', '17962', '6789', '48181', '29722', '5676', '686', '17877', '30283', '1120', '30294', '44425', '42208', '42209', '42210', '42211', '42212', '42213', '42198', '42937', '42938', '11113', '31661', '120', '19750', '635', '25914', '25913', '25903', '27175', '33074', '48820', '48821', '58597', '31803', '53742', '31893', '32221', '53719', '53718', '20167', '20424', '31804', '53733', '31898', '32220', '53726', '53725', '20267', '20187', '20467', '53600', '596', '2944', '8092', '27813', '27817', '27818', '33619');
INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES
('689', '0', '0.143', '0', 'Warlock - Drain Life'),
('18790', '0', '0', '0','Warlock - Fel Stamina'),
('172', '0', '0.2', '0', 'Warlock - Corruption'),
('42223', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 1'),
('42224', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 2'),
('42225', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 3'),
('42226', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 4'),
('42218', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 5'),
('47817', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 6'),
('47818', '0.6932', '0', '0', 'Warlock - Rain of Fire Triggered Rank 7'),
('1949', '0', '0.0949', '0', 'Warlock - Hellfire'),
('5857', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 1'),
('11681', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 2'),
('11682', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 3'),
('27214', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 4'),
('47822', '0.1427', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 5'),
('27243', '0.2129', '0.25', '0', 'Warlock - Seed of Corruption'),
('30108', '0', '0.2', '0', 'Warlock - Unstable Affliction'),
('17962', '0.4293', '0', '0', 'Warlock - Conflagrate'),
('6789', '0.214', '0', '0', 'Warlock - Death Coil'),
('48181', '0.4793', '0', '0', 'Warlock - Haunt'),
('29722', '0.7139', '0', '0', 'Warlock - Incinerate'),
('5676', '0.4293', '0', '0', 'Warlock - Searing Pain'),
('686', '0.8569', '0', '0', 'Warlock - Shadow Bolt'),
('17877', '0.4293', '0', '0', 'Warlock - Shadowburn'),
('30283', '0.1932', '0', '0', 'Warlock - Shadowfury'),
('1120', '0', '0.429', '0', 'Warlock - Drain Soul'),
('30294', '0', '0', '0', 'Warlock - Soul Leech'),
('44425', '0.7143', '0', '0', 'Mage - Arcane Barrage'),
('42208', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 1'),
('42209', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 2'),
('42210', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 3'),
('42211', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 4'),
('42212', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 5'),
('42213', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 6'),
('42198', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 7'),
('42937', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 8'),
('42938', '0.1437', '0', '0', 'Mage - Blizzard Triggered Spell Rank 9'),
('11113', '0.1936', '0', '0', 'Mage - Blast Wave Rank'),
('31661', '0.1936', '0', '0', 'Mage - Dragons Breath'),
('120', '0.214', '0', '0', 'Mage - Cone of Cold'),
('19750', '1', '0', '0', 'Paladin - Flash of Light'),
('635', '1.66', '0', '0', 'Paladin - Holy Light'),
('25914', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 1'),
('25913', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 2'),
('25903', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 3'),
('27175', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 4'),
('33074', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 5'),
('48820', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 6'),
('48821', '0.81', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 7'),
('58597', '0.75', '0', '0', 'Paladin - Sacred Shield'),
('31803', '0', '0.018', '0.03', 'Paladin - Holy Vengeance'),
('53742', '0', '0.018', '0.03', 'Paladin - Blood Corruption'),
('31893', '0', '0', '0', 'Paladin - Seal of Blood Enemy Proc'),
('32221', '0', '0', '0', 'Paladin - Seal of Blood Self Proc'),
('53719', '0', '0', '0', 'Paladin - Seal of The Martyr Enemy Proc'),
('53718', '0', '0', '0', 'Paladin - Seal of The Martyr Self Proc'),
('20167', '0.15', '0', '0.15', 'Paladin - Seal of Light Proc'),
('20424', '0.1035', '0', '0', 'Paladin - Seal of Command Proc'),
('31804', '0.22', '0', '0.14', 'Paladin - Judgement of Vengeance'),
('53733', '0.22', '0', '0.14', 'Paladin - Judgement of Corruption'),
('31898', '0.25', '0', '0.16', 'Paladin - Judgement of Blood Enemy'),
('32220', '0', '0', '0', 'Paladin - Judgement of Blood Self'),
('53726', '0.25', '0', '0.16', 'Paladin - Judgement of the Martyr Enemy'),
('53725', '0', '0', '0', 'Paladin - Judgement of the Martyr Self'),
('20267', '0.1', '0', '0.1', 'Paladin - Judgement of Light Proc'),
('20187', '0.4', '0', '0.25', 'Paladin - Judgement of Righteousness'),
('20467', '0.25', '0', '0.16', 'Paladin - Judgement of Command'),
('53600', '0', '0', '0', 'Paladin - Shield of Righteousness'),
('596', '0.8068', '0', '0', 'Priest - Prayer of Healing'),
('2944', '0.8149', '0', '0', 'Priest - Devouring Plague'),
('8092', '0.428', '0', '0', 'Priest - Mind Blast'),
('27813', '0', '0', '0', 'Priest - Blessed Recovery Rank 1'),
('27817', '0', '0', '0', 'Priest - Blessed Recovery Rank 2'),
('27818', '0', '0', '0', 'Priest - Blessed Recovery Rank 3'),
('33619', '0', '0', '0', 'Priest - Reflective Shield');
|
