Announcement

Collapse
No announcement yet.

Is there a way to selectively delete all posts made by one user in one forum?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Is there a way to selectively delete all posts made by one user in one forum?

    eom

  • #2
    Go into phpMyAdmin and run the following query:


    SELECT post.userid, post.postid, thread.title, post.pagetext
    FROM post AS post
    LEFT JOIN thread AS thread
    USING ( threadid )
    WHERE post.userid = {x}
    AND thread.forumid = {y}



    where {x} is the userid of the user and {y} is the forumid of the forum.



    Note the postids of the posts you want to delete.


    This query will delete them:


    DELETE FROM post
    WHERE postid = {x}
    OR postid = {y}
    OR...



    where {x} and {y} are the postids of posts to delete.
    Sig? What sig?

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X