"Requires a scipt" ? Yeah, I know, I'm lame but it's essential.
create an alcohol-related item (fun fact: chemically, "drinking alcohol" is actually ethanol, the alt fuel that they put in cars)
create a variable, shots, to keep track.
every time you use one of your consumable
items, have a common event attached to it that increases the shots variable by a proportion equal to the "proof" of the drink.
create a condition branch (somewhere) that gives you a warning text after, say, 5 (lightweight! ) then after about 8 insert into another condition branch the command line (either via call script or comment) that advances it to the next cycle. Ha! You blacked out. After you "wake up" have it show a text like "Ugh...what happened? ". Any state changes or effects are up to your own imagination.
This is also handy for those games that have (for whatever reason) contraban, like NARC did. Ha ha. Oh, NARC.