Let's do something to help VGF out...

Crazybirdanimations · 12-14-2007, 02:34 AM

How about deleting members that have 0 posts on the forum?
Not NEW members, but old members that are just spam.

***CaptHayfever*** · 12-15-2007, 05:51 PM

That's happened before, I think.

And remember, "I'm-a Luigi, number one!"

Eric · 12-15-2007, 05:54 PM

^^agreed

Crazybirdanimations · 12-17-2007, 06:40 PM

Then why not do it again?

**Booyakasha** · 12-17-2007, 06:56 PM

Uhhh...all right, I'm just going to ask--how's that going to help the site out?

***CaptHayfever*** · 12-17-2007, 07:39 PM

It clears up server space, for one. Also, the less people who came but never did anything you have, the more incentive for new people to come and do things.

And remember, "I'm-a Luigi, number one!"

**Booyakasha** · 12-17-2007, 07:41 PM

Fair enough on the first part. 'Uhhh?' on the second part.

Metal Man · 12-18-2007, 05:02 PM

This is about as effective as defeating disease by moving all the graves of people who died from the disease out of sight.

***CaptHayfever*** · 12-18-2007, 09:09 PM

^More like burning the records of SIDS victims so that more healthy people will move into town.

And remember, "I'm-a Luigi, number one!"

wariovswario · 01-20-2008, 08:37 PM

That would be A LOT of filtering unless there's such a function for VB 2.0. If there isn't a function then it would take quite a while to go through the list and see which ones to delete and which ones to keep. This is something Shane SHOULD'VE kept up with, but decided not to give a damn instead.

Metal Man · 01-31-2008, 02:57 PM

Quote:

Originally Posted by wariovswario

That would be A LOT of filtering unless there's such a function for VB 2.0. If there isn't a function then it would take quite a while to go through the list and see which ones to delete and which ones to keep. This is something Shane SHOULD'VE kept up with, but decided not to give a damn instead.

DELETE FROM `users` WHERE `post_count`=0 AND `join_date` < '1-1-2007';

It couldn't be easier if I tried.

Everybody Nose · 02-06-2008, 10:34 PM

Quote:

Originally Posted by Booyakasha

Fair enough on the first part. 'Uhhh?' on the second part.

If you see a board has 15,000 Members, and only 80 of them are active, something may click.

LinkManDX · 02-07-2008, 03:17 PM

There's no real reason for this, if you delete it from the database, it's going to save at most 5 megabytes (I think).

Metal Man · 02-07-2008, 03:38 PM

Well, yeah. It's all the posts which eat space. Dead members sorta sit there.

***Ace Mercury*** · 02-07-2008, 03:54 PM

Quote:

Originally Posted by Metal Man

DELETE FROM `users` WHERE `post_count`=0 AND `join_date` < '1-1-2007';

It couldn't be easier if I tried.

drop table users;

LinkManDX · 02-07-2008, 04:08 PM

DELICIOUS POISON · 02-07-2008, 10:23 PM

12-14-2007, 02:34 AM	#1
Crazybirdanimations Platinum Member Join Date: Mar 2006 Location: California Gender: Posts: 4,652 Thanks: 233 Thanked 202 Times in 166 Posts Points: 14,612.34 Bank: 9,511.32 Total Points: 24,123.66 Donate	Let's do something to help VGF out... How about deleting members that have 0 posts on the forum? Not NEW members, but old members that are just spam.

12-17-2007, 06:56 PM	#5
Booyakasha Mod of War Join Date: Nov 2000 Location: Wisconsinland Gender: Posts: 6,921 Thanks: 78 Thanked 383 Times in 242 Posts Points: 12,559.39 Bank: 28,896.88 Total Points: 41,456.27 Donate	Uhhh...all right, I'm just going to ask--how's that going to help the site out? __________________ Boo--the only dude bad enough to rescue the president

12-17-2007, 07:41 PM	#7
Booyakasha Mod of War Join Date: Nov 2000 Location: Wisconsinland Gender: Posts: 6,921 Thanks: 78 Thanked 383 Times in 242 Posts Points: 12,559.39 Bank: 28,896.88 Total Points: 41,456.27 Donate	Fair enough on the first part. 'Uhhh?' on the second part. __________________ Boo--the only dude bad enough to rescue the president

