Not Solved [How To?] Move alot of users from "awaiting activation" to regular member
#1
Not Solved
I have alot of users stuck in "awaiting activation". But I changed settings upon registering to automated activation. I have alot of users in the "awaiting activation" group. I do I move all of them at once to the regular member group?
Reply
#2
Not Solved
Get the gid for groups "awaiting activation" and whatever your target group.

Assuming your database is not somehow changed - with mysql or phpmyadmin - use your mybb database.  Then run:

UPDATE mybb_users
SET usergroup = target-group-gid
WHERE usergroupawaiting-activation-gid ;

I highly recommend a straight select query first, as a sanity check:

SELECT * FROM mybb_users WHERE usergroup = gid-awaiting-activation;

Also highly recommend you backup your database before running any update queries.

cheers...
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)