Administrative and Maintenance Tools - Move Inactive and Lurker Users To New Usergroup

As of 23 Nov 2017 this modification has been withdrawn.

This runs daily to check the activity of members and move them to a new usergroup if they meet certain rules.

Lurkers
If a member has not posted on the forum for a defined number of days (90 by default) then they will be moved from their existing usergroup to the defined usergroup (this can be any existing usergroup, however, you should really create a new 'Lurkers' group

Inactive Members
If a member has not visited the forum for a defined number of days (180 by default) then they will again be moved from their existing usergroup to the defined usergroup (this can also be any existing usergroup, however, you should again really create a new 'Inactive Users' group.

Only members of a defined list of usergroups are checked for inactivity.

If a member of the Inactive usergroup returns to the forum, or the Lurkers usergroup posts again, and auto-restore is enabled, they are automatically restored either to another pre-defined usergroup (by default this is usergroup 2, Registered Users) or to the usergroup they were in before they got initially moved. Note that if you use this option then you really must have seperate Inactive and Lurker usergroups, otherwise you are going to get in a mess.

Any of the options above can be disabled if not required. All options are in ACP > Options > Inactive and Lurker Members

To install simply download the file and import in vbulletin using the product manager.

Note: The move of inactive users is done once per day as part of the existing vbulletin daily update cron job. The restore function should be pretty much instant. Also, this works purely on the Primary usergroup, secondary groups are neither checked or altered.


History:

v4.0.1 : 02-Jan-2010 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 02-Jan-2010 : Prevent restore to usergroup 0 if old usergroup data is missing.
v4.0.3 : 16-Feb-2010 : Lurker & Inactive settings split out.
v4.0.4 : 18-Feb-2010 : Installer & code updates.
v4.0.5 : 12-Sep-2010 : Fix bug in disable options.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.

[Paul M]

Technically you could probably modify the sql into something really horrible to do this - but I wouldnt recommend trying.

[Julie]

Originally Posted by Paul M

Technically you could probably modify the sql into something really horrible to do this - but I wouldnt recommend trying.

Oh ok, thanks, then I won't try altering the SQL

[blue6995]

Originally Posted by Paul M

Well I suppose you could read the options

BTW, those users are not in COPPA, they will have a usergroup of zero - its just that vbulletin has no u/g of zero, so it shows the first one in the list.

I too must learn to read! I installed this mod but then got called away before I could make any changes. Consequently, I didn't get round to setting the Lurker cut off point to 0 until the next day. Of course, by then, I presume the daily check had been run and loads of my members have been moved to usergroup 0, which is preventing them accessing some parts of the forum and getting a message they have been banned.

Other than going through every member that hasn't made a post for 90 days, is there an easier way I can get them back to the registered users group from usergroup 0?

Many thanks

[Paul M]

Try setting the lurker group as usergroup 2, it should then move them all to that next time it runs.

Otherwise you can just run a bit of SQL :

UPDATE user SET usergroupid = 2 WHERE usergroupid = 0

[blue6995]

Originally Posted by Paul M

Try setting the lurker group as usergroup 2, it should then move them all to that next time it runs.

Otherwise you can just run a bit of SQL :

UPDATE user SET usergroupid = 2 WHERE usergroupid = 0

Paul, many thanks. I ran the SQL, which worked a treat!

[Raptor]

Is there a lurker option for the 3.8.x mod ?

I only see inactive option. Thanks.

[Paul M]

Nope, its only in the 4.0 version.

[Raptor]

Thanks Paul M

OK can you help me structure an SQL query then please ?

basically to update a usergroup id if belongs to X where join date is before Y and activity after Z with posts less than A

example move users from registered ug to lurker ug if they registered before 2010-01-01 and visited the board after 2010-05-01 with posts less than 1

[Bouncer222]

nvm

[Ken Sanders]

Wow! Exactly what I need! Will this work with 4.0.3? If so, count me in and I'll happily donate!
Managing users has been a real pain.