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...
You do not have permission to view the full content of this resource.
Log in or register now.
