POP3 ANTISPAM MYSQL script

filip7

Hi.
I was planning to write a PHP script that
- connects to a given POP3 mailbox
- retrieves the messages and checks for each message whether 'prohibited' words are found in the message subject or message body. The prohibited words (or email-addresses) are found in a mysql database that the script connects to.
- the messages that contain prohibited words are then immediately deleted from the server (or saved in the database)
- 'clean' messages are left on the server of course
- log out and end of the script

The idea is to run this script every x minutes through a cronjob on my PHP server. This way my regular Mail Inbox will never overflow (even when on holiday for several weeks) with spam messages.

My question is : has anyone heard of such a script ? Because if it exists, I'm not going to reinvent the whole thing. Searches on the internet didn't bring me to any existing script or solution. But this method for getting rid of spam must surely have crossed the mind of others already. Or is this kind of script not going to work, or silly, or ... ? 😕

vaaaska

From time to time I check my spam...perhaps it would be better to put it in a spam folder. I believe GMail does this...

I use SpamAssasin to mark spam and then a custom filter to move those things to a spam folder when I download via pop. Effectively doing the same thing you are talking about.

But, it sounds like you are writing an email app? True? My webmail (that I never use) doesn't have a filter I can setup to move marked messages to a spam filter. Or, better yet, it would be nice if I could filter messages in the inbox that were not marked as spam (then I could get to the real stuff much quicker).

I know that SpamAssassin checks dbl.org (or whatever it is) for each message to see the details - probably the exact same thing you are talking about.

Anyays, just waking up so I'm not sure why I wrote all of this.

Good luck...v