Spam users and delete their posts with query

[toplisek]

I have set query to transfer all unwanted users to SPAM folder. Issue is that after moving it will not be deleted their posts. As I have noticed it is possibility to manually remove their posts or I'm wrong...
Need help.


1. How to delete all posts for all SPAM users?
2. How to set correct query to delete all post with one query?

[Wayne Luke]

1) Click the checkbox in the top-right corner of the post.

2) Scroll down to "Moderation Tools" at the bottom.

3) Choose "Delete As Spam" and click "Proceed"

4) Follow the steps as provided.

Don't recommend using queries to delete content. To delete a post, there are 5 or 6 queries needed but they need variable processing as well.

[toplisek]

Issue is that there are so many SPAM users that I can move them in second but needs delete of posts also.

1. Is there possibility to move users to SPAM folder and all SPAM users will have deleted posts?
2. I have done your steps but it is notice like:
The following users had more than 50 posts and these posts will need to be removed via the admin control panel.
3. If I go to Usergroup it will be shown Primary users and I have to delete each user (banned) separately? There is notice:
Are you sure you want to delete the user called '...'?
(userid: 6758)

All posts made by this user will be set to 'Guest'

This action cannot be undone.


- User will be deleted but posts not?

- How to be removed inside admin CP?

- What is definition for such post : posts made by this user will be set to 'Guest'

[toplisek]

Please help.

[Trevor Hannant]

What happens when you prune the spam posts via AdminCP? Are all spam posts in the same forum? How many users are you talking about? And how many posts?

If a user is set to 'Guest', their username will still show against posts they've made but their profile will not be available nor will users be able to search for their posts.

[toplisek]

- How to remove inside admin CP ALL banned users and their posts?
Its asks me:Are you sure you want to delete the user called '...'? I like to delete them and their posts.
1. It is time consuming to delete each post. Can be this done?
2. Their username will still show against posts they've made but their profile will not be available. Will be post seen inside visible forum?

[Wayne Luke]

You can prune all of a user's post under Threads & Posts -> Prune.