??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/[EMAIL PROTECTED]://savannah.gnu.org/maintenance _______________________________________________ Savannah-cvs mailing list [email protected] http://lists.gnu.org/mailman/listinfo/savannah-cvs
