Aright this has been a sticking point for a while now.

I get sex closes with girls i dont care much about or like even. but when it comes to girls I like i end up in the friendzone because i show that i care for them and they take me as the best friend and they guy they trust.

The other night i was with a girl I did like but was with her and another friend. I have been this girls close friend for about 7 years or so. She knows i like her. We were all drinking and my guy friend was actually hitting it off and flirting with her and she was giving back responses too. I was actually really uncomfortable and hurt by the whole thing. The whole night i was basically just there and tried to contribute to whatever they would talk about or tried to lead but they were having so much fun that it over flowed me. I was put aside.

What is something i could do so that this stops happening or what are ways i could save myself in a situation like that? and how the hell do i get out of this friendzone thing i keep getting into with girls i like.?