Rejoining a conversation you have left

[lazy llama]

Is there any way to rejoin a conversation which you have left and selected the "no responses" option?

Some of our users use conversations as an informal private thread, but want to stop receiving responses when they are away on holiday etc. If they leave, as far as I can see, there's no way back in, other than by me changing their status directly in the database.

I guess they should just turn their notifications off while they're away but I wouldn't have thought being able to rejoin a conversation would be a completely unusual thing.

 

[Mike]

You'd have to manipulate the database directly.

 

[lazy llama]

You'd have to manipulate the database directly.

Thanks, Mike.
Will removing the relevant recipient row from xf_conversation_recipient and reducing the recipient_count in the xf_conversation_master be sufficient?

 

[Jake Bunce]

This is the code for leaving a conversation:

XenForo_Model_Conversation::deleteConversationForUser

It updates the xf_conversation_recipient record and deletes the xf_conversation_user record.

If no one else is left in the conversation then it deletes these records by conversation_id:

xf_conversation_master
xf_conversation_message
xf_conversation_recipient
xf_conversation_user

It also updates alerts and inbox counters, but those are less important.

 

[lazy llama]

Thanks, Jake.
I'll have a look at the code to double check but it sounds like the bits I did should sort it out cleanly.

<wonder if there's some scope for an add-on in this area>

 

[CritiKiL]

This is the code for leaving a conversation:

XenForo_Model_Conversation::deleteConversationForUser

It updates the xf_conversation_recipient record and deletes the xf_conversation_user record.

If no one else is left in the conversation then it deletes these records by conversation_id:

xf_conversation_master
xf_conversation_message
xf_conversation_recipient
xf_conversation_user

It also updates alerts and inbox counters, but those are less important.

Jake, can you help me with how to use this? I never knew that we could not delete Conversations and most who use it on my forum do not know how, or would be too lazy to remove themselves. Also, there was a conversation started which has grown 'legs' and has a mind of it's own and it's distracting the normal functions of the forum. I would like to be able to either manually or automatically remove such 'started' convo's ;-)

 

[Jake Bunce]

Jake, can you help me with how to use this? I never knew that we could not delete Conversations and most who use it on my forum do not know how, or would be too lazy to remove themselves. Also, there was a conversation started which has grown 'legs' and has a mind of it's own and it's distracting the normal functions of the forum. I would like to be able to either manually or automatically remove such 'started' convo's ;-)

Run these queries to manually delete a conversation from the database (you need to specify the conversation_id):

DELETE
FROM xf_conversation_master
WHERE conversation_id = 7;

DELETE
FROM xf_conversation_message
WHERE conversation_id = 7;

DELETE
FROM xf_conversation_recipient
WHERE conversation_id = 7;

DELETE
FROM xf_conversation_user
WHERE conversation_id = 7;

 

[CritiKiL]

Ok, but I've never run a querie so who do I do that exactly? Thanks in advance...

 

[Jake Bunce]

You have a CPanel server which will have phpmyadmin preinstalled. You can run queries in there. Click the SQL tab inside of phpmyadmin.

 

[CritiKiL]

Oh ok! Gotcha ;-)

 

[CritiKiL]

Ok, I'm thinking the conversation_id= 118 (http://sck-mobile.com/community/index.php?conversations/team.118/). So I put this in and run the querie but I get this error:

"SQL query:
DELETE FROM xf_conversation_master WHERE conversation_id = team.118;

MySQL said:
#1046 - No database selected "


???

 

[ENF]

Did you choose your database first?

Click on your Database and then the SQL tab. Then enter the queries...

(based on your error, no database selected)

 

[CritiKiL]

Haha...hold on ;-)

 

[CritiKiL]

Works now. THANKS for being patient Jake and ENF.

 

[Paul B]

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

 

[ragtek]

DELETE FROM xf_conversation_master WHERE conversation_id = team.118;

no

the id is ONLY 118 and not team.118

 

[DRE]

Run these queries to manually delete a conversation from the database (you need to specify the conversation_id):

DELETE
FROM xf_conversation_master
WHERE conversation_id = 7;
 
DELETE
FROM xf_conversation_message
WHERE conversation_id = 7;
 
DELETE
FROM xf_conversation_recipient
WHERE conversation_id = 7;
 
DELETE
FROM xf_conversation_user
WHERE conversation_id = 7;

Could this be done as an add-on?

 

[CritiKiL]

Could this be done as an add-on?

I currently have an addon which allows you to 'see all convos' and delete them one by one. It works great and I apologize that I don't remember the name of it. Hold on...

 

[CritiKiL]

In this pic, the 'See All Conversations' is available in my profile (if person is granted permissions) and you can only SEE and DELETE any conversations whether you are in them or not. It's sneaky but it's what an ADMIN needs to have:



Here in the "HEY!" conversation, I am not included but at the top-right you can see that I can delete it if I wanted to:



I changed the name of the addon but it's real name is: "[tLk] ReadPC" ;-)

 

[DRE]

I didn't know you could delete pms in that addon. It would take too long doing it that way though.

Lets say I had some addon that sent 'Welcome PMs to each new user' but all the information in that welcome pm is no longer relevant and I do not want them to read that pm especially if it was a mistake. So what if I wanted to just delete every PM that a certain member or member group had, like noobs for instance.