Lock Old Threads

[Gardener]

Is the any way to automatically lock old threads after a certain. For example, one of the forums on my board imports several news groups. I would like to be able to automatically loke these after the post is 30 days old.

[Logician]

edit newthread.php, find:

PHP Code:

eval("standardredirect(\"".gettemplate("redirect_postthanks")."\",\"$goto\");"); 


before that add:

PHP Code:

$log_lockdate=mktime (date("H"), date("i"), date("s"), date("m"), date("d")-30, date("Y"));

$DB_site->query("UPDATE thread SET open=0 WHERE dateline<=$log_lockdate AND forumid=X"); 


Replace X with your forumid you want the auto-lock..

Not tested, first try in a test board! It has SQL query that wil make modifications in the records of your db, so do not apply to your real board without testing it in a test board..

The auto-lock will be triggered whenever someone creates a new thread in your board so do not expect the hack to work if someone does not create a new thread for a few days..

Enjoy

[Gardener]

Thanks for the help. I'll try it out later tonight.

The auto-lock will be triggered whenever someone creates a new thread in your board so do not expect the hack to work if someone does not create a new thread for a few days..

Since the news groups are pulled every 15 minutes this shouldn't be a problem.

I'll let you know how it works.

[Logician]

Since the news groups are pulled every 15 minutes this shouldn't be a problem.

nope.. The hack is triggerred when someone creates a thread by going the normal way (via newthread.php). So your other hack's threads will not trigger the hack..

But this still shouldnt be a problem since even the slowest forums have at least 1 thread per day..

how can you add multiple forums?

[Logician]

change line

PHP Code:

$DB_site->query("UPDATE thread SET open=0 WHERE dateline<=$log_lockdate AND forumid=X"); 


as

PHP Code:

$DB_site->query("UPDATE thread SET open=0 WHERE dateline<=$log_lockdate AND (forumid=X OR forumid=Y OR forumid=Z)"); 


Thanks a lot.

[Joe]

Originally Posted by Logician

edit newthread.php, find:

PHP Code:

eval("standardredirect(\"".gettemplate("redirect_postthanks")."\",\"$goto\");"); 


before that add:

PHP Code:

$log_lockdate=mktime (date("H"), date("i"), date("s"), date("m"), date("d")-30, date("Y"));

$DB_site->query("UPDATE thread SET open=0 WHERE dateline<=$log_lockdate AND forumid=X"); 


Replace X with your forumid you want the auto-lock..

Not tested, first try in a test board! It has SQL query that wil make modifications in the records of your db, so do not apply to your real board without testing it in a test board..

The auto-lock will be triggered whenever someone creates a new thread in your board so do not expect the hack to work if someone does not create a new thread for a few days..

Enjoy

Any reason this would NOT work in v3.0.0?