Core/Misc: Fix exploit

Fix exploit that allowed to learn spells from recipes without consuming them.
Core/Misc: Fix warning
DB/Creature: Remove more incorrect trigger flags

By dr-j, closes #11995 
Closes #7744
DB/Creature: Add some missing spawns in HoL.
Fix import
[TW] Core/Spells: Los for few aoe spells

- Blizzard, Rain of fire, Hurricane and Volley, now checks targets are
in los of the center of the spell
- Bladestorm now goes through normal effect los check
- Shadowfury and Flamestrike targets selected from los of center of
spell and not the caster
- Flamestrike persistent damage only target players in los of center
Scripts/Ulduar: Fix crash when Algalon's Big Bang is casted by player
Merge pull request #12000 from Dehravor/algalon-big-bang

Scripts/Ulduar: Fix crash when Algalon's Big Bang is casted by player
Core/GameObject: Solve some TODOs related to traps in GameObject::Update and improve logic.

Some more changes, TODO solutions and a fix for traps like those in #1359 or #6388 will follow.
Fix indention from changes in previous commit.
Merge pull request #28 from gecko32/TCSPELL

[TW] Core/Spells: Los for few aoe spells
[TW302] - Core/Scripts: Ulduar - add a probably futile check that 'may' fix Hodir's encounter state not being set properly after completed

as Reset() is called when he turns friendly
Core/Gameobject: Added missing break in 24ef7dbdf4b76d312cb1df44958c6ccc79bf75f4
Core/GameObject: Format comments and apply rename of previous commit.
Core/GameObject: Store unit in GameObject::SetLootState - required for trap activation.
Core/GameObject: Add missing initialization of m_lootStateUnit
Core/Misc: Fix enchants broken in 3aca9e64b34baee781f402c3f33ad7ee7991c232

Compare cast item entry instead of checking cast item spells to fix the exploit mentioned in 3aca9e64b34baee781f402c3f33ad7ee7991c232 without breaking any functionality.
Core/GameObject: Finish moving activation code of traps to GO_ACTIVATED

Fixing #6388 should be easier now...
Core/GameObject: Fix crash added in c6bf7e0b1d615a22c2145c6f4a757a10a9eca92c

Thanks @jackpoz
Remove unnecessary check in previous fix