UseBB Community

Hello

I changed some of my users' postcounts, manually in the database. What is the best way to restore this?

A query to calculate the postcount of every user should do the trick, then I can manually enter the correct postcounts in the database again.

Thanks in advance.

SELECT poster_id, COUNT(*) as posts
FROM usebb_posts
WHERE poster_id IN(1, 2, 3)
GROUP BY poster_id

IN() containing the user ID's of the members you want to count the posts for.

This query should return the postcount for members named 1, 2 and 3, right?

Thanks.

Yes it would.