Mass Changing User Group for Older Users

[MarkFL]

Originally Posted by ShannonA

...More importantly, is there an easy way to flip all users who haven't logged in, for, say 3 years to "Users Awaiting Email Confirmation" as their primary group?

You could follow;

AdminCP ► Maintenance ► Execute SQL Query

And run the manual query:

UPDATE user set usergroupid = 3 where (usergroupid = 2 AND ((UNIX_TIMESTAMP() - lastactivity)/(86400*365) >= 3))

Note: Before running any manual queries, make sure you have a backup of your database in case things do not go as expected.