Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Users Cleanup Details »
Users Cleanup
Mod Version: 0.4, by Vitaly (Coder/Designer) Vitaly is offline
Developer Last Online: Jul 2014 I like it Show Printable Version Email this Page

vB Version: 4.0.x Rating: (9 votes - 4.89 average) Installs: 142
Released: 16 Jun 2010 Last Update: 21 Mar 2011 Downloads: 737
Not Supported Uses Plugins Additional Files Re-usable Code  

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.

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	uc1.gif
Views:	1460
Size:	37.6 KB
ID:	118509   Click image for larger version

Name:	uc2.gif
Views:	1516
Size:	53.4 KB
ID:	118510  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Administrative and Maintenance Tools Users Cleanup Vitaly vBulletin 3.8 Add-ons 62 09 Jan 2016 21:51

Comments
  #2  
Old 16 Jun 2010, 09:26
Marek58's Avatar
Marek58 Marek58 is offline
 
Join Date: Oct 2005
Real name: Marek
Polish version
Attached Files
File Type: xml Users_Cleanup_Polish-language.xml (3.4 KB, 17 views)
__________________
Best regards,
Marek
Reply With Quote
  #3  
Old 16 Jun 2010, 11:16
gwerzal's Avatar
gwerzal gwerzal is offline
 
Join Date: Oct 2007
Could be very useful for one of my sites.

Thank you.
Reply With Quote
  #4  
Old 16 Jun 2010, 11:22
BozzaJos BozzaJos is offline
 
Join Date: Feb 2006
Tagged for future use, thanks for the hard work!
Reply With Quote
  #5  
Old 30 Jun 2010, 13:07
tornado88 tornado88 is offline
 
Join Date: Apr 2007
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!
Reply With Quote
  #6  
Old 13 Jul 2010, 15:26
cobaku cobaku is offline
 
Join Date: Oct 2005
it works
thank you
Reply With Quote
  #7  
Old 21 Mar 2011, 11:32
Vitaly's Avatar
Vitaly Vitaly is offline
 
Join Date: Apr 2004
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.
__________________
I no longer develop for vB. Use my vb addons/code as you wish, without limits & conditions. Latest versions @ github repo.
My new forum project is Nodeca. Node.js+MongoDB. If you wish to help with coding & design - feel free to join.
Reply With Quote
  #8  
Old 21 Mar 2011, 14:10
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Real name: Doug
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
Reply With Quote
  #9  
Old 21 Mar 2011, 17:57
phr4nk13 phr4nk13 is offline
 
Join Date: Jul 2009
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
Attached Files
File Type: php functions_users_cleanup.php (5.6 KB, 5 views)

Last edited by phr4nk13; 21 Mar 2011 at 18:07. Reason: vB version added
Reply With Quote
  #10  
Old 21 Mar 2011, 18:44
Vitaly's Avatar
Vitaly Vitaly is offline
 
Join Date: Apr 2004
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 no longer develop for vB. Use my vb addons/code as you wish, without limits & conditions. Latest versions @ github repo.
My new forum project is Nodeca. Node.js+MongoDB. If you wish to help with coding & design - feel free to join.
Reply With Quote
  #11  
Old 21 Mar 2011, 19:30
phr4nk13 phr4nk13 is offline
 
Join Date: Jul 2009
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":


Datenbankfehler in vBulletin 4.1.2:

Invalid SQL:
SELECT
`user`.*
FROM
vb_user AS user
LEFT JOIN vb_groupmessage ON `groupmessage`.postuserid = `user`.userid
LEFT JOIN vb_blog_text ON `blog_text`.bloguserid = `user`.userid
WHERE
`user`.`posts` = 0 AND `groupmessage`.gmid IS NULL AND `blog_text`.blogtextid IS NULL AND `user`.`userid` NOT IN (0);

MySQL-Fehler : Unknown column 'groupmessage.gmid' in 'where clause'
Fehler-Nr. : 1054
Fehler-Zeit : Monday, 21.03.2011 @ 20:23:28
Datum : Monday, 21.03.2011 @ 20:23:28
Skript : vbroot/admincp/users_cleanup.php?do=test
Referrer : vbroot/admincp/users_cleanup.php?do=add
IP-Adresse : xXx
Benutzername : xXx
Klassenname : vB_Database
MySQL-Version : 5.1.43-nmm4-log
I was first trying to hardcode the prefix. Than i got the variable to work.

That are the only lines i changed:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #12  
Old 21 Mar 2011, 19:36
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Real name: Doug
Does the last few posts mean there's a problem with the mod and we should put it's use on hold for now?

Thanks ...

Regards,
Doug
Reply With Quote
  #13  
Old 21 Mar 2011, 19:44
phr4nk13 phr4nk13 is offline
 
Join Date: Jul 2009
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.
Reply With Quote
  #14  
Old 21 Mar 2011, 20:05
Vitaly's Avatar
Vitaly Vitaly is offline
 
Join Date: Apr 2004
Thanks again for your efforts. Try 0.4 updated version.
__________________
I no longer develop for vB. Use my vb addons/code as you wish, without limits & conditions. Latest versions @ github repo.
My new forum project is Nodeca. Node.js+MongoDB. If you wish to help with coding & design - feel free to join.
Reply With Quote
  #15  
Old 21 Mar 2011, 20:14
phr4nk13 phr4nk13 is offline
 
Join Date: Jul 2009
Yay it works. Thanks

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


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 18:54.

Layout Options | Width: Wide Color: