Suggest Remedy For Stomach Pain

I'm a 50-yr. old male. Since I was a child, I get very painful stomach aches at night if I swallowed nasal mucus during the day. The pain is localized on the far right side of my stomach and is often excruciating. It feels like a round ball slightly bigger than a golf ball. It goes away around 4 AM and then returns 24 hours later. This typically goes on for 3 straight nights.