Deleted user, now how to delete posts?

[Urinemachine]

Hello - I deleted a user and their name says guest under it now, which is good. But, their posts still show.

Can I delete their posts somehow in a graceful manner? I could do a SQL query and just start dropping things but I think that'd get hairy.

Also, can I delete their posts even if they're the original poster (thread starter) and still have their thread remain? IE - make the 2nd post the first post of the thread since the user I want to delete will be removed?

Thanks all

[SEOvB]

I'm not so sure its possible now that you've deleted the user. You need to delete the posts before deleting the user.

One way to try is to register a new user with that username and run the maintenance tools for rebuilding information and see if they get reassociated with his account by chance, then remove the posts and then the user.

It should only remove his posts, and no one elses. So if he started a thread, it should remain while his first post is gone.

[Bellardia]

You could forcefully change a new users userid to the user id of the one you deleted (If you can find it somewhere). All posts will be associated with this user and delete the posts.

[Urinemachine]

If the user created a thread and I delete his posts, will the thread be deleted? Or will the 2nd poster inherit the thread?

[SEOvB]

Originally Posted by Urinemachine

If the user created a thread and I delete his posts, will the thread be deleted? Or will the 2nd poster inherit the thread?

The second post will become the first unless you delete the whole thread.

[Lynne]

Originally Posted by FRDS

The second post will become the first unless you delete the whole thread.

I think you may be wrong here. I know if I try to delete the first post of a thread when on the site, I get told:

Deleting the first post of a thread will result in the deletion of the thread.

That's using the inline moderation tool.

[SEOvB]

Originally Posted by Lynne

I think you may be wrong here. I know if I try to delete the first post of a thread when on the site, I get told:


That's using the inline moderation tool.

First time for everything

Really though, i always thought it just deleted the first post

[Digital Jedi]

It will delete the whole thread, sadly.

Just in case you couldn't find it, the SQL Query for restoring a Guest post to it's original user name is:

PHP Code:

UPDATE post SET userid='xxx' WHERE username='Old Name'; 


Just make sure you add your table prefix to post.

[Dismounted]

Depends how you delete his posts. If it is a single query to the post table, the thread information and the rest of the posts will still exist in the database, but the thread will not be displayed on the front-end.

[Urinemachine]

So I can restore them back to users from guest, then delete psots from user? That will take the thread out though if they started it? Is there a way to split the thread from the second post onward? I have a couple threads 20 pages long that i could split at post #2 and then delete the post and user after