A drunk man climbed out of a window and onto a roof - before damaging a drainpipe he tried to cling to as he fell to the ground.