diff options
| -rw-r--r-- | sql/updates/3810_world_spell_bonus_data.sql | 94 | ||||
| -rw-r--r-- | src/game/SpellAuras.cpp | 1 |
2 files changed, 95 insertions, 0 deletions
diff --git a/sql/updates/3810_world_spell_bonus_data.sql b/sql/updates/3810_world_spell_bonus_data.sql new file mode 100644 index 00000000000..777a3c2213d --- /dev/null +++ b/sql/updates/3810_world_spell_bonus_data.sql @@ -0,0 +1,94 @@ +-- by Drahy +UPDATE `spell_bonus_data` SET `direct_bonus` = '0,6453' WHERE `entry`=33763; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.67305' WHERE `entry`=50464; +UPDATE `spell_bonus_data` SET `dot_bonus` = '0.2' WHERE `entry`=5570; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7143' WHERE `entry`=44425; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1936' WHERE `entry`=11113; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1936' WHERE `entry`=31661; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.214' WHERE `entry`=120; +UPDATE `spell_bonus_data` SET `direct_bonus` = '1' WHERE `entry`=19750; +UPDATE `spell_bonus_data` SET `direct_bonus` = '1.66' WHERE `entry`=635; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4280' WHERE `entry`=8092; +UPDATE `spell_bonus_data` SET `dot_bonus` = '0.2' WHERE `entry`=172; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2129' WHERE `entry`=27243; +UPDATE `spell_bonus_data` SET `dot_bonus` = '0.2' WHERE `entry`=30108; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0' WHERE `entry`=17962; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2140' WHERE `entry`=6789; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4793' WHERE `entry`=48181; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7139' WHERE `entry`=29722; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4293' WHERE `entry`=5676; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.8569' WHERE `entry`=686; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4293' WHERE `entry`=17877; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1932' WHERE `entry`=30283; +UPDATE `spell_bonus_data` SET `dot_bonus` = '0.143' WHERE `entry`=689; +UPDATE `spell_bonus_data` SET `dot_bonus` = '0.429' WHERE `entry`=1120; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=5857; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=11681; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=11682; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=27214; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1427' WHERE `entry`=47822; +UPDATE `spell_bonus_data` SET `dot_bonus` = '0.0949' WHERE `entry`=1949; +UPDATE `spell_bonus_data` SET `ap_bonus` = '0.025' WHERE `entry`=31803; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42208; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42209; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42210; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42211; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42212; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42213; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42198; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42937; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.1437' WHERE `entry`= 42938; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2861' WHERE `entry` =49821; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.2861' WHERE `entry` =53022; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42223; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42224; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42225; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42226; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=42218; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=47817; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.7024' WHERE `entry`=47818; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.4762' WHERE `entry`=379; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=25914; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=25913; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=25903; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=27175; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=33074; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.81' WHERE `entry`=48821; +UPDATE `spell_bonus_data` SET `direct_bonus` = '0.6453' WHERE `entry`=33763; +DELETE FROM `spell_bonus_data` WHERE `entry` IN (53742,61391,47897,50796,50590,58597,974,47757,52986,52987,52988); +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES +('53742', '0.013', '0', '0.025', 'Paladin - Blood Corruption'), +('61391', '0.193', '0', '0', 'Druid - Typhoon'), +('47897', '0.1064', '0.0667', '0', 'Warlock - Shadowflame'), +('50796', '0.7139', '0', '0', 'Warlock - Chaos Bolt'), +('50590', '0', '0.1622', '0', 'Warlock - Immolation Aura'), +('58597', '0.75', '0', '0', 'Paladin - Sacred Shield'), +('47757', '1.6135', '0', '0', 'Priest - Penance (Rank 1'), +('52986', '1.6135', '0', '0', 'Priest - Penance (Rank 2'), +('52987', '1.6135', '0', '0', 'Priest - Penance (Rank 3'), +('52988', '1.6135', '0', '0', 'Priest - Penance (Rank 4'); +DELETE FROM `spell_bonus_data` WHERE `entry` IN (48505,50288,50294,53191,53188,53194,53189,53195,53190); +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `comments`) VALUES +(50288, 0.05, 0, 0, 'Druid - Starfall rank 1'), +(50294, 0.012, 0, 0, 'Druid - Starfall AOE rank 1'), +(53191, 0.05, 0, 0, 'Druid - Starfall rank 2'), +(53188, 0.012, 0, 0, 'Druid - Starfall AOE rank 2'), +(53194, 0.05, 0, 0, 'Druid - Starfall rank 3'), +(53189, 0.012, 0, 0, 'Druid - Starfall AOE rank 3'), +(53195, 0.05, 0, 0, 'Druid - Starfall rank 4'), +(53190, 0.012, 0, 0, 'Druid - Starfall AOE rank 4'); + +-- by nesocip +DELETE FROM `spell_bonus_data` WHERE `entry` IN (48721, 55078, 52212, 47632, 55095, 49184, 45477, 50536, 51373, 51374, 51375); +INSERT INTO spell_bonus_data( entry, ap_bonus, comments ) VALUES +('48721', '0.04', 'DK - Blood Boil'), +('55078', '0.055', 'DK - Blood Plague'), +('52212', '0.0475', 'DK - Death and Decay'), +('47632', '0.15', 'DK - Death Coil'), +('55095', '0.055', 'DK - Frost Fever'), +('49184', '0.1', 'DK - Howling Blast'), +('45477', '0.1', 'DK - Icy Touch'), +('50536', '0.013', 'DK - Unholy Blight (Rank1)'), +('51373', '0.013', 'DK - Unholy Blight (Rank2)'), +('51374', '0.013', 'DK - Unholy Blight (Rank3)'), +('51375', '0.013', 'DK - Unholy Blight (Rank4)'); diff --git a/src/game/SpellAuras.cpp b/src/game/SpellAuras.cpp index 39c959bdc3e..b6c44b8cc60 100644 --- a/src/game/SpellAuras.cpp +++ b/src/game/SpellAuras.cpp @@ -6650,6 +6650,7 @@ void AuraEffect::PeriodicDummyTick() case SPELLFAMILY_WARLOCK: switch (spell->Id) { + // Demonic Circle case 48018: GameObject* obj = m_target->GetGameObject(spell->Id); if (!obj) return; |