• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Recalculate user stats?

Kevin

Well-known member
#1
Any way of recalculating user stats, in particular the number of items posted? Can't find an option for it.

Background = Imported users from a vB database but not the posts; users came over with their stats already set. I want to reset their stats based upon current threads/posts in XF.
 

Jake Bunce

XenForo moderator
Staff member
#4
If you only imported the users then their post counts should all be 0. You can do this with a database query:

Code:
UPDATE xf_user
SET message_count = 0;
You may wish to manually exclude some users from the reset (those users who were not imported who have posts):

Code:
UPDATE xf_user
SET message_count = 0
WHERE user_id NOT IN (1,2,3,4);
If you want to actually recalculate post counts for all users then it's a little more involved. See this thread:

http://xenforo.com/community/threads/recalculating-message-count.10266/
 

Kevin

Well-known member
#5
If you only imported the users then their post counts should all be 0.
Ever hear the phrase "Sometimes smart people do dumb things."? Yeah, we'll just leave it at that I wasn't thinking fully on some of the imports. :oops:

If you want to actually recalculate post counts for all users then it's a little more involved. See this thread:

http://xenforo.com/community/threads/recalculating-message-count.10266/
Thanks, I missed that one. Looks like I'll be doing a manual update. :(