UBB.Developers Forums UBB.threads 7 Development How Do I? Reduzind member post number. How?

When I delete one member's post, the number of post he/she did before won't go donw.
I have some user who send a lot of uselless post, just to get a better 'title'.
There is any way to control it? What I want is someting if the Admin delete the post, 1 is taken of the user's account too.

easy just add the following command in your SQL COMMAND in the admin. Thanks to Omegatron for this command. This command will only reduce or increase the post. But I am sure you wont keep track of it everytime a member puts in useless post for the sake of his post count. If I were you I would just give him a warning or ban him or something. Anyway here is the command:



UPDATE w3t_users SET U_Totalposts='titlegoeshere' WHERE U_Username='usernamegoeshere'

Salin,
The command you post is perfect for the second part of my problem and I will use it. Thank you. But still I have the first part: How can I re-count the number of posts that user has?
What's happen is 2 or 3 times a week I check all 'free' areas of my Forum, and delete those posts who are there only for add up the numbers in title.
There is more than one user, and more then one post. so will be hard to keep track of all.
I was thinking some bacth routine who gets all users, count all posts again, and give the correct titles to the users.
Too hard? I don't know nothing about MySQL
But I thank you for the command. That at least let me do it mannually for one expecific user, and if I can't find a better way, I will count posts mannually too.

This should help you count the posts of individual users after you delete the offending posts:

SELECT COUNT(*)
FROM w3t_Posts
WHERE B_PosterId = 'member#'

It should give you an accurate count of posts from that user in the db. It won't help with mass changes but will stop you from having to count the posts manually.

Bill

Thank Bill.
That command helps

Elton