Long ass post about going from a super AFC to a newbie PUA with no idea how to socialize

Basically from the age of around 14-17(Im 17 now), I spent almost all my time playing World of Warcraft and other video games alot. Like extreme amount of hours per week(In the summer I would spend more time on the computer than I would outside trying to be social) So basically throughout my whole high school life I sat at home on friday nights playing video games because video games couldn't reject me from having fun. So I slowly started to transition from video games to trying to get pussy, I thought it would be as easy as going out on a friday night, hanging around girls enough they will want to jump on me right? from 15 to 16 I would go out on a friday nights, attempting to get pussy(hanging around people that are drinking, etc etc) This made me very good friends with these chicks, but all they saw me was just a friend or a tool to get what they want. Around the last summer I moved into an town house complex, a few days later i found out this kid at my school is my neighbor, turns out hes a huge player( To the point where pussy just falls in his lap) I befriend him, every once in awhile we would chill on friday nights(go have drinks with the hottest girls in my school/other schools) This built up my network of hot girls i know from 0 to about 10-12 extremely hot girls. I got their phone numbers, turns out this one super HB turns out to me my neighbor. We start walking to starbucks and having a chat, thinking she likes me, etc. Im thinking she likes me because im pretty much socially retarded, nothing really comes of it, I still know these chicks but nothing really has come from it even though they are extremely hot. Discouraged that I could not get these chicks I got down on my luck, got really depressed. Started playing more and more video games. Eventually found out about the game, read it fully. Figured out there is a solution to all my depression, teen angst, lonelyness. Start digesting what I learned from the game, built up my confidence only to get it knocked down my kids at my school.I started watching shows like keys to the vip, reading these forums, watching my buddy pull chick after chick. I realized from all of this is from me having no social network and that Im socially retarded, spending 3 years sitting at a computer night after night with no social contact with anyone other than school and friday nights. One of the reason I never really pursued friendship was it was much easier to sit at home and play videos games, they are simple to turn on and off, they dont get pissed at you, they dont make fun of you. So ive slowly built up a resistance against these people making fun of me, now ive got a fairly rock solid confidence. Now to get any pussy I need friends to hang out that attract women and we can all be happy and have some fun and all chill.

The thing is i know nothing about the social dynamic, I basically wasted 3 years sitting at a computer that could of been spent learning how to be a social person. Tell me what the object of making friends is? Tell me why you do it? Tell me what will make people enjoy spending their time with me?(God this is depressing, whatever)