prune by user group

[milkmycow]

there has been a few times when i accidently deleted users that were spamming before i pruned their posts..

so all their posts are as guests... is there a way i can prune only guest posts?

[Xenon]

DELETE FROM post WHERE userid=0

this will remove ALL guest posts

[GoTTi]

how can threads by guest be moved into a forum (IE Trash can)

[Xenon]

UPDATE thread SET forumid=x WHERE postuserid=0

replace the x :)