water flagged

adj.

A drinker so far gone that a yellow iris becomes an official signal requiring immediate attention.

Source: Wiktionary