Core/Tickets

* Fixed .ticket complete command not marking tickets as completed
* Fixed "Need more help" button functionality after ticket has been answered by a GM

Closes #9383
Core/GameObjects: SMSG_DESTRUCTIBLE_BUILDING_DAMAGE needs to be sent for destructible building heals as well
Core/Spells

* Removed area MiscValue check for spells with SPELL_EFFECT_BIND, it's purpose is only to be sent in packets, not determine real area player will be bound to.
* Corrected guid sent in SMSG_PLAYERBOUND, it should be caster's guid, not player's
* Also updated position for Teach: Death Gate

Closes #9661
DB/Quests: Fix: The Focus on the Beach, Atop the Woodlands, The End of the Line

Closes #367 #1848
Allow use effectIndex in spell_target_position.
Merge pull request #9790 from vlad852/master

spell_target_position - allow use effectIndex
Core: Declare some functions const and remove use of "using" directive in a couple of files
Core/Logging: Performance-related tweaks to logging system
    All sLog->out* functions (except outCommand atm) are replaced with TC_LOG_* macros.
    Memleak fix
Core/Spells: Manually reverted 8dea73fc83ed00764e03c6ee3bb7c1ffa28527eb.

Will have a closer and better look later.
Core: Fixed windows compile
Core/Debugging: Marked assert functions as non returning
Scripts/Ulduar: Yogg-Saron

Known issues:
- encounter doesn't start immediately after you enter the room, you need to go closer
- players standing outside of the room are not turned Insane after 15 seconds
- encounter resets if the last living player is gripped by Constrictor Tentacle or encased in Hodir's Flash Freeze
- Hodir won't freeze multiple players when they die at the same moment
- Flash Freeze missile (64176) won't hit anybody, probably cast too soon (cosmetic issue)
- there are some unused spells, don't know when or why they should be cast
- some spell animations hit multiple players, but they shouldn't do that
Merge pull request #9690 from horn/yogg_saron

Scripts/Ulduar: Yogg-Saron
Core/Commands: Improve .damage command, now can damage destructible gameobjects => ".damage go <guid> <damage>"
Merge pull request #9799 from xjose93/DamageGO

Core/Commands: Improve .damage command, now can damage destructible gameobjects => ".damage go <guid> <damage>"
Scripts/Ulduar: Fix warnings
Merge pull request #9800 from horn/yogg_saron

Scripts/Ulduar: Fix warnings
Revert "SQL: Fixing C++ script errors."

This reverts commit 62bd4ba6deb4abc2b541a4aba09d3947ae8abb46.
Revert "Core: Adding Gunship Battle to the project. DB: Adding Gunship Battle SQL scripts"

This reverts commit 4c8bf8ef7a1cde4febedbfbfb28b168d4972ee8b.
Merge branch 'master' of https://github.com/TrinityCore/TrinityCore