Mate you have my sympathies...Been there bled a little, well a lot..
I got mine about 10 years ago while working in a kitchen were the usual beverage was coke, lots of it.
I was also working in a night club, the only clear fulids i would drink was contreau. I would have a few drinks every weekend, but, not heaps, just 2-3 a night, as i prefered to dance rather than drink outside of work hours.
I drank very little water, maybe 2L of milk a day, plus heaps of coke, lots of exercise ( no car just bike)
I got some pretty severe pain, mostly as the stone passed through the prostate ( as a guess) had a constant need to piss, When i got to the hospital just after it got really bad, I filled a sample cup with bright red piss..The pain was nasty, and lasted for about an hour. Its a awful feeling and were it is makes it soo much worse, either bent up or strait, or walking it just comes in waves, and not much you can do.'
After much swearing and making an ass of myself A nice male nurse came in, stuffed an analgesic suppository in my ass, and the pain subsided within 10minutes.
One of the first questions they asked was how much coke do I drink, than how much water do I drink..
I could still feel them present for months after, and was very tentitive to completely empty my bladder, I did feel a few smaller ones pass through, it was a matter of just grit the teeth and force it out quick, didnt want them getting stuck..
I now rarely touch coke, maybe once every 3-4 months maybe, I hate the taste now.
I drink 2L of water a day at least.