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

XF 1.4 Notable Members - Most Resources

#1
I must be missing a setting somewhere because I have several hundred resources on my website but it only states that I have "5" under the Notable Members - Most Resources tab within the members section. I rebuilt all of the caches and it shows all of my resources within my profile as well. Is there a setting I am missing?
 

Jake Bunce

XenForo moderator
Staff member
#2
Those counts are incremented when you post a resource. If for some reason the count is wrong then you can run this query on your database to correct it:

Code:
UPDATE xf_user u
SET u.resource_count = (
    SELECT COUNT(*)
    FROM xf_resource r
    WHERE r.user_id = u.user_id
    AND r.resource_state = 'visible'
);