Users Cleanup

[Vitaly]

This mod helps to automatically delete user account upon custom-defined rules. For example, you can delete members, who didn't comfirmed emails after 3 days, delete members, who have zero posts and didn't visited your forum for a long time, and so on.

Any conditions can be defined! Cleanup can be done in both automatic and manual mode.

Difference between built-in vB user pruner:

1. Completely automated.
2. Comfotable management of multiple rules.
3. More flexible prune criterias.

Some stat for my forum (only zero-posts users were cleared):

- last user ID 50652
- total users left 19359

60% effectivity!!!

Installation:

Upload files and import product XML.

Configuration:
Enter ACP and go to Users -> Cleanup.
Create cleanup rules you needs, and save in inactive state.
Test you rules. Do manual cleanup, if you wish.

Activate rules (enable automatic cleanup), if you are satisfied with testing results.Warning! Don't activate cleanup rules without testing! Don't forget to backup your forum database!

PS. Product is marked as beta, because i can't test all possible rules combinations. But those been used - works fine. If you have strange results duging testing, don't hesitate to post screenshot with your rule, and explain what is wrong.

Was NOT tested with 3.6.x & 3.7.x, but probably works.

This mod is delelopped here http://github.com/rcdesign/vb-users_cleanup . Patches are welcome.

[Vitaly]

Some hints. Here is current config at my site. Can't recomment to everyone, but that can give you some ideas.

User groups (upgraded on time basis):

1. Just registered - no posting permissions, upgraded after 1 day. Nice way to beat spammers.
2. Novice - specific for my forum. Limited access. Can make posts, but no writing access to "trading" categories. Upgraded after 30 days.
3. Full memfer

Cleanup rules:

1. Delete "Just registered" after 7 inactivity days.
2. Delete "Novice" with zero posts after 21 inactivity days.
3. Delete "Full Members" with zero posts after 180 inactivity days.
4. Delete "not validated emails" after 3 days.

Effectivity - 60%.

Also tested this rule: "delete old members, less than 5 posts, gone more than 2 years ago". - only 5% effectivity.

[Ronald0]

Wow, this is a very useful module, might end up using it in the future. Depending on whether or not i want to keep my statistics or not.

When you say above "havent viewed in a long time", what do mean like whats the set time?

[Vitaly]

I'm not sure, that understand your question. Any rule set depends on forum policy, and can't be generalised. All possible conditions are shown on screenshot, but values depend on each forum owner.

[YISRAEL]

Not so useful but still thanks a lot

[Vitaly]

Not so useful but still thanks a lot

I don't agree. More than 50% accounts are dummy, and can be cleared, to free usernames. That make sense for big forums, and simplify maintenance in some cases.

Stats for mu forum:

- last user ID 50652
- total users (after cleanup) 19359

PS. Added statistics to mod description.

[ishare]

Vitaly you do great works.. And i appreciate it very much. This is very very useful and i will sure use it in near future. Right now i will tag it for future use. But i did want to thank you for this great job.

[Frondy]

Very useful, thanx!

installed

Little suggestion:

When testing, it displays all users defined by rule on sinle page, maybe will be better to split on several pages, e.g. 100 per page?

[Vitaly]

Added "live config" example to second post. Enjoy :)

Little suggestion:

When testing, it displays all users defined by rule on sinle page, maybe will be better to split on several pages, e.g. 100 per page?

When your rules are active, those are applyed every days, and test results are very small. Big list can exist ONLY before first cleanup. So, I don't see reasons to overcomplicate code :)

Hint: you can increase "inactivity" value and clear users manually with several passes.

[Frondy]

Added "live config" example to second post. Enjoy :)



When your rules are active, those are applyed every days, and test results are very small. Big list can exist ONLY before first cleanup. So, I don't see reasons to overcomplicate code :)

Hint: you can increase "inactivity" value and clear users manually with several passes.

Yes, that is true. Before first clean up, my Firefox stops responding, but now, everithing works fine :up:

Thank You

[Vitaly]

Frondy, could you publish statistics for your forum? Last user ID and total members after cleanup?

[Frondy]

Frondy, could you publish statistics for your forum? Last user ID and total members after cleanup?

20.354 last ID
10,880 after

I have filtered just members not active for 365 days and with no posts

:D

[thedvs]

this is a big ask, but could you add an addon like a counter for the post thanks hack?
some boards, we just use the thanks hack so people dont post useless threads

