Move Users by Birth Date

[bishop93]

How can I move users around into a specific usergroup by their birthdate?

[Steve Machol]

This requires modifying the code. You can try asking for help with this over at vbulletin.org.

[bishop93]

Why should this be a code modification? The search function already has this ability. I would think that this should be something quite simple and standard to other functions that involve users as well. Just a thought/suggestion for the future since there are many situations that might call for moving/pruning by other than usergroup or username.

[Lats]

You can do this with a query...

 
UPDATE user SET usergroupid = [color=blue]8[/color]
WHERE year( current_date ) - year( birthday_search ) < [color=red]18[/color]
AND year( current_date ) - year( birthday_search ) > [color=red]15[/color]
AND usergroupid <> [color=green]4[/color]

Change the blue number to where you want them to go depending on the values of the red numbers.

The green number is there in case they are already in a particular usergroup and you don't won't them to move.

[Steve Machol]

I assumed he wanted to do this automatically, and not with a query.

As for why it requires modifying the code, I don't know how to answer this except to say the the current code does not currently have this function. Please feel free to post a suggestion to add this feature in the vB3 Suggestions forum.