Quote:
A simple SQL query can be used periodically to delete them. Use something like "DELETE FROM post WHERE username='username'" You'll also need to run DELETE FROM thread WHERE postusername='name of bad seed'" Or you can see my last post and add another thing to the if statement.
|
Is anybody sucessfully doing this through phpmyadmin and if so what is the exact query you are using? I tried this and it gives me a syntax error on line 1 and I really have alot of posts I would like to remove asap...thanks
DELETE FROM post WHERE username='username' <---this give me bad syntax when i run this query from phpmyadmin? is there something that goes in front or behind this...sorry for asking again but I've been waiting all weekend to be able to remove bulk spam posts and would appreciate help from anybody using phpadmin to run this query and delete posts by user, note I cannot mass prune by user from admincp and when I try it hops to the next page but appears there is buttons missing and I cant perform the action...perhaps others know what I mean....