deleting posts..
 

how can I delete all posts from a user that is deleted? :surprised:

finally an easy question :)

Admins Cp - Threads & Posts (left hand side category) --> Mass Prune --> Prune by username

it says this..

and there is nothing there, and also the posts are there still..

do you remember the userid? if not then find one of his posts then search for it in phpmyadmin and search out the userid... if its changed to zero then simply run this query...

else if you find the user id then replace the zero with the userid regards...

g-force2k2

Note you will also need to remove any threads by them:

[sql]DELETE FROM thread WHERE postuserid=0[/sql]

heh i didn't think of that NTLDR but then again if you do that how will the threads themselves be maintained? (meaning all of the posts in the thread) i don't think its a good idea to do such... im sure that'll it'll reindex the thread... but i think you know what i mean :P

g-force2k2

I hadn't thought about that, allthough somewhere allong the line I think it will go wrong no matter what you do, and there will probably be posts left that arn't needed.

The morral of the story, prune before deletion ;)