[Savannah-cvs] [SavaneTasks] (edit) despam using an IP address

[Beuc]

??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