Have you tried looking at the Meet Up app? There are loads of groups for activities that don't involve drinking. Or clubs at your uni/college? Sounds like you could do with having some like minded friends rather than ones who only care about getting pissed!