Is there a way to delete posts from a specific user prior to a certain date?

[tlw1999]

One of my forum users wants his posts from before a specific year deleted. From what I can tell they would have to be done manually, but there are thousands. I could delete all of his posts but he would prefer to keep the more recent ones. Is there any way to just delete posts from prior to, say, 2010? I'm thinking perhaps there's a plug in might do it?

Any ideas?

[Jim M]

There would be no means to do this via the core software. It would require a customization.

[Ocean West]

Perhaps via sql? 

Could you find all that persons topics prior to a specific date and move them to a new forum by updating all these to that forumID

This forum has only permissions for the Admin? 

once moved delete that forum? 

Edited May 2 by Ocean West

[Adriano Faria]

2 minutes ago, Ocean West said:

Perhaps via sql? 

Not recommended at all. You’ll left a lot of orphaned records in other tables, like search index.

[Ocean West]

I imagine you are just referring to TOPICS created by user not Posts (replies). Doing this on posts would make your site Swiss cheese making old topics incoherent. 

 

I agree with @Adriano Faria not a task id take on via SQL

[teraßyte]

Yes, it's not possible with the core software. The only way is a custom modification.

I had a client in the past who needed something similar. I made them a script that could be run from SSH because that's what they wanted. 🤔

Edited May 2 by teraßyte