What is the Du`a (supplication) of Istikhara (guidance prayer)?

O Allah, I consult You as You are All-Knowing and I appeal to You to give me power as You are Omnipotent, I ask You for Your great favor, for You have power and I do not, and You know all of the hidden matters. O Allah! If you know that this matter (then he should mention it) is good for me in my religion, my livelihood, and for my life in the Hereafter, or he said: "for my present and future life" then make it (easy) for me. And if you know that this matter is not good for me in my religion, my livelihood and my life in the Hereafter, or he said: "for my present and future life" then keep it away from me and take me away from it and choose what is good for me wherever it is and please me with it."

In our region in southern Oman, specifically in the city of Taqah, there is a mosque that they say was built hundreds of years ago. This mosque is surrounded by graves, meaning it is in the middle and the graves are around it. People in our area differ, with some considering it permissible and others considering it forbidden to pray there. Moreover, my grandmother saw in a dream that she entered this mosque..."

 

Is it permissible for a woman who is in her confinement to fast upon seeing blood signs that are neither black, nor red ?

Brownish, reddish, and yellowish discharges are all considered confinement until there is no colored discharge which marks the end of confinement. Moreover, the aforesaid woman is prohibited from fasting until she attains ritual purity. And Allah Knows Best.

Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?

If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].