What should one who made an intention, at night, to make up for a missed fasting day, but broke his fast on the next day?

One who started making up a missed fasting day, then broke his/her fast without a legitimate reason is considered sinful, and is only obliged to make up for the missed fasting days. And Allah Knows Best.

What is the ruling on staring at the Holy Ka'abah?

All perfecy 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.

Staring/looking at the Holy Ka'abah is an act of worship even if this took place while performing a prayer, since Al-Baihaqee stated that the Prophet (PBUH) said: " Staring at the Holy Ka'abah is an act of devotion." [Sho'aab Al-Imaan]. And Allah Knows Best.

What is the ruling on the cessation of blood after (40) days from delivery, but later continued sporadically during two days of Ramadan?

Once postpartum bleeding (Nifas) ceases, and the woman is certain that it won`t reoccur, then she becomes ritually pure and so she is free to make Ghusl (purificatory bath), pray, and fast. If the bleeding reoccurs before fifteen days from its cessation, and before the end of (60) days after delivery, then the ruling on postpartum bleeding is effective, and her fasting and prayer are null and void, thus she must make up the fasting that she missed and not the prayer during those particular days.

Is it a condition that the meat of the Eid sacrifice should be distributed in order for the sacrifice to be accepted by Allah?

The poor and needy should be given from that sacrifice , even if it be a small portion,(One kilo for example) as raw meat so that they would cook it the way they want. The remainder of that sacrifice is either distributed, eaten, or offered to people in a banquette .