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
Scripts/Misc: Some cleanups
SQL: Fix "No newline at end of file" in bf7f58365f5a2b2be24f27b328a66049cb03348e
Core/Battleground: Eye of Storm - Fel Reaver Ruins

Make it possible to deliver the flag at Fel Reaver Ruins which was
impossible before because of a big areatrigger which covered the original
areatrigger for the flag point.

Solves #337. Thanks to @Greymane
Fix codestyle in da21bbe93c219f6122f8f4a04eb5ef3d5210acb9
Once last codestyle change.
Core/Scripting: More cleanup to Mechanar scripts. Added missing doors and handling to instance.
DB/Waypoints: Fix waypoints for Mechano-Lord Capacitus
Scripts/Mechanar:
* cleanup for door system
* Convert mechano lord capacitus in c++
Misc: Reorder more scripts in some script files and some cosmetic stuff
Merge pull request #8928 from joschiwald/spellscripts_reorder3

Misc: Reorder more scripts in some script files and some cosmetic stuff