Automatic Inactive Users Pruning - vB3.7 RC2

[J98680Bxxxxx]

Originally Created by NeoRevan (https://vborg.vbsupport.ru/member.php?u=47482) (in 2005) for vB 3.0.7.

I could not run NeoRevan?s version (https://vborg.vbsupport.ru/showthread.php?t=78952) on vB3.7 CR2.

I also took a look at a similar Mod by Paul M (Dr Pepper Addict) on Inactive Users (https://vborg.vbsupport.ru/showthread.php?t=157409), but I missed some of NeoRevan?s features on it.

Thus I decided to update NeoRevan?s version (https://vborg.vbsupport.ru/showthread.php?t=78952) to suit my needs on vB 3.7 CR2. If needed, I Will update it accordingly for vB3.7 Gold, once it?s released.

Feel free to use this Mod as you see fit, I just wished to share it with this Community. :up:

What this Mod does:


Runs a daily cronjob, removing all members according to the script's configuration
Exclude selected usergroups from been pruned
Flag automatically selected user(s) for pruning after x days (7 by default)
Email automatically selected user(s) that have been flagged (on by default)
Has the ability to prune users that match ALL the following conditions:

Has not visited in the last x days (30 by default)
Has not posted in the last x days (30 by default)
Has x or fewer posts (0 by default)
Has been flagged for pruning earlier than x days (7 by default)

Send email to pruned users, notifying them of their change in status membership (on by default)
Send email to the admin (webmaster) for book keeping.


Installation instructions in the attachment. :)

[KURTZ]

basically this hack put the inactive users on a different user group right? have you tested it onto RC4?

[J98680Bxxxxx]

basically this hack put the inactive users on a different user group right? have you tested it onto RC4?

:up: Correct. No deletion performed.

I tested it on vB 3.7 CR2 and it works fine.

I haven?t installed the latest vB versions > 3.7 CR2, as I got tired of moving from one vB 3.7 beta xx to another vB 3.7 beta yy. Now waiting for the final vB 3.7 Gold, on which I will update the Mod if required.

[setishock]

Does it make the user group or do you have to manually set one up?

[J98680Bxxxxx]

Does it make the user group or do you have to manually set one up?

Manually set one and reference it in the configuration parameters.

[Jasem]

Thank you very much

[slowphantom]

nice mod thx
but is there a way to do not remove user
i was thinking to just move it to another group

[Alien]

Re-read the posts above for your answer. ;)

[slowphantom]

Re-read the posts above for your answer. ;)



yes got it thx

[slowphantom]

i got idea i hope it will do good jop

what about if the user read x post without posting answer will be moved too
that mean for all usere how log in and read therd without say thx or any thing will be moved to another group

i gusse we will need this option too

[J98680Bxxxxx]

i got idea i hope it will do good jop

what about if the user read x post without posting answer will be moved too
that mean for all usere how log in and read therd without say thx or any thing will be moved to another group

i gusse we will need this option too

If your forum is not a READ ONLY forum, if a user has read x posts without posting a reply in the last x days, you can still have it pruned by adjusting the value of "$lastactivity" to 0 or 1 in the configuration file. But choose your values accordingly so that they apply is a consistent manner as the days go by and your forum is running.

[Charlie98902]

With the setting you told us to use this is generating every 24 hours I think is there a way to have this done monthly only and how do I go about that please?

[J98680Bxxxxx]

With the setting you told us to use this is generating every 24 hours I think is there a way to have this done monthly only and how do I go about that please?

Hi Charlie,

You can specify when you wish to have the cron executed in the ACP -> Scheduled Task Manager -> Prune Inactive Members (Edit)

To have it executed every 29th (at 00:00) of the month for example, select the value 29 from the "Day of the month" drop down selection. :up:

Title : Prune Inactive Members
Day of the Week : *
Day of the Month : 29
Hour : 0
Minute : 0
Active : Yes

[Charlie98902]

Thank you I thought it was a small tweak such as this.

[Mum]

Installed, however it appeared to only flag 2 users, which is incorrect... i didn't get an email or anything tell me...

[BluAzn]

I am having problems using this mod, most of the users haven't posted over months and still their status is still there. I have adjusted the configuration of the file, help would be great. I wanted to prune the users to the "Newbie" status.

[J98680Bxxxxx]

I am having problems using this mod, most of the users haven't posted over months and still their status is still there. I have adjusted the configuration of the file, help would be great. I wanted to prune the users to the "Newbie" status.

Which configuration parameters are you using?

[BluAzn]

// Configuration parameters

// The user must had logged in the forum in the last x days
$lastactivity = 5;

// The amount of days an user stays "flagged" before been pruned
$flaggedtime = 7;

// The user must have posted in the forum in the last x days
$lastpost = 5;

// Users with more than this amount of posts will not be pruned
$maxposts = 100;

// Set this to true to email the members that are been pruned
$sendmail = true;

// This is the UserGroup that will receive pruned members.
// If you do not have such usergroup already available,
// please create one and refer to its id number here.
$groupid = 2;

// Set here the usergroups you do NOT wish to have modified,
// seperate each groupid with a space
$exclude = "6 7 5 13 133 9 136 134 12 60 135 11";

// End Configuration parameters

[Super Jinni]

and what about if the users who got pruned signed in and/or post a thread or post?
do they automatically remove to the group which they were belonged to before pruning?

thank you for this, I didn't notice it just now..
and currently I'm using Paul's which I really like.. but as you said, it has not features as yours..

are they work in the same way with Paul's or there is differences?

[J98680Bxxxxx]

// Configuration parameters

// The user must had logged in the forum in the last x days
$lastactivity = 5;

// The amount of days an user stays "flagged" before been pruned
$flaggedtime = 7;

// The user must have posted in the forum in the last x days
$lastpost = 5;

// Users with more than this amount of posts will not be pruned
$maxposts = 100;

// Set this to true to email the members that are been pruned
$sendmail = true;

// This is the UserGroup that will receive pruned members.
// If you do not have such usergroup already available,
// please create one and refer to its id number here.
$groupid = 2;

// Set here the usergroups you do NOT wish to have modified,
// seperate each groupid with a space
$exclude = "6 7 5 13 133 9 136 134 12 60 135 11";

// End Configuration parameters

Hi BluAzn,

I suppose that you are placing your registered members in usergroup(s) different from the standard "Registered Users" group (of Id = 2)?

Please ensure that the Usergroup that will receive pruned members is different from the usergroup(s) where those members are selected before been flagged or pruned.

Let me know if that's not the case.

[J98680Bxxxxx]

and what about if the users who got pruned signed in and/or post a thread or post?
do they automatically remove to the group which they were belonged to before pruning?

thank you for this, I didn't notice it just now..
and currently I'm using Paul's which I really like.. but as you said, it has not features as yours..

are they work in the same way with Paul's or there is differences?

There is no automatic removal from the "Pruned Usergroup", simply because, in my forum for example, moderator(s) must ensure that pruned users are not just posting non sense of the type "Thank you, nice thread" or "Thank you, keep up the good work", etc... over and over just to get unpruned.

The basic principle for pruning is the same as with Paul's Mod. Read the "What this Mod does" from the Thread text above.

[Super Jinni]

ok, I think I like this one more than Paul's Mod

I guess I have to uninstall Paul's Mod in order to install this one right?

and I think if you can make an option for the automatic removal from the "Pruned Usergroup" to turn it on/of according to some conditions depending on the cases that user has moved to the "Pruned Usergroup"

to be honest with you, I've been using Paul's Mod for a while no, and there are some users who they have been in the "Inactive Usergroups" ,and I'm afraid if I Uninstall Paul's Mod I'll have some problems with those who are now in the "Inactive Usergroup".

any suggestions?

:)

