Latest Forum Posts

Latest News Posts
Coming Soon!
Social
Go Back   Techgage.com > Site HQ > Site and Forum Comments & Issues

Site and Forum Comments & Issues Comments? Suggestions? Out-right flames? Found a bug? Feel free to post about it here!

Reply
 
Thread Tools
Old 08-24-2011, 07:24 PM   #1
Rob Williams
Editor-in-Chief
 
Rob Williams's Avatar
 
Join Date: Jan 2005
Location: Atlantic Canada
Posts: 13,352
Default 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.
__________________
Intel Core i7-3960X, GIGABYTE G1.Assassin 2, Kingston 16GB DDR3-2133, NVIDIA GeForce GTX 770 2GB
Kingston HyperX 3K 240GB SSD (OS, Apps), WD VR 1TB (Games), Corsair 1000HX, Corsair H70 Cooler
Corsair 800D, Dell 2408WFP 24", ASUS Xonar Essence STX, Gentoo (KDE 4.11. 3.12 Kernel)

"Take care to get what you like, or you will be forced to like what you get!" - H.P. Baxxter
<Toad772> I don't always drink alcohol, but when I do, I take it too far.


Rob Williams is offline   Reply With Quote
Old 08-24-2011, 07:27 PM   #2
TheCrimsonStar
Tech Monkey
 
TheCrimsonStar's Avatar
 
Join Date: Apr 2010
Location: Strawberry Plains, TN
Posts: 816
Default

O_O

dude....wow.
__________________

Intel Core i5-2500k @ 3.3GHz
ASUS Sabertooth P67
Corsair XMS 1600 8GB (2 x 4GB)
XFX Radeon HD 6970
Corsair CMPSU-850TX 850W
Corsair H80 High Performance Liquid CPU Cooler
Windows 7 Professional (x64)
TheCrimsonStar is offline   Reply With Quote
Old 08-24-2011, 08:47 PM   #3
Rob Williams
Editor-in-Chief
 
Rob Williams's Avatar
 
Join Date: Jan 2005
Location: Atlantic Canada
Posts: 13,352
Default

Quote:
Originally Posted by TheCrimsonStar View Post
O_O

dude....wow.


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...
__________________
Intel Core i7-3960X, GIGABYTE G1.Assassin 2, Kingston 16GB DDR3-2133, NVIDIA GeForce GTX 770 2GB
Kingston HyperX 3K 240GB SSD (OS, Apps), WD VR 1TB (Games), Corsair 1000HX, Corsair H70 Cooler
Corsair 800D, Dell 2408WFP 24", ASUS Xonar Essence STX, Gentoo (KDE 4.11. 3.12 Kernel)

"Take care to get what you like, or you will be forced to like what you get!" - H.P. Baxxter
<Toad772> I don't always drink alcohol, but when I do, I take it too far.


Rob Williams is offline   Reply With Quote
Old 08-27-2011, 01:33 PM   #4
eunoia
Partition Master
 
eunoia's Avatar
 
Join Date: Sep 2009
Location: Outside Poker Flat
Posts: 311
Default

Just testing to see if I was purged, whew.
__________________
Cooler Master HAF X - Thermaltake Toughpower W0178RU 850W - GIGABYTE G1.Assassin - Intel Core i7 930 - Noctua NH-U12P SE2 - Kingston Hyper X Red 1600 4x4GB - 2 X SAMSUNG DVD Burner SH-S223L LightScribe - WD1001FALS 1TB - WD FAEX 1TB - Acer AL2216W - Samsung S27D360 - Thermaltake Tt eSPORTS CHALLENGER Keyboard - Logitech MX620 - Win 7 Professional x64
eunoia is offline   Reply With Quote
Old 08-27-2011, 02:28 PM   #5
Doomsday
Tech Junkie
 
Doomsday's Avatar
 
Join Date: Nov 2008
Location: KHI, PAK
Posts: 1,559
Default

