Techgage.com

Techgage.com (http://forums.techgage.com/index.php)
-   Site and Forum Comments & Issues (http://forums.techgage.com/forumdisplay.php?f=20)
-   -   Forum user purging (http://forums.techgage.com/showthread.php?t=8704)

Rob Williams 08-24-2011 06:24 PM

Forum user purging
 
As our user count on the forums inched closer to 10,000, I had to do something to bring the number back down. No, it's not that I don't want lots of users on our forums; it's just that I wish more than 20% of them were legit users. To help clean things up, I removed all users who signed up but never activated their accounts, and also those who have never posted (or are spammers). Some stats:

Before Purge

Total Members: 9,971
Database Size: 390.6MB
SQL Records: 206,382

After Purge

Total Members: 2,651
Database Size: 375.8MB
SQL Records: 178,833

The users that were deleted consisted of:

Users with 0 Post Count: 5,297
Users Awaiting Confirmation: 2,024

No regular user should have been affected by this, but if you are in some way, let me know.

TheCrimsonStar 08-24-2011 06:27 PM

O_O

dude....wow.

Rob Williams 08-24-2011 07:47 PM

Quote:

Originally Posted by TheCrimsonStar (Post 49403)
O_O

dude....wow.

:D

I reverted our registration back to questions and answers, so I'll see if that slows down the spam registrations. It never used to, but these questions are a little more difficult, harder for most bots to answer. We'll see where that goes...

eunoia 08-27-2011 12:33 PM

Just testing to see if I was purged, whew. :D

Doomsday 08-27-2011 01:28 PM

Burn the Spamming! Kill the Spam!! Purge the Spammers!!

OriginalJoeCool 08-27-2011 05:34 PM

Spammers are among the world's worst scum. They deserve to be rounded up and forced to listen to a selection of the world's worst music. Bieber, Britney Spears, the Jonas Brothers. Play it in a loop non-stop, until their brains liquefy.

DarkStarr 08-27-2011 09:06 PM

I think you forgot the barney song in there after every other song :D

OriginalJoeCool 08-27-2011 09:38 PM

I knew I was missing something.

RainMotorsports 08-27-2011 10:11 PM

Quote:

Originally Posted by OriginalJoeCool (Post 49529)
I knew I was missing something.

If were going old school don't forget about the song that never ends. Pretty sure that alone after 5 days in solitary could drive even the strong minded insane.

Rob Williams 01-09-2012 06:25 PM

1 Attachment(s)
I sure don't regret moving to a moderated system for new users. Here's an idea of the spam you don't see:

Attachment 1365

OriginalJoeCool 01-09-2012 06:39 PM

I used to go to the forums on pinkfloyd.net, but it looks pretty much like that picture now.

MacMan 01-09-2012 07:23 PM

Quote:

Originally Posted by Rob Williams (Post 49402)
As our user count on the forums inched closer to 10,000, I had to do something to bring the number back down. No, it's not that I don't want lots of users on our forums; it's just that I wish more than 20% of them were legit users. To help clean things up, I removed all users who signed up but never activated their accounts, and also those who have never posted (or are spammers). Some stats:

Before Purge

Total Members: 9,971
Database Size: 390.6MB
SQL Records: 206,382

After Purge

Total Members: 2,651
Database Size: 375.8MB
SQL Records: 178,833

The users that were deleted consisted of:

Users with 0 Post Count: 5,297
Users Awaiting Confirmation: 2,024

No regular user should have been affected by this, but if you are in some way, let me know.

Wow, I wish they were all legit users! At least you save a lot of space and cut down on the spam.

Rob Williams 01-09-2012 07:56 PM

Quote:

Originally Posted by MacMan (Post 52626)
Wow, I wish they were all legit users! At least you save a lot of space and cut down on the spam.

Some forums just let that thing slide, so that it "appears" that their forum has a ton of users. And while 10,000 users looks better than 2,000, this is where I can't make a compromise. I'd rather have a forum with genuine users than one with 80% spam users. Stats wouldn't look so good if there are 50,000 posts and 25,000 spam users :D

MacMan 01-09-2012 10:19 PM

Quote:

Originally Posted by Rob Williams (Post 52629)
Some forums just let that thing slide, so that it "appears" that their forum has a ton of users. And while 10,000 users looks better than 2,000, this is where I can't make a compromise. I'd rather have a forum with genuine users than one with 80% spam users. Stats wouldn't look so good if there are 50,000 posts and 25,000 spam users :D

I totally agree, 100%!

Doomsday 01-10-2012 03:16 AM

Quote:

Originally Posted by Rob Williams (Post 52629)
Some forums just let that thing slide, so that it "appears" that their forum has a ton of users. And while 10,000 users looks better than 2,000, this is where I can't make a compromise. I'd rather have a forum with genuine users than one with 80% spam users. Stats wouldn't look so good if there are 50,000 posts and 25,000 spam users :D

^ Respect! :cool:


All times are GMT -4. The time now is 06:08 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Copyright 2005 - 2014, Techgage Networks Inc.