I am an airline pilot and attorney, although I do not practice aviation law. I strongly agree with the recommendation here that you find an aviation attorney, and AOPA is a good starting point. If you need another source to find a an aviation attorney I can help you with that.

So airline pilots stay away from illegal drugs, and we are very careful with respect to alcohol because they can be career ending decisions. That said, I didn't see you say that there was a final conviction, exactly when the charges were brought, details surrounding the stop and subsequent charges, or anything else about this unfortunate occurrence. It is possible that you were not the only party who made mistakes here, so an aviation attorney would be able to look at the circumstance in its totality to determine what (if any) chance you have to improve your situation from where you think it is right now.

The above is my initial legal thought. As a fellow pilot, and for a major airline, I would look deeply within yourself and have you reflect as to whether decision making is your strength, and whether this event is enough to keep you on course in the future. Professional airline pilots work hard to ensure not only that our flights are in fact safe, but that the public perceives that we are safe. An incident that calls out professionalism or sadety practices will tarnish us as a whole, so unless you are in fact able to meet that standard of ethic I would suggest recreational flying or not flying at all -- regardless of whether you can legally get out of this dilemma. PM me if you don't find an attorney through AOPA and I will provide you a list of aviation attorneys in your region.

Good luck!