XF 1.3 Users Awaiting Approval: 1300 of them

[Okiewan]

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!

Okie

 

[Mike]

If you're just going to delete all of them, you can use the batch user update tool.

 

[Liam W]

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

 

[Okiewan]

Thanks for the quick replies....

If you're just going to delete all of them, you can use the batch user update tool.

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.

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

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.