XenForo Rebuild user post counts (query)

[Jake Bunce]

Jake Bunce submitted a new resource:

Rebuild user post counts (query) (version 1.x) - A database query to rebuild all user post counts.

This will recalculate and update the post counts for all users at once. This is a large query that may take a while to finish.

Rich (BB 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 post.message_state =...

Click to expand...

Read more

Continue reading...