so we can check 0 posts 0 thanks etc

[Vitaly]

I'm not sure, that will customize this mod in nearest future for third-party products. The only good news, that mod is reuseable :)

[TWTCommish]

Looks interesting; what's the difference between vBulletin's built-in user pruning options and this? More criteria?

[Vitaly]

Looks interesting; what's the difference between vBulletin's built-in user pruning options and this? More criteria?

1. Completely automated.
2. Manage multiple rules.
3. More flexible criterias.

PS. added to mod description.

[Black Tiger]

Thank you Vitaly, I was just looking for something like this! Marked installed! :)

[smirkley]

I like this.

I used to have a mod that removed unverified accounts after 7 days if the member did not verify by email.

What settings would I use to do the same with your mod?

[Black Tiger]

Question. How does this get automated? I just installed and configured and marked the rule active. But I don't see any crontab appearing in the Scheduled task manager. How is it made automated then?

[Alfa1]

Would be really useful to my board, if inactive members get reminder emails first. This would certainly increase the number of active members on a board. Just deleting the inactive accounts without trying to get those members active first, seems to be missing the boat.

[a9eel]

thx Vitaly keep the good work

[Vitaly]

Would be really useful to my board, if inactive members get reminder emails first. This would certainly increase the number of active members on a board. Just deleting the inactive accounts without trying to get those members active first, seems to be missing the boat.

Sorry, no. I consider such methods as "abusing".

[Sunka]

Question. How does this get automated? I just installed and configured and marked the rule active. But I don't see any crontab appearing in the Scheduled task manager. How is it made automated then?

Installed and want to know answer for quoted question too!
And how to manually delete users? ==> Click on test and then delete users???

[Vitaly]

Installed and want to know answer for quoted question too!
There should be "Users Cleanup" crontab after import. Look for code in end of XML-file.
And how to manually delete users? ==> Click on test and then delete users???
Yes.

[Sunka]

aaaaa, I see now
So, by default it is run every 4 hours and 10 minutes?

Cpacibo!

[Vitaly]

Every day in 04:10. That's enougth.

[Frondy]

Is there any chance to add filter for members without e-mail?
I use one mod to remove nonvalid emails from users profile

Thank you

[Vitaly]

No such plans.

You could use email validation during registration, and the make rule to remove members from "validating email" group.

[Frondy]

No such plans.

You could use email validation during registration, and the make rule to remove members from "validating email" group.

Yes, that is my plan, tu use mail validation, but it is too late for older members...

Thank you anyway :up:

[LI_Pets]

Not sure why you would want toss members away like this, it doesn't cost anything to keep them.

I have old members that haven't posted in a long time, but when they get the birthday email they come back sometimes.

I would suggest a reminder email based on criteria, they signed up that is NOT abuse.

Also rather then deleting anyone ever they should be moved to another user group like "inactive"

Never discard members totally IMO.

[artpapa]

Hi Vitalik!
I'm trying to install it, but "Invalid File Specified" still came out while I'm importing xml file in my admin control panel.
please помогите.

[Vitaly]

Seems you haven't uploaded files from "upload" folder.

[dwkmi]

What happens to user's posts once the user is deleted?

[Vitaly]

Nothing. Result is the same, as when you delete user manually.

[TheInsaneManiac]

Wow, this is a very useful module, might end up using it in the future. Depending on whether or not i want to keep my statistics or not.

When you say above "havent viewed in a long time", what do mean like whats the set time?
Believe me... After awhile you just need to start as fresh as possible. Any server will crumble a few times when you DB is 200 MB. I went in cleaned up posts that haven't been replied to within the last year and I deleted all members that have no posts that registered over 2 weeks ago.

[AzzidReign]

What's the purpose of cleaning users? And if I clean up my users, will it decrease my "users" stat on my site?

[webhost]

Hello, uploaded all the files but can not get the file imported, exact steps for this please.

[BillieJoe]

this seems to be a very usefull mod!

but is there a chance to have the option that a user needs to have for example 3 posts within the last 30 days or otherwise he will get banned?

greetz

billiejoe

[webhost]

How are you guys importing this in vb admin please, havign issues here gettign it done

[mgurain]

Hi,
1. Does it work correctly with you ?
2. Can it display the users to be deleted for confirmation ? I may put by mistake undesired rules, then I loose my users without knowing !

Thanks,,

[Vitaly]

Hi,
Can it display the users to be deleted for confirmation ? I may put by mistake undesired rules, then I loose my users without knowing !
Thanks,,

