Relationships are hard enough without substance abuse. If you have no children involved, I think you need to move on.

I do feel sympathy for your friend, however. He is destined for a lifetime of hell if he keeps going.