Ban Settings: Bulk import banned email addresses?

[nealtz]

Hello,

switched recently from vB 4 to IPB 4.

I try to find a way to bulk import our list of over 600 banned email addresses. I definitely don't want to enter one email adress after another.

Any hints?  

[nealtz]

Nobody?

Also: What happens when I add an email adress to the ban settings and there are already registrated users with adresses that apply to the filter?

[Nathan Explosion]

INSERT INTO `core_banfilters` (`ban_type`, `ban_content`, `ban_date`, `ban_reason`) VALUES ('email', '*@yahoo.com', UNIX_TIMESTAMP(), 'Testing wildcard domain');
INSERT INTO `core_banfilters` (`ban_type`, `ban_content`, `ban_date`, `ban_reason`) VALUES ('email', 'address@gmail.com', UNIX_TIMESTAMP(), 'Testing specific email address');