Auto close thread after x days.

Requested by Skyline_GT

This is a simple script that will close all threads where the last post is 30 days or older

Edited script with KirbyDE's code

I got it this time ... and tested and works

Tnx

only 1 variable to edit here .... default is 30 days but you can change it to whatever you want

Please click Install

[trafix]

Fixed and tested

[nintendo]

How about making it so we can give different boards different XX days. On less active boards we might want to do 60 days for example.

Or even better, delete threads after XX days.

And is this XX days after the last reply, or the first post?

[TCattitude]

How can make it to close threads in specific forums by id?
I want this active but not in all forums.

This can be done in a easy way?
Please? Somebody?


By the way, this affect all threads?
Even the sticky ones?
(If it is, how do to not affect sticky?)

[Paul M]

Try this;
[sql]$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET open = 0
WHERE forumid IN (1,2,3) AND open = 1 AND sticky = 0 AND lastpost < " . intval(TIMENOW - (86400 * 30))
);
[/sql]
Where (1,2,3) is the list of forum id's you want it to work for, and 30 is the number of days

[TCattitude]

Originally Posted by Paul M

Try this;
[sql]$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET open = 0
WHERE forumid IN (1,2,3) AND open = 1 AND sticky = 0 AND lastpost < " . intval(TIMENOW - (86400 * 30))
);
[/sql]
Where (1,2,3) is the list of forum id's you want it to work for, and 30 is the number of days

Works like a charm!
Thanks Paul

[trafix]

well done guys

[Rebecca217]

Thank you. This is very useful! *clicks install*

Rebecca

[trafix]

Your welcome

[teedizz]

can this be set for one particular forum or is this for ALL threads because I want to have threads auto close after 8 days in 1 particular forum on my site....is that possible with this hack?

[teedizz]

bump