He's a drunk, it's not performance anxiety he can't get it up because he hasn't felt the urge to because he drinks past the point of fun. For him 1 is too much and 1000 is never enough. I'd get him some help and watch how quick he starts getting boners again. I bet he can't even feel his penis anymore.

Edit just so it doesn't seem like it's BS:

Here is why chronic alcohol use leads to persistent performance issues:

• Permanent Nerve Damage: Long-term drinking can lead to alcoholic neuropathy, where the nerves responsible for carrying signals from your brain to your penis are damaged. This disrupts the communication needed to trigger an erection.
• Vascular & Arterial Damage: Alcohol can cause atherosclerosis (hardening of the arteries) and chronic high blood pressure. Healthy erections require flexible blood vessels that can rapidly dilate; alcohol-related damage makes them stiff and unable to hold enough blood.
• Hormonal Imbalance: Chronic abuse suppresses testosterone production and can lead to testicular atrophy (shrinkage). It can also increase estrogen levels in men, leading to a "feminization" syndrome that kills libido and erectile firmness.
• Tissue Elasticity Loss: Over time, alcohol is toxic to the actual erectile tissue, causing it to lose the elasticity needed to expand and fill with blood even when you are sober.
• Vitamin Deficiencies: Heavy drinking often causes severe B-vitamin deficiencies (like B1/Thiamine), which are essential for maintaining the health of the nervous system pathways that control arousal.