Move inactive users to new usergroup

[Paul M]

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.

[Super Jinni]

Hi man

I was waiting for this

thank you som much

at last it's working on 3.7.

installed

[KURTZ]

*installed, thx Paul ... :)

[Super Jinni]

the daily update corn job was an hour ago, but nothing changed

I think this does not work..

I hope I'm wrong

[Paul M]

Works fine for me, are you sure you've actually set the usergroups in the settings.

Also, the daily cron job normally runs just after midnight, are you sure it ran just over an hour ago ?

[EagleNick]

What is the point of moving them to a usergroup if they don't log in for x days, and then when they do login, they are restored back to the Registered Users group?

[KURTZ]

Works fine for me [cut]


me too, i've ran manually the cronjob and the inactive users are gone correctly in the 'inactive ug' (that i've previously created)

[Super Jinni]

yes, I set the user group and did everything as I did just on 3.8.0 yesterday

and yes as I saw the schedule and it was just an hour ago when I post that

don't forget that the difference in the time zomes

I'll wait till tomorrow then I can tell for sure if it is working or not..

thank for your quick reply

:)

[Super Jinni]

What is the point of moving them to a usergroup if they don't log in for x days, and then when they do login, they are restored back to the Registered Users group?

that an opetional you can set..
you can choose to make them be restored or not..

[Super Jinni]

ok now..

it works for me now

great..

thanks for the great job Paule

[EagleNick]

that an opetional you can set..
you can choose to make them be restored or not..
I understand that.... but what would be the point of restoring them?
It would go by as if nothing has happened...

[airborneCAL]

Does this look in the primary usergroup or additional usergroups to make the determination? Basically, if a user is in primary group X, but are also in additional groups Y and Z will the hack move the user from X only into the inactive group and then restore into group X (if chosen) or do something else?

[COBRAws]

Does this look in the primary usergroup or additional usergroups to make the determination? Basically, if a user is in primary group X, but are also in additional groups Y and Z will the hack move the user from X only into the inactive group and then restore into group X (if chosen) or do something else?
I second this.

[VB-STYLE]

Move active users to new usergroup will be good allso :)

If a member spend more time in the forum
like style for X hours or conut how many post in the month.

[Paul M]

Does this look in the primary usergroup or additional usergroups to make the determination? Basically, if a user is in primary group X, but are also in additional groups Y and Z will the hack move the user from X only into the inactive group and then restore into group X (if chosen) or do something else?
This does not check, or affect, secondary usergroups (at all).

[slowphantom]

nice thx
is there is way to make it in another way

like lets say the Registered Users who only read without write any thing of even thx after x days of Register will change from Registered Users to another group

i gusse this will be more helpfull

thx paul ur hack r always so good
i will wait ur answer

[Kinneas]

Again, thanks Paul :)

[Paul M]

like lets say the Registered Users who only read without write any thing of even thx after x days of Register will change from Registered Users to another group
If you re-wrote the SQL query then i think you could do that, but I cant really help you on that as its a totally different thing.

[Silvio]

ty so much installed and very appreciated.

will never be possible to have an ON/OFF switch on the admin panel options menu?

take care

ciao

[echo2kk5]

Thanks Paul. **Installed

[Mum]

installed :)

[KURTZ]

Paul, just a little thing :p

right now i put into the 'List of Checked Groups' some UGs like Registered (ID. 2), Moderators (ID. 5) and some other special UGs (ID. 10 etc.) ... so obviously when a user of these goes into 'inactive list' they are moved onto the new UG that i've created (ID. 14) ... so it's fine ...

but when they returns on-line they are moved by default into Registered Users (UG. 2), so i need an option that puts the users into their previous UG ... it's possible?

example:

User (UG.2) ---> Inactive (UG.14) ---> Active (UG.2)
Moderator (UG.5) ---> Inactive (UG.14) ---> Active (UG.5)
BOT (UG.10) ---> Inactive (UG.14) ---> Active (UG.10)

[Paul M]

Nope, that facility does not exist, nor do I have any plan to add it. The common group they get returned to is an option already.

[AdrianH]

:up: another nice mod thanks Paul.

[PHILIPS-08]

Thanx for the cool mod

[fukdawrld]

It says it moved my inactive users to usergroup 9??? This doesn't exist so I have now way of editing them. If I uninstall this what happens to my users?

[Paul M]

You should have changed the settings when you installed it.

Nothing will happen to them if you uninstall it, they will stay where they are.

[BigDog56]

Clicked 'Installed'. Works fine!

[Paul M]

I made a new usergroup that I'd like them to enter. Do I have to do this manually or will It do it on it's own?
Set the "Inactive Group" to your new usergroup, and add the old usergroup (9 ?) to the "List of Checked Groups" and it will move them all next time it runs.

[x-death]

thanks post

[forumrunt]

XML Error: not well-formed (invalid token) at Line 1

Not sure what this means

[AuroraStorm]

Sweet...I prune every 30 days so this will help the administrators out tremendously and keep them from having to search for non-active members...

*installed*

[sinucello]

Hi,

thanks, great mod. A general question: is it possible to keep the members of the inactive group from increasing the total of the user-counter at the bottom of the forum?

thank you - all the best,
Sacha

[Paul M]

