[RESOLVED]Bulk update of member permissions. this is possible?

[pittu]

I enter a mysql query on vbulletin and get 300 member emails for which I need to update membergroup on SMF.

Code Select Expand

SELECT email FROM `forumuser` WHERE usertitle='private members'

Now I created this same membergroup in SMF with required permissions. (It is now under 'Regular groups' list)

Now how to update members with these emails to new membergroup?

Code Select Expand



UPDATE smf_members
SET ?????????????
WHERE emailAddress='[email protected]'

WHat to enter at SET ?

[Norv]

Do you want them to have the group as primary group or additional group?
Primary group is displayed on the profile page, as well as under their names in posts. Additional groups are not displayed, but they are applied, as far as permissions they allow are concerned.

Update: you're using SMF 1.1.x, it seems?

[Norv]

For SMF 1.1.x, setting primary group:

Code Select Expand


UPDATE smf_members
SET ID_GROUP = your_group_id
WHERE emailAddress='[email protected]'


[pittu]

Worked like a charm.

I changed 300 members to a special 'Regular group' I created.

thanks.

[Norv]

Cheers, good to hear!