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

XF 1.5 I need a query for some users

Discussion in 'XenForo Questions and Support' started by Arno Nühm, Aug 22, 2016.

  1. Arno Nühm

    Arno Nühm Active Member

    I have a premium usergroup where users can choose to be invisible in the forum. But if they leave this group they can still be invisible.

    I would like to run a query to set all users who are not in usergroup 'X' to be visible in the forum.

    Is there any MySQL-Guru who can help me? :)
  2. James

    James Well-Known Member

    You'll need a "where" clause in the above to say usergroup X but it'll work.

    What you're probably best off doing is getting an addon created so that when a user is downgraded it sets their status to visible automatically.
    Arno Nühm likes this.

Share This Page