What is the ruling on swearing an oath by the Prophet ﷺ, and does such an oath take effect according to Imām Aḥmad ibn Ḥanbal, requiring expiation upon its breach?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
Swearing an oath by a created being is disliked (makrūh) in our Shāfiʿī school. Shaykh al-Islām Imām al-Nawawī, may Allah have mercy upon him, states: "Swearing by a created being is disliked — such as swearing by the Prophet, the Kaʿbah, Jibrīl, the Companions, or the Prophet's family. Al-Shāfiʿī, may Allah have mercy upon him, said: 'I fear that swearing by other than Allah the Almighty may constitute an act of disobedience.' The scholars of the school explained this to mean: that is, something forbidden and sinful — indicating that he had some hesitation in the matter. Al-Imām stated: the established position of the school is that it is categorically not forbidden, but rather disliked. Furthermore, whoever swears by a created being, his oath does not take effect and no expiation (kaffārah) is required if he breaks it." [Rawḍat al-Ṭālibīn wa ʿUmdat al-Muftīn, Vol. 11/P.6]
According to the Ḥanbalī school, however, expiation becomes obligatory upon one who swears by our master the Prophet ﷺ and then breaks his oath. Imām al-Bahūtī al-Ḥanbalī, may Allah have mercy upon him, states: "No expiation is required for swearing by other than Allah the Almighty, even if the oath is broken — because expiation was made obligatory for swearing by Allah and His attributes, out of reverence for His names, and nothing else is equal to Him in this regard... except in the case of swearing by our Prophet Muḥammad ﷺ, for expiation becomes obligatory when one swears by him and then breaks the oath. This was explicitly stated in the narration of Abū Ṭālib, because he is one of the two conditions of the two testimonies of faith by which a disbeliever becomes a Muslim. Ibn ʿAqīl held the view that swearing by any of the other prophets, peace and blessings be upon them all, carries the same ruling." [Sharḥ Muntahā al-Irādāt, Vol. 3/P.441]. And Allah the Almighty knows best.
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.
Should the Zakah (obligatory charity) giver tell the poor recipient that this is the Zakah of his money?
No, he shouldn`t. But, the Zakah giver should make an intention in his heart that it is the Zakah of his money when paying it to the poor. And Allah Knows Best.
What is the ruling on eating or drinking during the second Adhan?
It is not permissible to eat or drink during the second Adhan because it announces the break of dawn and the obligation to start fasting. Allah Almighty says {what means}:"and eat and drink until you can discern the white streak of dawn against the blackness of night." [Al-Baqarah/187].
Whoever eats or drinks during this time invalidates their fast, and they must refrain from eating for the rest of the day and make up for the missed fast later.