Users total posts (even in no postcount areas)

[KaiSan]

How do I go about finding this?

I was to find out a members postcount, but we have no post count in the spam section...

I was just wondering if there was a way to find out how to count all those up as well.

Thanks.

[Tony G]

It depends, do you want to find the count for yourself or begin adding post counts from a forum which didn't allow them before?

[KaiSan]

No, I want to know how many posts a member has, counting the ones in the no postcount areas.

Thanks.

[Tony G]

I know of no other way besides turning post counts in that forum on and rebuilding the member stats, but that will update it on the forum as well as you knowing.

[Kingster]

Originally Posted by KaiSan

How do I go about finding this?

I was to find out a members postcount, but we have no post count in the spam section...

I was just wondering if there was a way to find out how to count all those up as well.

Thanks.

If it's really only for your knowledge, you can do it through MySQL...

SELECT username, COUNT(  *  )  AS realpostcount
FROM post
GROUP  BY username
ORDER  BY username DESC;

I'm trying to figure out a way to add this info onto the user, so I can build a dynamic "bar" that indicates how many "useful" posts a user has versus posts in our spammy area.

[Andreas]

grouping by userid would be better IMHO as this column is indexed - and integer operations should always be faster then string operations.