How to Update Post Count for a Single User

[tim330i]

It seems like there would be an easy way to do this. Anyone have any ideas?

Thanks in advance,
Tim

[fattony69]

Edit the member. There is a place for post count.

[tim330i]

Ok, but I need to know what the value should be.

Tim

[Lynne]

If you have phpMyAdmin, a real easy way would be to go into the post table and find all posts by that user. It then tells you in the query how many rows get returned. I think if you just want to make the query, it would be something like:

SELECT  count(*) 
FROM  `post` 
WHERE  `userid`  =x

where x is the userid. (That does not take into account table prefixes. It's copied straight from phpMyAdmin - except I put count(*) in the select part of the statement.)

[tim330i]

Yes, but that doesn't take into account forums that posts don't increment the post counter. As far as I can tell that option is stored in an option bitfield, which I can't decypher in mysql.

Tim

[Opserty]

AdminCP > Maintenance > Update Counters > Update Post Counts

READ MESSAGE GIVEN UNDER THE TITLE BEFORE YOU PROCEED

[Lynne]

Originally Posted by tim330i

Yes, but that doesn't take into account forums that posts don't increment the post counter. As far as I can tell that option is stored in an option bitfield, which I can't decypher in mysql.

Tim

I guess you can modify the query to add something in the where statement: AND 'forumid' !=y

[tim330i]

Originally Posted by Opserty

AdminCP > Maintenance > Update Counters > Update Post Counts

READ MESSAGE GIVEN UNDER THE TITLE BEFORE YOU PROCEED

Yes, I read that. I don't want to do this for all members, just one. I don't see why this is so complicated.

Originally Posted by Lynne

I guess you can modify the query to add something in the where statement: AND 'forumid' !=y

I guess I could do that, figure out all the IDs and use an NOT IN statement or something....I was hoping to have the SQL/code do all the work.

It seems like this shouldn't be this hard.

Tim

[Dave Hawley]

Updating all users post counts is the best way. Should only take 1-2 minutes.

[tim330i]

I have a feeling it is going to take a lot longer than a few min. And I have custom post counts for some users that I can't lose.

If I wanted to simply update all the users I would have just done it and not posted looking for a solution to what I thought was a simple request.

Tim