Core/Spells: Fixed issues with Death and Decay and similar spells not ticking if players stepping in the AoE are not in LoS with the caster.

Not exactly sure if that behavior should *exactly* be as such, but until more informations ...
Core/Spells: Fix an issue with previous commit (a309ca97279)
Tools/mmaps: Fix a possible mem leak and a compile warning
DB/Creature: Add a lot of missing texts

* Add a lot of missing texts (from sniff) and add sai to use them
* Add to some existing scripts to use texts which where missed from original scripts
Core/Shared: Change rand32 to return uin32 instead of int32

Fixes a crash that happened when rand32 returned negative values.
Also updated some related comments that were outdated since we changed to SFMT.

Closes #12638
Tools/mmaps: Fix build when building only tools

Closes #12631
DB/Misc: Misc fixups in Shattrath
Core/Network: Fix some possible exceptions on socket.close()

Ref #12634
DB/Misc: Misc fixups in Dalaran
Core/Realmlist: Force resolving realm addresses to ipv4

Closes #12640
Core/Network: Fix build
Core: Fix non pch build
Core/Threading: Fixed lock type used in HashMapHolder::Insert - a write lock is needed there, not a read lock
Core/Waypoints: Allow the table waypoint_data to use Takeoff and Land waypoints.
Core/PreparedStatements: Fixed a change I missed in the World prepared statements for waypoints.
Core/DBLayer: Fixed possible crashes with async queries retrieving result

Closes #12655
Added comments to 6961f957c9d03bff634f0b75466458564845722e to make sure noone decides that storing the result in a variable is unneccessary
DB/Waypoints: Add Pathing for Garadar Wolf Riders in Nagrand
DB/Creature Formations: Fix formation error in last commit.
Core/Network: Refactored socket code, moved common operations to base Socket class