News:

Wondering if this will always be free?  See why free is better.

Main Menu

Deleting first 200 posts from a member

Started by chase78, November 21, 2009, 04:03:54 AM

Previous topic - Next topic

chase78

HI,

Could anyone advise on deleting the first 200 posts by a member?

Use SQL? Any impact on post count or other issues?

If SQL please give the SQL to be use.

Thank you!

KT

N3RVE

Open phpMyAdmin (What is phpMyAdmin?):

Code (Run SQL) Select
SELECT * FROM `smf_messages` WHERE `poster_name` = '[n3rve]'

That would return all posts made by the user "[n3rve]", check all, delete and so on. Take note of the message ID (id_msg) so you don't go ahead of 200.

-[n3rve]
Ralph "[n3rve]" Otowo
Former Marketing Co-ordinator, Simple Machines.
ralph [at] simplemachines [dot] org                       
Quote"Somewhere, something incredible is waiting to be known." - Carl Sagan

Advertisement: