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]

Just to be clear - if the post setting is 31 days, it will move anyone who has not posted in the last 31 days, no matter how many posts they have in total.

[Juggernaut]

Great MOD

[Paul M]

<u>4.0.3</u>

The Settings have been split out for the Lurker & Inactive options.

[Nadeemjp]

hello paul
after upgrading to your latest version, i am getting an error whenever i click on anyone's username:

error:

UPDATE user

SET usergroupid = 2, milusergroup = 0

WHERE userid =;



MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

Error Number : 1064

Request Date : Wednesday, February 17th 2010 @ 04:48:59 AM

Error Date : Wednesday, February 17th 2010 @ 04:48:59 AM

Script : http://www.familybunker.com/forums/members/a.html

Referrer : http://www.familybunker.com/forums/forum.php

IP Address : xxxxxxxx
Username :

Classname : vB_Database_MySQLi

MySQL Version :

what could have caused this problem and how can this be cured?
thank you

[Paul M]

Originally Posted by Nadeemjp

what could have caused this problem and how can this be cured?
thank you

I have no idea - I cant see any way to cause that - you have no username or userid information (i.e. no userinfo). It makes no sense.

[Jonluci]

Thanks for this great mod. Installed it and works great
Can this be made to exclude some groups when searching for inactive and lurkers.

Like donors be exempt from this.

[Paul M]

I suggest you look at the settings

[Jonluci]

Originally Posted by Paul M

I suggest you look at the settings

oh boy....i was so blind
lol

[tahrim]

Thanksssssss

[JonnyThunder]

Hi Paul,

I wanted to put in a feature request.

Would it be possible to add the ability to automatically send an email to users who have been moved for lurking or inactivity. I think this would help the forum by reminding these people that the site exists! A little nudge to get them back to the site instead of just losing them, which could potentially happen!

Just an idea anyhow. Keep up the great mod work!