Stayed there as I was attending a conference in York not too long ago. Be prepared for a pleasant shock as you enter the bar. It's a little bit more upmarket than I remember it.
Sadly this wasn't on a Friday so can't comment on Happy Hour but the studes we spoke to were a very welcoming bunch.