I entered upon ʿAbdullāh ibn ʿAmr ibn al-ʿĀṣ while he was in an orchard of his in Ṭāʾif called al-Wahṭ, and he was restraining a young man from Quraysh who was suspected of drinking wine. He said: I heard the Messenger of Allah ﷺ say, “Whoever drinks wine once, his repentance will not be accepted for forty mornings; if he repents, Allah will accept his repentance. If he returns (to it), his repentance will not be accepted for forty mornings; if he repents, Allah will accept his repentance. If he returns again, it will be a due right upon Allah to make him drink from the mud of al-khabāl on the Day of Resurrection.” The wording is that of ʿAmr.  

دَخَلْتُ عَلَى عَبْدِ اللَّهِ بْنِ عَمْرِو بْنِ الْعَاصِ وَهُوَ فِي حَائِطٍ لَهُ بِالطَّائِفِ يُقَالُ لَهُ الْوَهْطُ وَهُوَ مُخَاصِرٌ فَتًى مِنْ قُرَيْشٍ يُزَنُّ ذَلِكَ الْفَتَى بِشُرْبِ الْخَمْرِ فَقَالَ سَمِعْتُ رَسُولَ اللَّهِ ﷺ يَقُولُ مَنْ شَرِبَ الْخَمْرَ شَرْبَةً لَمْ تُقْبَلْ لَهُ تَوْبَةٌ أَرْبَعِينَ صَبَاحًا فَإِنْ تَابَ تَابَ اللَّهُ عَلَيْهِ فَإِنْ عَادَ لَمْ تُقْبَلْ تَوْبَتُهُ أَرْبَعِينَ صَبَاحًا فَإِنْ تَابَ تَابَ اللَّهُ عَلَيْهِ فَإِنْ عَادَ كَانَ حَقًّا عَلَى اللَّهِ أَنْ يَسْقِيَهُ مِنْ طِينَةِ الْخَبَالِ يَوْمَ الْقِيَامَةِ اللَّفْظُ لِعَمْرٍو  

The Messenger of Allah [SAW] said: "Whoever drinks Khamr in this world and does not repent from that, will be denied it in the Hereafter."  

أَنَّ رَسُولَ اللَّهِ ﷺ قَالَ مَنْ شَرِبَ الْخَمْرَ فِي الدُّنْيَا ثُمَّ لَمْ يَتُبْ مِنْهَا حُرِمَهَا فِي الآخِرَةِ