Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 17 Feb 2017, 07:20
XYZ500 XYZ500 is offline
 
Join Date: Aug 2014
Pruning inactive/spam users

Okay, so apparently there are tons of users who have never made a post and haven't logged in for a long while so I'm guessing they were spam/inactive and stuff like that so we are thinking about pruning all these users who have never made a post.

1. What happens to user IDs of other users when all these users get pruned? Will their user IDs remain intact?
2. Are there any benefits of doing this action? This will decrease the 'total members' count by a significant number but will there also be any kind of benefits? Just wondering.
Reply With Quote
  #2  
Old 17 Feb 2017, 07:30
cellarius's Avatar
cellarius cellarius is offline
 
Join Date: Aug 2005
Real name: Sven
Originally Posted by XYZ500 View Post
1. What happens to user IDs of other users when all these users get pruned? Will their user IDs remain intact?
Not sure what you're asking here. But no, they won't stay intact - the users are deleted from the database. The id will cease to exist. If you're asking if that id will be used again (as in will vB fill in the gaps): No, it won't. All ids are auto increment. It's always last entry id +1.

2. Are there any benefits of doing this action? This will decrease the 'total members' count by a significant number but will there also be any kind of benefits? Just wondering.
Hardly. You lose a little of database size, but nowadays that just doesn't matter. Unless you're pruning really, really many users you won't notice a difference.
__________________
Please note that there will be no further updates to my addons, especially they will not be upgraded for vB5. I'm leaving vB, since IB choose to go the banana-way yet again.

http://www.roma-antiqua.de
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Anti-Spam Options [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam GlowHost.com vBulletin 4.x Add-ons 3490 29 Jul 2019 20:11
Add-On Releases Automatic Inactive Users Pruning - vB3.7 RC2 J98680Bxxxxx vBulletin 3.7 Add-ons 44 28 Mar 2009 16:56
Automatic Inactive Users Pruning Revan vBulletin 3.0 Full Releases 20 29 Apr 2008 19:05



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 00:10.

Layout Options | Width: Wide Color: