Resource icon

xF2 Guides Rebuild User Post Counts (query)

📀 Resource submitted by: AnimeHaxor • 💬 Messages: 6522 • 🏆 Points: 113 • 👍 Likes: 40593 • 📀 Resources: 2252
Compatible XF Versions
  1. 2.0
  2. 2.1
  3. 2.2
This is a query which updates user post counts. It takes into consideration moderated and deleted status of threads and posts, as well as each forum's "Count messages posted in this forum toward user total" setting.
Code: 
UPDATE xf_user AS user...
You do not have permission to view the full content of this resource. Log in or register now.
Author
AnimeHaxor
Views
1,766
First release
Last update

More resources from AnimeHaxor

Share this resource

Similar resources

Creating custom user banner styling AnimeHaxor
xF2 Guides Creating custom user banner styling
More or less
0.00 star(s) 0 ratings
Updated
Customising the layout with custom user fields Admin
xF2 Guides Customising the layout with custom user fields
Now you see it ...
0.00 star(s) 0 ratings
Updated
Hide user extra info ... AnimeHaxor
xF2 Guides Hide user extra info ...
... and show it on hover
0.00 star(s) 0 ratings
Updated
How to add a Custom Group Badge / Banner to User Info AnimeHaxor
xF2 Guides How to add a Custom Group Badge / Banner to User Info
A short tutorial on how to add a custom user group badge/banner to the user info area
0.00 star(s) 0 ratings
Updated
Online indicator based on user ID AnimeHaxor
xF2 Guides Online indicator based on user ID
Now you see it, now you don't
0.00 star(s) 0 ratings
Updated

741Threads
2,309Messages
67,657Members
draksLatest member
Back