Have you seen the most famous pick up artists and gurus? All ugly.
Do you think we would need to create an attraction theory, develop seduction and pick up techniques if we were so good looking that all women were naturally receptive to us to the point of coming up to us and saying "fuck me!"? :)
Can you solve problems and pass exams drunk? Then what makes you think that being drunk will make you remember and be aware of all the PUA learnings you have learned? You are shooting yourself in the foot. Go sober! Honestly you are like a formula driver complaining because he didn't win the race while DUI :D
Your buddy has his own reality, his own problems, challenges, and advantages. Don't compare yourself to him. If you want to compare: compare yourself to Brad Pitt. See how hopeless that sounds? Now, compare yourself to the you from yesterday. Compare yourself to the you from yesteryear. How far have you come?
Your body went home with a trashy drunk bar girl. Congratulations. Maybe they will speak 3 words in the morning. And nobody will see each other ever again, unless.. STDs and Pregnancy.
You have the knowledge and (if trained) the skills to approach a sober, classy woman and make her fall in love with you and want to fuck you everyday and every night.
Now get up, drink water for your hangover and stop drinking. You're not a clueless idiot jock who needs the confidence boost from the alcohol to talk to girls. As a budding PUA you are made of confidence. Stop drinking. It will be easier on your wallet too.