PDA

View Full Version : Keep users post counter

AsukaValentine
11-25-2011, 02:09 PM
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!
setishock
11-25-2011, 03:20 PM
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
AsukaValentine
11-25-2011, 03:34 PM
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.
setishock
11-25-2011, 03:56 PM
Ok so now we have the reason why. Let's persue another idea. Where are your images stored? DB or file system?
AsukaValentine
11-25-2011, 05:51 PM
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...
setishock
11-26-2011, 01:27 AM
ACP > Attachments > Attachment Storage Type
BACK UP YOUR DATABASE FIRST!!!
woodburyMan
12-06-2011, 04:08 AM
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.
SpikedRocker
12-07-2011, 01:41 AM
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.