I try the search first, since I guess it would be a comom issue, but find notthing, so there it is:
I deleted posts from members time to time, and I would like to recound the number of post for all members on a UBB Trhead 6.3.
Is that possible? I was thinking in some kind of command line at the SQL windown under ADMIN who could do it.
Thank you

hi there!

you can actually ask questions & search for answers about UBB.threads on our UBB.threads Support Forums, but I'll answer your question here to save you some extra work today!

So, let me make sure I understand the question: you're saying that each member's post count does not change to reflect deleted posts? that's actually designed behavior that it counts all posts that ever existed - are you looking for a SQL query to change the post counts as a sort of one-off thing? to synch things up?

This message has been edited. Last edited by: Kate Thaete,

Hi Kate,
First, thank you for your kindess in anwsering here

Now about your question, the anwser is yes. What happens is I had a police that post like "me too", "thank you", "see you", and other similars should not count to the post numbers, so what I do is delete those (it's a pain, but worth).
Then I just finished deleting all those 'No practical content' posts and now I would like to reclassify all my users.
This is why I would like to have a SQL query to change the post counts on all members.

Thank you
Elton

Thanks for clarifying, Elton:

Unfortunately, a single SQL query would not work for this, as UBB.threads would need to recount all the members posts and then update each member. It would actually require a script that would loop through each
member, grab the total # of posts that exist in the database, and then update the total posts for that member. Someone over at ThreadsDev may have a script for this already written so you can inquire there.

Thanks!
Kate

Thank you Kate.
I will do it right now.