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.
Is the one offering the sacrifice liable if its meat spoils?
Praise be to Allah, and prayers and peace be upon our Master the Messenger of Allah.
If the meat (of the sacrifice) spoils due to the negligence of the one offering the sacrifice in preserving it, or due to improper storage, then he is liable to compensate for the portion due to the poor (which is estimated as half a kilogram of meat). If the sacrifice was a vowed (mandatory) one, then he is liable for all of it.
However, if he was not negligent, then there is no liability upon him, because its ruling is the ruling of a trust (like an item left in someone's care). And Allah Almighty knows best.
Is it obligatory to have an intention (niyyah) for every prayer?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
It is obligatory for the worshiper to have a specific intention (Niyyah) for every prayer, meaning they must consciously intend the act of worship they are performing. The intention is a pillar (Rukn) of the prayer, and the prayer is not valid without it. It is not a requirement to utter the intention verbally; rather, doing so is considered a recommended Sunnah. And Allah the Exalted knows best.
Is it valid to perform the obligatory prayer while sitting?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
Standing (Al-Qiyam) while having the ability to do so is one of the pillars (Arkan) of the prayer; the obligatory (Faridah) prayer is not valid without it. However, whoever is unable to stand may pray sitting down. As for voluntary (Nafilah) prayers, it is permissible to pray them sitting even if one is able to stand, but the one sitting receives half the reward of the one who prays standing. And Allah the Exalted knows best.