XF 1.5 List of most-ignored users?

ScarletCox

Active member
Is there some way to find out which users are being ignored, and by which other users?

I think it'd be a super-useful way for mods to identify the most disruptive elements on a forum, so if there's a way for staff to find this it'd be fab!
 
The best you can do is run a query on the database.

It's something like this, though I haven't tested it:
Code:
SELECT user.username, COUNT(*) AS count
FROM xf_user_ignored AS ignored
INNER JOIN xf_user AS user ON
    (ignored.ignored_user_id = user.user_id)
GROUP BY ignored.ignored_user_id
ORDER BY count DESC
 
Top Bottom