public static function prune_attachment($forum_id, $time = FALSE)
{
// delete attachments.
$result = dbquery("\n SELECT post_id, post_datestamp FROM " . DB_FORUM_POSTS . "\n WHERE forum_id='" . $forum_id . "' " . ($time ? "AND post_datestamp < '" . $time . "'" : '') . "\n ");
$delattach = 0;
if (dbrows($result) > 0) {
while ($data = dbarray($result)) {
// delete all attachments
$result2 = dbquery("SELECT attach_name FROM " . DB_FORUM_ATTACHMENTS . " WHERE post_id='" . $data['post_id'] . "'");
if (dbrows($result2) != 0) {
$delattach++;
$attach = dbarray($result2);
@unlink(FORUM . "attachments/" . $attach['attach_name']);
dbquery("DELETE FROM " . DB_FORUM_ATTACHMENTS . " WHERE post_id='" . $data['post_id'] . "'");
}
}
}
}