• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Deleting PM's

mrchasez

Active member
#1
I own a rather large gaming community (25k registered in last 5 months).

I currently have 920 Unread private messages. Is there anyway i can mass delete them?
I am not good with phpmyadmin either.

Thanks
 

Jake Bunce

XenForo moderator
Staff member
#6
V

vVv

Guest
#8
Nah, oddly that didn't work.. The PC's are in my Inbox, showing as just ME as participant of the PC's. I'd probably have to run it.. removing with "0" participants. Basically pruning all of my own PC's with no/zero participants/replies.
 
V

vVv

Guest
#9
This worked.. xD Removed all PC's with just me as PC participant, Private messages that I had with deleted/ users from vB4 after import to XF.

Code:
DELETE
FROM xf_conversation_message
WHERE conversation_id IN (
    SELECT conversation_id
    FROM xf_conversation_master
    WHERE user_id = 0
);
 
DELETE
FROM xf_conversation_recipient
WHERE conversation_id IN (
    SELECT conversation_id
    FROM xf_conversation_master
    WHERE user_id = 0
);
 
DELETE
FROM xf_conversation_user
WHERE conversation_id IN (
    SELECT conversation_id
    FROM xf_conversation_master
    WHERE user_id = 0
);
 
DELETE
FROM xf_conversation_master
WHERE user_id = 1;