Abdullah bin Umar reported,

I heard the Messenger of Allah ﷺ say, "Whoever drinks wine, his prayer will not be accepted for forty nights. If he repents, Allah will accept his repentance. If he drinks it a second time, his prayer will not be accepted for forty nights. If he repents, Allah will accept his repentance. If he drinks it a third time, his prayer will not be accepted for forty nights. If he repents, Allah will accept his repentance. If he drinks it a fourth time, his prayer will not be accepted for forty nights, and if he repents, Allah will not accept his repentance, and it will be Allah's right to make him drink from the mire of khabal."Someone asked, "What is the mire of khabal?"He replied, "The pus of the people of the Fire."

Azami 7461

Sahih

عن ابن عمر قال

سمعت رسول الله ﷺ يقول: من شرب الخمر لم تقبل له صلاة أربعين ليلة، فإن تاب، تاب الله عليه، وإن شربها الثانية لم تقبل له صلاة أربعين ليلة، فإن تاب، تاب الله عليه، فإن شربها الثالثة لم تقبل له صلاة أربعين ليلة، فإن تاب تاب الله عليه، فإن شربها الرابعة لم تقبل له صلاة أربعين ليلة فإن تاب لم يتب الله عليه، وكان حقا على الله أن يسقيه من طينة الخبال. قيل: وما طينة الخبال؟ قال: صديد أهل النار

الأعظمي 7461صحيح
Contents
Reference
Commentary
Ayat
Collection
Jami al-Kamil
Book
Drinks
Section
Discouragement from drinking wine
Numbering
Jami al-Kamil 7461 (2nd edition)
Azami 7461