I would think if you're amongst the tiny percentage of people blessed with enough talent to make it as a professional footballer, and given how short that career is, you would be best advised not to drink alcohol at any time, especially in the modern game. It certainly isn't going to aid your physical fitness or longevity.
Cristiano Ronaldo wouldn't even accept having a sponsors' bottle of Coca Cola in front of him, let alone an alcoholic drink. If you want to be as successful and long-lasting as him, drink "Agua". Then you'll earn enough money by the time you've retired to get p*ssed every day for the rest of your life if you want to!
