[Savannah-cvs] [For administrators] (edit) zombie projects: better SQL query

[Beuc]

??changed:
- SELECT bug_id, unix_group_name FROM groups, task WHERE groups.status='P' AND 
task.summary LIKE CONCAT("Submission of ", groups.group_name) AND 
task.status_id=3
-
-It only fails if the task summary or group name was changed after the 
submission.
 SELECT groups.group_id, unix_group_name, groups.status, task.bug_id, 
task.status_id, groups.group_name FROM groups, task WHERE groups.status='P' AND 
task.group_id=5802 AND task.status_id=3 AND task.category_id=1 AND task.details 
LIKE CONCAT("%* System Name:  *", groups.unix_group_name, "*%") AND (SELECT 
count(*) FROM task WHERE task.group_id=5802 AND task.status_id=1 AND 
task.category_id=1 AND task.details LIKE CONCAT("%* System Name:  *", 
groups.unix_group_name, "*%")) = 0 GROUP BY groups.group_id ORDER BY bug_id;
 
 DELETE groups FROM groups, task WHERE groups.status='P' AND task.group_id=5802 
AND task.status_id=3 AND task.category_id=1 AND task.details LIKE CONCAT("%* 
System Name:  *", groups.unix_group_name, "*%") AND (SELECT count(*) FROM task 
WHERE task.group_id=5802 AND task.status_id=1 AND task.category_id=1 AND 
task.details LIKE CONCAT("%* System Name:  *", groups.unix_group_name, "*%")) = 
0;

It only fails if the group name was changed after the submission, or if a user 
maliciously fakes a submission item.

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