Well dear, it seems that you have learned a lesson the hard way. Never lie to a friend and never get involved in a relationship - no matter how much you think you can do to help them.
Realize that this is an experience and don't get involved again like that.
Respect your friends as you would want them to respect you with or without magic.
All you can do now is wait and hope that she forgives you for what you did and make some new friends - but live ones, not chat rooms or messaging..