Someone who has an undeniably acute addiction to cocaine.
I see Sir Sniffalot has arrived...he looks absolutely clattered.