Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 25 Nov 2011, 15:09
AsukaValentine AsukaValentine is offline
 
Join Date: Nov 2005
Keep users post counter

Hello
Everytime I delete a thread on the forum the post are discounted from the counters of the users that participate in this thread.
Now I need to delete a lot of threads in the forum (around 18.000) and users will lost a lot of messages, ranks and some permissions based on number of post.

It's possible to mantain the number of post for every user (and forum total post and threads will be good too) when you delete threads? How can I do it? I'm sure when I used phpbb some years ago that deleting threads or messages don't affect post count, I can't understand why I can't change this in vbulletin, specially when you can create different usergroups based on post.

Thanks!
Reply With Quote
  #2  
Old 25 Nov 2011, 16:20
setishock setishock is offline
 
Join Date: Feb 2008
You could make a trash can forum and move the threads to there. Make it closed to the public but have the posts/threads count
__________________
Working on new projects and expanding our horizons. Come by and see what we're up to now.
Reply With Quote
  #3  
Old 25 Nov 2011, 16:34
AsukaValentine AsukaValentine is offline
 
Join Date: Nov 2005
Yes, this it's what I have but I need to delete everything there because we have a large, large database and want to save some space.
Reply With Quote
  #4  
Old 25 Nov 2011, 16:56
setishock setishock is offline
 
Join Date: Feb 2008
Ok so now we have the reason why. Let's persue another idea. Where are your images stored? DB or file system?
__________________
Working on new projects and expanding our horizons. Come by and see what we're up to now.
Reply With Quote
  #5  
Old 25 Nov 2011, 18:51
AsukaValentine AsukaValentine is offline
 
Join Date: Nov 2005
The images I think are stored on DB... I never change this option and I don't see any image stored on the server, just the ones I uploaded with the forum package. I don't know how to change it...
Reply With Quote
  #6  
Old 26 Nov 2011, 02:27
setishock setishock is offline
 
Join Date: Feb 2008
ACP > Attachments > Attachment Storage Type
BACK UP YOUR DATABASE FIRST!!!
__________________
Working on new projects and expanding our horizons. Come by and see what we're up to now.
Reply With Quote
  #7  
Old 06 Dec 2011, 05:08
woodburyMan woodburyMan is offline
 
Join Date: Jun 2010
Real name: Erik
Anyone find the answer to the original question?
I have the same issue. I have a database I need to shrink down. Our attachments have been stored in filesystem all along. I have to delete around 15,000 posts without users screaming about lost post count. I have already moved all the posts I wanted to a non-public "Trash" forum. I just need to physically remove them without it affecting post count.
Reply With Quote
  #8  
Old 07 Dec 2011, 02:41
SpikedRocker SpikedRocker is offline
 
Join Date: Jul 2009
Bigger/Better DB host?

Short of that I really don't think you can do much with post counts because its a tallied count. TBH, if something is over a year old it probably doesn't need to be kept and people who whine over post counts need to probably re-evaluate their life.
Reply With Quote
Reply



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 11:03.

Layout Options | Width: Wide Color: