Auto assign user to group

[seamus]

Hello,

I currently have a client that has quite a number of employees. They all email from a single domain.
I would love it if there was the ability to automatically add a new user to a group (which i would name according to the domain)

Does anyone know if such a thing is possible.

e.g.
I create a group called "company.com"

Whenever a user submits a ticket (by email) to my support inbox, and the email comes from user@company.com, user2@company.com etc, those users are added to the group "company.com"

Does anyone know if this is possible?
I guess if i really had to, i could create my own cron job to do this, but it would be useful if such a feature was built in.
Perhaps i am just blind and its staring me in the face :P

[Matthew]

I would sure like this ability, too. I need to put users into a particular default group, which is NOT the 'registered' group, and I can't be bothered to move them manually every time one signs up.

[seamus]

Dang, support says its not currently possible

Time to get to work creating a custom script.

Will post it here if i get it working

Looks like it was suggested here Auto Group Users

[seamus]

got it, thanks to some help from other people

update swusers set usergroupid=3333 where userid in (select userid from swuseremails where email like '%domain.com');

Replace 3333 with the usergroup ID of the group you want the users to be placed into, and replace domain.com with the users's domain name.
Then, either place this code into a php file and have it called every so often using a cron, or have it execute on the database every so often.

[Siora]

Originally Posted by seamus

got it, thanks to some help from other people

update swusers set usergroupid=3333 where userid in (select userid from swuseremails where email like '%domain.com');

Replace 3333 with the usergroup ID of the group you want the users to be placed into, and replace domain.com with the users's domain name.
Then, either place this code into a php file and have it called every so often using a cron, or have it execute on the database every so often.

Wow, this is a great find and will be very helpful to many here.

[seamus]

Now, i wonder where it is best to put this code. The best option i can think of is to put it in its own php file (the reason for this is that you may want to have this mysql code run multiple times as you would obviously have multiple groups in many circumstances. so putting all these mysql update commands into a single self contained php file makes sense)
Then somehow add that file to the scheduler.
This is where i move to the passenger seat