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

XF 1.2 Anyway to mass approve "awaiting e-mail activation" users?

W1zzard

Well-known member
#5
We use an addon that adds buttons for select all, reject all, approve all on the listing page. You'd still have to go through all pages, I usually select all, reject all and then visually scan through the list to approve any which don't look like obvious spammers (usually none)
 

Sage Knight

Well-known member
#7
@Sage Knight
Why can't you just batch update users ??
It's not an option, unfortunately. There is a suggestion however.

We use an addon that adds buttons for select all, reject all, approve all on the listing page. You'd still have to go through all pages, I usually select all, reject all and then visually scan through the list to approve any which don't look like obvious spammers (usually none)
It would be awesome if you could share it here =3

This one really works:
Code:
UPDATE xf_user
SET user_state = 'valid'
WHERE xf_user.user_state = 'email_confirm';
Indeed! This is the one that worked, @Liam W's gave an error :p

Thanks a lot Roldan. This just saved me hours of manual work.