Burn the Spamming! Kill the Spam!! Purge the Spammers!!
__________________
PSU: Corsair AX850 - Case: Cooler Master HAF X - CPU:Core i7-2600k - Cooler: Cooler Master V6 GT - Motherboard: Asus Z68 Maximus IV Extreme Z - Memory: Corsair Vengeance 8 GB-1600Mhz - GPU: AMD MSI R6970 Lightning - HDD: WD Caviar Black 1TB, Seagate 2TB Barracuda Green - SSD: Intel 520 Series 120GB - K/B: Razer Lycosa Mirror - Mouse: Logitech G700 - MouseMat: Steel Series 4HD - LCD: Asus VG278H 27" - Speakers: Creative Inspire M4500 4.1 - Headset: Logitech G35 7.1



"Do not look at a man's prayers nor his fasts, rather, measure him by how well he deals with others, the compassion he shows his fellow man, his wisdom and his integrity" - Umar Ibn Al-Khattab


Doomsday is offline   Reply With Quote
Old 08-27-2011, 06:34 PM   #6
OriginalJoeCool
Tech Monkey
 
OriginalJoeCool's Avatar
 
Join Date: Sep 2010
Location: Saint John, New Brunswick, Canada
Posts: 617
Default

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.
__________________
Last.fm

Raptr

"Man could hold the universe in his palm, if only he could learn to unclench his fist."
OriginalJoeCool is offline   Reply With Quote
Old 08-27-2011, 10:06 PM   #7
DarkStarr
Tech Monkey
 
DarkStarr's Avatar
 
Join Date: Apr 2010
Posts: 634
Default

I think you forgot the barney song in there after every other song
__________________
Intel Core i7 2700k (4.8 @ 100x48) Watercooled - 16GB Crucial Ballistix @ 1600 Mhz 9.9.9.24 2T
8GB
Corsair Vengeance @ 1600 Mhz 9.9.9.24 2T - Asus Sabertooth P67
- Asus Radeon 7970 Ref. (Non Ghz)
Heatkiller 79xx Ni-Bl (Soon) @ 1050/1500
- 64Gb Crucial M4 SSD - 3x Hitachi 1Tb - Corsair TX950W
Azza Genesis 9000B - 2x Samsung SyncMaster S27A550H - Vizio 32" LCD

DarkStarr is offline   Reply With Quote
Old 08-27-2011, 10:38 PM   #8
OriginalJoeCool
Tech Monkey
 
OriginalJoeCool's Avatar
 
Join Date: Sep 2010
Location: Saint John, New Brunswick, Canada
Posts: 617
Default

I knew I was missing something.
__________________
Last.fm

Raptr

"Man could hold the universe in his palm, if only he could learn to unclench his fist."
OriginalJoeCool is offline   Reply With Quote
Old 08-27-2011, 11:11 PM   #9
RainMotorsports
Partition Master
 
RainMotorsports's Avatar
 
Join Date: Jul 2011
Posts: 359
Default

Quote:
Originally Posted by OriginalJoeCool View Post
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.
RainMotorsports is offline   Reply With Quote
Old 01-09-2012, 07:25 PM   #10
Rob Williams
Editor-in-Chief
 
Rob Williams's Avatar
 
Join Date: Jan 2005
Location: Atlantic Canada
Posts: 13,352
Default

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

Click image for larger version

Name:	the_spam_you_never_see.png
Views:	144
Size:	147.0 KB
ID:	1365
__________________
Intel Core i7-3960X, GIGABYTE G1.Assassin 2, Kingston 16GB DDR3-2133, NVIDIA GeForce GTX 770 2GB
Kingston HyperX 3K 240GB SSD (OS, Apps), WD VR 1TB (Games), Corsair 1000HX, Corsair H70 Cooler
Corsair 800D, Dell 2408WFP 24", ASUS Xonar Essence STX, Gentoo (KDE 4.11. 3.12 Kernel)

