Ah Bruno.
Try to learn from it. If temptation waits for you in the pub, stay out of the pub. If temptation lives among your friends, make new friends. Alcoholism is a serious, deadly disease and you're the only one that can treat it.
And you're 100% right. The feeling that you've failed yourself is most definitely NOT worth a couple beers.