- Compatible XF Versions
- 1.x
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.
Code:
UPDATE xf_user AS user
SET message_count = (
SELECT COUNT(*)
FROM xf_post AS post
LEFT JOIN...
You do not have permission to view the full content of this resource.
Log in or register now.
![[TH] AC.UI](/data/resource_icons/3/3247.jpg?1640285413){kind=icon}
![[XTR] Reputation System](/data/resource_icons/1/1265.jpg?1555926130){kind=icon}
![[DohTheme] Royal](/data/resource_icons/0/9.jpg?1551063984){kind=icon}