FRIENDS of a man who went missing on his brother’s stag weekend in Hamburg say there have been fresh sightings of a “confused” Scottish man.