dehortered

adj.

Drunk to a degree that turns the drinker into an ineffective dissuader.

Source: Wiktionary