Core/Scripting: Move Boss_Gatewatcher_Gyrokill to c++ scripting. Additional cleanup in Mechanar.
DB/SAI: Hulking Abomination
Core/Tickets: Allow viewing of ticket response(if any) when using .ticket viewid or .ticket viewname.

Fix an sql name.
Core/Script: Pyroguard emberseer

Cleanup while working on #4586
Core/UnitAI: Checks in DoCastVictim

Consider triggered flag and unit state
Scripts/Scholomance: Fix warning
Core/Spell: Gordunni Trap

Casting npc of the trap should not remove the summoned chest on despawn.
Solves #4811
Core/Scripting: More updates to Mechanar
Core/Commands: Fix sql warnings with pinfo at ban players
Core: Fix build
Core/Ticket: Fix unassigned message not showing who was assigned to ticket

Thanks to @Bezo
Closes #8923
Merge branch 'master' of git://github.com/TrinityCore/TrinityCore into teste2