I have had similar pains for almost 7 years now, I'm 20 years old and the pain is seriously unbearable, I have broken bones, had a toenail ripped off by a small toy train track my grandpa had built for me when I was little, and plenty of other painful experiences but this one is seriously the worst. I have been to the emergency room numerous times and to gastroenterologists. They have not been able to figure out what the problem is yet. They believed that I was lactose intolerant at first, then allergic to gluten, IBS, Crohn's, Ulcers, the whole nine yards. Testing for most of these conditions has already occurred and needless to say none of these have been the culprit of my unbearable pains. I have another appointment to go back after almost half a year with no episodes, I have an idea that Gastric Emptying and Volvulus could be possibilities for not just myself but many of the other concerned posts on this thread.
As for help, I wanted to give my two cents to everyone. I have had pains that cause diarrhea, vomiting (although I think the few times it has occurred is from the pain), dizziness, and weariness that has led to passing out. Rather than sitting on the toilet and waiting for the pain to go away, I urge you all to try sitting in a very hot bath or very hot shower. If nothing else works I can almost always ensure this will help at least a little, I believe it is because the muscles that are acting up and causing pain are relaxed in a hot bath or shower. If all else fails, as dangerous as it sounds, I take enough benadryl to make it so that I cannot stay awake even if I wanted to.
As for additional ways that may not be available to everyone/are not certain people's preference. I have found that working out and breaking a sweat also helps to ease the pain if you are able to add this in your everyday routine. Something a little more out of the box, as ridiculous and un-credible this will make me sound, smoking weed helps. I do not condone this, nor do I smoke recreationally, but I have found that this, under cerain circumstances, also helps to relax the nerves and take some of the edge off of the pain.
I hope that I can at least help someone, because if your stomach problems are anything like mine, you never want to get them again, and coming from someone who has experienced this pain, I hope this helps all of you in the future get past these agonizing nights.