Mass Delete Inactive Members and Zero Posters

[Gamingforce]

[ Feature Description ]
After some quick calculations we found out that over 7000 of our members were both zero posters and have not visited the board in over one month. After searching first through vBulletin, I noticed there was no script that did this (although there was a script to hunt out inactive users). Deleting each user one by one would take forever so I decided to write a script that made this much easier! In the script just set the minimum number of posts and the maximum number of days inactive and the script will automatically delete these users. Instead of just deleting the user from the user table, all calendar items made by the user are deleted, all custom avatars are deleted, private mesages are deleted and even their subscription settings. I hope this script helps a lot of other people as well.

[ What you need to do ]
Open up massdelete.php, edit the two variables under CONFIGURATION. Then just drop this into your admin directory and run the file.

[ Tested on ]
vBulletin versions 2.2.6 (should work with any vBulletin 2+)

[ Future Plans ]
Probably I will add a feature that emails the user telling them their account has been deleted.

Hope everyone finds this hack useful! If you have any comments or suggestions post them here.

[proxyMX]

very COOL, Will be installing this baby thanks :)

[afterlab]

Aha, sweet work gamingforce. When I need it, i'll load it up. Thanks for this extra feature. :rambo:

[Neo]

HAHAHAH Funny but have you ever looked at the Move/Prune option in the user area of the admin cp? ;)

LOL

[afterlab]

Hmm.. Good point. I guess we don't need a hack like this then.

[Birdie501]

will the posts of this users also be deleted?

[wooolF[RM]]

]Originally posted by Neo
HAHAHAH Funny but have you ever looked at the Move/Prune option in the user area of the admin cp? ;)

LOL

I have the same opinion...

[Gamingforce]

Oops! Mine is easier to use though! just change 2 vars, upload and run. Takes 30 secs. ;)

Is it faster too? I dunno. You can use either, and if FireFly wants to delete this he can. Seems like many people don't know about it though.

[LouChipher]

for a second version, it would be nice when i can see everyday which users are xx days not logged in (or last activity would be better) and then i can delete this... maybe a automatic mail a week bevor and yes/not auto remind in the user cp...?

[Neo]

Originally posted by Gamingforce
Oops! Mine is easier to use though! just change 2 vars, upload and run. Takes 30 secs. ;)

Is it faster too? I dunno. You can use either, and if FireFly wants to delete this he can. Seems like many people don't know about it though.

Yes I figured it would be. But good job anyways :)

[Gamingforce]

LOL I better add the auto email feature soon to make this feature actually useful!

EDIT: That's the thing about PHP Lou. You can't have things done really on time intervals unless you store the date in the database and every single time a page is loaded, it checks the date to see. Another option is cron though. Since PHP is a dynamic on-the-fly language, it can't be open like a program ready to run at specific intervals.

[Velocd]

Very nice! :p

[Velocd]

What's the quickest way to set it at deleting members with posts less than X value and have not visited the forums for Y days? And..is there a way to do this automatically? Probably not, would have to use one of those cron job thingies, which I've never used. But If I could do this just through admincp it would help alot. This hack allows the members to remain, but a modified version I could really use is one that allows them to be deleted.

Thanks ;)

[Schorsch]

works fine, thanks :)

[Kumaro]

how is "inactive" defined in this script.
Inactive is when the user hasn't been online in X days?
or
Inactive is when the user hasn't posted in X days?

I hope its the first one.

[Kumaro]

Originally posted by Birdie501
will the posts of this users also be deleted?

i believe nobody answered this?

[Gamingforce]

Posts will not be deleted in this version but is planned for a future versions. I originally designed this for 0 posters. I think it's a good idea still keeping the posts of inactive posters just for history and continunity of threads.

30 days inactive means they haven't even visited the board in over 30 days.

[Birdie501]

Ok, it hink it would be a great feature if the user gets an email that tells him: You have not logged on for x days. Your account will be deleted in x days if you do not reactivate your account by clicking the link below.

What do you think?

[KeithMcL]

That would be a cool feature birdie501.

[LouChipher]

Originally posted by Gamingforce
EDIT: That's the thing about PHP Lou. You can't have things done really on time intervals unless you store the date in the database and every single time a page is loaded, it checks the date to see. Another option is cron though. Since PHP is a dynamic on-the-fly language, it can't be open like a program ready to run at specific intervals.


I Know. Look at the Birthday or Member Of The Day "Hack"... the first one who visit the forum at a new day induce the update.. or a cron job version... indifferently...

Mail a week before or when deleted? Pro? Contra?

[LouChipher]

-

[-=Sniper=-]

ok about the 0 posters thing, would it not be great, where you can offer the user ID to be retaken by new members, with either the same user name or a new one!

[wolfe]

hey d00d does this make it so it don't delete the posts of the members who are mass deleted :D

[Shaede]

I think this is a great feature. I've always used the move/prune at my board, but from what I can see, it works really well on Gamingforce's board. :p

[kj187]

It can for one in such a way make which one by a form in input test AREAS the days and Posts to indicate can and then only delete. Super would be nice.

[mv540]

sweet hack, just deleted 550 members with in 2.5 seconds...

Awsum work gentleman!!

[jasonx]

Question: How can I set these inactive users so their profile is no longer viewable. They don't get added in total members. You can't PM those users.

But if they log in again it reactivates their account?

[Boofo]

Would there be a way to make this so you can enter the number of days of inactivity each time instead of having it only be in the php file?

[chitown]

Thank You, I am very appreciative of this hack, helped clean up alot of crap. :D