XF 1.4 Number of user posts


Well-known member
I'd like to know if there's a way to exclude certain forums from the total number of messages of each member.

I've one forum devoted to chitchat and it's widely used but I don't want that all the messages posted here count towards the number of messages of each user.

I've also seen that from @Jake Bunce
UPDATE xf_user AS user
SET message_count = (
    FROM xf_post AS post
    LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)
    WHERE post.user_id = user.user_id
    AND thread.node_id NOT IN (1,2,3)
    AND post.message_state = 'visible' AND thread.discussion_state = 'visible'
    GROUP BY post.user_id
where I can input the ID of the forum I don't want to count...

Can I use this one or there's a better way to do that?
Last edited:


Well-known member
In the ACP, edit a node and in the forum options tab, untick "Count messages posted in this forum toward user total". You may then need to rebuild the caches (can't remember which one).


XenForo developer
Staff member
There's no rebuild built-in. You need to do it via that query. Change the numbers here to the forums that don't count:
thread.node_id NOT IN (1,2,3)