XF 1.4 Number of user posts

AndreaMarucci

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
Code:
UPDATE xf_user AS user
SET message_count = (
    SELECT 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:
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).
 
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:
Code:
thread.node_id NOT IN (1,2,3)
 
Top Bottom