Ban disposable or spam email hosts

Ban disposable or spam email hosts December 2018 Update

No permission to download

alexD

Well-known member
I've merged both lists for this update. I didn't find any false-positives in them, so both should be OK.
 

Assadi

Well-known member
Props for not blocking Yandex. Too often people blanket ban just about every Russian email provider.
 

Nirjonadda

Well-known member
Oh my, thank you for highlighting that. Just a silly typo.


I have a yandex developer account myself, which I created when I was still in college. It's got a great TTS API.
New update will be adding Reason https://xenforo.com/community/resources/ban-disposable-email-hosts.5939/ but before Datio/MailChecker the Reason. Its not looking nice. Please fix this issue.
 

alexD

Well-known member
The reason it was changed from Datio/MailChecker is because MailChecker is not the only source anymore.
I couldn't find a better name, so I simply added the URL of the resource as the Reason. I might change it again to something more eye pleasing in the next update.
 

Nirjonadda

Well-known member
The reason it was been changed from Datio/MailChecker is because MailChecker is not the only source anymore.
I couldn't find a better name, so I simply added the URL of the resource as the Reason. I might change it again to something more eye pleasing in the next update.
Yes but not add long title or add link inside the title. Does auto update/change old title with new update?
 

alexD

Well-known member
You can manually delete any records that match the old xf_ban_email.reason value and then re-apply the new update.
SQL:
DELETE FROM `xf_ban_email`
WHERE reason = 'https://xenforo.com/community/resources/ban-disposable-email-hosts.5939/'
Even though that is just a cosmetic change, it will result to a more homogeneous result.
 

Nirjonadda

Well-known member
You can manually delete any records that match the old xf_ban_email.reason value and then re-apply the new update.
SQL:
DELETE FROM `xf_ban_email`
WHERE reason = 'https://xenforo.com/community/resources/ban-disposable-email-hosts.5939/'
Even though that is just a cosmetic change, it will result to a more homogeneous result.
Done but not added new ban email with re-importing XML. Does total are 5,678 items?

Code:
1322 rows affected. (Query took 0.0228 seconds.)
DELETE FROM `xf_ban_email` WHERE reason = 'https://xenforo.com/community/resources/ban-disposable-email-hosts.5939
 

alexD

Well-known member
The current list holds 6,992 records. The counter should go back around to that number whenever you re-import the update.
 

alexD

Well-known member
I was able to reproduce that, that's a cache issue, try pruning the cache by either executing the following SQL command:
SQL:
UPDATE xf_data_registry SET data_value = 'a:0:{}' WHERE data_key = 'bannedEmails'
Or alternatively, by manually banning a new host, e.g. *@000.test, which you then can delete. That should update the cache.

Afterwards, re-import the updated list.
 
Top