It is narrated from Sayyiduna Abdullah bin Amr bin al-As (may Allah be pleased with them both) that he (peace and blessings be upon him) said: "Whoever abandons the prayer once due to intoxication, it is as if the world and everything in it were taken away from him; and whoever abandons the prayer four times in a state of intoxication, it is a right upon Allah Almighty that He make him drink of tinat al-khabal." It was asked: "What is meant by tinat al-khabal, O Messenger of Allah?" He (peace and blessings be upon him) said: "The pus of the people of Hell."
Hadith Referenceالسنن الكبرى للبيهقي / كتاب الصلاة / 1829
It is narrated from Sayyiduna Jabir (may Allah be pleased with him) that the Messenger of Allah (peace and blessings be upon him) said: "There are three whose prayer is not accepted and whose good deeds do not ascend (to the heavens): the runaway slave until he returns to his masters and places his hand in their hands, the woman whose husband is displeased with her, and the intoxicated person until he becomes sober."
Zuhayr alone narrated it in this way.
Hadith Referenceالسنن الكبرى للبيهقي / كتاب الصلاة / 1830