Users Cleanup
 

3.8 version repost. The same code.

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.

History:

0.4
- Fixed SQL queries for some conditions (thnks to phr4nk13)

0.3
- compleete code rafactoring
- removed deletet posts count as useless
- added support for blogs & social groups

(!) For upgraders - your cleanup rule swill be disabled! Plese, recheck & enable again.

Polish version

Could be very useful for one of my sites.

Thank you.

Tagged for future use, thanks for the hard work!

Worked for me... did exactly what it said it would do.

I only used the test and manual delete function....

Maybe later, I'll try the cron enabled function.

In any case - thanks for the handy utility!

it works
thank you

Code is completely refactored to make it clear & more effective. Blogs & SG support added.

After upgrade your previous rules wil be disabled. Please, check those manually & enable again.

Installed with thanks for testing on 4.04 .... :)

We'd like to use it to clear out any users "Awaiting Email Confirmation" user group who haven't responded to validation email in 14 days or more ...

Regards,
Doug

That'S exatly what i've searched for. Thanks.

But I gat a SQL/database-error with it when selecting "User has never posted (also count in social groups and blogs)" and test this option.


With my little SQL knowlegde and some Try and Error this function_users_cleanup.php (attachment) is working i think. Anyway please chekc my changes if there are any security mistakes.

Is there a chance to include custom profilefields in the options?

Using vBulletin Suite 4.1.2. German

Sorry for my bad english :)

Thanks for your help. Could you tell full text of SQL error?

May be, problem can be with scopes, but "never posted" condition works at my forum. Can't accept your patch into mainline, because you removed table prefix - that will not be compatible with all installations. But i'll try to do somerthing, if you tell me more info about error. Please, tell me also your SQL version & exact selections set in your cleanup rule, that cause problems.

I didn't remove the table prefix, i added it. That ist the errormessage onli with this option "User has never posted (also count in social groups and blogs)" selectet and clicked on "test":


I was first trying to hardcode the prefix. Than i got the variable to work.

That are the only lines i changed:

Does the last few posts mean there's a problem with the mod and we should put it's use on hold for now? :confused:

Thanks ... :)

Regards,
Doug

Thats only a problem at my installation (atm) and the last option selected. If you push "test" you can try it yourself. All other options working fine for me.

Thanks again for your efforts. Try 0.4 updated version.

Yay it works. Thanks :)

And now my question from above: Is there a chance to include custom profilefields in the options?

Chances are a bit less than zero :) . But if you could explain, why this required for my progect, or at least to hundreds of vborg visitors - somerthing can change.

OK...this is a lifesaver...great plugin! I had about 100K in posts and pruning would just cause time out. so I used this and was able to prune users by certain post counts. If the list of users list was too large it wouldn't work but it's an enormous list of users...so I just had to shorten the distance in posts.

After doing that I ran SQL Query of DELETE FROM post WHERE userid = 0 to get rid of all the posts from users who were turned into guests. Updated all counters and I accomplished what I have been trying to do for about a month.

I'm nominating for MOTM!

Installed on 4.1.2 but getting the same issue as a previous user - db error when I choose "User has never posted (also count in social groups and blogs)."

The error is:

Seems to be mysql 5.0 bug http://www.zen-cart.com/forum/showpo...14&postcount=4

Try to insert
BEFORE that line

https://github.com/rcdesign/vb-users...eanup.php#L151

and tell me result + how many visitors registered on your forum.

Hello,

i have installed this plugin but if a run the task, its nothing happen. any idea?

this is funny..
I added the product and this worked correctly.
I have it in the installed products.
I have it in the ACP general options.
I havent it in the ACP users panel.. :(

i am running 4.1.2

i mean i can set the time and frequence options in the ACP panel, but i dont find where to set WHAT users i have to clean

by the way, i have a ton of RC jeepers on my site..

@giaguaro

this option is in the "Users"-Panel (where you can edit users etc.) in ACP.

as i told you, i have not the option in the User panel.
Everything else seem to be there correctly..

there is no way for recovering the userids, of the people which got deleted?

I'm using 4.1.3, and I've also installed the mod as instructed, and do not see it under Users in the Admin CP...

me too. But no answer..

Great mod, what I would love to see and would absolutely use it if it is possible is if instead of deleting members they would be moved into a membergroup. For example I want to have a deactivated accounts membergroup and if they haven't visited in two months they are moved into this group.

up. Need assistance.. :(

up, need assistance

What I would like to see in something like this is ability to prune members who have not accepted the rules yet. Any way to add that in easily?

Try Move Inactive and Lurker Users To New Usergroup mod

Nice and easy tool, works perfect here on 4.1.4, thanks for this ;)

I've got some other problems with spam-users. Let me explain my problem, and see if this mod can do this or can be modified easily.

I run a car forum, where every user can specify his car/model via 2 custom profile fields. spam bots do always fill out these fields upon registration and always choose the first option of these custom fields.
can I insert these custom profile fields into this mod, to find only users, who have filled out these 2 profile fields with the first answers?

Awesome; thanks.

Assuming you've already eliminated spambots with one of the many solutions for them, I can only say I wish I was as lucky as you that our spam-humans would be so obvious. The way it is, I can't tell them from real members and that makes squashing them particularly difficult.

The Best Mod Ever, thank you very much

why do i need a title and what do i put there also what would i put in display order?
also how would i do a admin control of this mod?

hello,
This mod allows it to put the id in order?

ID:1,2,5,7,8,10...
ID:1,2,3,4,5,6...

Thank you ;)