[J98680Bxxxxx]

Hi Super Jinni,

It's up to you how you want to use these two mods. I don't think that this Mod and the one from Dr. Peper conflict. Just ensure that you specify the same usergroup Id for prumed members. In any case, you can always move pruned members to any other usergroup manually from your ACP -> Usergroups -> Usergroup Manager.

It is possible to have an automatic removal from the "Pruned Usergroup" according to some conditions. You can use the cron of this mod as basis and just change the SQL query accordingly. :)

[Super Jinni]

ok then, I'm gonna give it a try.. I'll install it beside Paul's Mod..

if I have any problem, I'll post it here..

thanks

:)

[Zelda-King]

I just ran the first cron job on 3.7 Gold. Some users were 'pruned' but they weren't put in the specified usergroup. Would that be because they'd already been inactive for well over the specified time and thus immediately deleted or what?

Am using the following config:
// The user must had logged in the forum in the last x days
$lastactivity = 365;

// The amount of days an user stays "flagged" before been pruned
$flaggedtime = 7;

// The user must have posted in the forum in the last x days
$lastpost = 365;

// Users with more than this amount of posts will not be pruned
$maxposts = 1;

// Set this to true to email the members that are been pruned
$sendmail = true;

// This is the UserGroup that will receive pruned members.
// If you do not have such usergroup already available,
// please create one and refer to its id number here.
$groupid = 23;

// Set here the usergroups you do NOT wish to have modified,
// seperate each groupid with a space
$exclude = "5 6 7 10 22";

[J98680Bxxxxx]

I just ran the first cron job on 3.7 Gold. Some users were 'pruned' but they weren't put in the specified usergroup. Would that be because they'd already been inactive for well over the specified time and thus immediately deleted or what?
...

