The 42-year-old had been tipped to become one of the football greats, but eventually succumbed to the pressures of sporting fame and alcohol problems.