Deleting user posts

[ert4]

hello,

how can I delete all topics and posts of user X, who was once deleted from the forum? only his posts and topics on the forum are left. is there any sql query that will do it automatically? thanks for the help

[thecoalman]

If it's just handful of posts you can find them with:

Code: Select all

example.com/search.php?author_id=1

You can find them in DB using this, XYZ is the username:

Code: Select all

SELECT * FROM phpbb_posts WHERE post_username = 'XYZ'; 

I don't know if there is any unforeseen consequences if you delete them though DB so I would strongly suggest you don't unless someone else more knowledgeable says otherwise.

[Brf]

Deleting the first post or the last post of a topic will mess them up if you don't also fix the topic table. It is safer to delete them normally.

[ert4]

the user on the forum is a guest and has the name "electronix", you can't even click on his name because he doesn't have a registered profile, and I have to delete 8000 posts of this user so I can't do it manually... only with an sql query to the database?

[KevC]

Is it because they have requested the removal?

You should be able to change the username if they don't want that name being shown but it'll still be in any quoted text. I've had people ask before to have all their posts removed, I've said no because it's really complicated and messes up the topic flow and they've just said fine, leave it.

The name isn't clickable because the profile has already been disabled or deleted. If it's only been deactivated, you can change the username in the admin panel.

[thecoalman]

You can go to Users tab, put check next to "select anonymous user". Should be 8000 plus posts listed for anonymous.

You can select delete posts under basic tools but this is going to delete any posts by guest users. If you have other guest users with posts you want to keep there is other solutions.

Note you might want to go into your hosting control panel and increase the max execution time for php before deleting.

[ert4]

this is a spammer who added erotic posts and I need to delete it but how?

[LePaul]

this is a spammer who added erotic posts and I need to delete it but how?

In User Administration, when you pull up the user, at the bottom it says "Delete User"
There's a pull down menu that says "Delete Posts"

I use that to eliminate bad users/spammers and take their posts out too

[ert4]

only these posts are as guest (unregistered user)