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

XF 1.2 Ignored members

Discussion in 'XenForo Questions and Support' started by Blue, Sep 17, 2013.

  1. Blue

    Blue Well-Known Member

    Anyone know how to see the top ignored members? Like a query that would list them by the most ignored to the least?
  2. Amaury

    Amaury Well-Known Member

    A resource would be required for this.
  3. Liam W

    Liam W Well-Known Member

    Off hand, this SQL should do the trick:

    SELECT      `ignored_user_id`,
                COUNT(`ignored_user_id`) AS `value_occurrence`
        FROM    `xf_user_ignored`
        GROUP BY `ignored_user_id`
        ORDER BY `value_occurrence` DESC
        LIMIT    1;
    just run it in phpmyadmin, or somewhere else, and it'll give you the ignored_user_id and how many times it's there.
    Blue likes this.
  4. Blue

    Blue Well-Known Member

    Worked great, thanks!

Share This Page