Harrogate man 'out of his mind' on alcohol admits attacking friend