Is there any way to delete all messages from spesific member once ?
ludogorie Wrote:Is there any way to delete all messages from spesific member once ?
No.
The best you can do is find all posts by that user and delete them one by one.
You can do it via SQL
Run this SQL code in phpMyAdmin
DELETE FROM mybb_posts WHERE uid=<uid>
(Remember to replace any instance of mybb_ with your forum's database table prefix, if different and to replace <uid> with the user's uid)
DennisTT I'm using your method in SQL it deletes all messegas but in the end user posts number is not change how can I updated "0"
Run this query in the same way DennisTT showed:
UPDATE mybb_users SET postnum = 0 WHERE uid = <uid>
Again, replace mybb_ with your table prefix, and <uid> with the user id.
It is also a good practice to perform a Recount & Rebuild counters after deleting posts/threads from your db.