Why you have to be PARTY MAN? Why you are so pompous about going to some stupid pub/club? Everything you have written so far to this thread seems extremely schizophrenic to me. On one side you are talking how extremely cool, influential and social (the guy knows everybody) people you have around you and on the other hand you are debating whether to even go, and you seem almost scared, for a few hours to some building with people.

Op is obviously a pudgy nerd with a small pecker and will never get laid.

Sorry man you must have gotten something wrong then...Honestly... Where do i say im cool and know everybody? or what makes you say that? Because i said i have contact to a royal family and contacts in the middle east? Thats true. But please...They are like 5000km away from where i live those are not my FRIENDS! I only see them once a year. So whats the matter?
And no im not SCARED to go out... thing is i dont have ANYBODY to go out with since i dont have that many friends. And the guy who invited me to come with him is some guy from work! So thats not a friend either...
I dont know, maybe you got something wrong here...
What do you mean? I have never done it before why cant i be a tiny little bit exited then? Common...

Ok buddy, here's your main problem: You are waiting for your life to get better, but you are not working towards it.

You want friends to call you to hang out?
You want free invitations to clubs?
You want your schedule to be full of things to do that you start choosing which one to prioritize?

GO OUT ALONE. I mean it by all means.
Just go to a bar and order a beer, sit and start socializing.
If you are non-alcoholic, order a redbull or a nonalcoholic beverage.
Just sit and socialize. Even if you didn't talk to anyone from the first time, keep going there. Soon, people will notice you coming and you will AT LEAST start initiating contact with the bartenders and waitresses. Later on, you will start having a wider social circle and people will start calling you or telling you to come with them to a certain place.

Another thing is: DITCH TV. It gets you nowhere, unless you have your private show to watch for an hour daily (that's what I do). Anything more than 2 hours of TV per day is USELESS. Sign up for gym. That way, you get to meet new people + improve your physical appearance more than it already is. I mean by the first month I joined the gym, I got to know around 30 people and most of them want to hang out after the training.

Just find out what suits you and replace non beneficial things with beneficial. Don't wait to do this. DO IT NOW or you'll be stuck like that for the rest of your life. START, don't close this thread and go back to your normal life. START RIGHT NOW. Make your plan for tomorrow, and if you can start right away, it's even BETTER.