Klute: the pit of hell, and definitely helped in its hell like appearance by the adjacent 'dirties' aka the Elvet Arch Pizzeria. Go there in freshers week, but then never return is my advice. The dancefloor is smaller than a postage stamp and if you want to dance like sardines then that's up to you. The cheese is better when DJ Robin does it at Planet of Sound.
Studio: went in here once, during freshers week, not been back since but it seemed like a quite a small but nice club. Not my type of music though...but what is my type of music now eh?
Walkabout: overpriced, and scary stairs up to the top level(all walkabouts seem to have this though) but i did see the legend Karl Kennedy there, and three of my housemates saw Hell is for Heroes there.
Planet of Sound: being a veteran of the cheese room now(aka riverside cafe) i can admit that sometimes DJ Robin doesn't always play your requests but being a rock man at heart he likes to play some obscure ones from time to time! It's not always the music that makes it though for me, it's the company and the trick with Planet is to go in a large group.
Pubs: my recommendations are as follows!
Ye Olde Elm Tree: fantastic pub, not as cheap as the Swan and Three or the Colpitts but go for the quiz. You will be hooked.
The Colpitts: often filled with old men leaning on the bar looking at the Northern Echo, but cheapest pub in Durham. Sam Smiths 1.24 a pint, it has a good pool table too. You do get students in here though, so don't be afraid!
The Swan and Three Cygnets: Lots of little rooms, quite packed on a sunday night but another good place to get Sam Smiths cheaply(1.34 a pint).
The Victoria Hotel: Fantastic selection of ales, friendly landlord, opposite Ricardos on Hallgarth street. They have several different rooms, and one round the back hidden and very old wallpaper. This does seem to be the place(along with the Half Moon and Dun Cow) where lecturers also drink.
The Woodman: My local this year, cracking pub with a landlord who is friendly to students, not as cosy as the Elm Tree pub there is a good pool table and quality ales from the Durham Brewery.
Steer clear of pub wise:
The Fighting Cocks: unless you want to get beaten up
Any chain pubs(apart from Wetherspoons as they have cheap curries and cheap ale)
The New Inn: why?
The Garden House: its stuck up the top end of North Road and is very expensive and just seems a bit stuck there and boring. Also, from an experience from a friend who lived right next door to it, you have to wait ages for food.