I'd avoid going for the weekend if I were you. If your able to go between Mon-Thursday I'd recommend you doing so, much more pleasant experience and less aggro. Otherwise your in for Temble Bar on a Saturday night x100.
It's a nice place, cheap if you drink in the 'local' bars and I found the food to be excellent. The city is best explored on foot and easy to get around (I don't think I went on one tram or bus whilst I was there). It's definitely worth a visit. I went with the missus so I didn't partake in any of the 'dodgy' night scene activities that some men go for . A nutter who works in our building and likes to pay for sex had a great time......... they were doing two for one offers and it sounded sleazy as hell. But hey he was a happy man.