The former striker scored seven times in 40 appearances for Aston Villa - and played in that infamous UEFA Cup game