Forum Stats look wrong in some cases

[#1]

Incidentally, I've seen a couple of incorrect ones, but the post counts look right based on previous post counts don't they?
Split from the Christmas Photo Competition thread.

[#2]

Quote from: James_H

Which parts are wrong?

The bit that says you've jumped above me in the league table!

[#3]

Have you seen that the person who is 9th in the 'Topic Starters' table only has 1 post, even though they have started 194 topics......

[#4]

I hadn't - but rjbashford being in 7th when he has made no posts at all is a bit clever!

[#5]

Don't mention it to Colin, in case he disassociates my old posts again.

[#6]

Feel free to tell me... I'd rather know and be able to fix it than not know.

[#7]

I presume you've seen the ones we mentioned in #62 and #63 now.
I've not spotted anything else, but those do stand out a lot more than they would if say Peter V had the wrong number of topic starts attributed to him.

[#8]

Yeah, my post count is about 5000 posts short aswell.

[#9]

James, your post count is fine.
In relation to this, I know why and have got the fix awaiting SQL review.

[#10]

Not so fast soldier!
I think your maths is letting you down James, your post count looks to have been inflated by a factor of ten somehow.
Perhaps Colin can reduce it to 770 or so for you.

[#11]

Looks about right to me... from querying a copy of the PHPBB database:

+------------+------------+
| username   | user_posts |
+------------+------------+
| lestones   |        612 |
| peterstone |        270 |
+------------+------------+

[#12]

This appears to be fixed.

[#13]

If this is fixed, can it be moved to Resolved Bugs?

[#14]

Yup - moving it now.