Selective delete messages...

[Areku]

Hi there,

A user started to edit and just delete contents of 1K messages he posted long time ago.

Is there any way to delete ALL of the ones that have been EDITED already, leaving untouched the rest of messages he has not yet edited?

[Xenon]

hmm, just if you have enabled the show edited by.

if you have enabled the feature you can run this query:
DELETE FROM post WHERE userid=xx AND edituserid=xx

and replace the xx with his userid.

you have to update the counters after that.