diff options
| author | xinef1 <w.szyszko2@gmail.com> | 2017-02-04 23:50:32 +0100 |
|---|---|---|
| committer | ariel- <ariel-@users.noreply.github.com> | 2017-02-04 19:50:32 -0300 |
| commit | 93746e8c4a79c8256cd4896533315683f143508c (patch) | |
| tree | fc593ddd9a6bc026b6842f52446f1e9bc9a8dcb3 /sql | |
| parent | 86da1a19bb36edf3242dafac6e45e87434ddff73 (diff) | |
Implemented binary resistances and some more (#18933)
- Fixed possible exploit with tamed pets having template immunities
- Implemented binary resistances
- Corrected resistances calculations
- Pets properly inherit players spell penetration
- Fixed doubled block calculation for damaging melee spells
- Auras removing snare effects will only remove the snaring component
- Shapeshifting will properly remove movement impairing auras only and not crowd control (dragon's breath)
- Immunities are properly checked versus all schools appearing in spell, unit is immune only if immune to all schools
- Spells with melee and magic school mask should compare armor reduction with resistances and select smaller reduction
- Demonic Circle: Teleport no longer removes root effects
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2017_02_04_14_world.sql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_02_04_14_world.sql b/sql/updates/world/3.3.5/2017_02_04_14_world.sql new file mode 100644 index 00000000000..ed889d3f03e --- /dev/null +++ b/sql/updates/world/3.3.5/2017_02_04_14_world.sql @@ -0,0 +1,34 @@ + +DELETE FROM `spell_custom_attr` WHERE `entry` IN (63124) AND `attributes`= 131072; +INSERT INTO `spell_custom_attr` VALUES (63124, 131072); -- quest "There's Something About the Squire" (13654) + +DELETE FROM `spell_custom_attr` WHERE `entry` IN (63293, 68873, 70324, 64619) AND `attributes`= 4; +INSERT INTO `spell_custom_attr` VALUES +(63293, 4), -- Mimiron - spinning damage +(68873, 4), -- Wailing Souls +(70324, 4), -- Wailing Souls +(64619, 4); -- Ulduar, Mimiron, Emergency Fire Bot, Water Spray + +DELETE FROM `spell_custom_attr` WHERE `entry` IN (66809, 67331, 66765, 67333) AND `attributes`=8; +INSERT INTO `spell_custom_attr` VALUES +(66809, 8), -- Meteor Fists +(67331, 8), -- Meteor Fists +(66765, 8), -- Meteor Fists +(67333, 8); -- Meteor Fists + +DELETE FROM `spell_custom_attr` WHERE `entry` IN (66378, 67097, 67098, 67099, 64125, 64126, 72409, 72447, 72448, 72449, 62775) AND `attributes`=32768; +INSERT INTO `spell_custom_attr` VALUES +(66378, 32768), -- Trial of the Crusader, Jaraxxus, Shivan Slash +(67097, 32768), -- Trial of the Crusader, Jaraxxus, Shivan Slash +(67098, 32768), -- Trial of the Crusader, Jaraxxus, Shivan Slash +(67099, 32768), -- Trial of the Crusader, Jaraxxus, Shivan Slash +(64125, 32768), -- Ulduar, Yogg-Saron, Squeeze +(64126, 32768), -- Ulduar, Yogg-Saron, Squeeze +(72409, 32768), -- Rune of Blood (Deathbringer Saurfang) +(72447, 32768), -- Rune of Blood (Deathbringer Saurfang) +(72448, 32768), -- Rune of Blood (Deathbringer Saurfang) +(72449, 32768), -- Rune of Blood (Deathbringer Saurfang) +(62775, 32768); -- Ulduar: XT-002 Tympanic Tamparum + +DELETE FROM `spell_custom_attr` WHERE `entry` IN (45145) AND `attributes`= 1048576; +INSERT INTO `spell_custom_attr` VALUES (45145, 1048576); -- Snake Trap Effect |