Core/Misc: Fix some static analysis issues

Add some asserts and additional NULL checks as sanity checks.
Core/Misc: Fix typo in f47962f6707bb53a3241d23257a5bbd1b2679f87
DB/Gameobjects: Spring clean up for "TEMP" spell focus gameobjects.

* Added missing spell focus gameobjects.
* Old "TEMP" gameobjects now have sniffs values for their radius and the proper entries.
DB/Gameobjects: Bye bye old "TEMP" Gameobjects...
DB/Misc: Fix startup errors after 8ff8f30 and 33be04d
Revert f79a8813a020991f398fc87a9025bf49f610f1e8
Fix trinkets/talents procs on hots taken/done
Merge pull request #11815 from Unholychick/master

Fix trinket/talent procs on hots done/taken
DB/Gameobject: Fix 2 Gameobjects names after 8ff8f30 and 33be04d
DB/Gameobject: Delete another TEMP gameobject
Merge pull request #8 from TrinityCore/master

TrinrtyCore commits merge