1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 List of most-ignored users?

Discussion in 'XenForo Questions and Support' started by ScarletCox, Jan 22, 2016.

  1. ScarletCox

    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!
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    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
     
  3. ScarletCox

    ScarletCox Active Member

    Ah, this is a cunning plan! Cheers Chris :)
     
  4. wang

    wang Well-Known Member

    I have developed an add on that will show all users being ignored by an user.

    https://xenforo.com/community/resources/view-all-ignored-users-by-user.5005/
     
    ScarletCox and 51463 like this.
  5. ScarletCox

    ScarletCox Active Member

    Yet again @wang to the rescue! You're my hero :D
     
    wang likes this.

Share This Page