Consoling a friend

[mason55]

My friend and his wife of 9 years got into a big fight last night. He came and stayed over here. He went home this morning and they broke up for good. He's obviously very upset and distraught. He's coming back over here right now. I have no idea what to say or do besides get drunk (my solution for everything). Also, they have an 8 year old that she is taking with her back to her parents house about 12 hours away. Any tips guys? Ideas?

Thanks