Since Coventry has not yet made an appearance here at XF, my idea is to do a mass soft-deletion of all threads and posts by these members. Not perfect, but it achieves the same result. Normally I would just find a way to flag those messages as soft-deleted in the database, but I am not yet familiar enough to know which tables and columns need to be updated. We do not want to hard delete, so that is not an option. And since we will be using the moderation queue heavily, tagging those as unapproved would just make a big mess for us.
Has anyone figured out a database query like this which would do the trick for us? Or is there another workaround I could use?