Ban disposable or spam email hosts

Ban disposable or spam email hosts December 2018 Update

No permission to download

JoyFreak

Formerly Zuse
@JoyFreak
Try this query too:
SQL:
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

Well-known member
@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)?
SQL:
SELECT `reason` FROM `xf_ban_email`
GROUP BY `reason`;
 

JoyFreak

Formerly Zuse
@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)?
SQL:
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

Well-known member
Does this result to more than 5,318 records?

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

alexD

Well-known member
Try this once more:

1)
SQL:
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:
SQL:
SELECT COUNT(*) FROM `xf_ban_email`
WHERE `reason` = 'Ban disposable emails';
 

ElsmarMarc

Member
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

Formerly Zuse
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

Member
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.
 
Top