What Dee74 said - as long as you are breathing, you have another chance.
The shame and guilt and regret about missing your child's event - you do not have to experience that again. One day, one breath, at a time, don't pick up the first drug.
Maybe go to a meeting, whether in person or online, and keep coming here.