It wasnarrated from 'Abdullah bin 'Amr that the Messenger of Allah(ﷺ) said:
"Whoever drinks wine and gets drunk, his prayer willnotbe accepted for forty days, and if he dies he will enter Hell,but ifhe repents, Allah will accept his repentance. If he drinkswine againand gets drunk, his prayer will not be accepted for fortydays, and ifhe dies he will enter Hell, but if he repents, Allahwill accept hisrepentance. If he drinks wine again and gets drunk,his prayer willnot be accepted for forty days, and if he dies hewill enter Hell, butif he repents Allah will accept his repentance.But if he does itagain, then Allah will most certainly make himdrink of the mire ofthe puss or sweat on the Day of Resurrection."They said: "O Messengerof Allah, what is the mire of the pus orsweat? He said: "Thedrippings of the people of Hell."
English reference: Vol. 4, Book 30, Hadith 3377
Arabic reference: Book 30, Hadith 3502