Core/Spell:
Triggered spells now will be cast on the primal target instead of on caster

Close #10853
Close #10860
Core/Movement:Fix waypointed creature aggro
Core/Spells: Fixed Shadowstep taking the caster out of combat while it shouldn't
Make Cyclone and faerie fire unable to pierce cyclone and banish
DB/Creature: Link more creatures with their hard modes

Thx jackpoz by the sql to ease my life!
This will add a flood of startup errors, don't open new tickets, they will be fixed.
DB/Creature Fix even more hard modes values

I have this is annoying thing?
Fix percentage HOTs proccing everything

Unforeseen sideeffect of 057169c21c141f690891c908b8f09e63d917289d
Percentage HOTs are not supposed to proc anything at all.
Closes: https://github.com/TrinityCore/TrinityCore/issues/11914
Merge pull request #11957 from Unholychick/patch-1

Fix percentage HOTs proccing everything
Core/Creature: Addet "possible fix" log for creature_template errors
Core/Creature: Added creature template log for default creature is greater than difficulty creature
Core: Droped `faction_H` field -- only one faction table is necessary
Core/Creature: Missed changes in c536305e3a3c4f41e94d14fae73ba7a2d8d13be2
DB/Creature: Fix even more creature templates
Core: Fix warning
DB/Creature: Fix even more creature templates
DB/Creature: Fix even more creature templates
DB/RBAC: Fix rbac_permissions order
SQL: Update old .sql files to keep consistency with auth_database.sql

Also update characters_database.sql (generated by mysqldump)
DB/Command: Added missing data in 6045c05e0d5390c8d8a3f2d85691f1e37010328a
SQL: Fix typo (thx @cr4st)