Hi Zelda-King,

On the first cron job, users get flagged, not pruned yet. Nothing get deleted. Users are moved from one usergroup to another only after the specified flagged time.

Ensure that you actually have the specified usergroup Id = 23 created, also checkout the usergroup ID of those members that were 'pruned'.

:)

[Zelda-King]

Hello!

Well that would explain it then. Nicely timed response too! I was just wondering why no one had changed to that usergroup and yet my member count hadn't gone down either.

What I'm not sure about is how to find which users have been flagged. Oh, and are they e-mailed at this stage or on being pruned?

[J98680Bxxxxx]

Hi,

Those members flagged receive an e-mail notifying them of their situation and asking them to improve their activity status. When the specified flagged time expire, they get 'pruned' and also receive a second e-mail notifying them of their change in status.

To find users that have been flagged, you can use phpMyAdmin (on your server CPanel) and view the (last column of) user table.

Hope it help. :)

[Mum]

What does the email say? (i'm not sure how to find it to read it)

[Zelda-King]

Perfectly clear. Thanks for clearing that up!

[J98680Bxxxxx]

What does the email say? (i'm not sure how to find it to read it)

Open the attached document, using WordPad, and check it out.

[Marvin Hlavac]

Hi all :)

Can this mod delete members automatically, not just move them to another group? I'd like a mod that would delete all my members with 0 posts, who have not been active for one year, and also I'd like to delete all members who have been in the "Waiting for email confirmation" group for over 30 days.

[Vinyljunky]

Installed and working.

Thank you

[polgara_j]

Installed this mod but have received database errors each time I've tried to run it.
Error:
Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE `user` SET `deleflag` = '1216967229' WHERE `userid` = '91';

MySQL Error : Unknown column 'deleflag' in 'field list'
Error Number : 1054
Request Date : Thursday, July 24th 2008 @ 11:27:09 PM
Error Date : Thursday, July 24th 2008 @ 11:27:09 PM
Script : http://www.houseofmoms.org/admincp/cronadmin.php?do=runcron&cronid=19
Referrer : http://www.houseofmoms.org/admincp/cronadmin.php?do=modify
IP Address : 64.xxx.xxx.xxx
Username : polgara_j
Classname : vB_Database
MySQL Version : 4.1.11-Debian_4sarge7

any ideas?

[J98680Bxxxxx]

Installed this mod but have received database errors each time I've tried to run it.
Error:

any ideas?

Did you follow those instructions on creating the database TABLES? :)

[Panagioths]

Hello and thanks for the nice mod. Is there a chance to make a cron job that put back users that have visited the forum back to registered users?

[J98680Bxxxxx]

Hello and thanks for the nice mod. Is there a chance to make a cron job that put back users that have visited the forum back to registered users?

Almost no chances to sit down and write one. The reason is due to the fact that the cron was written to encourage users to become active in posting. If a user is just visiting the board without posting anything, he can well stay in the "pruned" box if he/she has been pruned. If the "pruned" user decide to create a post, I haven't found a way to automatically check that what the "pruned" users will be posting: spams just to get unpruned or will effective posts? Thus, I use a manual process to move a "pruned" user back to the "registered" usergroup.

[polgara_j]

Did you follow those instructions on creating the database TABLES? :)

Actually the issue was that one of the other admins forgot to change the vb language from swedish. :rolleyes: Once we changed it to the standard latin thing your addon worked. :) Thanks, it's a great mod!

[Davey-UK]

Really wish this could include an option to add a user back to the registered usergroup once they are active again.

You mention that the cron could be tweaked to do this???

Any chance of doing it. All my members are in the registered usergroup, and i wouldnt have VIP members included in this mod anyway, so it should just be a straight role reversal??

Any ideas would be greatly appreciated. I may even pay for this mods upgrade. Basically we just dont have the time to monior users continuously. We want it really to stop members playing in the arcade and never even looking at the forum! We could use the vBcredits mod, but its far too intrusive and long winded for this simple option that we require.

Thanks for a great mod though and hopefully you will shed a bit of light on this issue.

:D

[popmyzit]

yeah would be nice to move users back once active again

[Alfa1]

Does this work in vb 3.8.1?

[indie2industry]

Will there ever be a version that WILL DELETE the user?

[titodj]

Is this supported??

[titodj]

Has the ability to prune users that match ALL the following conditions:

1. Has not visited in the last x days (30 by default)
2. Has not posted in the last x days (30 by default)
3. Has x or fewer posts (0 by default)
4. Has been flagged for pruning earlier than x days (7 by default)


All the conditions need to be meeted? or will for example prune a menber that logs in, but has not posted in more than 30 days?

Im actually interested in pruning users that dont post.

[The4um]

Installed and waiting for pruning