Wildberry, I'm sorry you're in this place where there seems no way out. I've been there many times too and it is so hard to deal with. All you can do is try and get through the next hour, then the next hour and hope and pray it'll settle down a bit and give you a break.
I'm only on a few basic meds at the moment, baclofen for muscle spasms/cramps etc and endep for the nerve pain. Then I take a variety of vitamins etc. And I take temgesics when I have flareups. They can last a few hours and take the edge off the pain... sometimes! The only thing is most of my flareups are at night, but the temgesic keeps me awake. So I may get the edge off the pain but I'm still up until 4am!
I hope you can find something to help you asap so you can get your head above water again.
x Kate