Look for description in first post. The're manual "test" mode. It contains confirmation and list of found users for that rule. Anyway, it's a good idea to backup database prior changes.

[ravenfaust]

you think you could make this PM users with 0 posts?

[Vitaly]

No plans now to do that. But code is reuseable, you can make your fork, or send changes here http://github.com/rcdesign/vb-users_cleanup

[sixdemons]

does anybody know if this mod is compatible with vb4 ?

[Chef_uk]

Thanks alot. This mod has its uses for some but not for others, each to their own. For me, it has a use so thanks :D

[pablete]

does anybody know if this mod is compatible with vb4 ?

Nobody know..... i also want this mod for vb4.

Thanks

[Plurall]

Hi, I´d like to purge users who have 0 posts and have the same registration and last visit date. And all spammers users, for example, every user registered with @mail.ru e-mails, or @*up.com.

Can I mass prune using this criteria types with Users Cleanup?

Thanks!

[robk6364]

I downloaded and installed this today on 3.8.5. I uploaded each of three files individually and triple-checked their locations. (users_cleanup.php is in admincp) I then imported the product XML. I do not have a "Cleanup" option under the Users menu in the navigation frame. I tried uninstalling and reinstalling the product XML, but that didn't seem to fix it. What might I have done wrong?

Edit: Solved. I had to add myself to the superadministrator group before I could see it. Might be helpful for other newbies to mention that in your description.

This is a very handy tool you've created and a big time saver. Thank you for sharing!

[R.o.o.t]

thank u

[mp3president]

Thank you, i'll try this mod for a month or so.
Normaly i do this manualy.

[gsmworldone]

Urgent Thread starter, we need HELP...
W have installed your plug ins
"" ISO-8859-1__Users-Cleanup-0.1.rar ""

and we tried to set it to"below 10 posts members will be deleted", and "30days inactive account will be deleted"

We didn't expect that many members have that kind of posts, which is below 10 posts. Its our mistake.

most of our member deleted ( we're so lonely with this. yesterday our members count is 1100plus. now we are only 500+ (

we don't have the back up for this month (January), we forget to backup, our only backup is last december 2010.

we love our members. and we need them..

Is there any other way to restore them? Other than to restore our back up which is Dec back up. And how can we retain the new members who registered from January 1 up to now?


I hope there is.......

TIA

[Vitaly]

This mod have "test" button for each rule. And red bold text in description, that all rules should be tested prior to activate.

There are no way to restore without backups. Sorry for bad news.

[mp3president]

I tested it for 2 weeks now and it's working great here.
But be carefull with some settings.
Only thing i am missing is a setting for moving a user to another group instead of deleting the user.
But maybe a tip for the future.

[owning_y0u]

installed on vb4.1.1 tested and working Thumbs up :D

[Daryn]

Hey this is a really great addon. Very practical. I was wondering though, would it be possible to add the option to move users to a specific usergroup?

Also, I noticed that if you run a test and the mod only finds 1 user it will go straight to that profile rather than giving you the list of users and options to take.

[Gadget_Guy]

I installed this add-on (great add-on but I just really needed to run it once to do a massive cleanup) and it worked great.

I decided to uninstall so that someone else didn't accidentally use it and mess things up.

It left remnants in my AdminCP

Under "Users" I now have: *[users_cleanup]*

How do I completely remove the product?

D.

[xorex]

Under "Users" I now have: *[users_cleanup]*

How do I completely remove the product?


delete cpnav_users_cleanup.xml from includes/xml folder and other files for this hack

[ezak]

can you add this functions for this great mod

clean up who have invalid email
SQL query example
SELECT * FROM users WHERE email NOT LIKE '_%@__%.__%'

also, is this mod make confirmation before delete ?

[ricardoNJ]

Thanks !

[JordanBuss13]

Is there a version of this for vBulletin 4.2.0?

[azn_romeo_4u]

Just tested this. I didn't create a setting but mostly just deleted users through the "test" worked perfectly. Over 40k accounts just deleted. Still got 60k to go through.

[gtrcanada]

NOt sure if I am doing this correctly...I set my rules, clcik "Test" and get a list of 14,000 members. I then click "Select All" (all users have a check mark), "Delete" then "Go".

I get an error "Invalid Action Selected" "No User Matched Your Query".

[msibm]

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

[TAIFUN_T]

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Do not need to run the script manually.