DB/QUEST: Quest a Carver and a Croaker

Closes #3649
I must not forget to add broadcasttext IDS...
DB/QUEST: Healing the lake

Closes #12504
Closes #12526
DB/Waypoints: Pathing for Empoor and Formation for his bodyguard
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