rope's ended

adj.

Having drunk enough to become both useless and mildly threatening at the loose end.

Source: Wiktionary