Core/Misc: Remove remaining COMPILER_HAS_CPP11_SUPPORT related macros
DB/Creature: Fix Dead Mage Hunter

By dr-j closes #11979
Core/Spells: Fix hots proccing wrong auras

& Partly revert unnecessary changes in 1719e19572bc22463edbcbe4089e68a97019e787
Merge pull request #11981 from Unholychick/patch-1

Core/Spells: Fix hots proccing wrong auras
Core/Misc: Fix static analysis issues
Core/Auth: Add support for build 13930 of china

By phoenixfight closes #11978
Core/Spells: Correct a mistake in HOT aura procs

A crash fix was added in 3e0d2e49448ae5d53baefa0ef3b2df4542aae1dd
but the usage of spellProcEvent itself was incorrect, we should instead use spellProto of aura to be procced
DB/Creature: Remove trigger flags from Dead Caravan mobs

By phoenixfight, closes #11986
DB/Gossip: Fix some gossip stuff
Merge pull request #11984 from Unholychick/patch-1

Core/Spells: Correct a mistake in HoT aura procs
Merge pull request #11968 from Dehravor/cpp11

Core/Misc: Remove remaining COMPILER_HAS_CPP11_SUPPORT related macros
Core/Misc: Fix exploit

Fix exploit that allowed to duplicate stackable splitable items. If the item that cast the spell can't be found anymore, the spell is cancelled.

Fixes https://github.com/TrinityCore/TrinityCore/issues/11977
DB/Creature: Remove Trigger Flags on Chaotic Rift

By dr-j, closes #11988
DB/Quest: Prepping the Speech

By untaught, closes #11348
DB/CreatureTexts: Set some creature_text field BroadcastTextId to 0 because change on cata/mop
Core/Misc: Fix exploit

Fix exploit that allowed to learn spells from recipes without consuming them.
Core/Misc: Fix warning
DB/Creature: Remove more incorrect trigger flags

By dr-j, closes #11995 
Closes #7744
DB/Creature: Add some missing spawns in HoL.
Fix import