“He went on a night out with his new football team mates, celebrating the end of their first semester at uni. Devastatingly, he never made it home,” his family said.