XF 1.5 Search report comments

upnet

Active member
#1
Is it possible to search the report comments using an SQL query or other method? also the reported post Im assuming is stored somewhere and not just a reference? As when the post is moderated the post in report stays to it's original. If I could find a way to search these that would be very helpful.
 

Mike

XenForo developer
Staff member
#2
They're stored in the xf_report and xf_report_comment tables, though they may not be that easy to search, at least the stored version of the content as it's serialized.
 

Mike

XenForo developer
Staff member
#4
The cached version of the content is serialized as it contains a number of various components. The comments (which includes actual reports and moderator comments) are not serialized.
 

suineg

Active member
#5
The cached version of the content is serialized as it contains a number of various components. The comments (which includes actual reports and moderator comments) are not serialized.
Am I missing where it logs who reports something so that I can query who my high quantity reporting members are?

I see the content_id and the content_user_id but not anything like a reporter_user_id.
 

S Thomas

Well-known member
#6
It's as Mike said, reporter names are indirectly stored in the report comments.
SQL:
SELECT COUNT(*) as reports, username  FROM `xf_report_comment` WHERE is_report GROUP BY username ORDER BY reports DESC;
 
Top