PDA

View Full Version : Member's Post Count


Craig Antill
10-21-2001, 04:39 PM
In this link (http://www.vbulletin.com/forum/showthread.php?s=&threadid=25657&highlight=user+post+count) 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
10-21-2001, 04:49 PM
You can manually change a user's post count in the Admin CP. Be sure to update user counters afterwards.

Craig Antill
10-21-2001, 04:52 PM
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... :p

Steve Machol
10-21-2001, 04:57 PM
This would probably require hacking. Sorry.

Craig Antill
10-21-2001, 05:03 PM
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... :)