Cronjob: remove redirects after X days

[Boothby]

I'm looking for a cronjob, which removes redirects to moved threads after X days. I hope you can help me.

Thx.

[sabret00the]

isn't this a default vB action?

[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.

[memobug]

This would be a nice feature.

Regards,

Matt

[Boothby]

Thank you Paul.

[Boothby]

Now I need 2 more cronjobs.

First, one which deletes "Deleted Posts / Threads" finally.

Secondly I would like to set a profile field, in which users can insert a number of days, after which their PMs are deleted. And the cronjob I am looking for should do the delete.

[Stargesicht]

wrong Post from me!!!
Sorry..

[Boothby]

And I hoped that someone could help me with my last post I did in April.

[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*