how can I reset users' post counts to zero ?

[yl88]

hello,

is there a way to reset all users' post counts to zero in control panel ?

or

can anyone tell me a SQL statement that resets users' post counts to zero? I would like to do it in phpMyAdmin.


thanks!

[Lats]

You can do this in phpmyadmin, or from within the ACP

UPDATE user SET posts = 0