What kind of pills or treatment can somebody get for drug abuse?

Depends on drug. Opiate abuse can be treated with several medications. Alcohol abuse as well, although not as successfully. Several advertised treatments aren't universally accepted. The best treatment for drug abuse is an approach that includes the entire person, looking for underlying causes for the drug problem, 12-step program & drug/alcohol counseling.