The Holiday Season (http://out-there.livejournal.com/794718.html?format=light) by out_there. PG, John/Rodney. John has a hangover at some point, and he's not remember what happened to him ;).
I know you're asking for John being drunk, but he is so cute when he's taking care of a drunk Rodney in Sproing and Sproing II. I don't have the addys but I'm sure someone will. They're adoreable!
The livejournal link did not work for me, so I found the stories at wraithbait. Link here: http://www.wraithbait.com/viewstory.php?action=printable&textsize=0&sid=12781&chapter=all
The brand spankin' new sga_santa fic Under the Influence (McKay/Sheppard, PG13) (http://community.livejournal.com/sga_santa/316785.html) has John inebriated on Pegasus tea.
Also, the wonderful Where You Want To Be (http://semivowel.livejournal.com/2757.html) by semivowel has a cute scene with John accidentally getting sloshed offworld.
I just found: Sex With Your Drugged Team Leader: Is It Really Such A Bad Idea? by imperfectcircle http://archiveofourown.org/works/42856 (though not completely fitting, because not alcohol-abuse, but some compromising behavior and hangover afterwards)
and found (again): Equinox by Punk http://www.wraithbait.com/viewstory.php?sid=11206 (John wanders off drunkenly and has to be freed from the grip of... flowers :). )
(If high on alien drugs counts too, there is also Contact High by chelle, with a funny-high John turning horny, McShep http://chelle.slashcity.org/atlantis/contacthigh.shtml )
no subject
Date: 2010-12-22 09:15 am (UTC)no subject
Date: 2010-12-23 07:39 am (UTC)no subject
Date: 2010-12-22 09:20 am (UTC)no subject
Date: 2010-12-23 07:39 am (UTC)no subject
Date: 2010-12-22 09:26 am (UTC)Credentials (http://archiveofourown.org/works/82668?view_adult=true) by thegrrrl2002
no subject
Date: 2010-12-22 10:26 am (UTC)no subject
Date: 2010-12-23 07:29 am (UTC)no subject
Date: 2010-12-22 12:58 pm (UTC)no subject
Date: 2010-12-23 07:25 am (UTC)no subject
Date: 2010-12-23 07:47 am (UTC)http://aesc.livejournal.com/302787/html
I'll try to find the other one.
link for sproing 1 and 2 at wraithbait
Date: 2010-12-25 11:00 pm (UTC)http://www.wraithbait.com/viewstory.php?action=printable&textsize=0&sid=12781&chapter=all
Re: link for sproing 1 and 2 at wraithbait
Date: 2011-01-11 07:29 am (UTC)no subject
Date: 2010-12-22 12:59 pm (UTC)no subject
Date: 2010-12-22 01:27 pm (UTC)no subject
Date: 2010-12-23 07:24 am (UTC)no subject
Date: 2010-12-23 07:24 am (UTC)no subject
Date: 2010-12-22 04:45 pm (UTC)no subject
Date: 2010-12-23 07:22 am (UTC)I present to you the epitome of cute, fluffy McShep.
Date: 2010-12-25 10:21 pm (UTC)http://community.livejournal.com/mcsmooch/87680.html#cutid1
Re: I present to you the epitome of cute, fluffy McShep.
Date: 2011-01-11 07:30 am (UTC)no subject
Date: 2011-01-03 06:43 pm (UTC)Sex With Your Drugged Team Leader: Is It Really Such A Bad Idea?
by imperfectcircle
http://archiveofourown.org/works/42856
(though not completely fitting, because not alcohol-abuse, but some compromising behavior and hangover afterwards)
and found (again):
Equinox by Punk
http://www.wraithbait.com/viewstory.php?sid=11206
(John wanders off drunkenly and has to be freed from the grip of... flowers :). )
no subject
Date: 2011-01-11 07:11 am (UTC)no subject
Date: 2011-01-19 10:37 am (UTC)(If high on alien drugs counts too, there is also Contact High by chelle, with a funny-high John turning horny, McShep
http://chelle.slashcity.org/atlantis/contacthigh.shtml )