Print Page - Deleting first 200 posts from a member

Title: Deleting first 200 posts from a member
Post by: chase78 on November 21, 2009, 04:03:54 AM

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

Title: Re: Deleting first 200 posts from a member
Post by: N3RVE on November 21, 2009, 05:18:52 AM

Open phpMyAdmin (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)):

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]

Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: chase78 on November 21, 2009, 04:03:54 AM