Auto Prune Threads

[Andreas]

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 (https://vborg.vbsupport.ru/showthread.php?t=60175), 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


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


REPLACE that with

$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..

[Jujimufu]

This is a great hack, especially for general discussion forums that never have anything of value. In some of the other forums though, it takes out the stickied threads too. Is there a way to prevent it from taking out your stickied threads, no matter the date?

[jluerken]

Hi,

I am searching for a small addition to this hack.
I would delete all Posts from a forum after X days but only from a special user.

Background is that I installed the Article Hack to post RSS Articles under a special userid into some of my forums. I want to delete those Articles all X days but want to let the others untouched.

Is it possible to update this hack that you have the choice to either delete all threads in a forum after X days or to chose to have all from a single user deleted after X days?

[ethics]

Awesome, just what I needed!

[venomx]

Wont this mess up post counts?

[adp]

Is there any chance that this can be modified to close threads instead of deleting them?

thanks,
adp

[Candycane]

Hi there,
Does this mod work for version 3.0.3?

[Acido]

Hi KirbyDE

Sorry if this is a Stupid question, but i want to know if when the thread is deleted, the POSTS are deleted too. I mean to delete records in the POST table.
The autoprune Option could be cool to have "chit chat" forums without moderation (and not count for posts there), but with threads and post deleted in few days or weeks.

Great Solution for users that can avoid use the forum as chat, forcing to the moderators to delete posts (or worse: move it), explain to the newbies how the forums works, discuss with users about that, etc, etc..


But if the table POST mantain all the records, i think this could be a bad idea.

Can you clarify this to me?
Thanx . (sorry my bad english)

[CrazyLady]

so am I to understand that this mod only deletes the thread and NOT the posts? can someone clarify before I add this hack?

thanks

[CrazyLady]

does this hack remove both threads AND posts?

[Acido]

does this hack remove both threads AND posts?

This hack remove threads, but post remain in database. You still can remove orphan post on database from update counters >> Remove Orphan Posts:

"This function will delete any posts that belong to threads that no longer exist. Such posts are not accessible via the forums but they do add your your totals. You will see the number of orphan posts in parenthesis."

;)

[Cyricx]

Is it just me or does this seem to be pruning based on last views instead of last post?

Looking at the code it shouldn't be, but on my test site it is pruning by views...

Any one else having that problem? or any ideas what could be wrong?

[almqdad]

great hack

[Andreas]

This hack remove threads, but post remain in database.
This is not true. Function delete_thread() also removes the posts, edit-notes, etc.

@Cyricx
No. Threads don't even have a 'last view' property ...

[Acido]

This is not true. Function delete_thread() also removes the posts, edit-notes, etc.

@Cyricx
No. Threads don't even have a 'last view' property ...

Thanx for clarify that :)

[HeloHi]

How would one modify this to auto-move threads to a specific forum instead of deleting them?

[SuprSurfr]

KirbyDE could you explain this step a little further?
I am new to VB and i am not sure what i should do here.

Thanks

2. Add the following phrase to phrasegroup Forum-Related Phrases
varname: prune_after
text: Prune After<dfn>Stetting this to a value > 0 will automatically prune all threads from this forum where the last reply is older then the set amount of days</dfn>

I found where i needed to apply step 2.

Thanks

[FROGGYJ]

would this work in vb 3.5 gold?

[Acido]

I really need this hack ported to vb 3.5