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

XF 1.3 Users Awaiting Approval: 1300 of them

Discussion in 'XenForo Questions and Support' started by Okiewan, Jun 24, 2014.

  1. Okiewan

    Okiewan Member

    Thought this would be an easy one, then again it was 3AM.

    This is a converted vB4 site.

    I've got 1300 + users awaiting approval and need to mass reject them, with no notification. I've browsed the listing, just a bunch of old registrations, not sure how far they go back, but I'm comfortable just dropping the table, IF I could figure out which table.

    Anyone willing to offer-up a SQL query to rid my database of these entries?

    Much appreciated!

  2. Mike

    Mike XenForo Developer Staff Member

    If you're just going to delete all of them, you can use the batch user update tool.
    Deathstarr and Liam W like this.
  3. Liam W

    Liam W Well-Known Member

    It's still the user table - the user's have the moderated state, making them appear in the moderation queue.
  4. Okiewan

    Okiewan Member

    Thanks for the quick replies....

    Right under my nose. Unless of course someone added that option to my install between 3 & 8am.
    Thanks for the info, sorry for the waste of ASCII, lol.

    Thanks Liam.

    Love this forum, reminds me of the old days when vBulletin was young. Not getting hammered for asking a noob question is also quite refreshing.
    Liam W likes this.

Share This Page