Solving Half of Spam
- user warning: Table 'nolan.comments' doesn't exist
query: SELECT COUNT(*) FROM comments WHERE nid = 277 AND status = 0 in /home/sneakin/web/nolan.eakins.net/includes/database.mysql.inc on line 120.
- user warning: Table 'nolan.comments' doesn't exist
query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.picture, u.data, c.score, c.users, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 277 AND c.status = 0 GROUP BY c.cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, u.picture, c.homepage, u.uid, u.name, u.picture, u.data, c.score, c.users, c.thread, c.status ORDER BY c.thread DESC LIMIT 0, 50 in /home/sneakin/web/nolan.eakins.net/includes/database.mysql.inc on line 120.
Submitted by sneakin on Tue, 2006/05/09 - 05:35.
Internet
I was just flagging a lot of spam and came up with an idea that could help solve this problem. Basically it involves having my mail server ask the supposed sender really sent that message. It's really a lot like Jabber's reverse domain look up, but on a per-message basis. Email (sendmail, qmail, and friends) really needs this.
|
