ALERT!
Click here to register with a few steps and explore all our cool stuff we have to offer!
Home
Upgrade
Credits
Help
Search
Awards
Achievements
 7895

Mass prune all PMs (queries)

by Bi0S - 05-04-2017 - 03:05 AM
#1
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.
Reply

Users browsing: 1 Guest(s)