Delete all messages and new users SINCE

[loki66]

I had some massive spam I have not noticed until recently. It would take too much time to delete manually all faked users and spam. I noticed that if i delete the users, the posts remain. since I had only spam, I am looking for the right sql command to delete all messages since - date - Thanks

[Kindred]

It is complicated and there is no good way to do it in sql.

You can bulk delete users and bulk delete posts

Please do not try to do it by direct database edit. You will screw up your site

[loki66]

I dont see how to mass delete posts. please tell me.

Would it be possible in the future that there is some option to delete users as well as their posts ... ?

[Doug Heffernan]

This is better done with a custom mod that will handle the deletion process properly, rather than manipulatin the database directly. YOu can put in a paid or free request at our Mod Requests board and hopefully someone will code it for you.

[@rjen]

I dont see how to mass delete posts. please tell me.

Would it be possible in the future that there is some option to delete users as well as their posts ... ?

That is a standard function in SMF.
Go to them member profile and hit "Delete this account"

You then get the opption to "Remove posts made by this member:
select is and choose "Topics and Posts"

Then both the accoutn and all posts are deleted...

[Doug Heffernan]

That won't delete posts based on the op's criteria though.

I am looking for the right sql command to delete all messages since - date - Thanks

[@rjen]

I believe he is looking to identity users and posts since a date. Typically spam users register and start posting.

He did not specify how many accounts it involves, if the number is limited to a few dozens, this method is perfectly doable

[loki66]

Here are more details. The forum is located at https://forum.monstrous.com
When I switched to 2.1.x I failed to check the mods and since hundreds of spammers made thousands of posts ...

I also realized that a lot of mods dont work anymore ...

[Doug Heffernan]

Here are more details. The forum is located at https://forum.monstrous.com
When I switched to 2.1.x I failed to check the mods and since hundreds of spammers made thousands of posts ...

I also realized that a lot of mods dont work anymore ...

It looks like you have a lot of users and content that you want to delete. Doing that in one fell swoop, it will require a custom mod.

[Kindred]

To mass delete posts,change your moderation settings to checkbox

Then,  in a board,you can select posts by checkbox and choose delete

[loki66]

OK found it in user settings

[loki66]

How can I delete all messages instead of 50 by 50, would take too long ... Those posts are orphan, give me please the right sql command

[Arantor]

You need a whole bunch of SQL commands, that's the problem. And they're not simple to write because they're chained together (which is why the delete function is suggested)