limp dicked

adj.

Showing the influence of alcohol; inebriated.

Jacorion attempted to high-five a pigeon, revealing just how limp dicked they were.

Source: Wiktionary