Deleting oldusers PM.

[guardia]

HI,

SMF 2.0.9

I want to delete all users older than date X BUT NOT their posts.

I want to delete all users PM older than X , but exclude PM's with a certain subject (same for all of these) and/or certain users.

Anyone able to lend me a helping hand for the SQL queries?   I searched for mods as well but wasn't able to find a suitable one.

regards

[guardia]

Sorry.
Correction for first query.

I want to delete all users older not logged IN since X BUT NOT their posts.

[Illori]

admin -> forum maintenance remove all members who have not <logged in> for x days

[guardia]

Thank you.

And how to delete All users PM older then X but exclude certain message subjects and/or users?

[Illori]

that would require a database query. i really doubt many will help you with that as we dont like to give instructions that deal with PMs and the database as they should be private.

[Steve]

You should also patch up to 2.0.11 as there have been a number of security fixes.

[Arantor]

And touching PMs is complicated because for every recipient of a message there is only one master copy - person A sends person B a message, the message is shared between them (in A's sent messages and B's inbox, one message total) but if A sends a message to B, C, D and E, there is still only one message. Pruning that is a lot more complex because you don't want to remove legitimate messages.

[guardia]

You should also patch up to 2.0.11 as there have been a number of security fixes.

Will do that soon. Thanks.

that would require a database query. i really doubt many will help you with that as we dont like to give instructions that deal with PMs and the database as they should be private.

I am not sure I understand what you mean. I only want to prune all messages older then 6months and from every user.  Only the automatically sent "welcome message" with a certain subject should be excluded.
I made 100% sure my users agreed to that Actually they ask for that since quite some time.

And touching PMs is complicated because for every recipient of a message there is only one master copy - person A sends person B a message, the message is shared between them (in A's sent messages and B's inbox, one message total) but if A sends a message to B, C, D and E, there is still only one message. Pruning that is a lot more complex because you don't want to remove legitimate messages.

True. But the way it works made sure there are only A -> B messages. There is no single message with multiple recipients existing.



I played a bit with sqp queries but I still cannot make it work in my testing database.

Help is very very very appreciated

Regards and thanks to everyone.

[Arantor]

Except A -> B still means both A and B have access to that same message...

[Kindred]

Hell, if "they are on board with that"
then why not just have THEM prune their own mailboxes?