Drunk.
Intoxicated (by drugs or alcohol).
(by extension) Disgusting.
(by extension) Damaged or unusable.