The Prophet ﷺ said, and Muhammad bin Adam reported it as from the Messenger of Allah ﷺ, "Whoever drinks wine and lets it settle in his stomach, Allah will not accept any prayer from him for seven days. If he dies during that time," and Ibn Adam's wording is, "if he dies during those days, he dies as a disbeliever. And if it causes him to lose his awareness of any of the obligatory duties," and Ibn Adam's wording adds, "or of the Quran, no prayer of his will be accepted for forty days. If he dies during that time," and Ibn Adam's wording is, "if he dies during those days, he dies as a disbeliever."
أخبرني محمد بن آدم بن سليمان عن عبد الرحيم عن يزيد ح وأنبأنا واصل بن عبد الأعلى حدثنا ابن فضيل عن يزيد بن أبي زياد عن مجاهد
عن النبي ﷺ وقال محمد بن آدم عن رسول الله ﷺ قال من شرب الخمر فجعلها في بطنه لم يقبل الله منه صلاة سبعا إن مات فيها وقال ابن آدم فيهن مات كافرا فإن أذهبت عقله عن شيء من الفرائض وقال ابن آدم القرآن لم تقبل له صلاة أربعين يوما إن مات فيها وقال ابن آدم فيهن مات كافرا
No references are available.
[Its chain is daif] Tabarani reported it, 12/404, no. 13492, from the hadith of Wasil bin Abdul-Ala, and it is also in al-Kubra, no. 5179, with the wording being Wasil's.Yazid bin Abu Ziyad is daif, confused in his narrations, and a mudallis.