Just discovered this.
Quote:
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*