I recently migrated an ancient Active Forums site to Xenforo, by way of a manual conversion to phpBB. In the process I forgot to drop the soft-deleted posts from ActiveForums, and now I have roughly a thousand messages that should be deleted that aren't. Since I retained the IDs, can I simply run a query along the lines of this
to set them all to a soft-deleted state, or are there other tables I would need to update as well?
UPDATE xf_posts WHERE post_id IN (long list here) SET message_state = 'deleted';