Nope, vb will always count them, no matter what usergroup they are in.

[sinucello]

Nope, vb will always count them, no matter what usergroup they are in.
thanks for your reply, I added a feature request (http://www.vbulletin.com/forum/showthread.php?p=1605112) for it.

best,
Sacha

[popowich]

I wish i noticed this sooner. I tried doing the job manually a few weeks ago and accidentally turned all the banned members into inactive members. *installed* Thanks as always for yet another nifty product! :D

-Raymond

[popowich]

What is the point of moving them to a usergroup if they don't log in for x days, and then when they do login, they are restored back to the Registered Users group?

I will be using this to easily identify members who have not been active for over 90 days.

I can send my regular news letters only to those who visit the site at least semi regularly.

I can every 6 months or so try to get back the people who did not come back (and the inactive reminder e-mail at 2 weeks didn't work...)

-Raymond

[ssandgirls]

Great mod....... is there a way to also delete all PMs upon being moved to the inactive group?
Many thanks

[Binoy]

*Clicks Install.

Btw, Is there any option to view which usergroup does these users earlier belonged to ?

[Paul M]

Nope, no record is kept of that.

[The Ottoman]

This does not check, or affect, secondary usergroups (at all).


Are there any plans for it to work with secondary user groups?

[Paul M]

Nope.

[voglermc]

what are most of you setting as defaults?

[ArnyVee]

Thanks! :D

This is going to help me as I choose to have my 'inactive' group setup with this mod and then the 'mass pm' sent to these folks to prompt them to participate or at least visit the site and hope to get a few clicks on ads ;)

[ArnyVee]

Ran last night and identified my inactive users! Worked as advertised! ;)

Thanks Paul! :D

[BucWiLd]

installed thanks :)

[blue6995]

I have set up which groups to check for inactive users, and a new group to move inactive users to. I clicked on the hourly update cron job and it doesnt seem to have done anything. No members have been moved. Any idea what's wrong?

[Paul M]

I have set up which groups to check for inactive users, and a new group to move inactive users to. I clicked on the hourly update cron job and it doesnt seem to have done anything. No members have been moved. Any idea what's wrong?

As the text says ;

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

[blue6995]

Paul,

Thanks for the reply, much appreciated. I waiting for the daily update cron job to run, which was set for 20:00 tonight. Nothing appears to have happened; no inactive members have been moved to the specified Group!

In the Cron job, it says the File is ./includes/cron/inactiveusers.php. Is this correct?

[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.

[blue6995]

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]

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!

[Paul M]

Sorry, I dont understand your issue.

[King Diamond]

*i instaled the product move inactive use to new usergroup

but the users that was movd to the group i choose simply desapear.
the group show like 0 users on it.
but they can still login as coopa users.

i setup it wrong, i shold had setup it to be moved to inactives but i setup it to move to coopa users group.
you understand?

[Paul M]

You set it up wrong ?

What is your question exactly ?

[King Diamond]

hey paul sorry if you dont understand my doubt, im brasilian so my english its not good. i will show you a printscren of the problen im having after install your "Move inactive users to new usergroup" i wold like some soluction for i back the members that are gone,

https://vborg.vbsupport.ru/external/2009/06/133.jpg
https://vborg.vbsupport.ru/external/2009/06/134.jpg

*this users that desapears, wen they login on the forum, they show up as COPPA Registration System and not as regular members.

[Paul M]

TBH, it sounds like you moved them to a non existant usergroup.

What usergroup did you set them up to move to ?

When you look in the database at one of these users, what usergroup are they in ?

[yotsume]

INSTALLED: Should the cron job be listed anywhere?

[Paul M]

No, it hooks into an existing vb cron job.

[yotsume]

No, it hooks into an existing vb cron job.

Well which cron job and how is it set? Its been active now for a while but no members have been moved and I have at least 100 inactive members. Wouldn't the cron job for this be better on its own? So we can set it the way we want it to run?

I am sure it just has not run yet but id like to manually run it now. Please let me know how I can run it manually...


THANKS!

[Paul M]

As the main post says ;

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

I have no plans to change that, it works just fine for me and everyone else.

[globalinsites]

Strange question perhaps, but I would like inactive users to re-register. Can this mod help me to achieve that? I would prefer not to delete inactive users but I do want them to re-register, it may be a little impossible hehe.

[Paul M]

What would be the point of that ?

[jaderollie]

I understand that.... but what would be the point of restoring them?
It would go by as if nothing has happened...

this is a good point, and is it worked out that members do keep there status for being away??

[Huendin]

Is there an option to exclude certain usergroups from this rule, such as the Banned usergroup, or at least select the usergroup that this rule applies to?

[Paul M]

Read the description ......

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

[Kinneas]

Should this continue to work in 4.0, Paul?

[Paul M]

I would think so.

[samiro]

not working with vb4

[rwoscott]

bummer!!

Got this on Import.
The following dependencies were not met:

1. This product is not compatible with version 4.0.2 of vBulletin. (Compatible starting with 3.7.0 / Incompatible with 3.7.99 and greater)

[koby411]

Is there something similar to this but instead of not visited x-days... change to not posted in x-days?

I'm looking for a way to make it so a user has to post every so often to have access to a certain part of the forum.