Auto Prune Threads

Description
-----------
This hack gives you the ability to specify if you want to automatically have
threads pruned from a x days after the last post.
The amount of days can be set separately for each forum in forum manager.

Files to modify: 1
Queries to run: 1

Difficulty
----------
Easy-Medium

Compatibility
-------------
I coded this snippet for RC3 quite a while ago, but it should work with all 3.x-Versions.

[Bison]

Could we have a little Show and Tell here?

[mrboz]

i've been looking for this for some time great hack

--

is there also a way to only delete threads that have not been replied to.

i am using the RSS Bot mod to add posts from an RSS feed and i'd like to delete all the posts that have not been replied to after say 2 days and leave the ones that have had replies

thanks

[Andreas]

> is there also a way to only delete threads that have not been replied to.

Pretty easy:

In autoprune.php FIND

PHP Code:

$threads = $DB_site->query("SELECT threadid FROM " . TABLE_PREFIX . "thread WHERE forumid=$forum[forumid] AND lastpost <= " . (TIMENOW - ($forum['pruneafter'] * 86400))); 

REPLACE that with

PHP Code:

$threads = $DB_site->query("SELECT threadid FROM " . TABLE_PREFIX . "thread WHERE forumid=$forum[forumid] AND replycount = 0 AND lastpost <= " . (TIMENOW - ($forum['pruneafter'] * 86400))); 

@Bison
Hmm ... there's not much to see, just a new input-box in forum manager.

[mrboz]

thanks very much

[Andreas]

Attention. There was a typo in my last post. Of course it must be replycount = 0 instead of replycount > 0 (which would delete all threads that have replies and leave those which haven't).

[Sir_Yaro]

Its possible to add "auto prune" to each thread separately?
For ex:
Im create thread "aaaaaaaaa" and set him auto-prune date - 5 days.
Another user create thread "bbbbbbbb" and set him 30 days
And another create "ccccccccc" but auto-prune is unset (0 days) - thread will be never deleted

Such hack exist in phpBB and is veeeeeeeeery useful (especially for moderators)

[mrboz]

got it, thanks

[romeshomey]

Awsome hack.. Thanks!

[romeshomey]

How would I go about just pruning posts by certain users?

Like MrBoz above, I want to pruno only RSS Feeds, but dont want to prune other users posts at the same time.

So basically, can I enter a username(s) or user id(s) in this line somewhere?

$threads = $DB_site->query("SELECT threadid FROM " . TABLE_PREFIX . "thread WHERE forumid=$forum[forumid] AND replycount = 0 AND lastpost <= " . (TIMENOW - ($forum['pruneafter'] * 86400)));

Thanks...

Also, is there a way to make it run on all forums istead of having to specify it on each forum in the forum manager? Id like it to run Global if possible..