[JJR512]

OK, there's something I don't get.

I ran this script just after I imported from UBB, and peoples counts jumped, in some cases quite a bit. I expected this, because UBB never decriments the post count. So all the posts that were deleted still count for who posted them. Now vB does decriment the post count if you delete someone's posts, so I expected the count to be accurate.

But I just saw someone's post count drop by almost 600 posts. That should not be.

Here's another curious thing. What does this script do...where does it get its number, the number that it sets a person's post count to?

And what does this query do:

SELECT COUNT(*) FROM post WHERE userid='384';

That's an example using my user ID. After I ran this script, my post count was 6736, which is about what it was before (I don't remember it exactly). But if I run the above query on the database, I get a number of 7056. Which one is right?