Fix passive pets not using spells when commanded to attack

Closes #8941
Core/SmartScripts: Check Conditions also for timed Events
* some cleanup work in SmartScripts.cpp

Core/SmartScripts: Some Corrections to last commit
Core/Spell: convert more spells to SpellScripts
DB/Misc: Add back flight aura on Wyrmrest Defender.(probably deleted on last template_addon cleanup)

Correct a SAI line for Nerub'ar Broodkeeper.
Core/Log: Allow configuring a maximum file size for a log file. If the file size is about to be exceeded, the core will create a new file titled <oldname>_.log and start outputting there.
Script/Commands: Add command to join an existing group/party.
Typo fix.
Merge pull request #9016 from joschiwald/spellscripts4

Core/Spell: convert more spells to SpellScripts
SQL: Rename SQL merged in PR
Core/DBLayer: Drop support for MySQL versions <5.1

Both server and client libraries must be up to date in order to run TC.
Scripts/Icecrown Citadel: Fixed Essence of the Blood Queen interrupting player spell casts

Closes #8665
Tools: Remove a bit of spam when mmaps_generator loads vmaps
Merge branch 'HEAD' of git@github.com:TrinityCore/TrinityCore.git
Tools/mmaps_generator: Multithreading optimisations. Should save some time generating mmaps.
Fix error when swapping unique equipped weapon on dual wield

Also fix rings and trinkets
Core/DBLayer: Fixed required version definitions
Merge pull request #9045 from krofna/mysql

Fix magic numbers: You meant 5.1 and not 5.10
Core/Log: Rotate logs when maximum size is exceeded, backup name will be "filename".datetime
- This is an addition to 39c2d89
Update src/server/shared/Logging/Log.cpp

Fix crash when the last iter plus and change value
Merge pull request #9037 from krofna/crefixes

Fix error when swapping unique equipped weapon on dual wield