Alright OP, if you're not trolling, I will give you some advice. If you are, then the following might help someone else.
The people who you call "friends" are not your friends. And I think you understand that. The more important part of this is to convince you that they are actually not your friends. Denial is a bitch of a thing. What you need to do is to stop hanging out with them.
It's hard to do for sure, since you "got no one else". But "to make the best of it" sounds like you're in an abusive relationship. Which you are. It's toxic and it's detrimental, not only emotionally, but also to your confidence. They make you feel worthless, so why waste your time with them?
Other problem is, you go out clubbing when you clearly do not want to. You're the type of person who would rather go enjoy a beer or a quiet night out with a group of close friends and have a more intimate and fulfilling time than something shallow like hitting on girls and what have yous at the clubs.
I'll tell you something user, I've been there and done that, and at the end of the day, having a good beer with people who care about you is a lot more enjoyable and time better spent than going to the clubs with a bunch of people who give no shit but themselves.
How to get these close friends then? You need hobbies. Get into some hobbies that will not only help you shift your focus to doing "things", but also help you physically and mentally. This is your distraction, only it'll help you a lot more in the long run. Let me tell you why.
>First, people who have more than one dimension are more fun and enjoyable to be around because they can talk about a multitude of things. They are, essentially, more interesting.
>Second, having hobbies make you seem like you can manage your time with or without friends. This makes you seem like a confident person in the eyes of others. That you don't necessarily rely on others to have a fulfilling time.