Administrative and Maintenance Tools - Move inactive users to new usergroup

This modification is no longer available or supported.

If a member has not visited the forum for a defined number of days (180 by default) then they will be moved from their existing usergroup to another usergroup (this can be any existing usergroup, however, you should really create a new 'Inactive users' group - esp if you use the auto-restore option).

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

If a member of the inactive usergroup returns to the forum, and auto-restore is enabled, they are automatically restored to another defined usergroup (by default this is usergroup 2, Registered Users).

Note: The move of inactive users is done once per day as part of the daily update cron job.



History:

v3.7.001 : First Release for vB 3.7.

[blue6995]

Originally Posted by Paul M

No idea what that is, but its nothing to do with this mod. This does not have an associated cron of its own - like I said above, it taps into the standard daily update cron.

Thanks Paul. I get it now, doh!

Once the Daily Cleanup ran, inactive members were moved to the Usergroup I set up.

[Deviant K1]

INSTALLED! Thanks for the hack

[AdrianH]

Ran this mod before in the earlier v3.7 versions and it worked fine.

Re-installed it with v3.7.4 and the usergroups don't change, this error message is received some hours later when the cron job runs.

Database error in vBulletin 3.7.4:

Invalid SQL:

UPDATE forum_user
SET usergroupid = 16
WHERE usergroupid IN(02,)
AND lastactivity < 1219107463;

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 ')
AND lastactivity < 1219107463' at line 3
Error Number : 1064
Request Date : Monday, November 17th 2008 @ 12:57:43 AM
Error Date : Monday, November 17th 2008 @ 12:57:43 AM
Script : http://www.xxxxx.org/cron.php?rand=1226883462
Referrer : http://www.xxxxx.org/f29/jenny-mccarthy-726/
IP Address : 92.237.xxx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

[Paul M]

You need to check the mods settings, you appear to have 02, in the List of Checked Groups setting, you need to remove the comma.

[AdrianH]

Thanks Paul,tried that and all appears to work again.

[nibb]

Im looking to accomplish something similar so I was searching and found this mod. I think this mod would work for what I need. Im willing to pay for this modification.

It needs to be changed so instead of moving inactive users to a usergroup it moves users that are registered from a specific IP to a usergroup and runned in cron automatically.

Please see my thread here of what i need:
http://www.vbulletin.com/forum/showthread.php?p=1654720

If someone is willing to do this I can pay him something. My forum is new im not rich but since im not a php programmer someone that is or the author can help me do modify it so it works the way i need.

Thanks to all.

[tjh4384]

Thanks!

[badheeu]

waiting for mod 3.8.1

[Paul M]

Originally Posted by badheeu

waiting for mod 3.8.1

Maybe your should read the first post more carefully

[King Diamond]

Hello Paul M, i instaled your Hack and setup it to move the inactive members to another group, unfortunly i didnt know that it also moves the inactives that had coments to the coopa users.

more then 20 thousand members, but wen i go check the coopa group it dont show any users.. and for me reactivate 20 thousand aconts one by one its imposible.

do you have any solution for me please?

thanks!