What are the pillars of fasting?
The pillars of fasting are intention and abstaining from all nullifiers of fasting from dawn to sunset.
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.
What is the ruling on swimming while fasting?
Swimming while fasting is disliked (makruh) due to the risk of water entering the body cavity (jauf) through the nose, ears, or mouth, which would break the fast.
Ramadan is a month of tasbeeh (glorifying Allah), not Sibaha (swimming).
Some online stores offer a discount on a customer's first purchase — what is the ruling on creating a new account each time a customer makes a purchase in order to obtain that discount?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
It is obligatory upon a Muslim to uphold honesty in both his words and his actions. Allah the Almighty says {what means}: "O you who have believed, do not betray Allah and the Messenger or betray your trusts while you know." [Al-Anfāl/ 27] And He says {what means}: "O you who have believed, fear Allah and be with the truthful." [Al-Tawbah/ 119]. And the Messenger of Allah ﷺ said: "Whoever deceives us is not of us." (Reported by al-Bukhārī.)
As for creating a new account for the same buyer, the terms and conditions of the website must be observed and respected. If doing so violates those terms, it is not permissible. And Allah the Almighty knows best.