The Arcive of vBulletin Modifications Site.

milkmycow · #1 03-04-2003, 06:51 PM

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 · #2 03-04-2003, 07:25 PM

[sql]DELETE FROM post WHERE userid=0[/sql]

this will remove ALL guest posts

GoTTi · #3 03-20-2003, 03:52 AM

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

Xenon · #4 03-20-2003, 11:16 AM

[SQL]UPDATE thread SET forumid=x WHERE postuserid=0[/sql]

replace the x