XF 1.5 How to mass reject all reports by a user?

[Alpha1]

Some reported 180 posts. How do I mass reject all Open reports by this user?

Is there a query I can use?

 

[Chris D]

UPDATE xf_report_comment AS rc
INNER JOIN xf_report as r ON
    (r.report_id = rc.report_id)
SET r.report_state = 'rejected'
WHERE rc.is_report = 1
AND r.report_state = 'open'
AND rc.user_id = 12345

I have only briefly tested this. Please backup first.

 

[Alpha1]

Thank you Chris. That worked like a charm. I appreciate it!

 

[dougdirac]

@Chris D
How would you modify this query to reject all reports older than a specified date?

 

[dougdirac]

@Chris D
How would you modify this query to reject all reports older than a specified date?

Or that haven't been updated with a comment older than a specific date.

 

[rdn]

UPDATE xf_report_comment AS rc
INNER JOIN xf_report as r ON
    (r.report_id = rc.report_id)
SET r.report_state = 'rejected'
WHERE rc.is_report = 1
AND r.report_state = 'open'
AND rc.user_id = 12345

I have only briefly tested this. Please backup first.

Thanks; it works fine for XF 2.2.