Manifesting SP Sobriety

Has anyone manifested sobriety for their SP? I am focused on the guy I love to get sober from alcohol and to cut off his female so-called best friend who enables him such as having him drive drunk. Thank you in advance.