[Rik Brown]

First I want to thank lierduh for his work on developing this mod and krandall for his fixes. We've been importing 3-years of messages from a large newsgroup this week and all appears working well so far (haven't tried exporting yet).

While it would be best to filter out spam and other junk in the importation phase [killfile], one obviously doesn't know what and who to scan for at first. Has anyone developed a series of mySQL commands for the post-importation of messages to work on cleaning up the spam and bad users? If so, could you please advise a sample here that I and perhaps others can build on?

In my case, I would like to:

1) Posts

- delete any post with a URL in it (99% spam)
- delete any post with certain keywords in them
- delete any post by specified users
- delete any post with a URL in the User Name

2) Threads

- delete any thread with a URL in the title
- delete any thread with certain keywords in them
- delete any thread by specified users
- delete any thread with a URL in the User Name

Thanks. -- Rik