Post Count after forum delete

[hunz]

Assume I have test forum with one user posting 5 post count, one trophy.
Once I delete that test forum, the user post count still 5 with one trophy.
I can do manual reset if I know that detail.

Question is,
How can I reset if I don't know how many post actually that user posted on that test forum?

 

[Jake Bunce]

See this guide:

http://xenforo.com/community/resources/rebuild-user-post-counts-query.363/

There is a query to exclude certain forumids if you want.

And here are some queries to reset the trophies if you wish:

http://xenforo.com/community/threads/recalculate-trophy-points.30800/#post-351948

 

[hunz]

Thanks Bunce , I'll check it out.