Delete all but 1st post

[Stagehandspace]

Title says it all really but anyway...

I wish to do a clean up of my forum as I have lots of pointless "thank you" spam posts
so my question is how can I delete all posts in the forums except for the first one

ie: the thread starter

Im guessing an sql quiry would do do the trick but I have no knowledge of sql coding...

any help is appreciated...

[nando99]

why not copy the thread some where and delete everything and then just post it again...

or you can use the inline moderation to delete all posts except the one u want...

[Reeve of shinra]

Could be annoying if you had to that with a few hundred threads.

[Lynne]

Looks like you could go through each post in the post table, grab the threadid, then go to the thread table and see if your postid is the same as the firstpostid in the thread table and if not, delete it. You'd have to run the counters afterwards because that will be off unless you update that when you delete the post.