Alpha1 Well-known member Sep 7, 2017 #1 Some reported 180 posts. How do I mass reject all Open reports by this user? Is there a query I can use?
Some reported 180 posts. How do I mass reject all Open reports by this user? Is there a query I can use?
Chris D XenForo developer Staff member Sep 7, 2017 #2 SQL: 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. Upvote 0 Downvote
SQL: 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 Well-known member Sep 7, 2017 #3 Thank you Chris. That worked like a charm. I appreciate it! Upvote 0 Downvote
dougdirac Active member Nov 11, 2019 #4 @Chris D How would you modify this query to reject all reports older than a specified date? Upvote 0 Downvote
dougdirac Active member Nov 11, 2019 #5 dougdirac said: @Chris D How would you modify this query to reject all reports older than a specified date? Click to expand... Or that haven't been updated with a comment older than a specific date. Upvote 0 Downvote
dougdirac said: @Chris D How would you modify this query to reject all reports older than a specified date? Click to expand... Or that haven't been updated with a comment older than a specific date.