Abdullah bin Amr bin As reported,

The Messenger of Allah ﷺ said, "Whoever drinks wine and becomes intoxicated, his prayer will not be accepted for forty mornings. If he dies, he will enter the Fire. But if he repents, Allah will accept his repentance. If he returns to drinking and becomes intoxicated again, his prayer will not be accepted for forty mornings. If he dies, he will enter the Fire. But if he repents, Allah will accept his repentance. If he returns yet again and drinks and becomes intoxicated, his prayer will not be accepted for forty mornings. If he dies, he will enter the Fire. But if he repents, Allah will accept his repentance. If he returns once more, it becomes binding upon Allah to give him to drink from the Radghat al-Khabal on the Day of Resurrection."They asked, "Messenger of Allah, what is Radghat al-Khabal?"He replied, "The pus discharged by the people of the Fire."

Azami 7456

Sahih

عن عبد الله بن عمرو بن العاص قال

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

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