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, and if he dies he will enter the Fire. But if he repents, Allah will accept his repentance. If he returns to it and drinks and becomes intoxicated again, his prayer will not be accepted for forty mornings, and if he dies he will enter the Fire. But if he repents, Allah will accept his repentance. If he returns to it once more and drinks and becomes intoxicated, his prayer will not be accepted for forty mornings, and if he dies he will enter the Fire. But if he repents, Allah will accept his repentance. If he returns to it yet again, it will be Allah's right to make him drink from the Radghat al-Khabal on the Day of Resurrection."They asked, "Messenger of Allah, what is the Radghat al-Khabal?"He replied, "The pus that flows from the people of the Fire."

Ibn Majah 3377

Sahih

حدثنا عبد الرحمن بن إبراهيم الدمشقي حدثنا الوليد بن مسلم حدثنا الأوزاعي عن ربيعة بن يزيد عن ابن الديلمي

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

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

ابن ماجه 3377صحيح
Contents
Reference
Commentary
Ayat
Collection
Sunan Ibn Majah
Book
Drinks
Chapter
Whoever drinks wine, his prayer will not be accepted
Numbering
Darussalam 3377
Ibn Majah 3377