the sdden pain in stomach caused a vasovagal attack associated with fainting
You did the right thing by sitting ,better would have been to lie down .
the cramps and pain as described may be due to some urinary stone
,may be due to infection .
please consult surgeon and get a clinical examination .Investigations to be done as advised .an urine examination,u s g of abdomen .plain x-ray abdomen will be helpful
for the pain at present you can take some anti spasmodics like dicyclomine
tablets like decolic tab.
But proper treatment to take after a diagnosis is made
Hope you be all right soon .