[current version] [instructions] [feedback wanted]
I work at an ISP and use this script to track people who send us email in violation of RCW 19.190.
Version .61 (January 26, 2004) reworks the main page SQL so it doesn't take forever to load, includes some bugfixes, and attempts to clear out the incoming SPAM_MBOX after inputting it into the database.
Version .60 (February 28, 2003) works with the new PHP default of register_globals being off.
Version .59a (March 17, 2002) incorporates many changes including an incoming spam database that reads from a spam-filled mbox.
View colorfied code
MySQL create table statements
Test it out - can't modify/insert/delete any data, as this is the actual data I work from.
Instructions (sorta)
This script tracks companies. Companies have associated keywords, spams and actions (an action is when you call a company and tell them to stop spamming you). Dates are entered in "YYYY-MM-DD" format. The delete function doesn't yet verify that you really want to delete.
Feedback and help wanted
If you actually start using this, let me know. I hacked this together and I don't know anything about computers, programming or anything really, so some of the code is ugly. If people are actually using it, I'd probably be inclined to make it better and save myself embarrassment. I would especially love help from someone with CSS skills.