Core/Conditions: Implement CONDITION_CREATURE_TYPE - 24
Core/Conditions: Missing grid search support for CONDITION_CREATURE_TYPE
Core/Spells: operate spell correction on SpellInfo store instead of dbc (picked from 77b85b2ea0aec6cd3e545e60e46ac60eebb11e47)
Scripts/Spells: backport some SpellScripts from 4.3.4 branch

- Fix Earth Shield
- Fix Necrotic Touch
- Fix Reflective Shield

Closes #9145, #9163, #9665
Merge pull request #10336 from joschiwald/spellscripts5

Scripts/Spells: backport some SpellScripts from 4.3.4 branch
Core/Spells: add some logs for loading spell_script_names
Core/Spells: load spell ranks for talents from dbc
Merge pull request #10327 from joschiwald/spell_talent_ranks

Core/Spells: load spell ranks for talents from dbc
Core/Commands: Added the rank id to .pinfo for guild data
Merge pull request #10350 from Ascathor/master

Core/Commands: Added the rank id to .pinfo for guild data
Core/Spells: allow to use ranked spells in `spell_proc_event` table (like in `spell_proc` table)
Merge pull request #10331 from joschiwald/spell_proc_ranks

Core/Spells: allow to use ranked spells in `spell_proc_event` table (lik...
Merge pull request #10342 from joschiwald/spellinfo_corrections

Core/Spells: operate spell correction on SpellInfo store instead of dbc ...
Core/Spells: move Death Knights Presences into SpellScripts, fix possible issue after spec change, and fix some startup errors

Closes #10354
Core/Spells: fix uninitialised value
DB/Conditions: Fix gossip condition for Bat Handler Camille <Bat Handler>

Closes #10240
Core/Spells: moved Improved Paladin Auras and Aura Mastery into SpellScripts

Closes #205
Closes #5163
Closes #6809
Closes #7408
Closes #9587
Scripts/Spells: simplified "spell_dk_presence"
Scripts/Spells: Fixed typo in 7678800a9372f9234f0bf29459b46a8514dc59f2
DB/GOs: Spawns of Discarded Soul Crystal for "The Fate Of The Fallen"

Closes #

Signed-off-by: Nay <dnpd.dd@gmail.com>