Automatically Lock Old Threads (Via vB Cron)

This vB cron allows you to define a certain period of time for threads to be automatically locked.

• Copy-paste the following into a new PHP file, and upload to ./includes/cron/YOURFILENAME.php
• Enter the adminCP and go to scheduled tasks, click "add new scheduled task"
• Setup when you want the script to run, and add the filename into the 'filename' field.

PHP Code:

<?php

    error_reporting(E_ALL & ~E_NOTICE);
    
    // start editing
    // forum ID's to monitor - put a comma between each one
    
    DEFINE('FORUM_IDS', '15,59,14');
    
    // time span to go back to.
    // eg for months use; 6 MONTH or 9 MONTH
    // years; 1 YEAR or 2 YEAR
    // days; 5 DAY or 29 DAY
    
    DEFINE('TIME_SPAN', '6 MONTH');    
    
    // stop editing here
    
    if (!is_object($DB_site))
    {
        exit;
    }    
    
    $DB_site->query("UPDATE " . TABLE_PREFIX . "thread SET open=0 WHERE forumid IN(". FORUM_IDS .") AND FROM_UNIXTIME(dateline) <  DATE_SUB(CURDATE(),INTERVAL ". TIME_SPAN .")");
    
    log_cron_action('Old Threads Locked', $nextitem);

?>

[Corriewf]

I love the concept however this needs to be revised for last post activity as a lot of members use the same thread as an update thread which can go on for a long time.

[TrentTech]

Is the time based on when the thread is created, or when the last reply was?

[Delphy]

I wrote something similar for my board a while back.

What I would do is change the query to:

    $DB_site->query("UPDATE " . TABLE_PREFIX . "thread SET open=0 WHERE forumid IN(". FORUM_IDS .") AND open <> 0 AND FROM_UNIXTIME(lastpost) <  DATE_SUB(CURDATE(),INTERVAL ". TIME_SPAN .")");

This way you are:
1) Only locking threads that aren't already locked (saves re-locking already locked threads)
2) Basing it on the lastpost in the thread, so you don't lock active threads that are created within your timespan

What I also do is hard delete any that are locked and within another timeframe using the same cron job.

Regards,
Delphy

[Corriewf]

Thanks for that...... So when are the sims coming out to psp?

[Logikos]

Something like this has already been released. https://vborg.vbsupport.ru/showthrea...threadid=70302 and it goes by the last post date.