| blob | 7d62722bd10d4197f73ea01a05031d3b643ec1a6 |
1 ALTER TABLE db_version CHANGE COLUMN required_7196_01_mangos_spell_chain required_7196_02_mangos_spell_bonus_data bit;
3 -- ----------------------------
4 -- Table structure for spell_bonus_data
5 -- ----------------------------
6 DROP TABLE IF EXISTS `spell_bonus_data`;
7 CREATE TABLE `spell_bonus_data` (
8 `entry` smallint(5) unsigned NOT NULL,
9 `direct_bonus` float NOT NULL default '0',
10 `dot_bonus` float NOT NULL default '0',
11 `ap_bonus` float NOT NULL default '0',
12 `comments` varchar(255) default NULL,
13 PRIMARY KEY (`entry`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
16 INSERT INTO `spell_bonus_data` VALUES
17 ('5185', '1.6104', '0', '0', 'Druid - Healing Touch'),
18 ('33763', '0', '0.09518', '0', 'Druid - Lifebloom'),
19 ('774', '0', '0.37604', '0', 'Druid - Rejuvenation'),
20 ('8936', '0.539', '0.188', '0', 'Druid - Regrowth'),
21 ('18562', '0', '0', '0', 'Druid - Swiftmend'),
22 ('44203', '0.538', '0', '0', 'Druid - Tranquility Triggered'),
23 ('48438', '0', '0.11505', '0', 'Druid - Wild Growth'),
24 ('50464', '0.6611', '0', '0', 'Druid - Nourish'),
25 ('339', '0', '0.1', '0', 'Druid - Entangling Roots'),
26 ('42231', '0.12898', '0', '0', 'Druid - Hurricane Triggered'),
27 ('5570', '0', '0.127', '0', 'Druid - Insect Swarm'),
28 ('8921', '0.1515', '0.13', '0', 'Druid - Moonfire'),
29 ('2912', '1', '0', '0', 'Druid - Starfire'),
30 ('5176', '0.5714', '0', '0', 'Druid - Wrath'),
31 ('30451', '0.7143', '0', '0', 'Mage - Arcane Blast'),
32 ('1449', '0.2128', '0', '0', 'Mage - Arcane Explosion'),
33 ('7268', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 1'),
34 ('7269', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 2'),
35 ('7270', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 3'),
36 ('8419', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 4'),
37 ('8418', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 5'),
38 ('10273', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 6'),
39 ('10274', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 7'),
40 ('25346', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 8'),
41 ('27076', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 9'),
42 ('38700', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 10'),
43 ('38703', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 11'),
44 ('42844', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 12'),
45 ('42845', '0.2857', '0', '0', 'Mage - Arcane Missiles Triggered Spell Rank 13'),
46 ('1463', '0.8053', '0', '0', 'Mage - Mana Shield'),
47 ('44425', '0.8571', '0', '0', 'Mage - Arcane Barrage'),
48 ('11113', '0.1357', '0', '0', 'Mage - Blast Wave Rank'),
49 ('31661', '0.1357', '0', '0', 'Mage - Dragons Breath'),
50 ('2136', '0.4286', '0', '0', 'Mage - Fire Blast'),
51 ('133', '1', '0', '0', 'Mage - Fire Ball'),
52 ('2120', '0.2357', '0.122', '0', 'Mage - Flamestrike'),
53 ('11366', '1.15', '0.05', '0', 'Mage - Pyroblast'),
54 ('2948', '0.4286', '0', '0', 'Mage - Scorch'),
55 ('44614', '0.8571', '0', '0', 'Frostfire Bolt'),
56 ('44457', '0.4', '0.2', '0', 'Mage - Living Bomb'),
57 ('42208', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 1'),
58 ('42209', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 2'),
59 ('42210', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 3'),
60 ('42211', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 4'),
61 ('42212', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 5'),
62 ('42213', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 6'),
63 ('42198', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 7'),
64 ('42937', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 8'),
65 ('42938', '0.0952', '0', '0', 'Mage - Blizzard Triggered Spell Rank 9'),
66 ('120', '0.1357', '0', '0', 'Mage - Cone of Cold'),
67 ('122', '0.193', '0', '0', 'Mage - Frost Nova'),
68 ('116', '0.8143', '0', '0', 'Mage - Frost Bolt'),
69 ('11426', '0.8053', '0', '0', 'Mage - Ice Barrier'),
70 ('30455', '0.1429', '0', '0', 'Mage - Ice Lance'),
71 ('19750', '0.4286', '0', '0', 'Paladin - Flash of Light'),
72 ('635', '0.7143', '0', '0', 'Paladin - Holy Light'),
73 ('25912', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 1'),
74 ('25911', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 2'),
75 ('25902', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 3'),
76 ('27176', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 4'),
77 ('33073', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 5'),
78 ('48822', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 6'),
79 ('48823', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Hurt Rank 7'),
80 ('25914', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 1'),
81 ('25913', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 2'),
82 ('25903', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 3'),
83 ('27175', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 4'),
84 ('33074', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 5'),
85 ('48820', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 6'),
86 ('48821', '0.4286', '0', '0', 'Paladin - Holy Shock Triggered Heal Rank 7'),
87 ('31935', '0.07', '0', '0.07', 'Paladin - Avengers Shiled'),
88 ('26573', '0', '0.04', '0.04', 'Paladin - Consecration'),
89 ('879', '0.15', '0', '0.15', 'Paladin - Exorcism'),
90 ('24275', '0.15', '0', '0.15', 'Paladin - Hammer of Wrath'),
91 ('20925', '0.09', '0', '0.056', 'Paladin - Holy Shield'),
92 ('2812', '0.07', '0', '0.07', 'Paladin - Holy Wrath'),
93 ('31893', '0.25', '0', '0.16', 'Paladin - Seal of Blood Enemy Proc'),
94 ('32221', '0.25', '0', '0.16', 'Paladin - Seal of Blood Self Proc'),
95 ('20424', '0.25', '0', '0.16', 'Paladin - Seal of Command Proc'),
96 ('379', '0', '0', '0', 'Shaman - Earth Shield Triggered'),
97 ('20167', '0.25', '0', '0.16', 'Paladin - Seal of Light Proc'),
98 ('53719', '0.25', '0', '0.16', 'Paladin - Seal of The Martyr Enemy Proc'),
99 ('53718', '0.25', '0', '0.16', 'Paladin - Seal of The Martyr Self Proc'),
100 ('25742', '0.07', '0', '0.039', 'Paladin - Seal of Righteousness Dummy Proc'),
101 ('31803', '0', '0.013', '0.15', 'Paladin - Holy Vengeance'),
102 ('52042', '0.045', '0', '0', 'Shaman - Healing Stream Totem Triggered Heal'),
103 ('32546', '0.8068', '0', '0', 'Priest - Binding Heal'),
104 ('34861', '0.402', '0', '0', 'Priest - Circle of Healing'),
105 ('19236', '0.8068', '0', '0', 'Priest - Desperate Prayer'),
106 ('2061', '0.8068', '0', '0', 'Priest - Flash Heal'),
107 ('2060', '1.6135', '0', '0', 'Priest - Greater Heal'),
108 ('23455', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 1'),
109 ('23458', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 2'),
110 ('23459', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 3'),
111 ('27803', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 4'),
112 ('27804', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 5'),
113 ('27805', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 6'),
114 ('25329', '0.3035', '0', '0', 'Priest - Holy Nova Heal Rank 7'),
115 ('17', '0.8068', '0', '0', 'Priest - Power Word: Shield'),
116 ('596', '0.8086', '0', '0', 'Priest - Prayer of Healing'),
117 ('33110', '0.8068', '0', '0', 'Priest - Prayer of Mending Heal Proc'),
118 ('139', '1.88', '0', '0', 'Priest - Renew'),
119 ('2944', '0.1849', '0', '0', 'Priest - Devouring Plague'),
120 ('14914', '0.5711', '0.024', '0', 'Priest - Holy Fire'),
121 ('15237', '0.1606', '0', '0', 'Priest - Holy Nova Damage'),
122 ('8129', '0', '0', '0', 'Priest - Mana Burn'),
123 ('8092', '0.4296', '0', '0', 'Priest - Mind Blast'),
124 ('15407', '0.257', '0', '0', 'Priest - Mind Flay'),
125 ('49821', '0.7143', '0', '0', 'Priest - Mind Sear Trigger Rank 1'),
126 ('53022', '0.7143', '0', '0', 'Priest - Mind Sear Trigger Rank 2'),
127 ('34433', '0.65', '0', '0', 'Priest - Shadowfiend'),
128 ('32379', '0.4296', '0', '0', 'Priest - Shadow Word: Death'),
129 ('589', '0', '0.1829', '0', 'Priest - Shadow Word: Pain'),
130 ('585', '0.714', '0', '0', 'Priest - Smite'),
131 ('34914', '0', '0.4', '0', 'Priest - Vampiric Touch'),
132 ('974', '0.4762', '0', '0', 'Shaman - Earth Shield'),
133 ('1064', '1.34', '0', '0', 'Shaman - Chain Heal'),
134 ('331', '1.6106', '0', '0', 'Shaman - Healing Wave'),
135 ('8004', '0.8082', '0', '0', 'Shaman - Lesser Healing Wave'),
136 ('61295', '0.4', '0.18', '0', 'Shaman - Riptide'),
137 ('421', '0.57', '0', '0', 'Shaman - Chain Lightning'),
138 ('8042', '0.3858', '0', '0', 'Shaman - Earth Shock'),
139 ('8443', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 1'),
140 ('8504', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 2'),
141 ('8505', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 3'),
142 ('11310', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 4'),
143 ('11311', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 5'),
144 ('25538', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 6'),
145 ('25539', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 7'),
146 ('61651', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 8'),
147 ('61660', '0.2142', '0', '0', 'Shaman - Fire Nova Totem Casted by Totem Rank 9'),
148 ('8050', '0.2142', '0.1', '0', 'Shaman - Flame Shock'),
149 ('8026', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 1'),
150 ('8028', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 2'),
151 ('8029', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 3'),
152 ('10445', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 4'),
153 ('16343', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 5'),
154 ('16344', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 6'),
155 ('25488', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 7'),
156 ('58786', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 8'),
157 ('58787', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 9'),
158 ('58788', '0.1', '0', '0', 'Shaman - Flametongue Weapon Proc Rank 10'),
159 ('8056', '0.3858', '0', '0', 'Shaman - Frost Shock'),
160 ('8034', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 1'),
161 ('8037', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 2'),
162 ('10458', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 3'),
163 ('16352', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 4'),
164 ('16353', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 5'),
165 ('25501', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 6'),
166 ('58797', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 7'),
167 ('58798', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 8'),
168 ('58799', '0.1', '0', '0', 'Shaman - Frostbrand Attack Rank 9'),
169 ('51505', '0.5714', '0', '0', 'Shaman - Lava Burst'),
170 ('403', '0.7143', '0', '0', 'Shaman - Lightning Bolt'),
171 ('26364', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 1'),
172 ('26365', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 2'),
173 ('26366', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 3'),
174 ('26367', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 4'),
175 ('26369', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 5'),
176 ('26370', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 6'),
177 ('26363', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 7'),
178 ('26371', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 8'),
179 ('26372', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 9'),
180 ('49278', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 10'),
181 ('49279', '0.33', '0', '0', 'Shaman - Lightning Shield Proc Rank 11'),
182 ('8188', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 1'),
183 ('10582', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 2'),
184 ('10583', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 3'),
185 ('10584', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 4'),
186 ('25551', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 5'),
187 ('58733', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 6'),
188 ('58736', '0.1', '0', '0', 'Shaman - Magma Totam Passive Rank 7'),
189 ('3606', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 1'),
190 ('6350', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 2'),
191 ('6351', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 3'),
192 ('6352', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 4'),
193 ('10435', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 5'),
194 ('10436', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 6'),
195 ('25530', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 7'),
196 ('58700', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 8'),
197 ('58701', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 9'),
198 ('58702', '0.1667', '0', '0', 'Shaman - Searing Totem Attack Rank 10'),
199 ('980', '0', '0.1', '0', 'Warlock - Curse of Agony'),
200 ('603', '0', '2', '0', 'Warlock - Curse of Doom'),
201 ('172', '0', '0.3', '0', 'Warlock - Corruption'),
202 ('348', '0.2', '0.2', '0', 'Warlock - Immolate'),
203 ('27243', '0.22', '0.25', '0', 'Warlock - Seed of Corruption'),
204 ('18265', '0', '1', '0', 'Warlock - Siphon Life'),
205 ('30108', '0', '0.24', '0', 'Warlock - Unstable Affliction'),
206 ('17962', '0.4286', '0', '0', 'Warlock - Conflagrate'),
207 ('6789', '0.22', '0', '0', 'Warlock - Death Coil'),
208 ('48181', '0.4729', '0', '0', 'Warlock - Haunt'),
209 ('29722', '0.7143', '0', '0', 'Warlock - Incinerate'),
210 ('5676', '0.4286', '0', '0', 'Warlock - Searing Pain'),
211 ('686', '0.8571', '0', '0', 'Warlock - Shadow Bolt'),
212 ('17877', '0.4286', '0', '0', 'Warlock - Shadowburn'),
213 ('30283', '0.195', '0', '0', 'Warlock - Shadowfury'),
214 ('6353', '1.15', '0', '0', 'Warlock - Soul Fire'),
215 ('689', '0', '0.1428', '0', 'Warlock - Drain Life'),
216 ('5138', '0', '0', '0', 'Warlock - Drain Mana'),
217 ('1120', '0', '0.4286', '0', 'Warlock - Drain Soul'),
218 ('755', '0', '0.4485', '0', 'Warlock - Health Funnel'),
219 ('1949', '0', '0.0946', '0', 'Warlock - Hellfire'),
220 ('5857', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 1'),
221 ('11681', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 2'),
222 ('11682', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 3'),
223 ('27214', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 4'),
224 ('47822', '0.1428', '0', '0', 'Warlock - Hellfire Effect on Enemy Rank 5'),
225 ('42223', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 1'),
226 ('42224', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 2'),
227 ('42225', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 3'),
228 ('42226', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 4'),
229 ('42218', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 5'),
230 ('47817', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 6'),
231 ('47818', '0.952', '0', '0', 'Warlock - Rain of Fire Triggered Rank 7'),
232 ('18220', '0.96', '0', '0', 'Warlock - Dark Pact'),
233 ('6229', '0.3', '0', '0', 'Warlock - Shadow Ward');