"Take care to get what you like, or you will be forced to like what you get!" - H.P. Baxxter
<Toad772> I don't always drink alcohol, but when I do, I take it too far.


Rob Williams is offline   Reply With Quote
Old 01-09-2012, 07:39 PM   #11
OriginalJoeCool
Tech Monkey
 
OriginalJoeCool's Avatar
 
Join Date: Sep 2010
Location: Saint John, New Brunswick, Canada
Posts: 617
Default

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

Raptr

"Man could hold the universe in his palm, if only he could learn to unclench his fist."
OriginalJoeCool is offline   Reply With Quote
Old 01-09-2012, 08:23 PM   #12
MacMan
Partition Master
 
MacMan's Avatar
 
Join Date: Mar 2007
Location: Canada
Posts: 436
Default

Quote:
Originally Posted by Rob Williams View Post
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.
__________________
MacMan is offline   Reply With Quote
Old 01-09-2012, 08:56 PM   #13
Rob Williams
Editor-in-Chief
 
Rob Williams's Avatar
 
Join Date: Jan 2005
Location: Atlantic Canada
Posts: 13,352
Default

Quote:
Originally Posted by MacMan View Post
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
__________________
Intel Core i7-3960X, GIGABYTE G1.Assassin 2, Kingston 16GB DDR3-2133, NVIDIA GeForce GTX 770 2GB
Kingston HyperX 3K 240GB SSD (OS, Apps), WD VR 1TB (Games), Corsair 1000HX, Corsair H70 Cooler
Corsair 800D, Dell 2408WFP 24", ASUS Xonar Essence STX, Gentoo (KDE 4.11. 3.12 Kernel)

"Take care to get what you like, or you will be forced to like what you get!" - H.P. Baxxter
<Toad772> I don't always drink alcohol, but when I do, I take it too far.


Rob Williams is offline   Reply With Quote
Old 01-09-2012, 11:19 PM   #14
MacMan
Partition Master
 
MacMan's Avatar
 
Join Date: Mar 2007
Location: Canada
Posts: 436
Default

Quote:
Originally Posted by Rob Williams View Post
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
I totally agree, 100%!
__________________
MacMan is offline   Reply With Quote
Old 01-10-2012, 04:16 AM   #15
Doomsday
Tech Junkie
 
Doomsday's Avatar
 
Join Date: Nov 2008
Location: KHI, PAK
Posts: 1,559
Default

Quote:
Originally Posted by Rob Williams View Post
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
^ Respect!
__________________
PSU: Corsair AX850 - Case: Cooler Master HAF X - CPU:Core i7-2600k - Cooler: Cooler Master V6 GT - Motherboard: Asus Z68 Maximus IV Extreme Z - Memory: Corsair Vengeance 8 GB-1600Mhz - GPU: AMD MSI R6970 Lightning - HDD: WD Caviar Black 1TB, Seagate 2TB Barracuda Green - SSD: Intel 520 Series 120GB - K/B: Razer Lycosa Mirror - Mouse: Logitech G700 - MouseMat: Steel Series 4HD - LCD: Asus VG278H 27" - Speakers: Creative Inspire M4500 4.1 - Headset: Logitech G35 7.1



"Do not look at a man's prayers nor his fasts, rather, measure him by how well he deals with others, the compassion he shows his fellow man, his wisdom and his integrity" - Umar Ibn Al-Khattab


Doomsday is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Deus Ex: Human Revolution - A user review (Part III) marfig Reader-Submitted Reviews 29 10-17-2011 02:15 PM
Flickr Accidentally Deletes User's 4,000 Photos Tharic-Nar General Technology 3 02-06-2011 06:31 PM
Need user manual gdg411 General Hardware 5 02-18-2009 08:16 PM
Who can explain my user text? Buck-O Off Topic 6 01-09-2006 01:52 PM


All times are GMT -4. The time now is 12:10 PM.