PDA

View Full Version : Prune Guest Posts//


Jadelit
06-08-2002, 07:33 PM
Ok I removed about 500 members from my board, because they had 5 posts and below.

My question is that after I installed the "thread & post count" hack, it gives me an error when a removed user posted in that thread who is now a guest.

Is there a way to prune all the guest posts?

Jadelit
06-09-2002, 06:13 AM
anyone?

Xenon
06-09-2002, 10:34 AM
run this query
DELETE FROM post WHERE userid='0'

Logician
06-09-2002, 04:11 PM
and:

DELETE from thread where postuserid='0';

Jadelit
06-09-2002, 06:14 PM
Thanks.. it worked.