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) 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: 146
Released: 16 Jun 2010 Last Update: 21 Mar 2011 Downloads: 761
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:	1523
Size:	37.6 KB
ID:	118509   Click image for larger version

Name:	uc2.gif
Views:	1566
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

  #16  
Old 21 Mar 2011, 20:23
Vitaly's Avatar
Vitaly Vitaly is offline
 
Join Date: Apr 2004
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.
__________________
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
  #17  
Old 23 Mar 2011, 15:22
combs combs is offline
 
Join Date: Aug 2007
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!
Reply With Quote
  #18  
Old 04 Apr 2011, 04:10
Merriweather Merriweather is offline
 
Join Date: Nov 2006
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:

Database error in vBulletin 4.1.2:

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

MySQL Error : The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Error Number : 1104
Request Date : Sunday, April 3rd 2011 @ 09:09:41 PM
Error Date : Sunday, April 3rd 2011 @ 09:09:41 PM
Script : http://www.mysite.com/admincp/users_cleanup.php?do=test
Referrer : http://www.mysite.com/admincp/users_cleanup.php?do=add
IP Address : 76.28.215.148
Username : MyUserName
Classname : vB_Database
MySQL Version : 5.0.51a-24+lenny5-log
Reply With Quote
  #19  
Old 05 Apr 2011, 18:48
Vitaly's Avatar
Vitaly Vitaly is offline
 
Join Date: Apr 2004
Seems to be mysql 5.0 bug http://www.zen-cart.com/forum/showpo...14&postcount=4

Try to insert

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

BEFORE that line

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

and tell me result + how many visitors registered on your forum.
__________________
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
  #20  
Old 09 Apr 2011, 17:37
Kraxell's Avatar
Kraxell Kraxell is offline
 
Join Date: Jun 2010
Real name: Andi
Hello,

i have installed this plugin but if a run the task, its nothing happen. any idea?
Reply With Quote
  #21  
Old 09 Apr 2011, 19:20
giaguaro giaguaro is offline
 
Join Date: Feb 2011
Real name: Marco
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

Last edited by giaguaro; 09 Apr 2011 at 19:47.
Reply With Quote
  #22  
Old 09 Apr 2011, 20:14
giaguaro giaguaro is offline
 
Join Date: Feb 2011
Real name: Marco
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
Reply With Quote
  #23  
Old 10 Apr 2011, 10:47
giaguaro giaguaro is offline
 
Join Date: Feb 2011
Real name: Marco
by the way, i have a ton of RC jeepers on my site..
Reply With Quote
  #24  
Old 11 Apr 2011, 20:48
Kraxell's Avatar
Kraxell Kraxell is offline
 
Join Date: Jun 2010
Real name: Andi
@giaguaro

this option is in the "Users"-Panel (where you can edit users etc.) in ACP.
Reply With Quote
  #25  
Old 26 Apr 2011, 18:51
giaguaro giaguaro is offline
 
Join Date: Feb 2011
Real name: Marco
as i told you, i have not the option in the User panel.
Everything else seem to be there correctly..
Reply With Quote
  #26  
Old 27 Apr 2011, 00:25
rob01 rob01 is offline
 
Join Date: Sep 2008
Real name: robert
there is no way for recovering the userids, of the people which got deleted?
Reply With Quote
  #27  
Old 27 Apr 2011, 21:14
LBGSHI LBGSHI is offline
 
Join Date: Jun 2009
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...
Reply With Quote
  #28  
Old 28 Apr 2011, 19:07
giaguaro giaguaro is offline
 
Join Date: Feb 2011
Real name: Marco
Originally Posted by LBGSHI View Post
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..
Reply With Quote
  #29  
Old 28 Apr 2011, 23:16
AWMGolfer AWMGolfer is offline
 
Join Date: Dec 2007
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.
__________________
http://www.maineforums.net
Reply With Quote
  #30  
Old 30 Apr 2011, 18:37
giaguaro giaguaro is offline
 
Join Date: Feb 2011
Real name: Marco
Originally Posted by giaguaro View Post
me too. But no answer..
up. Need assistance..
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 12:33.

Layout Options | Width: Wide Color: