No, the post count for user is not dependent on pruning.

If you prune all threads/posts prior to 90 days ago, for example, the total posts for each user will not change because the "user" table has a "posts" field. Like tubedogg said, if you wanted a number of threads started independent of which threads still exist, you would have to do the same as posts, and add a "threads" column to the "user" table.

OK, I don't know much about the prune option. I never use it.

But I do know, by direct observation, that if you delete a post by a user, the user's post count goes down by one. I have seen this with my own two eyes. Last time was a few days ago...a user had double-posted. His post count was 4360. I deleted one of the two messages, and after that, the post count in the remaining thread said 4359. This is indisputable.

So regardless of pruning, a user's post count does indeed go down if any of the user's posts are deleted directly, and presumably also is an entire thread is deleted, too. So, it is clear the the post count does not reflect how many times the person has ever submitted a message.

just forget it. I think tubedogg understood what I was talking about, and that was the point to begin really.

Hey look, there's no need to get hostile about it. I admit maybe I was wrong about the pruning part, because I have no experience with it. But I did get your point, which was that this hack will only count how many current threads were started by a person. Now how many threads the person has ever started. Now my point, which is that the post count also does not display how many posts a person has posted, is a valid point, and one that says your premise may have another dimension to it that you maybe didn't consider. And I'd appreciate it if you wouldn't just dismiss me like that, just because what I said might invalidate your point.

JJR I wasn't dismissing you, I was dismissing the subject, because it's of no importance, that's all.

tubedogg on a hacking roll

hmmmm tubedog, I may just have to try this out! ;)

Now that is a compliment, if someone with a board the size of Me2Be's wants to try my hack out. :)

**blush** Awwww, shucks :)

I'll let you know when I get it online (I'm waiting for Kier's PM hack and Chris to finish our new chat room then I'll add yours too!).

great hack, thanks

but if you can make the thread started first letters capitalized that would be better so it's Thred Started instead of thread started