E-Mail Verification Question

[Chad F.]

I just recently enabled the e-mail verification in the registration options but this only affects new members, how can I make all of my members verify their e-mail addresses?

[Viktor Kraft]

Running this query should do the trick:
UPDATE `user` SET `usergroupid` = '3' WHERE `usergroupid` = '2' ;

Please note the table prefix.

[Chad F.]

I'm sorry I'm a newbie lol.. so I'd replace 3 with my registered users group ID and replace 2 with the ID of the users awaiting e-mail confirmation right? Thanks.

????

[Chad F.]

:ermm:

[Paul M]

I'm sorry I'm a newbie lol.. so I'd replace 3 with my registered users group ID and replace 2 with the ID of the users awaiting e-mail confirmation right? Thanks.

????Well yes, but normally they would 3 & 2 as these are the vB defaults, have you changed yours for some reason ?