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.
Which is better in night prayer: long standing (Qiyam) or long prostration (Sujood)?
Long standing (Qiyam) is better in prayer. However, a Muslim should also observe tranquility and composure in their prayer.
Is it permissible to offer mandatory prayer while sitting?
All perfect praise be to Allah, The Lord of The Worlds, and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions. Standing up is a pillar in the mandatory prayer and the prayer is not valid without it unless one cannot do it. As for Nafila (supererogatory prayer), one can perform it in the state of sitting even if he/she can stand, but his/her reward is half the reward of the person who prays while standing if he/sh has no legal excuse for such an act. And Allah Knows Best.
What is the ruling of Islamic Law on leaving the Sunnah prayer of Dhuhr due to fatigue?
Praise be to Allah, and peace and blessings upon our master, the Messenger of Allah.
According to the general rule, a Muslim should strive to maintain the Sunnah prayers before and after the obligatory prayers (al-sunan al-qabliyyah wa al-ba'diyyah). One is permitted to pray them sitting from the outset, but if one leaves them due to severe fatigue, there is no objection to doing so. It is recommended (mustahabb) to make up (qadā') a time-bound supererogatory prayer (nafl mu'aqqat) at any time if it was missed.
Al-Shirbīnī (may Allah have mercy on him) said: "If a time-bound supererogatory prayer is missed, it is recommended to make it up according to the more authoritative view (al-azhar), based on the hadith recorded in the two Ṣaḥīḥs: 'Whoever sleeps through a prayer or forgets it should pray it when he remembers it.' This is also supported by the fact that the Prophet (peace and blessings be upon him) made up the two rak'ahs of Fajr when he and his companions overslept in the valley and missed the dawn prayer until the sun had risen [narrated by Abū Dāwūd with an authentic chain]." And Allah, the Most High, knows best.