XF 2.1 Deleting every private message from a certain date

[dieg0]

Hello,

A few days ago somehow someone created a lot of new user accounts on our forum y started sending a **** load of private messages to a **** load of members.

I managed to stop the a lot of the e-mails that were being sent to my users since they were in a backlog queue but the fact is that those PM with sex pictures are still al over the place.

I would like to know the specific SQL query that would delete them since I'm on 2.1.12. Let's say the date was november the 7th. Obviously I don't mind losing any other PMs for that day.

Best,

 

[beerForo]

Go to that profile in acp and click "Delete conversations."

 

[dieg0]

Go to that profile in acp and click "Delete conversations."

Hi, as I said there are 765464564 profiles

 

[beerForo]

It is not recommended to delete anything directly from the db. It can screw things up in XF.

 

[beerForo]

Just delete from senders' profiles

 

[djbaxter]

Hi, as I said there are 765464564 profiles

Just delete from senders' profiles

I think @dieg0 is saying there are 765464564 senders, probably a bot net.

 

[dieg0]

I think @dieg0 is saying there are 765464564 senders, probably a bot net.

That is correct.