[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-cvs] [SavaneTasks] (edit) despam using an IP address
From: |
Beuc |
Subject: |
[Savannah-cvs] [SavaneTasks] (edit) despam using an IP address |
Date: |
Sat, 16 Aug 2008 11:15:41 +0000 |
??changed:
-To better understand the tables structure, here are a few manually queries::
To better understand the tables structure, here are a few manually queries
(Note: several actions are already implemented in the site admin interface,
such as detect suspect users and IP addresses, and ban users or unban IP
addresses)::
++added:
-- Mark all posts from 89.251.107.6 over the last 24h as spam
UPDATE support_history,spam_stats
SET spamscore=spamscore+5
WHERE support_history.bug_id=spam_stats.bug_id
AND support_history.field_name='details'
AND spam_stats.date > ADDDATE(NOW(), -1)
AND support_history.ip='89.251.107.6';
--
forwarded from
https://savannah.gnu.org/maintenance/address@hidden://savannah.gnu.org/maintenance
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Savannah-cvs] [SavaneTasks] (edit) despam using an IP address,
Beuc <=