PDA

View Full Version : delete guest posts


pantani
10-18-2011, 07:01 AM
Hello,
I had to delete someone's account in a hurry, because of some major problems at home, i will not go in to detail with this, but now i have to delete this members posts, and you can not find the post under his name offcource, now all the posts of this person are with his name, for example "Jim" and under his name is Guestn so you can not find the posts "Jim" posted.
You have to look in topic per topic to find if he made a reply somewhere and delete it, so you can see this is impossible to do like this, so now the question, is there a way to delete all his post in one time?? But can't search his name because it's account is deleted.

Thank, hope there is a way :)

Phalynx
10-18-2011, 08:07 AM
Execute this query:
DELETE FROM post WHERE username='Jim' AND userid=0

Add your DB-Prefix before "post", if you have one.

Nelson58
02-18-2013, 02:23 PM
Where do you execute this inquiry, in PHPAdmin?

Thanks!

Nelson

ForceHSS
02-18-2013, 03:48 PM
You can run it from the admin panel

Nelson58
02-27-2013, 01:04 PM
Thanks Force, it works great!

Nelson