The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Users Cleanup Details »» | |||||||||||||||||||||||||||||||||||
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:
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
Screenshots
Show Your Support
|
Благодарность от: | ||
Insta-Gator |
Comments |
#12
|
|||
|
|||
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":
Quote:
That are the only lines i changed: Code:
// social groups $join[] = 'LEFT JOIN ' . TABLE_PREFIX . 'groupmessage ON ' . TABLE_PREFIX .'groupmessage.postuserid = `user`.userid'; $where[] = TABLE_PREFIX .'groupmessage.gmid IS NULL'; // blog if ($vbulletin->products['vbblog']) { $join[] = 'LEFT JOIN ' . TABLE_PREFIX . 'blog_text ON ' . TABLE_PREFIX .'blog_text.bloguserid = `user`.userid'; $where[] = TABLE_PREFIX .'blog_text.blogtextid IS NULL'; } break; |
#13
|
|||
|
|||
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 |
#14
|
|||
|
|||
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.
|
#15
|
||||
|
||||
Thanks again for your efforts. Try 0.4 updated version.
|
#16
|
|||
|
|||
Yay it works. Thanks
And now my question from above: Is there a chance to include custom profilefields in the options? |
#17
|
||||
|
||||
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.
|
#18
|
|||
|
|||
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! |
#19
|
|||
|
|||
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: Quote:
|
#20
|
||||
|
||||
Seems to be mysql 5.0 bug http://www.zen-cart.com/forum/showpo...14&postcount=4
Try to insert PHP Code:
https://github.com/rcdesign/vb-users...eanup.php#L151 and tell me result + how many visitors registered on your forum. |
#21
|
||||
|
||||
Hello,
i have installed this plugin but if a run the task, its nothing happen. any idea? |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|