Hi,
I'm only a couple of days in but what worked was admitting I had a major problem and giving myself a100% commitment not to drink or take drugs ever again, whatever happens.
If you don't ever want to be that person who got too drunk at the party again then say enough is enough, I'm never going to drink again *whatever* happens.
I did this with smoking tobacco 15 years ago & it worked (although I've managed to get messed up on just about every other substance since then) - but stuck to the never smoking tobacco as I'd made this promise.
Now I've had to make the same promise for drink & drugs before something terrible happens.
I'm no expert, I'm not saying this is right for you or anyone else, but I'm just saying it seems to be the only psychology that works for me.
I think SMART recovery works on this a bit.
Good luck