savannah-cvs
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]