stiffshipped

adj.

Drunk to a degree that leaves the lower half settled immovably while friends manage the voyage home.

Source: Wiktionary