Hi.
I've a 1.1.18 SMF board with around 2500 registered users.
Now I want that all registered users will come to a new user group that I will create.
How can I do it without modifying their profile one by one??
Thank you very much for your reply! :)
How many primary membergroups do you have? Don't some of those users have a membergroup assigned already (other than post count groups)?
the only realistic way to do this would be to use a direct SQL edit...
Yup, that's why I was trying to understand what is the actual "state of things".
I don't get why there is a need to move anyone, if it's permissions, use Registered Members or post count groups, if it's anything else it's likely for display purposes only.
In any case I wouldn't be too concerned about 1.1.x, I'd be more concerned about planning an upgrade since 1.1.x will not be supported forever.
well... for new users going forward
http://custom.simplemachines.org/mods/index.php?mod=819
All my users are in one group, registered members by default.
That's not entirely true. You and other administrators are in a different group :)
I'm not on the computer and I don't remember the database schema for 1.1.x but you are looking at something like:
UPDATE smf_members
SET id_group = 99
WHERE id_group =0
Now... You need to check both the table and column names because I'm not on the computer...
Oh, and of course you'll backup first, right? ;)
It works!!!!! Thank you very much!! :)
@margarett Just FYI, the schema on this subject is basically unchanged. The only difference is that the column is capitalised in 1.1, being ID_GROUP to signify it is a foreign key (as key constraints aren't actually used in the code), but MySQL isn't case sensitive.
On a related note, additional_groups in 2.0 is additionalGroups in 1.1 if that's needed here.
Ty ;)