Mass change usergroups

[Chruser]

Recently, I moved my board to a new server, and I realized that a small problem was that the server wouldn't send emails out, so I have around 400 users who are "waiting for email activation". Can anyone remind me of where to find the "change all users in the usergroup to another usergroup" feature? I just can't find it.

[Matze0007]

Hiho =)

Originally posted by Chruser
Recently, I moved my board to a new server, and I realized that a small problem was that the server wouldn't send emails out, so I have around 400 users who are "waiting for email activation". Can anyone remind me of where to find the "change all users in the usergroup to another usergroup" feature? I just can't find it.

AFAIK there is no such feature, but running this SQL query should help you out:

UPDATE user SET usergroupid='2' WHERE usergroupid = '3'

This will move everyone from the waiting for activation group to the normal registered users group.