Scripts/Halion: Fixed Soul Consumption's pull effect.

Thanks to Winterfell for pointing out the issue.
Core/Entities: correct creature damage, offhand damage should work too
* todo: some creatures need dmg_multiplier update in creature_template
Merge remote-tracking branch 'TrinityCore/master'