keenants's latest activity
-
keenants replied to the thread Rebuild User Post Counts (query).Back in the vB days, lynee was the one who used to play with SQL queries now we have you on xenforo :D All good, when you have time... -
I'm glad it was helpful. I have a few other queries like this that I need to add as Resources, when things slow down enough to have the...
-
Sorry about that, I had a typo in the first query. It should be: UPDATE xf_user AS user SET message_count = COALESCE( (...
-
keenants replied to the thread Rebuild User Post Counts (query).My site guy, you the man, this worked like a charm when I ran into user post count total needs to be updated.
-
This is a query which updates user post counts. It takes into consideration moderated and deleted status of threads and posts, as well...
