I'm sorry to hear about what you're going through!
In terms of day to day coping, have you spoken at all with a therapist or have you had the opportunity to attend an in person support group?
For me, I'm a person who prefers doing something to doing nothing. However, sometimes you have to just accept that you've done all you can realistically do in a given day. The other challenge is realizing that small decisions made each day are what takes to accomplish big things long term. I bet it's really tough though to think about the long term when you're facing such immediate pain/discomfort.
In terms of alcohol abuse, while I'm not an alcoholic, I certainly used to drink more than I do now. I discovered I really like jogging and LONG showers. You just have to think about things you enjoy, or might and enjoy and give it a try. And, I work a lot (50+ hours a week), so it doesn't give me much time to do much else.
I apologize if I'm not entirely empathetic to your situation, but I hope I'm at least being sympathetic.