What a sad story of your friend. Sometimes life puts you on the wrong path and it's often hard to get yourself back in the right track.
And how you can help... Be there as a friend. You can try to convince him that life can be nice, but he has to admit he has a problem and he must be willing to change it. If he isn't committed to quit drinking it won't happen. And unfortunately you cannot do anything about it.
It sometimes helps to get someone out of his environment. The place on the photo's doesn't look like a cheerful place. But again... he is the one that needs to turn the switch.