[giovannicosta]

Originally Posted by Paul M

Create a plugin ;

Hook: cron_script_cleanup

PHP Code:

$days = 31;
$forums = '1,2,3,4,5';
$vbulletin->db->query_write("
    UPDATE ".TABLE_PREFIX."thread SET open = 0
    WHERE forumid IN($forums) AND open = 1 AND sticky = 0 AND lastpost < ".intval(TIMENOW-(86400*$days))
); 


do we edit TABLE+PREFIX with out table prefix?