Core/Items: Fix logic in Player::AddItem

Should send client the amount it gave you, not the amount it couldn't
give you
Scripts/Icecrown Citadel: Improvements to Shadowmourne quest line
Core/Auras: Always run all script hooks attached to the aura to prevent leaving aura script state stack in unbalanced state
Remove BOM from 2 SQL files

Closes #9233
Core/Vehicles: Fix another crash

Don't set Unit::m_vehicle until VehicleJoinEvent::Execute
declared WEATHER_STATE_FOG
Core/Auras: Restore part of 1845ab79 that was accidentally reverted
Update src/server/game/Weather/Weather.cpp