Hi Jay, welcome to the forum. Have you considered going into a rehab?
At least look into AA meetings around you. You'll get lot's of support here on the forum. People are always willing to help out. Stick around.
Sorry to hear about your friend. Maybe it is a wake up call?