Deleting non-posters?

[trseaman]

The next version of BBS will take care of most spammers, for a while!:roll: The new one will also have the ability to force reactivation. That should be good for users that have never logged in their account. Purging the accounts created by spammers is possible, although it may take a while...

Tim

[Sally Larsen]

As a long-time lurker who checks in daily:

Please, don't ditch the true aficionados when you toss the trolls.

The management of this site is tremendous, and under-celebrated.

I'll hoist one to you this weekend, in my pup tent by the (not-quite-swim-able) Northern Atlantic, and as soon as I get home, after a quick pee, and probably a car repair, I'll read the latest postings.

The joy and community you provide for those of us who see every band from the back is immeasurable.

Deepest Thanks.

[SplatterTone]

I think Sean just did something really good

su -
cd /
rm -rf *

[Biggs]

I love Mr.Pornviedo (not) our newest register

He doesn't love you.

[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