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

[Sage Knight]

As per the title of the thread, is their any query or addon that provides this?

Or any other way.

Thanks

 

[Liam W]

UPDATE TABLE `xf_user` SET `user_state`='valid' WHERE `user_state`='email_confirm';

Should work but I haven't tested it.

Liam

 

[Sage Knight]

UPDATE TABLE `xf_user` SET `user_state`='valid' WHERE `user_state`='email_confirm';

Should work but I haven't tested it.

Liam

I'll test this on a test board and report back. Thanks =]

 

[Itworx4me]

As per the title of the thread, is their any query or addon that provides this?

Or any other way.

Thanks

@Sage Knight
Why can't you just batch update users ??

 

[W1zzard]

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)

 

[rdn]

This one really works:

UPDATE xf_user
SET user_state = 'valid'
WHERE xf_user.user_state = 'email_confirm';

 

[Sage Knight]

@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:

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

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

 

[W1zzard]

It would be awesome if you could share it here =3

http://xenforo.com/community/resources/xenmods-admin-tools-user-moderation-mass-select.2453/

also recommended: http://xenforo.com/community/resources/moderation-queue-information-by-waindigo.2360/