Resource icon

Mass prune all PMs (queries)

Jake Bunce

XenForo moderator
Staff member
#1
Jake Bunce submitted a new resource:

Mass prune all PMs (queries) (version 1.x) - Queries to delete all PMs for all users.

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.
Read more about this resource...
 

Cal

Well-known member
#3
Jake...excuse this question....but how do we run these queries? Are we doing this in PHPMYADMIN.....or is there a super secret debug area of Xen I don't know about....or what?
 
Top