J
Jake Bunce
Guest
Jake Bunce submitted a new resource:
Rebuild user post counts (query) (version 1.x) - A database query to rebuild all user post counts.
Read more
Continue reading...
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):
Click to expand...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 =...
Read more
Continue reading...