/** * @see \wcf\system\cronjob\ICronjob::execute() */ public function execute(Cronjob $cronjob) { parent::execute($cronjob); // delete orphaned attachments $attachmentIDs = array(); $sql = "SELECT\tattachmentID\n\t\t\tFROM\twcf" . WCF_N . "_attachment\n\t\t\tWHERE\tobjectID = ?\n\t\t\t\tAND uploadTime < ?"; $statement = WCF::getDB()->prepareStatement($sql); $statement->execute(array(0, TIME_NOW - 86400)); while ($row = $statement->fetchArray()) { $attachmentIDs[] = $row['attachmentID']; } if (!empty($attachmentIDs)) { AttachmentEditor::deleteAll($attachmentIDs); } }