Core/Spells: restore some special aura proc handling
Note: can cause some unexpected behavior

Closes: #12413
DB/Misc: Fix some runtime errors/incorrect triggers

By dr-j
DB/SAI: Fix Cosmetic Chains on Kirgaraak

By dr-j, closes #12420
DB/Items: Fix realtime duration of event items

By dr-j closes #12421
DB/Vendor: Add Arcanum of the Stalwart Protector reputation version
Core/Spells: Spells which do not apply auras should not apply DR

- Solves issue where Intimidating Shout applied DR twice on the main target
Rename 2014_06_20_01_world_spell_dbc.sql to 2014_06_20_01_world_creature_text.sql
DB/Items: Fix typos on 4c3cb80

By dr-j
Core/Spells: fixed Deep Freeze after 2a3546ca36468b81d673bdb27315006144af3165

Closes #12424
Core/VMAPs: Fix object orientation

Merge https://github.com/249CAAFE40/mangos-wotlk/commit/2f8b8e55d99122d34be2a08cbdbd2d2b1ae172d1
Quoting original commit log:
This patch fixes 2 issues with the vmap extractor. 1) Incorrectly converts vertex coordinates. 2) Forgets to convert coordinates on triangle indices.

The effects of [1] causes models to be flipped. This isn't very noticeable on most trees as flipping a cylinder results in the same cylinder, but it's very noticeable on any non-symmetrical geometry (which, even includes trees, it's just harder to notice). [2] Didn't seem to be a problem when the coordinates were incorrectly converted, but when applying the correct conversion caused some triangles to be flipped (i.e. facing inwards).

You will need to re-extract vmaps and re-generate mmaps for these changes to take effect.

Fixes #417
Rename 2014_07_01_02_world playercreateinfo_skills.sql to 2014_07_01_02_world_playercreateinfo_skills.sql
Core/Skills: Fixed players getting all ranged skills when learning one of bows/crossbows/guns
DB/Skills: Corrected languages for night elves, taurens and blood elves
Core/Spells: Fix Charge pathing

Fallback to "straight path" pathing when raycast doesn't find a valid path.
Fixes #7931
Core/Spells: Improve charge path logic, get a point to the target and then reduce it by the necessary distance
DB/Creature: Fix Abyssal Flamewalker

By mario-64 and dr-j, closes #10699
Merge branch 'master' of https://github.com/TrinityCore/TrinityCore