What is the ruling on using moisturizing creams on the skin during the day in Ramadan?
Using moisturizing creams on the skin does not break the fast because they do not enter the body cavity (jauf). Any absorption that occurs through the skin pores does not count as entering through an open passage.
What is the ruling on having an intention (Niyyah) for every prayer?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Intention (Niyyah) is a pillar (Rukn) without which the prayer is not valid. The worshiper must have an intention for every prayer, meaning they must consciously intend the act of worship they are performing. Its timing must coincide with the opening Takbir (Takbirat al-Ihram). It is not a requirement to utter it verbally; rather, doing so is considered a recommended Sunnah. There are three levels of intention:
1-If the prayer is obligatory (Fard): It is mandatory to include the Intent (to pray), the Specification (which prayer, e.g., 'Asr), and the Obligation (recognizing it as a Fard). For example, one should bring to mind or say: 'I intend to pray the Fard of 'Asr.'
2-If it is a voluntary prayer restricted by a specific time or cause (Sunnah Muqayyadah): It is mandatory to include the Intent and the Specification. For example: 'I intend to pray the Sunnah before Zuhr' or 'I intend to pray Duha.'
3-If it is an absolute voluntary prayer (Nafl Mutlaq): It is sufficient to simply have the Intent to pray. For example: 'I intend to pray.'
And Allah the Exalted knows best.
Does passing wind, from the anus without a smell, invalidate prayer?
If a person is certain of having passed wind even if it was with no smell, then both his/her ablution and prayer are invalidated, thus he/she should remake ablution and re-perform prayer.
Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.