01-20-2008, 08:37 PM	#10
wariovswario Don't ban me please. :( Join Date: Jul 2000 Gender: Posts: 4,238 Thanks: 89 Thanked 68 Times in 48 Posts Blog Entries: 2 Points: 1,665.45 Bank: 526,330.45 Total Points: 527,995.90 Donate	That would be A LOT of filtering unless there's such a function for VB 2.0. If there isn't a function then it would take quite a while to go through the list and see which ones to delete and which ones to keep. This is something Shane SHOULD'VE kept up with, but decided not to give a damn instead. __________________ Click here to level up my card!

02-07-2008, 10:23 PM	#17
DELICIOUS POISON Retro Nintendo Supermod Art & Literature Mod Metroid Mod Join Date: Aug 2002 Location: I rub my tilde all over your asterisk Gender: Posts: 16,334 Thanks: 528 Thanked 1,443 Times in 725 Posts Points: 9,359.13 Bank: 2,667,479.76 Total Points: 2,676,838.89 Donate	Loosely Relevant

12-15-2007, 05:51 PM	#2
*CaptHayfever* Smash Supermod Join Date: Jul 2002 Location: (n) - the place where I am Gender: Posts: 19,609 Thanks: 191 Thanked 871 Times in 545 Posts Points: 113,009.35 Bank: 1,372.71 Total Points: 114,382.05 Donate	That's happened before, I think. And remember, "I'm-a Luigi, number one!"

12-15-2007, 05:54 PM	#3
Eric Member Join Date: Mar 2006 Location: chained to shane's doghouse outside Gender: Posts: 1,035 Thanks: 130 Thanked 44 Times in 37 Posts Points: 6,932.92 Bank: 104.05 Total Points: 7,036.97 Donate	^^agreed

12-17-2007, 06:40 PM	#4
Crazybirdanimations Platinum Member Join Date: Mar 2006 Location: California Gender: Posts: 4,652 Thanks: 233 Thanked 202 Times in 166 Posts Points: 14,612.34 Bank: 9,511.32 Total Points: 24,123.66 Donate	Then why not do it again?

12-17-2007, 07:39 PM	#6
*CaptHayfever* Smash Supermod Join Date: Jul 2002 Location: (n) - the place where I am Gender: Posts: 19,609 Thanks: 191 Thanked 871 Times in 545 Posts Points: 113,009.35 Bank: 1,372.71 Total Points: 114,382.05 Donate	It clears up server space, for one. Also, the less people who came but never did anything you have, the more incentive for new people to come and do things. And remember, "I'm-a Luigi, number one!"

12-18-2007, 05:02 PM	#8
Metal Man Senior Member Join Date: Apr 2000 Location: Gender: Posts: 6,804 Thanks: 74 Thanked 208 Times in 143 Posts Points: 11,492.88 Bank: 0.00 Total Points: 11,492.88 Donate	This is about as effective as defeating disease by moving all the graves of people who died from the disease out of sight.

12-18-2007, 09:09 PM	#9
*CaptHayfever* Smash Supermod Join Date: Jul 2002 Location: (n) - the place where I am Gender: Posts: 19,609 Thanks: 191 Thanked 871 Times in 545 Posts Points: 113,009.35 Bank: 1,372.71 Total Points: 114,382.05 Donate	^More like burning the records of SIDS victims so that more healthy people will move into town. And remember, "I'm-a Luigi, number one!"

02-07-2008, 03:17 PM	#13
LinkManDX Senior Member Join Date: May 2002 Location: Some call it slums, some call it nice! Gender: Posts: 3,345 Thanks: 256 Thanked 209 Times in 122 Posts Points: 16,574.02 Bank: 6,327.87 Total Points: 22,901.89 Donate	There's no real reason for this, if you delete it from the database, it's going to save at most 5 megabytes (I think).

02-07-2008, 03:38 PM	#14
Metal Man Senior Member Join Date: Apr 2000 Location: Gender: Posts: 6,804 Thanks: 74 Thanked 208 Times in 143 Posts Points: 11,492.88 Bank: 0.00 Total Points: 11,492.88 Donate	Well, yeah. It's all the posts which eat space. Dead members sorta sit there.

02-07-2008, 04:08 PM	#16
LinkManDX Senior Member Join Date: May 2002 Location: Some call it slums, some call it nice! Gender: Posts: 3,345 Thanks: 256 Thanked 209 Times in 122 Posts Points: 16,574.02 Bank: 6,327.87 Total Points: 22,901.89 Donate	^