XF 1.2 Activate all users

[vozihcs]

Hey,

My mail system didnt work for a while and know about 120 users are waiting for theire aproval mail.
How can I change all to "valid" / ?

I tried for an hour or so but I cant find it

 

[Amaury]

Batch Update Users.

 

[Paul B]

The Batch Update Users function does not allow the user state to be changed.

It will need to to be done manually.

 

[rdn]

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

 

[vozihcs]

Thank you for ur answers!

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

This sounds great, would you please tell me where I have to paste it?

 

[rdn]

Thank you for ur answers!



This sounds great, would you please tell me where I have to paste it?

Phpmyadmin > sql query

 

[rdn]

Thank you for ur answers!



This sounds great, would you please tell me where I have to paste it?

Or install this addon: http://xenforo.com/community/resources/querier.2389/

 

[vozihcs]

I will download it and try it out, thank you