[Savannah-cvs] [SavaneTasks] (edit) more about spam

[Beuc]

??changed:
- mysql> update task_history set spamscore='5' where mod_by='64322';
- mysql> update user set status='S' where user_id='64322';
 -- Mark all posts from user '64322' as spam
 mysql> UPDATE task_history SET spamscore=spamscore+5 WHERE mod_by='64322' AND 
field_name='details';
 mysql> UPDATE user SET status='S' WHERE user_id='64322';

 -- Mark all posts in task #3491 posted after January 1st 2005 as spam
 mysql> UPDATE task_history SET spamscore=spamscore+5 WHERE 
task_history.field_name='details' AND bug_id='3491' AND date > 
UNIX_TIMESTAMP('2005-01-01');

--
forwarded from 
https://savannah.gnu.org/maintenance/address@hidden://savannah.gnu.org/maintenance