Cronjob: remove redirects after X days

[makaiguy]

Just discovered this.

Originally Posted by Paul M

It's not a default part of vB.

Personally I just put this in the includes/cron/cleanup2.php, at the top, before the "delete stale sessions" code.

PHP Code:

//    Auto delete re-directs.
$DB_site->query("
    DELETE FROM " . TABLE_PREFIX . "thread 
    WHERE open = 10 AND dateline < ". intval(TIMENOW - (60 * 60 * 24 *5))
); 


It removes them after 5 days.

For vB 3.5, it's:

PHP Code:

$vbulletin->db->query_write("
    DELETE FROM " . TABLE_PREFIX . "thread 
    WHERE open = 10 AND dateline < ". intval(TIMENOW - (60 * 60 * 24 * 5)) 


Thanks, Paul. Very handy. *installs*