Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Mass Delete Inactive Members and Zero Posters Details »»
Mass Delete Inactive Members and Zero Posters
Version: 1.00, by Gamingforce Gamingforce is offline
Developer Last Online: Jan 2007 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 07-30-2002 Last Update: Never Installs: 47
 
No support by the author.

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #12  
Old 07-31-2002, 10:38 PM
Gamingforce's Avatar
Gamingforce Gamingforce is offline
 
Join Date: Oct 2001
Location: New York City
Posts: 128
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #13  
Old 07-31-2002, 11:01 PM
Velocd's Avatar
Velocd Velocd is offline
 
Join Date: Mar 2002
Location: CA University
Posts: 1,696
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Very nice!
Reply With Quote
  #14  
Old 07-31-2002, 11:09 PM
Velocd's Avatar
Velocd Velocd is offline
 
Join Date: Mar 2002
Location: CA University
Posts: 1,696
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #15  
Old 08-01-2002, 01:54 AM
Schorsch's Avatar
Schorsch Schorsch is offline
 
Join Date: Jul 2002
Location: Germany
Posts: 345
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

works fine, thanks
Reply With Quote
  #16  
Old 08-01-2002, 03:03 AM
Kumaro's Avatar
Kumaro Kumaro is offline
 
Join Date: Oct 2001
Location: T.O
Posts: 122
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #17  
Old 08-01-2002, 03:18 AM
Kumaro's Avatar
Kumaro Kumaro is offline
 
Join Date: Oct 2001
Location: T.O
Posts: 122
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by Birdie501
will the posts of this users also be deleted?
i believe nobody answered this?
Reply With Quote
  #18  
Old 08-01-2002, 05:45 AM
Gamingforce's Avatar
Gamingforce Gamingforce is offline
 
Join Date: Oct 2001
Location: New York City
Posts: 128
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #19  
Old 08-01-2002, 06:05 AM
Birdie501's Avatar
Birdie501 Birdie501 is offline
 
Join Date: Dec 2001
Location: Germany
Posts: 272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #20  
Old 08-01-2002, 03:40 PM
KeithMcL's Avatar
KeithMcL KeithMcL is offline
 
Join Date: Nov 2001
Location: Dublin, Ireland
Posts: 85
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That would be a cool feature birdie501.
Reply With Quote
  #21  
Old 08-02-2002, 03:11 PM
LouChipher LouChipher is offline
 
Join Date: Oct 2001
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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?
Reply With Quote
Reply


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


All times are GMT. The time now is 03:05 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05096 seconds
  • Memory Usage 2,305KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete