[Mediawiki-l] multiple users to one group

Brion Vibber brion at wikimedia.org
Wed Oct 22 17:24:41 UTC 2008


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

André Meunier wrote:
> Is there a way to assign multiple people to one group?
> I don't seem to find how to do that in sql in the database, I can see 
> the users table, and the group table, but I don't find the link between 
> them.
> And in the web interface, the Special:permissions can only do it one 
> user at a time.

There's not a built-in user interface for changing group memberships for
multiple accounts at once, but you could do it manually in the database
something like this:

INSERT INTO user_groups (ug_user,ug_group)
SELECT user_id, 'target_group' FROM user
WHERE user_name IN ('First username', 'Second username', 'Third username');

- -- brion
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkj/YdkACgkQwRnhpk1wk46FmgCgzkz9QPeUIukUcRc3mgu6ZwmM
MY0An163QyjDKF4KjjfhMKhL6H83p3ni
=OJ/N
-----END PGP SIGNATURE-----



More information about the MediaWiki-l mailing list