Member's Post Count

[Craig Antill]

In this link Kier explains how the users post count is affected by the prune threads system:

Originally posted by Kier
Yes, this is a design feature - when you delete an individual post it will decrement the poster's post count by one, whereas if you mass-prune threads, the posters' counters will remain constant

This is because we assume that a single post being deleted will be an act of moderation, while a whole load of threads being pruned is an act of maintenance (albeit not an entirely necessary one... many vB boards never prune old threads, as there isn't a massive performance benefit in doing so )

I have a question on this though that i've been unable to find a solution to by searching.

I have used the mass-prune feature to remove a large number of posts, but how can I have this reflect in the individual's post count ? ie if a user previously had 1000 posts and I have removed 100 of them, how do I have the member's profile show that they have 900 posts on the forum ?

Cheers!

[Steve Machol]

You can manually change a user's post count in the Admin CP. Be sure to update user counters afterwards.

[Craig Antill]

But is it possible for the forum to simply recount the number of posts which a user has made ? Because obviously i'm not going to want to go through and count the number of posts they've made manually...

[Steve Machol]

This would probably require hacking. Sorry.

[Craig Antill]

Okay, thanks.

I wonder if anyone knows a MySQL query that will give me a total number of posts for each user id ? I could then quite quickly go through and update the users profiles manually...