34
34
$t = time() - $max_age_days*86400;
36
36
if (!$db) die("can't open DB\n");
37
$db->do_query("update DBNAME.thread, DBNAME.forum set DBNAME.thread.locked=1 where DBNAME.thread.forum=DBNAME.forum.id and DBNAME.forum.parent_type=0 and DBNAME.thread.timestamp<$t and DBNAME.thread.locked=0 and DBNAME.thread.sticky=0");
37
$db->do_query("update ".$db->db_name.".thread, ".$db->db_name.".forum set ".$db->db_name.".thread.locked=1 where ".$db->db_name.".thread.forum=".$db->db_name.".forum.id and ".$db->db_name.".forum.parent_type=0 and ".$db->db_name.".thread.timestamp<$t and ".$db->db_name.".thread.locked=0 and ".$db->db_name.".thread.sticky=0");
38
38
$n = $db->affected_rows();
40
40
echo "finished at $t; locked $n threads\n";