- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 21,417
- راهحلها
- 27
- پسندها
- 3,264
- امتیازها
- 113
- سن
- 27
- محل سکونت
- England
- وب سایت
- xenforo.xyz
Had a spamming incident. I need to delete the spam without killing a member's complete backlog of private conversations.
I'm thinking this:
Use the following query to get a list of all the appropriate messages:
Then, that query is used to populate a list of conversation IDs to delete, as follows.
SQL:
I'm thinking this:
Use the following query to get a list of all the appropriate messages:
SELECT cmaster.conversation_id FROM xf_conversation_master AS cmaster WHERE user_id = 5555 AND title = 'Spam!');Then, that query is used to populate a list of conversation IDs to delete, as follows.
SQL:
نام موضوع : Bulk delete private conversations
