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