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

[Andreas]

Seems to be complicated, and might/will issue a lot of UPDATEs

I think this could also be done in 1 line

[trafix]

Sorry if i steped on you toes KirbyDE

if updates are required ... its just the code

[Andreas]

Originally Posted by trafix

if updates are required ... its just the code

I don't understand this, sorry.
What do you mean?

I just wanted to point out that this can be done with just one UPDATE, instead of querying the table for outdated threads to get the threadis and then issue a query for each thread to close it.

Imagine the script is run for the first time and there are 10.000 outdated threads.
This would mean 10.001 queries are being executed ...

[cinq]

I think Kirby was refering to this easier way

[trafix]

hmm ... i see where you are comming from ....

can i use your 1 liner?

[Andreas]

Sure

I must admit that I didn't test it, but as the query is pretty simple I am 99,75% sure that it does the job.

[trafix]

Tnx Co-authour

[Andreas]

I fear that this version will close no threads ...

Let's say TIMENOW is 1106274310

Then $deletedate will be 1103682310

So (TIMENOW - $deletedate) will be 2592000, which is the timestamp of 1970-01-31 01:00:00.

I don't think you'll find threads that old anywhere

[trafix]

oh crap ... i forgot about that the line should be

PHP Code:

$DB_site->query("UPDATE " . TABLE_PREFIX . "thread SET open=0 WHERE lastpost <= $deletedate"
);