Fixed Tiberian Sun harvester under attack notification not playing

This fixes #6671 and documents things better for the future.
"Plays an audio notification and shows a radar ping when a building is attacked.  Attach this to the player actor."