Core/DataStores: Changed index on CharStartOutfit.dbc to allow lookups directly using race/class/gender combo instead having to iterate entire store to find the proper entry
Core/Conditions: Implement CONDITION_UNIT_STATE = 21
DB/Conditions: Convert shadowstep spell script in conditions
DB/SAI: Some SAI for aq20. Closes #8866
DB/SAI: Fix a couple errors. Closes #8839
DB/Scripts: Fix a few SAI errors.
Misc: Reorder more scripts in some script files and some cosmetic stuff
Merge pull request #8917 from joschiwald/spellscripts_reorder2

Misc: Reorder more scripts in some script files and some cosmetic stuff
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
Scripts/Misc: Some cleanups