You were legally intoxicated and not in a position to consent to the charges, and the club knew that. They tried to get you to take the drugs as part of a credit card scam. You should absolutely see a lawyer and see what you can do. I would imagine the club would rather refund the charges than get raided and charged with serious drug and fraud crimes.