DB/Loot: Fix drops of Fragment of Val'anyr

By dr-j, closes #11959.
DB/Seasonal:
* Added missing seasonal quest in game_event_seasonal_questrelation table
* Remove all event = 0 in character_queststatus_seasonal table
DB/Misc: Fix some incorrect triggers

By dr-j, closes #11963
DB/Creature: Fix even more creature templates
DB/Creature: Fix even more creature templates
DB/Creature: Fix even more creature templates
DB/Creature: Fix even more creature templates
DB/Creature: Fix even more creature templates
Core/Texts:
* Fix creautre text with gender female
* Small cleanUp
* ObjectMgr.cpp/ObjectMgr.h part from joschi
Core/Misc: Remove remaining COMPILER_HAS_CPP11_SUPPORT related macros
Core/Battleground: fixed possible crash in BattlegroundSA

Closes #11969
DB/Creature Fix incorrect trigger flags on Enchanted Tiki Warrior

By dr-j closes #11973
Core/Text: Fix typo in 5caf6aad98eba766017b6a3acc04dd0e30086142
DB/Locales: Fix some item locales because items renamed on cata
Closes #11974
DB/Gossip: Fix some gossip stuff
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