As far as your friend goes, you're sol. My suggestion to try to shake it off sooner than later b/c unless you're ready to buying into the nifty idea of straight guys falling left and right for their gay friends (which I don't think you are), this is gonna ruin you. Your time in school's limited and these couple years are gonna go by faster than you think and what Cia said is right, you're gonna make tons of friends and have tons of opportunity with other guys who ARE willing and even if it's not obvious they are, part of the fun (at least to me) is figuring it out and playing some of that guessing game....but unless you are willing to get over your friend and move forward, none of that will happen or you'll be with someone else and not having fun cuz all you can think about is your friend and that's shitty.
As far as straight guys go, and I know it's not what you're talking about but since a couple of people have spun the topic in that direction...idk what kinda school you go to but the whole "straight guy" being influenced to go gay for now thing is so undeniably over-fantasized it's as unrealistic as it comes, esp with the whole alcohol things. Not saying I have the best grasp on those situations but in my experiences i have yet to get anyone straight or gay to do anything with me under the influence of alcohol but that also may be because if I'm around people who are intoxicated, I am too, and when I'm drinking I always end up just having fun and eventually pass out or whatever instead of using the opportunity to start hitting on people and I'm not one of those people who absentmindedly hit on guys cuz one I'm not out, two, I cant get it up drunk anyways....The only times I've ironically gotten some indication of possibility or even had things happen were under sober conditions of mutual agreeability that this is just for fun, just experimental, just "to see', etc etc blah blah and if you play your cards right, these kinda guys will come your way too, especially since you're in the sports world where camaraderie is high and people trust each other, especially if you're openly gay...but don't go looking for it or push for it or you'll get a bloody mouth, let it come to you.