colorscrewed

adj.

The condition of a drinker who has plenty of intention but not the particular means needed to get home.

Source: Wiktionary