Users Cleanup

[Vitaly]

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.

[Marek58]

Polish version

[gwerzal]

Could be very useful for one of my sites.

Thank you.

[BozzaJos]

Tagged for future use, thanks for the hard work!

[tornado88]

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!

[cobaku]

it works
thank you

[Vitaly]

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.

[BadgerDog]

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

[phr4nk13]

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 :)

[Vitaly]

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.

[phr4nk13]

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:

// 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;

[BadgerDog]

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

[phr4nk13]

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.

[Vitaly]

Thanks again for your efforts. Try 0.4 updated version.

[phr4nk13]

Yay it works. Thanks :)

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

[Vitaly]

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.

[combs]

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!

[Merriweather]

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

[Vitaly]

Seems to be mysql 5.0 bug http://www.zen-cart.com/forum/showpost.php?p=618714&postcount=4

Try to insert
$db->query_write("SET OPTION SQL_BIG_SELECTS=1");

BEFORE that line

https://github.com/rcdesign/vb-users_cleanup/blob/master/upload/includes/functions_users_cleanup.php#L151

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

[Kraxell]

Hello,

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

[giaguaro]

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

[giaguaro]

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

[giaguaro]

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

[Kraxell]

@giaguaro

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

[giaguaro]

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

[rob01]

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

[LBGSHI]

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...

[giaguaro]

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..

[AWMGolfer]

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.

[giaguaro]

me too. But no answer..

