XF 1.1 Private Messages

Hello
How do I delete messages to one member and not total members
For example, I want to delete all messages of the membership of the No. 1
 
Conversations can't be deleted.
Once all participants have left they will automatically be pruned from the database.

It is also not possible to manually remove a participant.


I found some orders, but I do not know Is it true or not
See my friend in this topic


PHP:
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;


Are these orders sound
 
Back
Top Bottom