Resource icon

Unmaintained Mass prune all PMs (queries)

Run these queries to delete all PMs for all users.

Code:
TRUNCATE TABLE xf_conversation_master;
TRUNCATE TABLE xf_conversation_message;
TRUNCATE TABLE xf_conversation_recipient;
TRUNCATE TABLE xf_conversation_user;
UPDATE xf_user SET conversations_unread = 0;

Backup first.
Author
Jake Bunce
Views
853
First release
Last update

Ratings

5.00 star(s) 3 ratings

More resources from Jake Bunce

Latest reviews

Thank YOU! Really, very useful.
Excellent
So very useful. I make it a point to do this at least 1 - 2x a year. Users seem to save those things (can't imagine why).
Top Bottom