By digitalhead on

Is it possible to do a bulk update in the access rules? I downloaded a list of known spam domains in .csv format (a rather large list at that) and want to add all of them to the denied email addresses in the access rules.

Thanks.

⋅ Categories: Drupal 6.x

Comments

Grey Teardop’s picture

Grey Teardop commented

I am not aware of a drupalish way of doing what you need. I guess you could just manually insert those access rules into Drupal DB. Execute query

INSERT INTO `drupal_access` (`mask`, `type`, `status`) VALUES ('%@spam.domain', 'mail', 0);

for each spam.domain in your .csv list.

digitalhead’s picture

digitalhead commented

If I wanted to do the same thing with a list of known spam IP addresses from the same type of source, would I just change 'mail' to 'host'?

Grey Teardop’s picture

Grey Teardop commented

Yes, that's right. 'host' for IP filter and 'user' for username filer.

digitalhead’s picture

digitalhead commented

Thanks for the tips. This will help greatly in getting rid of spam.

JamesAven’s picture

JamesAven commented

I just got a copy of [link deleted] and I would recommend to anyone who needs to send out an opt-in email mailshot. Its the best free desktop based email marketing software I have used so far.

Edited by WorldFallz - spam link removed.

digitalhead’s picture

digitalhead commented

A spam comment in a thread concerning preventing spam. I'm all for irony, but that's just sad.