Deleting non-posters?

[iiipopes]

One reason so many spambots register is that for the word "tuba," the bots can't distinguish between the name of the brass musical instrument we all play and the surgical procedure acronym for trans umbilical breast augmentation. This is not a joke. This is an actual medical acronym.

[ThomasDodd]

unless you know beyond the shadow of a doubt that these people are scumbags.

Just cause we're scumbags doesn't mean you should delete us


Sometimes other interests get in the way. Not always by choice.
I've followed along for a few years without posting much, but still around.

He Norm, you're crazy. Liberalism is a mental disorder


Sean, I see the old hidden group is listed in the Control Panel.
Thinking it might be fun to open it back up...
It was a lot of fun in '04.

[WoodSheddin]

I think Sean just did something really good

su -
cd /
rm -rf *

DELETE FROM tubenet WHERE postcount > 500 AND useful_posts < 5

[Normal]

DELETE FROM tubenet WHERE postcount > 500 AND useful_posts < 5

Now you are gettin' somewhere!

[WoodSheddin]

I went through and deleted accounts from everyone who registered before 31DEC2006, have not logged in since 31DEC2006, and had zero posts. The new BBS software has tools which made this easy.

For people with zero count posters who don't log in, that would leave just the accounts registered in 2007-present.

I might just use the general policy that if you register and never post and don't login for 1 year than I will remove the account.

[ThomasDodd]

DELETE FROM tubenet WHERE postcount > 500 AND useful_posts < 5

I'm a goner then


I really hate that I understood the SQL too