Add-On Releases - Automatic Inactive Users Pruning - vB3.7 RC2

Originally Created by NeoRevan (in 2005) for vB 3.0.7.

I could not run NeoRevan?s version on vB3.7 CR2.

I also took a look at a similar Mod by Paul M (Dr Pepper Addict) on Inactive Users, but I missed some of NeoRevan?s features on it.

Thus I decided to update NeoRevan?s version 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:

1. Runs a daily cronjob, removing all members according to the script's configuration
2. Exclude selected usergroups from been pruned
3. Flag automatically selected user(s) for pruning after x days (7 by default)
4. Email automatically selected user(s) that have been flagged (on by default)
5. 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)
6. Send email to pruned users, notifying them of their change in status membership (on by default)
7. Send email to the admin (webmaster) for book keeping.

Installation instructions in the attachment.

[J98680Bxxxxx]

Originally Posted by Mum

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/c...cron&cronid=19
Referrer : http://www.houseofmoms.org/admincp/c....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]

Originally Posted by polgara_j

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]

Originally Posted by 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?

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]

Originally Posted by J98680B2423E

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

[popmyzit]

yeah would be nice to move users back once active again