Administrative and Maintenance Tools - 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.

[PeteMarko]

After uploading I import product users cleanup from my computer can you verify please

[PeteMarko]

All done and good, perfect, thank you

[PeteMarko]

Just trying to delete all users with zero posts and do not belong to certain groups, eg, administrators, top poster etc. It does not seem to play to the rule after I save ?

[PeteMarko]

I get invalid query, this is what was happening in the default move / prune routine also?

[TheLastSuperman]

Can you post a screenshot of the error?

Also how many members are listed with 0 posts from phpmyadmin? I would check and verify that its not a large number... if any mod attempts to delete via query a large amount of data or tons of users accounts it could timeout or produce a similar error (possibly it depends on a number of factors server type mainly) and this is why with most of the maintenance offered within the admincp you see notations about processing in batches of 250/500 but nothing over 500.

[PeteMarko]

I have been trying to delete far in excess of 500 so I'm sure that is the issue, I will try less and report back.

Is there away to restrict the amount of deletions? Doing by checking the list manually is longwinded.

Thank you for your response so far, its appreciated

[PeteMarko]

I have managed to delete the contacts I needed to by doing it in chunks.

[TheLastSuperman]

Originally Posted by PeteMarko

I have been trying to delete far in excess of 500 so I'm sure that is the issue, I will try less and report back.

Is there away to restrict the amount of deletions? Doing by checking the list manually is longwinded.

Thank you for your response so far, its appreciated

No place to edit and enter in a #, no. However in a sense by showing w/ option to check it simply won't process in a large batch. Long winded yes but for inexperienced users more safe than typing out a query that their unsure of what exactly its doing etc.

Originally Posted by PeteMarko

I have managed to delete the contacts I needed to by doing it in chunks.

Awesome .

[Reminisce32]

Just installed this on my 4.2.3 and activated plugin and the Clean Up link shows up no where in my Users section of admincp. Help please...?

[andy2295]

Works fine on 4.2.3 providing you dont try to prune more than 500 users at once