According to the Hadith, the duas of a person who consumes liquor is not accepted for 40 days.

Answer

All intoxicants are haraam. Whilst in the state of intoxication duas are not accepted. However, if one repents, then the duas will be accepted. Even if haraam meat is consumed, duas will be accepted if one regrets and repents. The duas will not be accepted if one does not repent and continues to consume haraam. The 40 days will apply if one does not repent and continues with the ingestion of haraam meat and consumption of liquor, etc. When sober, the person should not abstain from dua. He does not know if he will live for 40 days. His Maut may claim him a day after having consumed the haraam. Hence, he should not abstain from Dua and Istighfaar the moment he has sobered up.