DB/Locales: Fix some item locales because items renamed on cata
Closes #11974
DB/Gossip: Fix some gossip stuff
DB/Creature: Fix Dead Mage Hunter

By dr-j closes #11979
Core/Spells: Fix hots proccing wrong auras

& Partly revert unnecessary changes in 1719e19572bc22463edbcbe4089e68a97019e787
Merge pull request #11981 from Unholychick/patch-1

Core/Spells: Fix hots proccing wrong auras
Core/Misc: Fix static analysis issues