A person in an advanced stage of drunkness and/or intoxication. Used as a derogatory term when talking about the person in general and as an adjective if such a person is nearby.

Someone people turn to when they're sad who makes them feel better.