There are no core rules for the effects of alcohol.

The prestige class you refer to is the drunken master, from *Complete Warrior*. Its drink like a demon class feature increases Strength *or* Constitution by +2, while it decreases Intelligence *and* Wisdom by −2 for each swig the drunken master takes. At 8th level, it gains the spell-like ability *for medicinal purposes*, which turns allows an already-drunk swig to turn into a *potion of cure moderate wounds* for him, undoing the usual effects of that swig from drink like a demon, and healing him the appropriate amount. Please note that [we have a Q&A on the drunken master’s well-deserved reputation for being a terrible prestige class](https://rpg.stackexchange.com/q/48320/4563).

Note that the rules for the drunken master are particular to that class. Characters without that class are not subject to its rules, so none of the things alcohol does, *good or bad*, applies to someone who isn’t a drunken master. As described in [mxyzplk’s answer](https://rpg.stackexchange.com/a/1695/4563), there *are* separate, general-purpose rules for alcohol in *Arms & Equipment Guide*, a 3.0e book that you can use in a D&D 3.5e game, but if doing so in a game with a drunken master, you’ll have to figure out how drink like a demon combines, or overwrites, those general rules for everyone else.