<human>: I am a 27 year old male, never had a girlfriend. I had a fling about a year ago where I finally lost my virginity but she lives about 450 miles away and is now back with an old BF. It's a long story but it wasn't just a one time thing, we hooked up multiple times until the long distance thing fell apart, but anyway, that's about the extent of my experience. 

I've been given a ton of advice from many friends and I've noticed a few contradictions. Some say I should be myself, my closest and longest friend says I should stop "brooding and being all dark and mysterious". (In all honesty, I'm AM shy and quiet, partly from fear, partly from humility).
On one hand, people tell me "the right one will come to me" while my BFF says to go be social and find her.
I've been advised to learn from my mistakes (which are numerous), but others say to forget my past.
Along with the whole "right one will come to me", they tell me to not try so hard. But my buddy says to keep trying (but at times even HE says I try too hard).

The one thing everyone agrees on is confidence but I see a flaw in this tactic. Another friend is extraordinarily confident and out going, but his sense of humor is lacking along with his social skills. He meets a lot of girls, but can't really get past a drink or two. My own thoughts are: you can have all the confidence in the world, but if you suck as a human being, it's all for not. Confidence isn't everything, you gotta have a personality that is desirable and easy to accept.

What do I do? Who has the best advice?

Give me a shortened version of the text
<bot>: my closest and most trusted friend's advice goes completely against everything else everyone else says. Confidence is good, but if you're a complete douche, you aren't getting anything.