This happens sometimes with alcoholics when they are withdrawing. Some have an easier time than others do. He is probably combative toward the nursing staff and that is why his feet/hands are restrained.
I'm a nurse, so I konw all about this. He is probably getting something like Valium IV or Ativan IV for his withdrawals.
I hope he gets better soon. He's at high risk for getting pnuemonia being bedridden, etc.
You can talk to a case manager or social worker at the hospital, they should be able to help you with some resources for him, like alcohol rehab, etc.
Sounds like a really bad situation. Sorry you are having to get involved again.