How to Update Post Count for a Single User
 

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

Thanks in advance,
Tim

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

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

Tim

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:

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.)

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

AdminCP > Maintenance > Update Counters > Update Post Counts

READ MESSAGE GIVEN UNDER THE TITLE BEFORE YOU PROCEED

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

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.

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

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

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