Ban disposable or spam email hosts December 2018 Update

[JoyFreak]

@JoyFreak
Try this query too:

DELETE FROM `xf_ban_email`
WHERE reason = 'Datio/MailChecker';

The latest update should have 5318 entries.

That has dropped it down significantly but it's on 5,493 items now. So not exactly the same. Can you give me the query to run to delete all under 'Ban disposable emails" reason so I can see what is left over and re import afresh.

From your last query.. since im new to all this.. im guessing im needing to run this to do what I asked:

DELETE FROM `xf_ban_email`
WHERE reason = 'Ban disposable emails';

 

[alexD]

@Nirjonadda had me rename the reason a few times.

Can you run the following query and let me know the results it prints (which might be related to this list)?

SELECT `reason` FROM `xf_ban_email`
GROUP BY `reason`;

 

[JoyFreak]

@Nirjonadda had me rename the reason a few times.

Can you run the following query and let me know the results it prints (which might be related to this list)?

SELECT `reason` FROM `xf_ban_email`
GROUP BY `reason`;

Shows only 1 total. "Ban disposable emails ". Must be duplicates or something must have gone wrong.

 

[alexD]

Does this result to more than 5,318 records?

SELECT COUNT(*) FROM `xf_ban_email`
WHERE `reason` = 'Ban disposable emails';

 

[JoyFreak]

Does this result to more than 5,318 records?

SELECT COUNT(*) FROM `xf_ban_email`
WHERE `reason` = 'Ban disposable emails';

5492

 

[alexD]

Try this once more:

1)

DELETE FROM `xf_ban_email`
WHERE `reason` = 'Ban disposable emails';

2) manually ban a new host, e.g. *@007.test, which you then should delete

3) Re-import the list.

4) What is the count of:

SELECT COUNT(*) FROM `xf_ban_email`
WHERE `reason` = 'Ban disposable emails';

 

[JoyFreak]

5318 Thanks.

 

[Ignite]

Here's all the ones i ban, maybe you will add them maybe you won't.

I can provide an XML if you like.

Total: 7,508 -> https://pastebin.com/vNvfCKXc

You could also take a look @ this which is updated quite regularly as well -> https://github.com/martenson/disposable-email-domains/blob/master/disposable_email_blocklist.conf

 

[JoyFreak]

Please add @163.com emails to the list. Thanks

 

[Alpha1]

163.com is the gmail of china. Its not fake email.

 

[ElsmarMarc]

163.com is the gmail of china. Its not fake email.

True, but in my experience @163.com emails routinely bounce or fail so I have gotten 100's of unvalidated registrations and bounce or failed email notices over the last few years. I have no problem with people from China registering, but am not willing to put up with going through all the bounce/failed send notices. Another one I block is @123.com or @126.com (if I remember correctly) because of the same problem.

 

[JoyFreak]

Yes it’s why I suggested it because one registered on my forums and populated it’s profile with a load of spam/advertisement.

 

[ElsmarMarc]

This is a bit off topic, but - I get very little in the way of spam these days. Part of the reason I think is that when I get a spammer I look at key words and censor/ban them when I can. E.g.: I got a lot of fake IELTS stuff for a while (one tried today in fact) so I censor IELTS and I ban it in user names, too. It's not discussed in my forum so censoring it isn't a problem. I got a lot of casino spam for a brief time - I don't know the language they were in but I copied a number of 3 to 4 'word' 'phrases' and put them in spam management (if I remember correctly) and they ceased right after that.

That said - I do have a number of valuable visitors who registered and participated from before banning registrations from there. I contacted each one using Personal Conversation(s) and explained the situation - They all got Gmail addresses and updated their registrations.

 

[surfsup]

Can we get an update please?

 

[JoyFreak]

Sina.com - Not sure if this is disposable. Can someone confirm?

 

[Ozzy47]

Sina.com - Not sure if this is disposable. Can someone confirm?

I don't believe it is a disposable email, it appears to be one of the biggest email providers in China, so presumably a lot of spammers might use it.

 

[JoyFreak]

bigmir.net ?

 

[Ozzy47]

That is a email provider that is used by Russian spammers mostly.

 

[JoyFreak]

Nextemail.net ? Lol

 

[Ozzy47]

Nextemail.net ? Lol

Sure appears to be a junk email to me.