Core/Misc: Remove obsolete C++11 backward compatibility macros

OVERRIDE, FINAL, DELETE_MEMBER
Merge pull request #11950 from Dehravor/override-final-delete

Core/Misc: Remove obsolete C++11 backward compatibility macros
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/Battleground: fixed possible crash in BattlegroundSA

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

By dr-j closes #11973