I have been there. The definition of insanity is doing the same thing over and over again and expecting different results. So going out drinking is a bad idea.
It is going to take awhile of sobriety to gain back your good reputation and to be honest some people won't ever let you live it down. I have had to accept that. Some people won't ever see me as anything different than how I used to be....but that is okay once you do the work your self esteem will get better and you will be content with yourself.