[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-cvs] [SavaneTasks] (edit) analyse items posted by a spammer
From: |
Beuc |
Subject: |
[Savannah-cvs] [SavaneTasks] (edit) analyse items posted by a spammer |
Date: |
Tue, 22 Apr 2008 21:08:40 +0000 |
++added:
-- Show all new items posted by user #65804
mysql> SELECT * FROM bugs WHERE submitted_by='65804'
UNION SELECT * FROM task WHERE submitted_by='65804'
UNION SELECT * FROM patch WHERE submitted_by='65804'
UNION SELECT * FROM support WHERE submitted_by='65804';
-- Show all follow-ups posted by user #65804
mysql> SELECT * FROM bugs_history WHERE mod_by='65804' AND field_name='details'
UNION SELECT * FROM task_history WHERE mod_by='65804' AND field_name='details'
UNION SELECT * FROM patch_history WHERE mod_by='65804' AND
field_name='details'
UNION SELECT * FROM support_history WHERE mod_by='65804' AND
field_name='details';
??changed:
-
??changed:
-
--
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) analyse items posted by a spammer,
Beuc <=