up. Need assistance.. :(

[giaguaro]

up. Need assistance.. :(

up, need assistance

[dmm2020]

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?

[Gecuba]

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.Try Move Inactive and Lurker Users To New Usergroup (https://vborg.vbsupport.ru/showthread.php?t=231874) mod

[pantani]

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

[ckeins]

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?

[LBGSHI]

Awesome; thanks.

[Videx]

...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?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.

[riteshsanap]

The Best Mod Ever, thank you very much

[TombstoneWarrior]

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?

[14DH01]

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 ;)

[gsmlover4u]

is it working with vb 4.1.10 ?
cause its not working for me its show me blank page when i click on test

[sarangan]

It's doesn't works for me either. I'm using 4.1.10

[Black Tiger]

I just upgraded from version 0.1 to 0.4.
Now above it says this statement:
(!) For upgraders - your cleanup rule swill be disabled! Plese, recheck & enable again.
But I checked and neither the cleanup rules nore the cronjob were disabled as stated.
Did I do something wrong or can I just ignore the fact that they were not disabled?

[Black Tiger]

Found it.
I thought you ment the rules themselfs would be disabled, but it's the mod itself, there where the rules are place in users->cleanup.
Enabled it again. Works like a charm on 3.8.7.

[datoneer]

Great mod just what i needed. Installed & Nominated

[Nirjonadda]

Developer Last Online: Sep 2011

Any one can update it for work on 4.1.10 ?

[Danny Diamond]

It does NOT work for 4.1.12

[10giay.com]

I need user vb version 4.2.0 PL2

[Tize.]

Nominated, Installed, and 5stars.
Works perfect in vBulletin 4.0.7
Thanks.

[maximoII]

works ok with 4.1.7
Would be nice to add in the rule something to clear Invalid/rejected email

[sverdios]

Great mod just what i needed. Installed & Nominated

yea me too, I need to clean my db

[MattGarner]

Has anyone tried this in 4.2?

[toibs]

Same question here - Does this work in 4.2.x?

[navossoc]

Same question here - Does this work in 4.2.x?

Yes, it works. Tested on 4.2.0 PL3.

[gsmlover4u]

when i click on test it show only blank page i am using vb 4.2.1

[The Rocketeer]

Works okay in 4.2.1.

@gsmlover4u have you uploaded the files in the upload folder? also you have to select / tick one of the options in the page eg. xxx days before clicking test. pretty good plugin for what it is. Thanks :)

[sargunamtech]

hi there

i have a problem and i hope someone can help. i am getting the following error which i dont know what to do ....

/admincp/user.php?do=dopruneusers

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@******.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

[ozzy47]

You need to check the email that you should have received and post the full error, what you posted is of no help.

Or check your server error logs, if you don't know where they are at, ask your host.

[caciocode]

Could anyone help please.

This does not work at all. It returns a blank page when I click on test.

Am I missing something.

I have uploaded the files.

Vbulletin is powered by vBulletin® Version 4.2.1

Thanks.

[DemOnstar]

is there another add on that can do this job and has been proved to do so?

Thanks...

[ozzy47]

Why is this not working correctly for you?

[gsmlover4u]

is there any option to delete user which are registerd on specific date ?
for example i want delete user which are registerd on 11/06/2013 ?

[aquabid]

is there any option to delete user which are registerd on specific date ?
for example i want delete user which are registerd on 11/06/2013 ?

Use the User registered between X and X days ago option. Count the number of days back

[aquabid]

Can we get a option where Registration Date equals Last Activity Date?

[sreeve]

Could anyone help please.

This does not work at all. It returns a blank page when I click on test.

Am I missing something.

I have uploaded the files.

Vbulletin is powered by vBulletin? Version 4.2.1

Thanks.

I'm also having this issue and running 4.2.1

[AlpineZone]

Um, so how does this work? I have like 30,000 registered users in the past four days. I want to delete all of them, and their posts and threads.

I run the test then click Delete, OK and it says Invalid Action Specified, then No Users Matched Query, then it goes to the regular Prune page.

[Videx]

I don't know; maybe it's timing out - try smaller chunks if possible. But did you really get THIRTY THOUSAND junk registrations in the last 4 days?????

[AlpineZone]

I don't know; maybe it's timing out - try smaller chunks if possible. But did you really get THIRTY THOUSAND junk registrations in the last 4 days?????

I'll try a smaller one.

Yeah, like 28,000 registrations and 200,000 posts. On SkiMRV.com. Working it now ... slowly. One spam account alone had 48,000 posts.

[MattGarner]

The test thing doesn't seem to even work on 4.2.2?

[davidg]

The test thing doesn't seem to even work on 4.2.2?

then u are doing something wrong because it works just fine with 4.2.2

[J.kay]

not working on 4.2.2

[jazmos]

I installed this product on VB 4.2.2 and did a test and the test seems to work. However how does the product run and delete users? I know there is a manual and automated mode but where do I set those options and when does the automated mode run? I have over 40,000 Users awaiting Email Confirmations dated back to 2004 that I need to delete and using the prune option yields 1000 users deleted at a time.

[btedition]

This works great on 4.2.0, can't we add a search string to search for a specific IP ?

[jazmos]

What version of this product are you running on VB 4.2.2 that is working? I see that there is 3 different releases and I think I tried the third one which Is .04 I believe. I see all the files were last modified March 21, 2011 in the folder I downloaded for this product. Is that the latest version?

[YOODA230]

any updates?

[Alibass]

any updates?
Kinda doubt it, coder has be online since July of last year and there has been no updates since 2011.

[PeteMarko]

I don't see an option to clean users in / users? V4

[Alibass]

In admincp/users/cleanup then click add rule...

[PeteMarko]

I don't see anything called cleanup in the user area of admincp?

[TheLastSuperman]

I don't see anything called cleanup in the user area of admincp?

Log into admincp, now on the left look for:

Users > Cleanup

Example:
https://vborg.vbsupport.ru/attachment.php?attachmentid=118509

It's in the small left column on the left, click to expand the users box then @ the very bottom is the link. *If the link is not there under the users box in admincp, that means you didn't upload the files properly. When you download the mod its in a .zip archive, once you extract the files and folders there is a folder titled "upload" <-- you upload whats WITHIN that folder to your forums, DO NOT upload the entire "upload" folder else it won't work i.e. the files required are now within /public_html/upload/admincp/themodsfiles.php instead of public_html/admincp/themodsfiles.php because the "upload" folder was just a place holder for the files not the folder they need to be in on your server.

[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]

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.

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

Awesome :D.

[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

[Islamic Board]

The "User has never posted (also count in social groups and blogs)." is not taking deleted posts into account. I want to be able to remove only those user who have really never posted, not those whose posts were deleted.

[twistedsoul]

is there a way to make it move those inactives to an inactive usergroup instead of deleteing the user?

[tanzeelniazi]

i dont understand when i make a rule in Users Cleanup Rules Manager after Mod what do ?
i mean i create test rule no 1
User has not visited for days or more 365 days or more
User belongs to main usergroup [Members]
User has never posted (also count in social groups and blogs).
then save after when i click the test button i see i have 20000 members have 0 posts and at the below i see Action is Delete or Move so what i need to select from the last action ?
If i Tick yes and select Delete then mod need to activate or auto process on and delete these members ?

Can you have some more features like Total Post and Total threads ? your Mod has only post not threads.
Help----