Restrict prune by forum?

[Christine]

Sorry if this is in the wrong forum -- please move if appropriate!

Before I write a SQL script to do this, I thought I would float this idea out to y'all and see if anyone has already done it (a search didn't turn up anything).

I have certain forums (links, questions, etc...) that I don't want to prune, and it takes a mountain of time through the ACP to manually select and prune the others individually.

Has anyone seen a .php hack that would allow for selective pruning of forums based on date?

If not, is there a MySQL script flying around that does this?

Last question -- are we allowed to post SQL scripts that we write, even those aren't real "hacks"?

Thanks to anyone who can help!!

[Boofo]

The "Spin Threads" hack might be something you could use. ;)

[Xenon]

you can post sql queries, but not in full releases, as there they wouldn't make sense...

also delete a thread is not done with just one sql query, you have to deltete the posts, attachments... belonging to that thread, too

[Christine]

I will take a look at that spin threads hack and see what its all about~ Thanks for the heads up.

Thanks also, Xenon -- maybe it would be best if I pass anything like that onto an admin who can decide if its OK. As far as the query, yea, it is a bit complicated but can be done, albeit a little messy! It just takes so loooong to do this stuff through the ACP that if I can just hit the database directly, things fly (like IP address searches).

[Xenon]

of course, you can send me or another admin or mod those things if you are not sure if and where to put ;)