I have a large number of suspect users I want to delete. They were migrated from our previous vbb forum and they have been sitting on our forum as suspect users for some time. Many of these have profile link spam.
My criteria are to delete any user meeting the following criteria:
users that were last seen say more than 3 years ago
users that have no posts
users that have not read any posts
(maybe users that have a web profile url)
I am able to select these using sql, but now want to bulk delete them.
For future reference, the best way to handle this currently is to identify the criteria, code that into the import script, and rerun the import on a clean Discourse database.
Of course, that doesn’t work if you’ve been writing posts on the current database for weeks…